Aan de slagGa gratis aan de slag

Query parameters

You had a team meeting with your boss, and one of the topics raised was ensuring queries were well organized for ease of handover. Emphasis was also made on using query parameters whenever possible to minimize static filtering.

Your task will be to clean up your queries into organized folders and to add a new dynamic query parameter to quickly filter on desired value ranges from the master query on Early Warning System score ranges.

If you lost progress, load the workbook 3_2_query_parameters.xlsx from the Workbooks folder and launch the Power Query editor.

Deze oefening maakt deel uit van de cursus

Intermediate Power Query in Excel

Cursus bekijken

Praktische interactieve oefening

Zet theorie om in actie met een van onze interactieve oefeningen.

Begin met trainen