WISE OWL EXERCISES
POWER BI EXERCISES
POWER BI DESKTOP EXERCISES
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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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!. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
You can search our full list of Power BI exercises here.
This page has 0 threads
Add post