Free Power BI exercises
You are welcome to try any of the 111 Power BI exercises listed below, but please do not distribute them in any form without asking for our written permission first.
| Software: |
Power BI |
| Topic: |
Basic reports |
| Level: |
Relatively easy |
| Exercise: |
Create a basic report to show a simple table of Abba songs. |
| Software: |
Power BI |
| Topic: |
Basic reports |
| Level: |
Relatively easy |
| Exercise: |
Create a matrix and return some appropriate images above. |
| Software: |
Power BI |
| Topic: |
Basic reports |
| Level: |
Relatively easy |
| Exercise: |
Create a report listing Game of Thrones episodes, importing two tables. |
| Software: |
Power BI |
| Topic: |
Basic reports |
| Level: |
Relatively easy |
| Exercise: |
Load a webpage of the best films, and use this to create a table. |
| Software: |
Power BI |
| Topic: |
Basic reports |
| Level: |
Average difficulty |
| Exercise: |
Load 2 CSV files and one Excel workbook, and use this to report on films. |
| Software: |
Power BI |
| Topic: |
Basic reports |
| Level: |
Average difficulty |
| Exercise: |
Load FTSE data, and create a report with a table, shape and image. |
| Software: |
Power BI |
| Topic: |
Basic reports |
| Level: |
Average difficulty |
| Exercise: |
Use a matrix to compare the number of websites by country and type. |
| Software: |
Power BI |
| Topic: |
Basic reports |
| Level: |
Harder than average |
| Exercise: |
Compare Oscars won by genre and certificate for films using a matrix. |
| Software: |
Power BI |
| Topic: |
Basic reports |
| Level: |
Harder than average |
| Exercise: |
Count the number of world events for each country and year. |
| Software: |
Power BI |
| Topic: |
Basic reports |
| Level: |
Harder than average |
| Exercise: |
Load example tables from a SQL Server database, and use them to create a matrix. |
| Software: |
Power BI |
| Topic: |
Data sources |
| Level: |
Relatively easy |
| Exercise: |
Create relationships between tables using two methods. |
| Software: |
Power BI |
| Topic: |
Data sources |
| Level: |
Relatively easy |
| Exercise: |
Load an Excel workbook of Disney princesses, and create a table from this. |
| Software: |
Power BI |
| Topic: |
Query editor |
| Level: |
Relatively easy |
| Exercise: |
Importing, tidying up and filtering skyscraper data to create a column chart. |
| Software: |
Power BI |
| Topic: |
Query editor |
| Level: |
Relatively easy |
| Exercise: |
Use Query Editor to import and tidy up a list of the richest people. |
| Software: |
Power BI |
| Topic: |
Query editor |
| Level: |
Relatively easy |
| Exercise: |
Use Query Editor to load and tidy up a list of FTSE share prices. |
| Software: |
Power BI |
| Topic: |
Query editor |
| Level: |
Relatively easy |
| Exercise: |
Use the query editor to transform a rubbish data file into something useful. |
| Software: |
Power BI |
| Topic: |
Query editor |
| Level: |
Average difficulty |
| Exercise: |
Use Query Editor to cleanse a list of imported top websites. |
| Software: |
Power BI |
| Topic: |
Query editor |
| Level: |
Average difficulty |
| Exercise: |
Use Query Editor to rename and split columns in a Game of Thrones worksheet. |
| Software: |
Power BI |
| Topic: |
Query editor |
| Level: |
Harder than average |
| Exercise: |
Load some pivoted forecast data, unpivot it and much more!. |
| Software: |
Power BI |
| Topic: |
Query editor |
| Level: |
Harder than average |
| Exercise: |
Use Query Editor to remove, transform and add columns to a tall buildings list. |
| Software: |
Power BI |
| Topic: |
Filtering data |
| Level: |
Relatively easy |
| Exercise: |
Apply a filter and a slicer by continent to a list of most-visited websites. |
| Software: |
Power BI |
| Topic: |
Filtering data |
| Level: |
Relatively easy |
| Exercise: |
Apply a page filter to a list of films, then create a slicer by category. |
| Software: |
Power BI |
| Topic: |
Filtering data |
| Level: |
Average difficulty |
| Exercise: |
Allow a user to choose pizzas by calorie count and type using slicers. |
| Software: |
Power BI |
| Topic: |
Filtering data |
| Level: |
Average difficulty |
| Exercise: |
Create a date, numeric, dropdown and horizontal slicer on a report. |
| Software: |
Power BI |
| Topic: |
Filtering data |
| Level: |
Average difficulty |
| Exercise: |
Create a slicer and chart to choose which whale sightings dataset you want to see. |
| Software: |
Power BI |
| Topic: |
Filtering data |
| Level: |
Average difficulty |
| Exercise: |
Import skyscraper data, creating a new column and showing this in a chart controlled by a slicer. |
| Software: |
Power BI |
| Topic: |
Filtering data |
| Level: |
Average difficulty |
| Exercise: |
Use hidden synced slicers to filter all pages with a single slicer. |
| Software: |
Power BI |
| Topic: |
Filtering data |
| Level: |
Harder than average |
| Exercise: |
Create date and normal slicers on one page to affect visuals on other pages. |
| Software: |
Power BI |
| Topic: |
Filtering data |
| Level: |
Harder than average |
| Exercise: |
Create linked slicers to show a chart of crime statistics. |
| Software: |
Power BI |
| Topic: |
Drill-through |
| Level: |
Average difficulty |
| Exercise: |
Enable drill-through for a report to show a breakdown of tests taken. |
| Software: |
Power BI |
| Topic: |
Charts |
| Level: |
Relatively easy |
| Exercise: |
Compare Pizza Express pizza calories using pie and doughnut charts. |
| Software: |
Power BI |
| Topic: |
Charts |
| Level: |
Relatively easy |
| Exercise: |
Compare the number of Abba songs released by year using a column chart. |
| Software: |
Power BI |
| Topic: |
Charts |
| Level: |
Relatively easy |
| Exercise: |
Create a donut chart of population data, and morph this into a tree chart. |
| Software: |
Power BI |
| Topic: |
Charts |
| Level: |
Average difficulty |
| Exercise: |
Analyse 2018 crime figures for the Manchester area using various visuals. |
| Software: |
Power BI |
| Topic: |
Charts |
| Level: |
Average difficulty |
| Exercise: |
Compare the heights of skyscrapers by country and city, and create a KPI. |
| Software: |
Power BI |
| Topic: |
Charts |
| Level: |
Average difficulty |
| Exercise: |
Create a column chart of record sales, and drill-down to a pie chart. |
| Software: |
Power BI |
| Topic: |
Charts |
| Level: |
Average difficulty |
| Exercise: |
Use grouping in charts to show viewing figures by genre for BBC1. |
| Software: |
Power BI |
| Topic: |
Charts |
| Level: |
Harder than average |
| Exercise: |
Compare skills test results using a waterfall chart with breakdown. |
| Software: |
Power BI |
| Topic: |
Charts |
| Level: |
Harder than average |
| Exercise: |
Create a bubble chart comparing two sets of numbers, and play it over time to show changes. |
| Software: |
Power BI |
| Topic: |
Charts |
| Level: |
Harder than average |
| Exercise: |
Show a chart comparing films when you click on each genre in a tree map. |
| Software: |
Power BI |
| Topic: |
Matrices |
| Level: |
Average difficulty |
| Exercise: |
Create a stacked column chart with drill-down, a KPI, a gauge - and more. |
| Software: |
Power BI |
| Topic: |
Basic maps |
| Level: |
Relatively easy |
| Exercise: |
Compare sales of goods across the UK for large shopping centres. |
| Software: |
Power BI |
| Topic: |
Basic maps |
| Level: |
Relatively easy |
| Exercise: |
Create a map showing passenger numbers for UK stations, with drill-down. |
| Software: |
Power BI |
| Topic: |
Basic maps |
| Level: |
Relatively easy |
| Exercise: |
Use ArcGIS to generate a heat map showing train passengers in the UK. |
| Software: |
Power BI |
| Topic: |
Basic maps |
| Level: |
Average difficulty |
| Exercise: |
Create a map comparing house price sales for expensive houses across the UK. |
| Software: |
Power BI |
| Topic: |
Basic maps |
| Level: |
Average difficulty |
| Exercise: |
Create a map to show sales by town for selected regions. |
| Software: |
Power BI |
| Topic: |
Basic maps |
| Level: |
Harder than average |
| Exercise: |
Analyse Brexit voting patterns for the countries of the UK, using Electoral Commission data. |
| Software: |
Power BI |
| Topic: |
Calculated columns |
| Level: |
Relatively easy |
| Exercise: |
Create a calculated column in a calendar table dividing the year into thirds. |
| Software: |
Power BI |
| Topic: |
Calculated columns |
| Level: |
Relatively easy |
| Exercise: |
Create two simple calculated columns for film data (for Oscars and profitability). |
| Software: |
Power BI |
| Topic: |
Calculated columns |
| Level: |
Relatively easy |
| Exercise: |
Use calculated columns to show a film's length in text format. |
| Software: |
Power BI |
| Topic: |
Calculated columns |
| Level: |
Average difficulty |
| Exercise: |
Calculate average floor areas for tall building data using calculated columns. |
| Software: |
Power BI |
| Topic: |
Calculated columns |
| Level: |
Average difficulty |
| Exercise: |
Create new columns to group skyscraper data in new and unsurprising ways!. |
| Software: |
Power BI |
| Topic: |
Calculated columns |
| Level: |
Average difficulty |
| Exercise: |
Use the DATEDIFF and IF functions to analyse the length of GoT series. |
| Software: |
Power BI |
| Topic: |
Calculated columns |
| Level: |
Average difficulty |
| Exercise: |
Use the RELATED function to combine fields from four tables. |
| Software: |
Power BI |
| Topic: |
Calculated columns |
| Level: |
Harder than average |
| Exercise: |
Add lots of calculated columns to show a matrix summarising house prices. |
| Software: |
Power BI |
| Topic: |
Roles and security |
| Level: |
Average difficulty |
| Exercise: |
Roles can be used to change what data can be seen within a report. Use these to restrict which house information a user sees. |
| Software: |
Power BI |
| Topic: |
Report themes |
| Level: |
Relatively easy |
| Exercise: |
Change the colours available by default within a report. |
| Software: |
Power BI |
| Topic: |
Report themes |
| Level: |
Average difficulty |
| Exercise: |
Themes can affect more than just colours. Create on which defaults the size and font for all visuals. |
| Software: |
Power BI |
| Topic: |
Power BI mobile |
| Level: |
Relatively easy |
| Exercise: |
Try optimising a premade report for use with the Power BI mobile app. |
| Software: |
Power BI |
| Topic: |
Advanced tables |
| Level: |
Relatively easy |
| Exercise: |
Choose to create two versions of a table with different sorting for each. |
| Software: |
Power BI |
| Topic: |
Advanced tables |
| Level: |
Relatively easy |
| Exercise: |
Make a column into an image URL to list out sports with their icons. |
| Software: |
Power BI |
| Topic: |
Advanced tables |
| Level: |
Relatively easy |
| Exercise: |
Show a list of total quantities sold by parcel weight. |
| Software: |
Power BI |
| Topic: |
Conditional formatting |
| Level: |
Average difficulty |
| Exercise: |
Apply data bars to a chart to show the length of different films. |
| Software: |
Power BI |
| Topic: |
Conditional formatting |
| Level: |
Average difficulty |
| Exercise: |
Show icons for different values in a table using conditional formatting. |
| Software: |
Power BI |
| Topic: |
Conditional formatting |
| Level: |
Harder than average |
| Exercise: |
Create 4 tables using data bars, icons and other conditional formatting. |
| Software: |
Power BI |
| Topic: |
Conditional formatting |
| Level: |
Harder than average |
| Exercise: |
Use fields containing colour names to apply conditional colours to a chart. |
| Software: |
Power BI |
| Topic: |
Analytics |
| Level: |
Relatively easy |
| Exercise: |
Load a CSV file of running data and show a target line against it. |
| Software: |
Power BI |
| Topic: |
Analytics |
| Level: |
Average difficulty |
| Exercise: |
Load sleep data and add minimum, maximum and trend lines. |
| Software: |
Power BI |
| Topic: |
Decomposition tree |
| Level: |
Average difficulty |
| Exercise: |
Use a decomposition tree visual to analyse box office takings for films. |
| Software: |
Power BI |
| Topic: |
Other visuals |
| Level: |
Average difficulty |
| Exercise: |
Analyse total film Oscars won using breakdowns in a waterfall chart. |
| Software: |
Power BI |
| Topic: |
Tooltips |
| Level: |
Relatively easy |
| Exercise: |
Create a tooltip page showing how gauges work, and assign it to a visual header. |
| Software: |
Power BI |
| Topic: |
Tooltips |
| Level: |
Average difficulty |
| Exercise: |
Show the books for an author in a tooltip when you hover over their name. |
| Software: |
Power BI |
| Topic: |
Bookmarks |
| Level: |
Relatively easy |
| Exercise: |
Add a button using a bookmark to clear any slicer filters. |
| Software: |
Power BI |
| Topic: |
Bookmarks |
| Level: |
Average difficulty |
| Exercise: |
Bookmarks can be used to create the illusion of having multiple charts. |
| Software: |
Power BI |
| Topic: |
Bookmarks |
| Level: |
Average difficulty |
| Exercise: |
Clicking between pages breaking immersion? No problem connect pages using bookmark arrows. |
| Software: |
Power BI |
| Topic: |
Bookmarks |
| Level: |
Average difficulty |
| Exercise: |
Confusing visual? No problem use bookmarks to create helpful pop ups. |
| Software: |
Power BI |
| Topic: |
Quick measures |
| Level: |
Average difficulty |
| Exercise: |
Using a quick measure it is possible to apply a filter to a single column within a table. |
| Software: |
Power BI |
| Topic: |
Quick measures |
| Level: |
Average difficulty |
| Exercise: |
Using a quick measure list out all the filters applied to a given page. |
| Software: |
Power BI |
| Topic: |
Quick measures |
| Level: |
Harder than average |
| Exercise: |
Use quick measures to reference totals which either ignore or take into account filters. |
| Software: |
Power BI |
| Topic: |
Dynamic display |
| Level: |
Relatively easy |
| Exercise: |
Make a table title dynamic using a quick measure. |
| Software: |
Power BI |
| Topic: |
Custom visuals |
| Level: |
Average difficulty |
| Exercise: |
Mix up your report by using an image slicer instead of the traditional slicer. |
| Software: |
Power BI |
| Topic: |
Custom visuals |
| Level: |
Average difficulty |
| Exercise: |
Upgrade the basic tooltip feature by creating a tooltip page to use instead. |
| Software: |
Power BI |
| Topic: |
Custom visuals |
| Level: |
Harder than average |
| Exercise: |
The Synoptic panel can be used to create interactive images or even maps!. |
| Software: |
Power BI |
| Topic: |
Advanced data sources |
| Level: |
Relatively easy |
| Exercise: |
Use Power BI import option to connect and import entire folder of contents. |
| Software: |
Power BI |
| Topic: |
Advanced data sources |
| Level: |
Average difficulty |
| Exercise: |
Unpivot an excel pivot table to make it useable within a Power BI Data model. |
| Software: |
Power BI |
| Topic: |
Advanced data sources |
| Level: |
Average difficulty |
| Exercise: |
Use the Merge option to combine two tables in Power BI into one. |
| Software: |
Power BI |
| Topic: |
Advanced data sources |
| Level: |
Harder than average |
| Exercise: |
Switch the Query editor file target from an Excel sheet to a SQL database. |
| Software: |
Power BI |
| Topic: |
Basic parameters |
| Level: |
Average difficulty |
| Exercise: |
Use parameters to filter data before it enters the data model. |
| Software: |
Power BI |
| Topic: |
Column transforms |
| Level: |
Relatively easy |
| Exercise: |
Load data showing gun ownership rates by country and tidy it up. |
| Software: |
Power BI |
| Topic: |
Column transforms |
| Level: |
Average difficulty |
| Exercise: |
Transforming a dataset showing the followers of different religions. |
| Software: |
Power BI |
| Topic: |
Combining queries |
| Level: |
Relatively easy |
| Exercise: |
Combine four files containing Big Bang Theory episodes into a single query. |
| Software: |
Power BI |
| Topic: |
Combining queries |
| Level: |
Harder than average |
| Exercise: |
Merging 3 separate files of data, including unpivoting and other transforms. |
| Software: |
Power BI |
| Topic: |
Manipulation transforms |
| Level: |
Average difficulty |
| Exercise: |
A long exercise loading a list of tube stations, transforming and grouping data. |
| Software: |
Power BI |
| Topic: |
Normalising tables |
| Level: |
Relatively easy |
| Exercise: |
Divide a single table of dinosaurs into 3 separate tables (normalisation). |
| Software: |
Power BI |
| Topic: |
Normalising tables |
| Level: |
Harder than average |
| Exercise: |
Transforming a list of book sales and normalising into different tables. |
| Software: |
Power BI |
| Topic: |
Simple parameters |
| Level: |
Relatively easy |
| Exercise: |
Create a parameter and apply it to crime statistics to filter the data. |
| Software: |
Power BI |
| Topic: |
Dropdown parameters |
| Level: |
Average difficulty |
| Exercise: |
Create a drop list of hair treatments for users to filter their data model by. |
| Software: |
Power BI |
| Topic: |
Stored procedures |
| Level: |
Harder than average |
| Exercise: |
Pass parameters from a query to a stored procedure in a books database. |
| Software: |
Power BI |
| Topic: |
Dynamic connections |
| Level: |
Average difficulty |
| Exercise: |
Create a parameter which controls which song playlist you load. |
| Software: |
Power BI |
| Topic: |
Dynamic connections |
| Level: |
Harder than average |
| Exercise: |
Use a dropdown parameter to choose different sets of buildings in M. |
| Software: |
Power BI |
| Topic: |
Custom functions |
| Level: |
Relatively easy |
| Exercise: |
Write a custom function to parse dates, and apply it to the rows of a query. |
| Software: |
Power BI |
| Topic: |
Custom functions |
| Level: |
Average difficulty |
| Exercise: |
Use a custom function to combine all of the worksheets in a workbook. |
| Software: |
Power BI |
| Topic: |
Custom functions |
| Level: |
Harder than average |
| Exercise: |
Use a custom function to extract and combine the external links from websites. |
| Software: |
Power BI |
| Topic: |
APIs |
| Level: |
Relatively easy |
| Exercise: |
Use the NASA API to show a random image of somewhere in the Universe. |
| Software: |
Power BI |
| Topic: |
APIs |
| Level: |
Average difficulty |
| Exercise: |
Use an API to deal a hand of cards to yourself and show this in Power BI. |
| Software: |
Power BI |
| Topic: |
APIs |
| Level: |
Average difficulty |
| Exercise: |
Use the UK government crime statistics API to show crimes in your area. |
| Software: |
Power BI |
| Topic: |
Power BI Templates |
| Level: |
Average difficulty |
| Exercise: |
Save time by creating a template which has premade visuals ready for data. |
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!
