Free Power BI exercises

This page lists 92 Power BI exercises. You can use the menu on the left to show just exercises for a specific topic.

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

Software: Power BI
Version: Latest update
Topic: Calendars
Level: Relatively easy
Course:
Exercise: Create a calculated column in a calendar table dividing the year into thirds.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Report themes
Level: Relatively easy
Course: Advanced Power BI
Exercise: Change the colours available by default within a report.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Calculated columns
Level: Relatively easy
Course: Introduction to Power BI
Exercise: Create two simple calculated columns for film data (for Oscars and profitability).

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Multiple tables
Level: Relatively easy
Course: Introduction to Power BI
Exercise: Changing between left outer, full outer and inner joins.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Drill-through and bookmarks
Level: Relatively easy
Course:
Exercise: Use drillthrough to move between to pages, filtering the landing page.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Advanced data models
Level: Relatively easy
Course: Advanced Power BI
Exercise: Use Power BI import option to connect and import entire folder of contents.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Overview of maps
Level: Relatively easy
Course: Introduction to Power BI
Exercise: Create a map showing passenger numbers for UK stations, with drill-down.

Go to exercise ...

Software: Power BI
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
Version: Latest update
Topic: Overview of maps
Level: Relatively easy
Course: Introduction to Power BI
Exercise: Compare sales of goods across the UK for large shopping centres.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Bookmarks
Level: Relatively easy
Course: Advanced Power BI
Exercise: Add a button using a bookmark to clear any slicer filters.

Go to exercise ...

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

Go to exercise ...

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

Go to exercise ...

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

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Tooltips
Level: Relatively easy
Course: Advanced Power BI
Exercise: Create a tooltip page showing how gauges work, and assign it to a visual header.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Charts
Level: Relatively easy
Course: Introduction to Power BI
Exercise: Compare the number of Abba songs released by year using a column chart.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Basic reports
Level: Relatively easy
Course: Introduction to Power BI
Exercise: Create a matrix and return some appropriate images above.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Quick measures
Level: Relatively easy
Course: Advanced Power BI
Exercise: Using a quick measure list out all the filters applied to a given page.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Filtering data
Level: Relatively easy
Course: Introduction to Power BI
Exercise: Apply a filter and a slicer by continent to a list of most-visited websites.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Filtering data
Level: Relatively easy
Course: Introduction to Power BI
Exercise: Apply a page filter to a list of films, then create a slicer by category.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Query editor
Level: Relatively easy
Course: Introduction to Power BI
Exercise: Use Query Editor to import and tidy up a list of the richest people.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Query editor
Level: Relatively easy
Course: Introduction to Power BI
Exercise: Use Query Editor to load and tidy up a list of FTSE share prices.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Basic reports
Level: Relatively easy
Course: Introduction to Power BI
Exercise: Create a report listing Game of Thrones episodes, importing two tables.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Basic reports
Level: Relatively easy
Course: Introduction to Power BI
Exercise: Create a basic report to show a simple table of Abba songs.

Go to exercise ...

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

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Power BI mobile
Level: Relatively easy
Course: Advanced Power BI
Exercise: Try optimising a premade report for use with the Power BI mobile app.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Overview of maps
Level: Relatively easy
Course: Introduction to Power BI
Exercise: Use ArcGIS to generate a heat map showing train passengers in the UK.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Data sources
Level: Relatively easy
Course: Introduction to Power BI
Exercise: Create relationships between tables using two methods.

Go to exercise ...

Software: Power BI
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
Version: Latest update
Topic: Calculated columns
Level: Relatively easy
Course: Introduction to Power BI
Exercise: Use calculated columns to show a film's length in text format.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Charts
Level: Relatively easy
Course: Introduction to Power BI
Exercise: Compare Pizza Express pizza calories using pie and doughnut charts.

Go to exercise ...

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

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Drill-through filtering
Level: Average difficulty
Course: Introduction to Power BI
Exercise: Enable drill-through for a report to show a breakdown of tests taken.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Power BI Templates
Level: Average difficulty
Course: Advanced Power BI
Exercise: Save time by creating a template which has premade visuals ready for data.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Roles and security
Level: Average difficulty
Course:
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.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Bookmarks
Level: Average difficulty
Course: Advanced Power BI
Exercise: Confusing visual? No problem use bookmarks to create helpful pop ups.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Calendars
Level: Average difficulty
Course:
Exercise: Add two calendars to a data model to compare two different expense dates.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Charts
Level: Average difficulty
Course: Introduction to Power BI
Exercise: Compare the heights of skyscrapers by country and city, and create a KPI.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Charts
Level: Average difficulty
Course: Introduction to Power BI
Exercise: Analyse 2018 crime figures for the Manchester area using various visuals.

Go to exercise ...

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

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Overview of maps
Level: Average difficulty
Course: Introduction to Power BI
Exercise: Create a map to show sales by town for selected regions.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Basic reports
Level: Average difficulty
Course: Introduction to Power BI
Exercise: Use a matrix to compare the number of websites by country and type.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Filtering data
Level: Average difficulty
Course: Introduction to Power BI
Exercise: Allow a user to choose pizzas by calorie count and type using slicers.

