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 PowerPivot exercises

You are welcome to try any of the 72 PowerPivot exercises listed below, but please do not distribute them in any form without asking for our written permission first.

Software:	PowerPivot
Topic:	PowerPivot data models
Level:	Relatively easy
Exercise:	Create a pivot table of average prices for transactions.

Show this exercise

Software:	PowerPivot
Topic:	PowerPivot data models
Level:	Relatively easy
Exercise:	From the MAM database, import 6 tables and use them to show quantity sold by town.

Show this exercise

Software:	PowerPivot
Topic:	PowerPivot data models
Level:	Relatively easy
Exercise:	Import tables from the Make-a-Mammal database, then hide tables and columns to create a clean data model.

Show this exercise

Software:	PowerPivot
Topic:	PowerPivot data models
Level:	Average difficulty
Exercise:	Import a table then amend it and import others to create data model.

Show this exercise

Software:	PowerPivot
Topic:	PowerPivot data models
Level:	Average difficulty
Exercise:	Import tables into PowerPivot, hide tables and columns and create a pivot table and slicer.

Show this exercise

Software:	PowerPivot
Topic:	PowerPivot data models
Level:	Harder than average
Exercise:	Create a pivot table with slicer based on ten different tables.

Show this exercise

Software:	PowerPivot
Topic:	PowerPivot data models
Level:	Harder than average
Exercise:	Create two pivot tables, and two timelines which control both of the pivot tables.

Show this exercise

Software:	PowerPivot
Topic:	Pivot tables using PowerPivot
Level:	Average difficulty
Exercise:	Use slicers to control 2 pivot tables, and Quick Explore to drill down.

Show this exercise

Software:	PowerPivot
Topic:	Pivot tables using PowerPivot
Level:	Harder than average
Exercise:	Use a timeline to restrict a pivot table to 4 specific quarters.

Show this exercise

Software:	PowerPivot
Topic:	Using Excel tables
Level:	Average difficulty
Exercise:	Create a linked Excel workbook in PowerPivot and use it in relationships.

Show this exercise

Software:	PowerPivot
Topic:	Using Excel tables
Level:	Average difficulty
Exercise:	Import data from Access, Word and Excel, and link an Excel table, to create a PowerPivot data model.

Show this exercise

Software:	PowerPivot
Topic:	Using Excel tables
Level:	Average difficulty
Exercise:	Link to Excel, Access and the clipboard (via Word) to import and link 4 tables.

Show this exercise

Software:	PowerPivot
Topic:	Using other data sources
Level:	Harder than average
Exercise:	Link to two Excel workbooks and one SQL Server table in PowerPivot.

Show this exercise

Software:	PowerPivot
Topic:	Transforming data (Power Query)
Level:	Relatively easy
Exercise:	For a table of populations, change data types and make other changes in Power Query.

Show this exercise

Software:	PowerPivot
Topic:	Transforming data (Power Query)
Level:	Average difficulty
Exercise:	Divide exchange rate and investment symbols into more parts by splitting and removing columns.

Show this exercise

Software:	PowerPivot
Topic:	Transforming data (Power Query)
Level:	Average difficulty
Exercise:	How to unpivot data in Power Query, then use this as a basis for a pivot table.

Show this exercise

Software:	PowerPivot
Topic:	Transforming data (Power Query)
Level:	Harder than average
Exercise:	For a table of skyscrapers, perform lots of query transforms and then pivot the results.

Show this exercise

Software:	PowerPivot
Topic:	Calculated columns
Level:	Relatively easy
Exercise:	Create an aggregator column to sum transaction values by weekday in a pivot table.

Show this exercise

Software:	PowerPivot
Topic:	Calculated columns
Level:	Relatively easy
Exercise:	Create two new calculated columns in a table, using RELATED and CONCATENATE.

Show this exercise

Software:	PowerPivot
Topic:	Calculated columns
Level:	Relatively easy
Exercise:	Total sales by weekday, using simple two calculated columns.

Show this exercise

Software:	PowerPivot
Topic:	Calculated columns
Level:	Average difficulty
Exercise:	Calculate age bands for different dates using the SWITCH functon.

Show this exercise

Software:	PowerPivot
Topic:	Calculated columns
Level:	Average difficulty
Exercise:	Divide shopping centres into the circles of hell, using the IF and the SWITCH functions.

Show this exercise

Software:	PowerPivot
Topic:	Calculated columns
Level:	Average difficulty
Exercise:	Divide years into bands using SWITCH and calculated columns.

Show this exercise

Software:	PowerPivot
Topic:	Calculated columns
Level:	Harder than average
Exercise:	Summarise sales by status of animal, using calculated columns.

