EXERCISE TOPIC▼
- Access exercises (91)
- C# exercises (79)
- Excel exercises (278)
- Power Apps exercises (13)
- Power Automate exercises (18)
- Power BI exercises (139)
- Python exercises (28)
- Report Builder exercises (141)
- SQL exercises (198)
- SSAS exercises (51)
- SSIS exercises (46)
- SSRS exercises (99)
- VBA exercises (85)
- Visual Basic exercises (46)
POWER BI EXERCISES▼
POWER BI EXERCISES▼
- Basic reports (10)
- Data sources (2)
- Query editor (8)
- Filtering data (9)
- Drill-through (1)
- Charts (10)
- Matrices (1)
- Basic maps (6)
- Calculated columns (8)
- Roles and security (1)
- Drill-through and bookmarks (3)
- Report themes (2)
- Power BI mobile (1)
- Advanced tables (3)
- Conditional formatting (5)
- Analytics (2)
- Decomposition tree (1)
- Other visuals (1)
- Tooltips (2)
- Bookmarks (4)
- Quick measures (3)
- Dynamic display (1)
- Custom visuals (3)
- Advanced data sources (4)
- Basic parameters (1)
- Column transforms (2)
- Combining queries (2)
- Manipulation transforms (1)
- Normalising tables (2)
- Simple parameters (1)
- Dropdown parameters (1)
- Stored procedures (1)
- Dynamic connections (2)
- Custom functions (3)
- APIs (3)
- Power BI Templates (1)
Free Power BI exercises
This page lists 111 Power BI exercises. You can use the menu on the left to show just exercises for a specific topic.
This page lists 111 Power BI exercises. You can use the menu above to show just exercises for a specific topic.
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Calculated columns |
| Level: | Relatively easy |
| Courses: | Introduction to Power BIFast track 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: | |
| Exercise: | Change the colours available by default within a report. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Calculated columns |
| Level: | Relatively easy |
| Courses: | Introduction to Power BIFast track Power BI |
| Exercise: | Create two simple calculated columns for film data (for Oscars and profitability). |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Conditional formatting |
| Level: | Relatively easy |
| Courses: | Advanced Power BI ReportsFast track Power BI |
| Exercise: | Load movies data and apply conditional formatting to a bar chart. |
| 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 sources |
| Level: | Relatively easy |
| Course: | Fast track Power BI |
| Exercise: | Use Power BI import option to connect and import entire folder of contents. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Basic maps |
| Level: | Relatively easy |
| Courses: | Introduction to Power BIFast track Power BI |
| Exercise: | Create a map showing passenger numbers for UK stations, with drill-down. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Basic maps |
| Level: | Relatively easy |
| Courses: | Introduction to Power BIFast track Power BI |
| Exercise: | Compare sales of goods across the UK for large shopping centres. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Bookmarks |
| Level: | Relatively easy |
| Courses: | Advanced Power BI ReportsFast track Power BI |
| Exercise: | Add a button using a bookmark to clear any slicer filters. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Charts |
| Level: | Relatively easy |
| Courses: | Introduction to Power BIFast track Power BI and DAXFast track 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 |
| Courses: | Introduction to Power BIFast track Power BI and DAXFast track 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 |
| Courses: | Introduction to Power BIFast track Power BI and DAXFast track Power BI |
| Exercise: | Load an Excel workbook of Disney princesses, and create a table from this. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Tooltips |
| Level: | Relatively easy |
| Courses: | Advanced Power BI ReportsFast track Power BI |
| Exercise: | Create a tooltip page showing how gauges work, and assign it to a visual header. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Charts |
| Level: | Relatively easy |
| Courses: | Introduction to Power BIFast track Power BI and DAXFast track Power BI |
| Exercise: | Compare the number of Abba songs released by year using a column chart. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Custom functions |
| Level: | Relatively easy |
| Course: | Advanced Power BI Data |
| Exercise: | Write a custom function to parse dates, and apply it to the rows of a query. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Basic reports |
| Level: | Relatively easy |
| Courses: | Introduction to Power BIFast track Power BI and DAXFast track Power BI |
| Exercise: | Create a matrix and return some appropriate images above. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Filtering data |
| Level: | Relatively easy |
| Courses: | Introduction to Power BIFast track Power BI and DAXFast track Power BI |
| Exercise: | Apply a filter and a slicer by continent to a list of most-visited websites. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Filtering data |
| Level: | Relatively easy |
| Courses: | Introduction to Power BIFast track Power BI and DAXFast track Power BI |
| Exercise: | Apply a page filter to a list of films, then create a slicer by category. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Query editor |
| Level: | Relatively easy |
| Courses: | Introduction to Power BIFast track Power BI and DAXFast track Power BI |
| Exercise: | Use Query Editor to import and tidy up a list of the richest people. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Query editor |
| Level: | Relatively easy |
| Courses: | Introduction to Power BIFast track Power BI and DAXFast track Power BI |
| Exercise: | Use Query Editor to load and tidy up a list of FTSE share prices. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Basic reports |
| Level: | Relatively easy |
| Courses: | Introduction to Power BIFast track Power BI and DAXFast track Power BI |
| Exercise: | Create a report listing Game of Thrones episodes, importing two tables. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Basic reports |
| Level: | Relatively easy |
| Courses: | Introduction to Power BIFast track Power BI and DAXFast track Power BI |
| Exercise: | Create a basic report to show a simple table of Abba songs. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Query editor |
| Level: | Relatively easy |
| Courses: | Introduction to Power BIFast track Power BI and DAXFast track Power BI |
| Exercise: | Importing, tidying up and filtering skyscraper data to create a column chart. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Column transforms |
| Level: | Relatively easy |
| Course: | Advanced Power BI Data |
| Exercise: | Load data showing gun ownership rates by country and tidy it up. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Combining queries |
| Level: | Relatively easy |
| Course: | Advanced Power BI Data |
| Exercise: | Combine four files containing Big Bang Theory episodes into a single query. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Normalising tables |
| Level: | Relatively easy |
| Course: | Advanced Power BI Data |
| Exercise: | Divide a single table of dinosaurs into 3 separate tables (normalisation). |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Analytics |
| Level: | Relatively easy |
| Course: | Advanced Power BI Reports |
| Exercise: | Load a CSV file of running data and show a target line against it. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Power BI mobile |
| Level: | Relatively easy |
| Course: | |
| Exercise: | Try optimising a premade report for use with the Power BI mobile app. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Basic maps |
| Level: | Relatively easy |
| Courses: | Introduction to Power BIFast track Power BI |
| Exercise: | Use ArcGIS to generate a heat map showing train passengers in the UK. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Data sources |
| Level: | Relatively easy |
| Courses: | Introduction to Power BIFast track Power BI and DAXFast track Power BI |
| Exercise: | Create relationships between tables using two methods. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Advanced tables |
| Level: | Relatively easy |
| Course: | Advanced Power BI Reports |
| Exercise: | Make a column into an image URL to list out sports with their icons. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | APIs |
| Level: | Relatively easy |
| Course: | Advanced Power BI Data |
| Exercise: | Use the NASA API to show a random image of somewhere in the Universe. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Calculated columns |
| Level: | Relatively easy |
| Courses: | Introduction to Power BIFast track Power BI |
| Exercise: | Use calculated columns to show a film's length in text format. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Dynamic display |
| Level: | Relatively easy |
| Courses: | Advanced Power BI ReportsFast track Power BI |
| Exercise: | Make a table title dynamic using a quick measure. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Advanced tables |
| Level: | Relatively easy |
| Course: | Advanced Power BI Reports |
| Exercise: | Choose to create two versions of a table with different sorting for each. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Advanced tables |
| Level: | Relatively easy |
| Course: | Advanced Power BI Reports |
| Exercise: | Show a list of total quantities sold by parcel weight. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Simple parameters |
| Level: | Relatively easy |
| Course: | Advanced Power BI Data |
| Exercise: | Create a parameter and apply it to crime statistics to filter the data. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Charts |
| Level: | Relatively easy |
| Courses: | Introduction to Power BIFast track Power BI and DAXFast track Power BI |
| Exercise: | Compare Pizza Express pizza calories using pie and doughnut charts. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Query editor |
| Level: | Relatively easy |
| Courses: | Introduction to Power BIFast track Power BI and DAXFast track Power BI |
| Exercise: | Use the query editor to transform a rubbish data file into something useful. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Drill-through |
| Level: | Average difficulty |
| Courses: | Introduction to Power BIFast track Power BI and DAXFast track Power BI |
| Exercise: | Enable drill-through for a report to show a breakdown of tests taken. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Conditional formatting |
| Level: | Average difficulty |
| Courses: | Advanced Power BI ReportsFast track Power BI |
| Exercise: | Show icons for different values in a table using conditional formatting. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Power BI Templates |
| Level: | Average difficulty |
| Course: | |
| 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 |
| Courses: | Advanced Power BI ReportsFast track Power BI |
| Exercise: | Confusing visual? No problem use bookmarks to create helpful pop ups. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Charts |
| Level: | Average difficulty |
| Courses: | Introduction to Power BIFast track Power BI and DAXFast track Power BI |
| Exercise: | Compare the heights of skyscrapers by country and city, and create a KPI. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Charts |
| Level: | Average difficulty |
| Courses: | Introduction to Power BIFast track Power BI and DAXFast track Power BI |
| Exercise: | Analyse 2018 crime figures for the Manchester area using various visuals. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Basic maps |
| Level: | Average difficulty |
| Courses: | Introduction to Power BIFast track Power BI |
| Exercise: | Create a map comparing house price sales for expensive houses across the UK. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Basic maps |
| Level: | Average difficulty |
| Courses: | Introduction to Power BIFast track Power BI |
| Exercise: | Create a map to show sales by town for selected regions. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Basic reports |
| Level: | Average difficulty |
| Courses: | Introduction to Power BIFast track Power BI and DAXFast track Power BI |
| Exercise: | Use a matrix to compare the number of websites by country and type. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Decomposition tree |
| Level: | Average difficulty |
| Courses: | Advanced Power BI ReportsFast track Power BI |
| Exercise: | Use a decomposition tree visual to analyse box office takings for films. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Filtering data |
| Level: | Average difficulty |
| Courses: | Introduction to Power BIFast track Power BI and DAXFast track Power BI |
| Exercise: | Allow a user to choose pizzas by calorie count and type using slicers. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Charts |
| Level: | Average difficulty |
| Courses: | Introduction to Power BIFast track Power BI and DAXFast track Power BI |
| Exercise: | Create a column chart of record sales, and drill-down to a pie chart. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Tooltips |
| Level: | Average difficulty |
| Courses: | Advanced Power BI ReportsFast track Power BI |
| Exercise: | Show the books for an author in a tooltip when you hover over their name. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Matrices |
| Level: | Average difficulty |
| Courses: | Introduction to Power BIFast track Power BI and DAXFast track Power BI |
| Exercise: | Create a stacked column chart with drill-down, a KPI, a gauge - and more. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Other visuals |
| Level: | Average difficulty |
| Course: | Advanced Power BI Reports |
| Exercise: | Analyse total film Oscars won using breakdowns in a waterfall chart. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Calculated columns |
| Level: | Average difficulty |
| Courses: | Introduction to Power BIFast track Power BI |
| Exercise: | Use the DATEDIFF and IF functions to analyse the length of GoT series. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Calculated columns |
| Level: | Average difficulty |
| Courses: | Introduction to Power BIFast track Power BI |
| Exercise: | Use the RELATED function to combine fields from four tables. |
| 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: | Filtering data |
| Level: | Average difficulty |
| Courses: | Introduction to Power BIFast track Power BI and DAXFast track Power BI |
| Exercise: | Create a date, numeric, dropdown and horizontal slicer on a report. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | APIs |
| Level: | Average difficulty |
| Course: | Advanced Power BI Data |
| Exercise: | Use an API to deal a hand of cards to yourself and show this in Power BI. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Report themes |
| Level: | Average difficulty |
| Course: | |
| 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 |
| Courses: | Advanced Power BI ReportsFast track Power BI |
| Exercise: | Bookmarks can be used to create the illusion of having multiple charts. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Quick measures |
| Level: | Average difficulty |
| Courses: | Advanced Power BI ReportsFast track Power BI |
| Exercise: | Using a quick measure list out all the filters applied to a given page. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Dropdown parameters |
| Level: | Average difficulty |
| Course: | Advanced Power BI Data |
| Exercise: | Create a drop list of hair treatments for users to filter their data model by. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Filtering data |
| Level: | Average difficulty |
| Courses: | Introduction to Power BIFast track Power BI and DAXFast track 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 |
| Courses: | Introduction to Power BIFast track Power BI and DAXFast track Power BI |
| Exercise: | Load FTSE data, and create a report with a table, shape and image. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Custom functions |
| Level: | Average difficulty |
| Course: | Advanced Power BI Data |
| Exercise: | Use a custom function to combine all of the worksheets in a workbook. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Basic reports |
| Level: | Average difficulty |
| Courses: | Introduction to Power BIFast track Power BI and DAXFast track Power BI |
| Exercise: | Load 2 CSV files and one Excel workbook, and use this to report on films. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Filtering data |
| Level: | Average difficulty |
| Courses: | Introduction to Power BIFast track Power BI and DAXFast track 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 |
| Courses: | Introduction to Power BIFast track Power BI and DAXFast track 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: | Manipulation transforms |
| Level: | Average difficulty |
| Course: | Advanced Power BI Data |
| Exercise: | A long exercise loading a list of tube stations, transforming and grouping data. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Query editor |
| Level: | Average difficulty |
| Courses: | Introduction to Power BIFast track Power BI and DAXFast track Power BI |
| Exercise: | Use Query Editor to rename and split columns in a Game of Thrones worksheet. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Column transforms |
| Level: | Average difficulty |
| Course: | Advanced Power BI Data |
| Exercise: | Transforming a dataset showing the followers of different religions. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Advanced data sources |
| Level: | Average difficulty |
| Course: | Fast track 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 |
| Courses: | Advanced Power BI ReportsFast track 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 |
| Courses: | Advanced Power BI ReportsFast track 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 |
| Courses: | Advanced Power BI ReportsFast track 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: | Bookmarks |
| Level: | Average difficulty |
| Courses: | Advanced Power BI ReportsFast track Power BI |
| Exercise: | Clicking between pages breaking immersion? No problem connect pages using bookmark arrows. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Charts |
| Level: | Average difficulty |
| Courses: | Introduction to Power BIFast track Power BI and DAXFast track Power BI |
| Exercise: | Use grouping in charts to show viewing figures by genre for BBC1. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | APIs |
| Level: | Average difficulty |
| Course: | Advanced Power BI Data |
| Exercise: | Use the UK government crime statistics API to show crimes in your area. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Conditional formatting |
| Level: | Average difficulty |
| Courses: | Advanced Power BI ReportsFast track Power BI |
| Exercise: | Apply data bars to a chart to show the length of different films. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Analytics |
| Level: | Average difficulty |
| Course: | Advanced Power BI Reports |
| Exercise: | Load sleep data and add minimum, maximum and trend lines. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Query editor |
| Level: | Average difficulty |
| Courses: | Introduction to Power BIFast track Power BI and DAXFast track Power BI |
| Exercise: | Use Query Editor to cleanse a list of imported top websites. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Advanced data sources |
| Level: | Average difficulty |
| Course: | Fast track 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 |
| Courses: | Introduction to Power BIFast track 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 |
| Courses: | Introduction to Power BIFast track Power BI |
| Exercise: | Calculate average floor areas for tall building data using calculated columns. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Dynamic connections |
| Level: | Average difficulty |
| Course: | Advanced Power BI Data |
| Exercise: | Create a parameter which controls which song playlist you load. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Basic parameters |
| Level: | Average difficulty |
| Course: | |
| 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: | Conditional formatting |
| Level: | Harder than average |
| Courses: | Advanced Power BI ReportsFast track Power BI |
| Exercise: | Use fields containing colour names to apply conditional colours to a chart. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Advanced data sources |
| Level: | Harder than average |
| Course: | Fast track 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 |
| Courses: | Advanced Power BI ReportsFast track Power BI |
| Exercise: | Use quick measures to reference totals which either ignore or take into account filters. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Combining queries |
| Level: | Harder than average |
| Course: | Advanced Power BI Data |
| Exercise: | Merging 3 separate files of data, including unpivoting and other transforms. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Basic reports |
| Level: | Harder than average |
| Courses: | Introduction to Power BIFast track Power BI and DAXFast track 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: | Basic reports |
| Level: | Harder than average |
| Courses: | Introduction to Power BIFast track Power BI and DAXFast track Power BI |
| Exercise: | Compare Oscars won by genre and certificate for films using a matrix. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Basic reports |
| Level: | Harder than average |
| Courses: | Introduction to Power BIFast track Power BI and DAXFast track Power BI |
| Exercise: | Count the number of world events for each country and year. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Charts |
| Level: | Harder than average |
| Courses: | Introduction to Power BIFast track Power BI and DAXFast track Power BI |
| Exercise: | Show a chart comparing films when you click on each genre in a tree map. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Charts |
| Level: | Harder than average |
| Courses: | Introduction to Power BIFast track Power BI and DAXFast track Power BI |
| Exercise: | Compare skills test results using a waterfall chart with breakdown. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Charts |
| Level: | Harder than average |
| Courses: | Introduction to Power BIFast track Power BI and DAXFast track 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 |
| Courses: | Introduction to Power BIFast track Power BI and DAXFast track Power BI |
| Exercise: | Create date and normal slicers on one page to affect visuals on other pages. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Custom functions |
| Level: | Harder than average |
| Course: | Advanced Power BI Data |
| Exercise: | Use a custom function to extract and combine the external links from websites. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Filtering data |
| Level: | Harder than average |
| Courses: | Introduction to Power BIFast track Power BI and DAXFast track Power BI |
| Exercise: | Create linked slicers to show a chart of crime statistics. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Query editor |
| Level: | Harder than average |
| Courses: | Introduction to Power BIFast track Power BI and DAXFast track Power BI |
| Exercise: | Use Query Editor to remove, transform and add columns to a tall buildings list. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Normalising tables |
| Level: | Harder than average |
| Course: | Advanced Power BI Data |
| Exercise: | Transforming a list of book sales and normalising into different tables. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Custom visuals |
| Level: | Harder than average |
| Courses: | Advanced Power BI ReportsFast track Power BI |
| Exercise: | The Synoptic panel can be used to create interactive images or even maps!. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Basic maps |
| Level: | Harder than average |
| Courses: | Introduction to Power BIFast track Power BI |
| Exercise: | Analyse Brexit voting patterns for the countries of the UK, using Electoral Commission data. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Stored procedures |
| Level: | Harder than average |
| Course: | Advanced Power BI Data |
| Exercise: | Pass parameters from a query to a stored procedure in a books database. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Conditional formatting |
| Level: | Harder than average |
| Courses: | Advanced Power BI ReportsFast track Power BI |
| Exercise: | Create 4 tables using data bars, icons and other conditional formatting. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Query editor |
| Level: | Harder than average |
| Courses: | Introduction to Power BIFast track Power BI and DAXFast track Power BI |
| Exercise: | Load some pivoted forecast data, unpivot it and much more!. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Dynamic connections |
| Level: | Harder than average |
| Course: | Advanced Power BI Data |
| Exercise: | Use a dropdown parameter to choose different sets of buildings in M. |
| Software: | Power BI |
| Version: | Latest update |
| Topic: | Calculated columns |
| Level: | Harder than average |
| Courses: | Introduction to Power BIFast track Power BI |
| Exercise: | Add lots of calculated columns to show a matrix summarising house prices. |
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