Free Power Pivot exercises
You are welcome to try any of the 43 Power Pivot exercises listed below, but please do not distribute them in any form without asking for our written permission first.
| Software: |
Power Pivot |
| Topic: |
Using Excel tables |
| Level: |
Relatively easy |
| Exercise: |
Add a worksheet of the world's tallest building to a Power Pivot data model and create a simple pivot table from it. |
| Software: |
Power Pivot |
| Topic: |
Using Excel tables |
| Level: |
Average difficulty |
| Exercise: |
Add a worksheet of music tours to a simple Power Pivot data model and use it to create an Excel pivot table. |
| Software: |
Power Pivot |
| Topic: |
Power Pivot data models |
| Level: |
Average difficulty |
| Exercise: |
Use Power Pivot to import multiple worksheets from an Excel file and create a data model. |
| Software: |
Power Pivot |
| Topic: |
Slicers and timelines |
| Level: |
Relatively easy |
| Exercise: |
Use slicers to filter an Excel pivot table based on a Power Pivot data model of tall buildings. |
| Software: |
Power Pivot |
| Topic: |
Slicers and timelines |
| Level: |
Average difficulty |
| Exercise: |
Create slicers and timelines to filter pivot tables based on a Power Pivot data model. |
| Software: |
Power Pivot |
| Topic: |
Calculated columns |
| Level: |
Relatively easy |
| Exercise: |
Create DAX calculated columns in Microsoft Power Pivot to generate new values for a list of tallest buildings. |
| Software: |
Power Pivot |
| Topic: |
Calculated columns |
| Level: |
Relatively easy |
| Exercise: |
Use conditional functions like IF and SWITCH to add calculated columns to a Power Pivot data model of tallest buildings. |
| Software: |
Power Pivot |
| Topic: |
Calculated columns |
| Level: |
Relatively easy |
| Exercise: |
Use the RELATED function in DAX to create a calculated column which references another table. |
| Software: |
Power Pivot |
| Topic: |
Calculated columns |
| Level: |
Average difficulty |
| Exercise: |
Use conditional functions like IF, SWITCH, ISBLANK and AND to create calculated columns in a Power Pivot data model of music tours. |
| Software: |
Power Pivot |
| Topic: |
Calculated columns |
| Level: |
Average difficulty |
| Exercise: |
Use DAX to add calculated columns to a Power Pivot data model. |
| Software: |
Power Pivot |
| Topic: |
Calculated columns |
| Level: |
Average difficulty |
| Exercise: |
Use the RELATED function in DAX to create calculated columns which reference values in other tables. |
| Software: |
Power Pivot |
| Topic: |
Basic measures |
| Level: |
Relatively easy |
| Exercise: |
Write basic measures in DAX to calculate statistics for the world's tallest buildings. |
| Software: |
Power Pivot |
| Topic: |
Basic measures |
| Level: |
Average difficulty |
| Exercise: |
Create basic DAX measures to calculate statistics about music tours. |
| Software: |
Power Pivot |
| Topic: |
The CALCULATE function |
| Level: |
Relatively easy |
| Exercise: |
Use the CALCULATE and KEEPFILTERS functions in Power Pivot to alter the behaviour of context filters in Excel pivot tables. |
| Software: |
Power Pivot |
| Topic: |
The CALCULATE function |
| Level: |
Relatively easy |
| Exercise: |
Use the REMOVEFILTERS function in DAX to modify the filter context of measures in Power Pivot for Excel. |
| Software: |
Power Pivot |
| Topic: |
The CALCULATE function |
| Level: |
Average difficulty |
| Exercise: |
Use the ALL or REMOVEFILTERS functions in Power Pivot to calculate percentages of group totals in a pivot table. |
| Software: |
Power Pivot |
| Topic: |
The CALCULATE function |
| Level: |
Average difficulty |
| Exercise: |
Use the ALLEXCEPT function to remove multiple filters in a DAX measure in Power Pivot for Excel. |
| Software: |
Power Pivot |
| Topic: |
The CALCULATE function |
| Level: |
Average difficulty |
| Exercise: |
Use the ALLSELECTED function in Power Pivot to write DAX measures more efficiently. |
| Software: |
Power Pivot |
| Topic: |
The CALCULATE function |
| Level: |
Average difficulty |
| Exercise: |
Use the CROSSFILTER function in DAX measures to control the direction of relationships in a Power Pivot data model. |
| Software: |
Power Pivot |
| Topic: |
The CALCULATE function |
| Level: |
Average difficulty |
| Exercise: |
Use the DAX CALCULATE function to replace existing context filters in Power Pivot. |
| Software: |
Power Pivot |
| Topic: |
The CALCULATE function |
| Level: |
Average difficulty |
| Exercise: |
Use the KEEPFILTERS function in DAX to modify the way context filters behave in pivot charts. |
| Software: |
Power Pivot |
| Topic: |
The CALCULATE function |
| Level: |
Harder than average |
| Exercise: |
Use the CALCULATE function in DAX to apply filters to measures in Excel Power Pivot. |
| Software: |
Power Pivot |
| Topic: |
Variables |
| Level: |
Relatively easy |
| Exercise: |
Use variables in DAX measures in Power Pivot to break a long formula into separate steps. |
| Software: |
Power Pivot |
| Topic: |
Variables |
| Level: |
Average difficulty |
| Exercise: |
Use variables in DAX measures in Power Pivot for Excel to break a long formula into separate steps. |
| Software: |
Power Pivot |
| Topic: |
The FILTER function |
| Level: |
Relatively easy |
| Exercise: |
Use the FILTER function in a DAX measure in Power Pivot to provide a filtered version of a table to other functions. |
| Software: |
Power Pivot |
| Topic: |
The FILTER function |
| Level: |
Average difficulty |
| Exercise: |
Use the FILTER function in a DAX measure in Power Pivot to provide a filtered version of a table to other functions. |
| Software: |
Power Pivot |
| Topic: |
The FILTER function |
| Level: |
Harder than average |
| Exercise: |
Use the FILTER function in a DAX measure in Power Pivot to provide a filtered version of a table to other functions. |
| Software: |
Power Pivot |
| Topic: |
KPIs |
| Level: |
Relatively easy |
| Exercise: |
Create KPIs in Power Pivot for Excel to indicate progress towards a target. |
| Software: |
Power Pivot |
| Topic: |
KPIs |
| Level: |
Average difficulty |
| Exercise: |
Use Power Pivot KPIs in Excel pivot tables to indicate progress towards a goal. |
| Software: |
Power Pivot |
| Topic: |
3D maps |
| Level: |
Relatively easy |
| Exercise: |
Create a 3D map of the world's tallest buildings from a Power Pivot data model. |
| Software: |
Power Pivot |
| Topic: |
3D maps |
| Level: |
Average difficulty |
| Exercise: |
Use Excel's 3D maps feature to display data on concert tours from a Power Pivot data model. |
You can search our full list of Power Pivot exercises here.
Or why not learn to do them the right way on one of our Power Pivot training courses? You can attend our online training classes wherever you are in the world!
