WISE OWL EXERCISES
POWER BI EXERCISES
POWER BI EXERCISES
- Basic reports (4)
- Data sources (2)
- Query editor (2)
- Multiple tables (1)
- Filtering data (4)
- Bookmarks (3)
- 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)
- Roles and security (1)
- Advanced data models (4)
- Drill-through and bookmarks (3)
- Custom visuals (3)
- Parameters (5)
- Quick measures (3)
- Report themes (2)
- BI mobile (1)
- Power BI Templates (1)
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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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!. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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!. |
| 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. |
| 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. |
| 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. |
You can search our full list of Power BI exercises here.
This page has 0 threads
Add post