Free Power BI exercises

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

Software: Power BI
Version: Latest update
Topic: Calendars
Level: Relatively easy
Course: Introduction to Power BI
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: 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: 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: 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: 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: 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: 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: 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: 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: Bookmarks
Level: Relatively easy
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: 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: 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: Introduction to Power BI
Exercise: Add two calendars to a data model to compare two different expense dates.

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: 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: 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: 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: 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: 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: 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: 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: 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: 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 linked slicers to show a chart of crime statistics.

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: 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.

This page has 0 threads Add post