Show this exercise

Software:	PowerPivot
Topic:	Measures
Level:	Average difficulty
Exercise:	Calculate total and average transaction values using measures.

Show this exercise

Software:	PowerPivot
Topic:	Measures
Level:	Harder than average
Exercise:	Calculate ratio of area to units for shopping centres using AVERAGEX.

Show this exercise

Software:	PowerPivot
Topic:	The CALCULATE function
Level:	Relatively easy
Exercise:	Divide sales by 4 legs and other for a measure, using the FILTER function.

Show this exercise

Software:	PowerPivot
Topic:	The CALCULATE function
Level:	Relatively easy
Exercise:	Use ALL and CALCULATE to get proportions of totals for regions.

Show this exercise

Software:	PowerPivot
Topic:	The CALCULATE function
Level:	Relatively easy
Exercise:	Use the CALCULATE function to pick out only transactions whose price is a given amount.

Show this exercise

Software:	PowerPivot
Topic:	The CALCULATE function
Level:	Relatively easy
Exercise:	Use the CALCULATE function to show percentages of row and column totals in a pivot table.

Show this exercise

Software:	PowerPivot
Topic:	The CALCULATE function
Level:	Average difficulty
Exercise:	Create a ratio of sales between two different habitats, using the CALCULATE and SUMX functions.

Show this exercise

Software:	PowerPivot
Topic:	The CALCULATE function
Level:	Average difficulty
Exercise:	Create measure using CALCULATE and ALL to get ratios against total.

Show this exercise

Software:	PowerPivot
Topic:	The CALCULATE function
Level:	Average difficulty
Exercise:	Exclude a month from totals using the VALUES function to retain context.

Show this exercise

Software:	PowerPivot
Topic:	The CALCULATE function
Level:	Average difficulty
Exercise:	Use CALCULATE to work out the ratio of total sales to sales for a specific type of animal.

Show this exercise

Software:	PowerPivot
Topic:	The CALCULATE function
Level:	Average difficulty
Exercise:	Use FILTER and ALL to show sales as a proportion of one region's total.

Show this exercise

Software:	PowerPivot
Topic:	The CALCULATE function
Level:	Average difficulty
Exercise:	Use the CALCULATE function to show total sales for Northern powerhouse shopping centres.

Show this exercise

Software:	PowerPivot
Topic:	The CALCULATE function
Level:	Average difficulty
Exercise:	Use the RANKX function to order total sales over species.

Show this exercise

Software:	PowerPivot
Topic:	The CALCULATE function
Level:	Harder than average
Exercise:	Create a calculated column using EARLIER to show previous joiner count.

Show this exercise

Software:	PowerPivot
Topic:	The CALCULATE function
Level:	Harder than average
Exercise:	Filter calculated sums to compare two stores' sales figures.

Show this exercise

Software:	PowerPivot
Topic:	The CALCULATE function
Level:	Harder than average
Exercise:	Omitting a particular shopping centre from totals, using the VALUES function.

Show this exercise

Software:	PowerPivot
Topic:	The CALCULATE function
Level:	Harder than average
Exercise:	Use AVERAGEX to find average ratios, then CALCULATE to avoid divide-by-zero errors.

Show this exercise

Software:	PowerPivot
Topic:	More advanced DAX functions
Level:	Average difficulty
Exercise:	Create two measures, showing average price for the South and all other regions.

Show this exercise

Software:	PowerPivot
Topic:	More advanced DAX functions
Level:	Average difficulty
Exercise:	Exclude a single animal from a pivot table, using CALCULATE combined with the VALUES function.

Show this exercise

Software:	PowerPivot
Topic:	More advanced DAX functions
Level:	Average difficulty
Exercise:	Sorting total sales into ascending order, using the RANKX function.

Show this exercise

Software:	PowerPivot
Topic:	More advanced DAX functions
Level:	Harder than average
Exercise:	Group purchases into shopping centre size bands, using the EARLIER and FILTER functions.

Show this exercise

Software:	PowerPivot
Topic:	More advanced DAX functions
Level:	Harder than average
Exercise:	Group sales into size bands using the EARLIER function.

Show this exercise

Software:	PowerPivot
Topic:	Calendars
Level:	Average difficulty
Exercise:	Create and import a calendar in Excel or SQL giving star signs.

Show this exercise

Software:	PowerPivot
Topic:	Date functions
Level:	Relatively easy
Exercise:	Use the SAMEPERIODLASTYEAR and DATEADD functions to show various statistics for total sales.

Show this exercise

