WISE OWL EXERCISES
POWER BI EXERCISES
POWER BI DESKTOP EXERCISES
- Basic reports (4)
- Data sources (2)
- Query editor (2)
- Multiple tables (1)
- Filtering data (4)
- Charts (4)
- Other types of visualisation (1)
- Overview of maps (3)
- Calculated columns (2)
- Introduction to DAX (3)
- Creating measures in DAX (1)
- Calendars (2)
- Date functions (2)
- Drill-through and bookmarks (3)
- Parameters (2)
Free Power BI Desktop exercises
This page lists 36 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: | Calendars |
| Level: | Relatively easy |
| Course: | Introduction to Power BI Desktop |
| Exercise: | Create a calculated column in a calendar table dividing the year into thirds. |
| Software: | Power BI Desktop |
| Version: | Latest update |
| Topic: | Multiple tables |
| Level: | Relatively easy |
| Course: | Introduction to Power BI Desktop |
| Exercise: | Changing between left outer, full outer and inner joins. |
| Software: | Power BI Desktop |
| Version: | Latest update |
| Topic: | Drill-through and bookmarks |
| Level: | Relatively easy |
| Course: | Advanced Power BI Desktop |
| Exercise: | Use drillthrough to move between to pages, filtering the landing page. |
| 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: | Basic reports |
| Level: | Relatively easy |
| Course: | Introduction to Power BI Desktop |
| Exercise: | Create a matrix and return some appropriate images above. |
| 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: | Data sources |
| Level: | Relatively easy |
| Course: | Introduction to Power BI Desktop |
| Exercise: | Create relationships between tables using two methods. |
| 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: | Calendars |
| Level: | Average difficulty |
| Course: | Introduction to Power BI Desktop |
| Exercise: | Add two calendars to a data model to compare two different expense dates. |
| 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: | Filtering data |
| Level: | Average difficulty |
| Course: | Introduction to Power BI Desktop |
| Exercise: | Use hidden synced slicers to filter all pages with a single slicer. |
| 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