Free Power BI Desktop exercises

This page lists 29 Power BI Desktop exercises. You can use the menu to show just exercises for a specific topic.

Software: Power BI Desktop
Version: Latest update
Topic: Date functions
Level: Relatively easy
Course:
Exercise: Show cumulative sales for each quarter, and figures for the previous quarter.

Go to exercise ...

Software: Power BI Desktop
Version: Latest update
Topic: Introduction to DAX
Level: Relatively easy
Course:
Exercise: Show the average Brexit REMAIN votes by creating a couple of simple measures.

Go to exercise ...

Software: Power BI Desktop
Version: Latest update
Topic: Overview of maps
Level: Relatively easy
Course: Introduction to Power BI Desktop
Exercise: Compare sales of goods across the UK for large shopping centres.

Go to exercise ...

Software: Power BI Desktop
Version: Latest update
Topic: Charts
Level: Relatively easy
Course: Introduction to Power BI Desktop
Exercise: Create a donut chart of population data, and morph this into a tree chart.

Go to exercise ...

Software: Power BI Desktop
Version: Latest update
Topic: Basic reports
Level: Relatively easy
Course: Introduction to Power BI Desktop
Exercise: Load a webpage of the best films, and use this to create a table.

Go to exercise ...

Software: Power BI Desktop
Version: Latest update
Topic: Data sources
Level: Relatively easy
Course: Introduction to Power BI Desktop
Exercise: Load an Excel workbook of Disney princesses, and create a table from this.

Go to exercise ...

Software: Power BI Desktop
Version: Latest update
Topic: Query editor
Level: Relatively easy
Course: Introduction to Power BI Desktop
Exercise: Importing, tidying up and filtering skyscraper data to create a column chart.

Go to exercise ...

Software: Power BI Desktop
Version: Latest update
Topic: Query editor
Level: Relatively easy
Course: Introduction to Power BI Desktop
Exercise: Use the query editor to transform a rubbish data file into something useful.

Go to exercise ...

Software: Power BI Desktop
Version: Latest update
Topic: Overview of maps
Level: Average difficulty
Course: Introduction to Power BI Desktop
Exercise: Create a map comparing house price sales for expensive houses across the UK.

Go to exercise ...

Software: Power BI Desktop
Version: Latest update
Topic: Charts
Level: Average difficulty
Course: Introduction to Power BI Desktop
Exercise: Create a column chart of record sales, and drill-down to a pie chart.

Go to exercise ...

Software: Power BI Desktop
Version: Latest update
Topic: Other types of visualisation
Level: Average difficulty
Course: Introduction to Power BI Desktop
Exercise: Create a stacked column chart with drill-down, a KPI, a gauge - and more.

Go to exercise ...

Software: Power BI Desktop
Version: Latest update
Topic: Drill-through and bookmarks
Level: Average difficulty
Course: Advanced Power BI Desktop
Exercise: Use images and bookmarks to allow navigation between pages.

Go to exercise ...

Software: Power BI Desktop
Version: Latest update
Topic: Basic reports
Level: Average difficulty
Course: Introduction to Power BI Desktop
Exercise: Load FTSE data, and create a report with a table, shape and image.

Go to exercise ...

Software: Power BI Desktop
Version: Latest update
Topic: Filtering data
Level: Average difficulty
Course: Introduction to Power BI Desktop
Exercise: Create a slicer and chart to choose which whale sightings dataset you want to see.

Go to exercise ...

Software: Power BI Desktop
Version: Latest update
Topic: Filtering data
Level: Average difficulty
Course: Introduction to Power BI Desktop
Exercise: Import skyscraper data, creating a new column and showing this in a chart controlled by a slicer.

Go to exercise ...

Software: Power BI Desktop
Version: Latest update
Topic: Charts
Level: Average difficulty
Course: Introduction to Power BI Desktop
Exercise: Use grouping in charts to show viewing figures by genre for BBC1.

Go to exercise ...

Software: Power BI Desktop
Version: Latest update
Topic: Date functions
Level: Average difficulty
Course:
Exercise: Show the cumulative proportion of the previous month's total sales, using various date functions.

Go to exercise ...

Software: Power BI Desktop
Version: Latest update
Topic: Calculated columns
Level: Average difficulty
Course: Introduction to Power BI Desktop
Exercise: Create new columns to group skyscraper data in new and unsurprising ways!.

Go to exercise ...

Software: Power BI Desktop
Version: Latest update
Topic: Calculated columns
Level: Average difficulty
Course: Introduction to Power BI Desktop
Exercise: Calculate average floor areas for tall building data using calculated columns.

Go to exercise ...

Software: Power BI Desktop
Version: Latest update
Topic: Parameters
Level: Average difficulty
Course: Advanced Power BI Desktop
Exercise: Create a parameter and apply it to crime statistics to filter the data.

Go to exercise ...

Software: Power BI Desktop
Version: Latest update
Topic: Introduction to DAX
Level: Average difficulty
Course:
Exercise: Show ratios for a table of premier league results, using the CALCULATE function.

Go to exercise ...

Software: Power BI Desktop
Version: Latest update
Topic: Creating measures in DAX
Level: Average difficulty
Course:
Exercise: Calculate the ratio between normal and multi-legged animals, using variables, CALCULATE and VALUES.

Go to exercise ...

Software: Power BI Desktop
Version: Latest update
Topic: Drill-through and bookmarks
Level: Harder than average
Course: Advanced Power BI Desktop
Exercise: Make a more complex bookmark report by using DATA and SELECTED VISUAL modes.

Go to exercise ...

Software: Power BI Desktop
Version: Latest update
Topic: Basic reports
Level: Harder than average
Course: Introduction to Power BI Desktop
Exercise: Load example tables from a SQL Server database, and use them to create a matrix.

Go to exercise ...

Software: Power BI Desktop
Version: Latest update
Topic: Charts
Level: Harder than average
Course: Introduction to Power BI Desktop
Exercise: Create a bubble chart comparing two sets of numbers, and play it over time to show changes.

Go to exercise ...

Software: Power BI Desktop
Version: Latest update
Topic: Filtering data
Level: Harder than average
Course: Introduction to Power BI Desktop
Exercise: Create linked slicers to show a chart of crime statistics.

Go to exercise ...

Software: Power BI Desktop
Version: Latest update
Topic: Overview of maps
Level: Harder than average
Course: Introduction to Power BI Desktop
Exercise: Analyse Brexit voting patterns for the countries of the UK, using Electoral Commission data.

Go to exercise ...

Software: Power BI Desktop
Version: Latest update
Topic: Parameters
Level: Harder than average
Course: Advanced Power BI Desktop
Exercise: Create a parameter which controls which song playlist you load.

Go to exercise ...

Software: Power BI Desktop
Version: Latest update
Topic: Introduction to DAX
Level: Harder than average
Course:
Exercise: Omit certain columns from a matrix, using CALCULATE, VALUES and FILTER.

Go to exercise ...

You can search our full list of Power BI exercises here.

This page has 0 threads Add post