Software:	PowerPivot
Topic:	Date functions
Level:	Relatively easy
Exercise:	Use the TOTALQTD and TOTALYTD functions to show total sales with quarterly and annual to-date figures.

Show this exercise

Software:	PowerPivot
Topic:	Date functions
Level:	Relatively easy
Exercise:	Use the TOTALYTD and TOTALQTD functions to show cumulative totals.

Show this exercise

Software:	PowerPivot
Topic:	Date functions
Level:	Average difficulty
Exercise:	Calculate total sales for the last year and the one before it.

Show this exercise

Software:	PowerPivot
Topic:	Date functions
Level:	Average difficulty
Exercise:	Use FIRSTDATE and LASTDATE to pick out the start/end values.

Show this exercise

Software:	PowerPivot
Topic:	Date functions
Level:	Average difficulty
Exercise:	Use the SAMEPERIODLASTYEAR and DATEADD functions to show comparison figures.

Show this exercise

Software:	PowerPivot
Topic:	Date functions
Level:	Average difficulty
Exercise:	Use the TOTALQTD function to accumulate quarter-to-date figures for each environment.

Show this exercise

Software:	PowerPivot
Topic:	Date functions
Level:	Harder than average
Exercise:	Compare YTD totals for two years, showing variance.

Show this exercise

Software:	PowerPivot
Topic:	Date functions
Level:	Harder than average
Exercise:	Use the DATESYTD, TOTALYTD, SAMEPERIODLASTYEAR and various other date functions to compare totals.

Show this exercise

Software:	PowerPivot
Topic:	Date functions
Level:	Harder than average
Exercise:	Use the PARALLELPERIOD function to show this quarter's total sales divided by the previous quarter's.

Show this exercise

Software:	PowerPivot
Topic:	Hierarchies
Level:	Not specified
Exercise:	Create a pivot table using two hierarchies.

Show this exercise

Software:	PowerPivot
Topic:	Hierarchies
Level:	Average difficulty
Exercise:	Create hierarchies using the RELATED function to make a pivot table look neat and tidy.

Show this exercise

Software:	PowerPivot
Topic:	KPIs
Level:	Relatively easy
Exercise:	Create a KPI giving a 10% target proportion of total sales.

Show this exercise

Software:	PowerPivot
Topic:	KPIs
Level:	Relatively easy
Exercise:	Use a KPI to show how well you are performing against the previous quarter.

Show this exercise

Software:	PowerPivot
Topic:	KPIs
Level:	Average difficulty
Exercise:	Create a KPI, showing green if a period's sales are more than 10% of the same period two months previously.

Show this exercise

Software:	PowerPivot
Topic:	KPIs
Level:	Average difficulty
Exercise:	Create an absolute KPI that a product should contribute 10% of total sales.

Show this exercise

Software:	PowerPivot
Topic:	KPIs
Level:	Average difficulty
Exercise:	Set a KPI that sales should be equal to previous year's.

Show this exercise

Software:	PowerPivot
Topic:	Power View
Level:	Not specified
Exercise:	Use Power Map to create and play a tour showing varying sales quantities by town over time.

Show this exercise

Software:	PowerPivot
Topic:	Power View
Level:	Relatively easy
Exercise:	Create a tiled report in Power View, containing one table and one chart.

Show this exercise

Software:	PowerPivot
Topic:	Power View
Level:	Average difficulty
Exercise:	Use maps in Power View to create multiple pie charts with drill down.

Show this exercise

Software:	PowerPivot
Topic:	Power View
Level:	Average difficulty
Exercise:	Use Power View to show a report of pie charts by month and animal, with filtering applied.

Show this exercise

Software:	PowerPivot
Topic:	Power BI Desktop overview
Level:	Relatively easy
Exercise:	In Power BI Desktop, import some data and create a table visualisation with some formatting.

Show this exercise

Software:	PowerPivot
Topic:	Power BI Desktop overview
Level:	Average difficulty
Exercise:	Create and format a slicer, and also a column chart with formatting, and use them to show sales for 2 centre types.

Show this exercise

Software:	PowerPivot
Topic:	Power BI Desktop overview
Level:	Harder than average
Exercise:	Create a matrix with conditional formatting and a tree diagram on two separate report pages.

Show this exercise

Software:	PowerPivot
Topic:	Power BI Desktop maps
Level:	Average difficulty
Exercise:	Create a map showing a pie slices of purchases by family for each town in the South-West of the UK.

Show this exercise

You can search our full list of Power BI exercises here. Or why not learn to do them the right way on one of our Power BI 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 BI EXERCISES

POWERPIVOT EXERCISES

Free PowerPivot exercises

Head office

London

Manchester