Go to exercise ...

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

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Tooltips
Level: Average difficulty
Course: Advanced Power BI
Exercise: Show the books for an author in a tooltip when you hover over their name.

Go to exercise ...

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

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Calculated columns
Level: Average difficulty
Course: Introduction to Power BI
Exercise: Use the DATEDIFF and IF functions to analyse the length of GoT series.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Calculated columns
Level: Average difficulty
Course: Introduction to Power BI
Exercise: Use the RELATED function to combine fields from four tables.

Go to exercise ...

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

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Filtering data
Level: Average difficulty
Course: Introduction to Power BI
Exercise: Create a date, numeric, dropdown and horizontal slicer on a report.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Report themes
Level: Average difficulty
Course: Advanced Power BI
Exercise: Themes can affect more than just colours. Create on which defaults the size and font for all visuals.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Bookmarks
Level: Average difficulty
Course: Advanced Power BI
Exercise: Bookmarks can be used to create the illusion of having multiple charts.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Parameters
Level: Average difficulty
Course: Advanced Power BI
Exercise: Create a multi option list for users to choose how to filter their data model.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Filtering data
Level: Average difficulty
Course: Introduction to Power BI
Exercise: Use hidden synced slicers to filter all pages with a single slicer.

Go to exercise ...

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

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Basic reports
Level: Average difficulty
Course: Introduction to Power BI
Exercise: Load 2 CSV files and one Excel workbook, and use this to report on films.

Go to exercise ...

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

Go to exercise ...

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

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Query editor
Level: Average difficulty
Course: Introduction to Power BI
Exercise: Use Query Editor to rename and split columns in a Game of Thrones worksheet.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Advanced data models
Level: Average difficulty
Course: Advanced Power BI
Exercise: Use the Merge option to combine two tables in Power BI into one.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Custom visuals
Level: Average difficulty
Course: Advanced Power BI
Exercise: Mix up your report by using an image slicer instead of the traditional slicer.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Custom visuals
Level: Average difficulty
Course: Advanced Power BI
Exercise: Upgrade the basic tooltip feature by creating a tooltip page to use instead.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Quick measures
Level: Average difficulty
Course: Advanced Power BI
Exercise: Using a quick measure it is possible to apply a filter to a single column within a table.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Bookmarks
Level: Average difficulty
Course: Advanced Power BI
Exercise: Clicking between pages breaking immersion? No problem connect pages using bookmark arrows.

Go to exercise ...

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

Go to exercise ...

Software: Power BI
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
Version: Latest update
Topic: Query editor
Level: Average difficulty
Course: Introduction to Power BI
Exercise: Use Query Editor to cleanse a list of imported top websites.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Advanced data models
Level: Average difficulty
Course: Advanced Power BI
Exercise: Unpivot an excel pivot table to make it useable within a Power BI Data model.

Go to exercise ...

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

Go to exercise ...

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

Go to exercise ...

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

Go to exercise ...

Software: Power BI
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
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
Version: Latest update
Topic: Parameters
Level: Average difficulty
Course: Advanced Power BI
Exercise: Use parameters to filter data before it enters the data model.

Go to exercise ...

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

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Advanced data models
Level: Harder than average
Course: Advanced Power BI
Exercise: Switch the Query editor file target from an Excel sheet to a SQL database.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Quick measures
Level: Harder than average
Course: Advanced Power BI
Exercise: Use quick measures to reference totals which either ignore or take into account filters.

Go to exercise ...

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

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Basic reports
Level: Harder than average
Course: Introduction to Power BI
Exercise: Compare Oscars won by genre and certificate for films using a matrix.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Basic reports
Level: Harder than average
Course: Introduction to Power BI
Exercise: Count the number of world events for each country and year.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Charts
Level: Harder than average
Course: Introduction to Power BI
Exercise: Show a chart comparing films when you click on each genre in a tree map.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Charts
Level: Harder than average
Course: Introduction to Power BI
Exercise: Compare skills test results using a waterfall chart with breakdown.

Go to exercise ...

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

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Filtering data
Level: Harder than average
Course: Introduction to Power BI
Exercise: Create date and normal slicers on one page to affect visuals on other pages.

Go to exercise ...

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

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Query editor
Level: Harder than average
Course: Introduction to Power BI
Exercise: Use Query Editor to remove, transform and add columns to a tall buildings list.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Parameters
Level: Harder than average
Course: Advanced Power BI
Exercise: Using parameters change the connection string used within the M language.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Custom visuals
Level: Harder than average
Course: Advanced Power BI
Exercise: The Synoptic panel can be used to create interactive images or even maps!.

Go to exercise ...

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

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Query editor
Level: Harder than average
Course: Introduction to Power BI
Exercise: Load some pivoted forecast data, unpivot it and much more!.

Go to exercise ...

Software: Power BI
Version: Latest update
Topic: Calculated columns
Level: Harder than average
Course: Introduction to Power BI
Exercise: Add lots of calculated columns to show a matrix summarising house prices.

Go to exercise ...

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

Go to exercise ...

Software: Power BI
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. Or why not learn to do them the right way on one of our classroom Power BI training courses in the UK, or on one of our live online Power BI courses wherever you are in the world?

This page has 0 threads Add post