This page has 0 threads | Add post

Exercises

Many people around the world enjoy and benefit from our exercises. If you're one of them - and can afford to - please make a small donation to help keep this and future blogs, exercises, skills assessment tests, tips, tutorials and videos freely available to everyone!

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.

Show this exercise

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.

Show this exercise

Software:	Power Pivot
Topic:	Power Pivot data models
Level:	Relatively easy
Exercise:	Import three worksheets from an Excel workbook into a Power Pivot data model.

Show this exercise

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.

Show this exercise

Software:	Power Pivot
Topic:	Pivot tables using Power Pivot
Level:	Relatively easy
Exercise:	Create pivot tables based on a data model of the world's tallest buildings.

Show this exercise

Software:	Power Pivot
Topic:	Pivot tables using Power Pivot
Level:	Average difficulty
Exercise:	Create pivot tables with conditional formatting from a Power Pivot data model of concert tours.

Show this exercise

Software:	Power Pivot
Topic:	Pivot charts using Power Pivot
Level:	Relatively easy
Exercise:	Create pivot charts using a Power Pivot data model of the world's tallest buildings.

Show this exercise

Software:	Power Pivot
Topic:	Pivot charts using Power Pivot
Level:	Average difficulty
Exercise:	Create pivot charts from a Power Pivot data model of concert tours.

Show this exercise

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.

Show this exercise

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.

Show this exercise

Software:	Power Pivot
Topic:	Transforming data with Power Query
Level:	Relatively easy
Exercise:	Use the Power Query editor to clean a table of the world's tallest buildings using various transforms.

Show this exercise

Software:	Power Pivot
Topic:	Transforming data with Power Query
Level:	Average difficulty
Exercise:	Use Power Query in Excel to import and transform data on concert tours.

Show this exercise

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.

Show this exercise

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.

Show this exercise

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.

Show this exercise

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.

Show this exercise

Software:	Power Pivot
Topic:	Calculated columns
Level:	Average difficulty
Exercise:	Use DAX to add calculated columns to a Power Pivot data model.

Show this exercise

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.

Show this exercise

Software:	Power Pivot
Topic:	Basic measures
Level:	Relatively easy
Exercise:	Write basic measures in DAX to calculate statistics for the world's tallest buildings.

Show this exercise

Software:	Power Pivot
Topic:	Basic measures
Level:	Average difficulty
Exercise:	Create basic DAX measures to calculate statistics about music tours.

Show this exercise

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.

Show this exercise

Software:	Power Pivot
Topic:	The CALCULATE function
Level:	Relatively easy
Exercise:	Use the DAX Calculate function to add filters to measures in Power BI Desktop.

Show this exercise

Software:	Power Pivot
Topic:	The CALCULATE function
Level:	Relatively easy
Exercise:	Use the DAX CALCULATE function to replace context filters.

Show this exercise

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.

Show this exercise

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.

Show this exercise

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.

Show this exercise

Software:	Power Pivot
Topic:	The CALCULATE function
Level:	Average difficulty
Exercise:	Use the ALLSELECTED function in Power Pivot to write DAX measures more efficiently.

Show this exercise

Software:	Power Pivot
Topic:	The CALCULATE function
Level:	Average difficulty
Exercise:	Use the CALCULATE function in DAX measures to add filters to expressions.

Show this exercise

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.

Show this exercise

Software:	Power Pivot
Topic:	The CALCULATE function
Level:	Average difficulty
Exercise:	Use the DAX CALCULATE function to replace existing context filters in Power Pivot.

Show this exercise

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.

Show this exercise

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.

Show this exercise

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.

Show this exercise

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.

Show this exercise

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.

Show this exercise

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.

Show this exercise

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.

Show this exercise

Software:	Power Pivot
Topic:	Calendars and time intelligence
Level:	Relatively easy
Exercise:	Use Power Pivot's time intelligence functions in DAX measures.

Show this exercise

Software:	Power Pivot
Topic:	Calendars and time intelligence
Level:	Average difficulty
Exercise:	Import and configure a custom calendar table in Power Pivot for Excel.

Show this exercise

Software:	Power Pivot
Topic:	KPIs
Level:	Relatively easy
Exercise:	Create KPIs in Power Pivot for Excel to indicate progress towards a target.

Show this exercise

Software:	Power Pivot
Topic:	KPIs
Level:	Average difficulty
Exercise:	Use Power Pivot KPIs in Excel pivot tables to indicate progress towards a goal.

Show this exercise

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.

Show this exercise

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.

Show this exercise

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!

This page has 0 threads

Add a new post

EXERCISE TOPIC

POWER PIVOT EXERCISES

POWER PIVOT EXERCISES

Free Power Pivot exercises

Head office

London

Manchester