This page has 0 threads | Add post

Exercises

Many people around the world enjoy and benefit from our exercises. If you're one of them - and can afford to - please make a small donation to help keep this and future blogs, exercises, skills assessment tests, tips, tutorials and videos freely available to everyone!

Free Power BI exercises

You are welcome to try any of the 160 Power BI exercises listed below, but please do not distribute them in any form without asking for our written permission first.

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

Show this exercise

Software:	Power BI
Topic:	Basic reports
Level:	Relatively easy
Exercise:	Create a matrix and return some appropriate images above.

Show this exercise

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

Show this exercise

Software:	Power BI
Topic:	Basic reports
Level:	Relatively easy
Exercise:	Import data from a single source and use in the Table visual.

Show this exercise

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

Show this exercise

Software:	Power BI
Topic:	Basic reports
Level:	Average difficulty
Exercise:	Date Matrix with sorted days of the week and Conditional formatting.

Show this exercise

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

Show this exercise

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

Show this exercise

Software:	Power BI
Topic:	Basic reports
Level:	Average difficulty
Exercise:	Table visual with conditional formatting.

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

Software:	Power BI
Topic:	Data sources
Level:	Relatively easy
Exercise:	Create relationships between tables using two methods.

Show this exercise

Software:	Power BI
Topic:	Data sources
Level:	Relatively easy
Exercise:	Import data from multiple Excel sheets and use in the Table visual.

Show this exercise

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

Show this exercise

Software:	Power BI
Topic:	Data sources
Level:	Average difficulty
Exercise:	Import data from multiple source types.

Show this exercise

Software:	Power BI
Topic:	Data sources
Level:	Average difficulty
Exercise:	Manual data model join with Matrix visual.

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

Software:	Power BI
Topic:	Query editor
Level:	Average difficulty
Exercise:	Use Query Editor to cleanse a list of imported top websites.

Show this exercise

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

Show this exercise

Software:	Power BI
Topic:	Query editor
Level:	Average difficulty
Exercise:	Using the Query Editor to transform data.

Show this exercise

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

Show this exercise

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

Show this exercise

Software:	Power BI
Topic:	Filtering data
Level:	Not specified
Exercise:	Using buttons to Apply and Clear Slicers in Power BI Desktop.

Show this exercise

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

Show this exercise

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

Show this exercise

Software:	Power BI
Topic:	Filtering data
Level:	Relatively easy
Exercise:	Apply filters using the filter pane.

Show this exercise

Software:	Power BI
Topic:	Filtering data
Level:	Relatively easy
Exercise:	Synchronising Slicers in Power BI.

Show this exercise

Software:	Power BI
Topic:	Filtering data
Level:	Average difficulty
Exercise:	Adding Slicers to filter your report.

Show this exercise

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

Show this exercise

Software:	Power BI
Topic:	Filtering data
Level:	Average difficulty
Exercise:	Apply filters using the filter pane and a slicer.

Show this exercise

Software:	Power BI
Topic:	Filtering data
Level:	Average difficulty
Exercise:	Create a date, numeric, dropdown and horizontal slicer on a report.

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

Software:	Power BI
Topic:	Filtering data
Level:	Harder than average
Exercise:	Using Slicers in Power BI.

Show this exercise

Software:	Power BI
Topic:	Drill-through
Level:	Relatively easy
Exercise:	Drillthrough in Power BI Desktop.

Show this exercise

Software:	Power BI
Topic:	Drill-through
Level:	Average difficulty
Exercise:	Add Drillthrough to a Power BI report.

Show this exercise

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

Show this exercise

Software:	Power BI
Topic:	Working with visuals
Level:	Relatively easy
Exercise:	Set up Drilldown in a Pie chart.

Show this exercise

Software:	Power BI
Topic:	Working with visuals
Level:	Average difficulty
Exercise:	Create Grouping then use for Drilldown.

Show this exercise

Software:	Power BI
Topic:	Charts
Level:	Relatively easy
Exercise:	Basic Column chart with Formatting.

Show this exercise

Software:	Power BI
Topic:	Charts
Level:	Relatively easy
Exercise:	Compare Pizza Express pizza calories using pie and doughnut charts.

Show this exercise

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

Show this exercise

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

Show this exercise

Software:	Power BI
Topic:	Charts
Level:	Relatively easy
Exercise:	Power BI Waterfall chart with Breakdown.

Show this exercise

Software:	Power BI
Topic:	Charts
Level:	Average difficulty
Exercise:	Analyse 2018 crime figures for the Manchester area using various visuals.

Show this exercise

Software:	Power BI
Topic:	Charts
Level:	Average difficulty
Exercise:	Basic line chart and Small Multiples.

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

Software:	Power BI
Topic:	Charts
Level:	Harder than average
Exercise:	Compare skills test results using a waterfall chart with breakdown.

Show this exercise

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

Show this exercise

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

Show this exercise

Software:	Power BI
Topic:	Matrices
Level:	Average difficulty
Exercise:	Create a stacked column chart with drill-down, a KPI, a gauge - and more.

Show this exercise

Software:	Power BI
Topic:	Basic maps
Level:	Relatively easy
Exercise:	Azure filled map using Tall buildings data.

Show this exercise

Software:	Power BI
Topic:	Basic maps
Level:	Relatively easy
Exercise:	Compare sales of goods across the UK for large shopping centres.

Show this exercise

Software:	Power BI
Topic:	Basic maps
Level:	Relatively easy
Exercise:	Create a map showing passenger numbers for UK stations, with drill-down.

Show this exercise

Software:	Power BI
Topic:	Basic maps
Level:	Relatively easy
Exercise:	Use ArcGIS to generate a heat map showing train passengers in the UK.

Show this exercise

Software:	Power BI
Topic:	Basic maps
Level:	Average difficulty
Exercise:	Create a map comparing house price sales for expensive houses across the UK.

Show this exercise

Software:	Power BI
Topic:	Basic maps
Level:	Average difficulty
Exercise:	Create a map to show sales by town for selected regions.

Show this exercise

Software:	Power BI
Topic:	Basic maps
Level:	Average difficulty
Exercise:	Various Azure maps using Tall buildings data.

Show this exercise

Software:	Power BI
Topic:	Basic maps
Level:	Harder than average
Exercise:	Analyse Brexit voting patterns for the countries of the UK, using Electoral Commission data.

Show this exercise

Software:	Power BI
Topic:	Calculated columns
Level:	Relatively easy
Exercise:	Basic Calculated Columns.

Show this exercise

Software:	Power BI
Topic:	Calculated columns
Level:	Relatively easy
Exercise:	Conditional functions in DAX calculated columns.

Show this exercise

Software:	Power BI
Topic:	Calculated columns
Level:	Relatively easy
Exercise:	Create a calculated column in a calendar table dividing the year into thirds.

Show this exercise

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

Show this exercise

Software:	Power BI
Topic:	Calculated columns
Level:	Relatively easy
Exercise:	Use calculated columns to show a film's length in text format.

Show this exercise

Software:	Power BI
Topic:	Calculated columns
Level:	Average difficulty
Exercise:	Basic Calculated Columns.

Show this exercise

Software:	Power BI
Topic:	Calculated columns
Level:	Average difficulty
Exercise:	Calculate average floor areas for tall building data using calculated columns.

Show this exercise

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

Show this exercise

Software:	Power BI
Topic:	Calculated columns
Level:	Average difficulty
Exercise:	Use conditional functions like IF, SWITCH and AND to create calculated columns in a report on music tours.

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

Software:	Power BI
Topic:	Drill-through and bookmarks
Level:	Average difficulty
Exercise:	Drillthrough in Power BI Desktop using Summarize.

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

Software:	Power BI
Topic:	Advanced tables
Level:	Relatively easy
Exercise:	Add Images and Clickable links to a Power BI table.

Show this exercise

Software:	Power BI
Topic:	Advanced tables
Level:	Relatively easy
Exercise:	Choose to create two versions of a table with different sorting for each.

Show this exercise

Software:	Power BI
Topic:	Advanced tables
Level:	Relatively easy
Exercise:	Make a column into an image URL to list out sports with their icons.

Show this exercise

Software:	Power BI
Topic:	Advanced tables
Level:	Relatively easy
Exercise:	Multi level sorting in Power BI Table.

Show this exercise

Software:	Power BI
Topic:	Advanced tables
Level:	Relatively easy
Exercise:	Show a list of total quantities sold by parcel weight.

Show this exercise

Software:	Power BI
Topic:	Conditional formatting
Level:	Relatively easy
Exercise:	Column chart Dynamic formatting.

Show this exercise

Software:	Power BI
Topic:	Conditional formatting
Level:	Relatively easy
Exercise:	Conditional formatting in Power BI.

Show this exercise

Software:	Power BI
Topic:	Conditional formatting
Level:	Relatively easy
Exercise:	Load movies data and apply conditional formatting to a bar chart.

Show this exercise

Software:	Power BI
Topic:	Conditional formatting
Level:	Average difficulty
Exercise:	Apply data bars to a chart to show the length of different films.

Show this exercise

Software:	Power BI
Topic:	Conditional formatting
Level:	Average difficulty
Exercise:	Column chart Dynamic formatting using Rules.

Show this exercise

Software:	Power BI
Topic:	Conditional formatting
Level:	Average difficulty
Exercise:	Conditional formatting in Power BI using Fields.

Show this exercise

Software:	Power BI
Topic:	Conditional formatting
Level:	Average difficulty
Exercise:	Show icons for different values in a table using conditional formatting.

Show this exercise

Software:	Power BI
Topic:	Conditional formatting
Level:	Harder than average
Exercise:	Create 4 tables using data bars, icons and other conditional formatting.

Show this exercise

Software:	Power BI
Topic:	Conditional formatting
Level:	Harder than average
Exercise:	Use fields containing colour names to apply conditional colours to a chart.

Show this exercise

Software:	Power BI
Topic:	Analytics
Level:	Relatively easy
Exercise:	Load a CSV file of running data and show a target line against it.

Show this exercise

Software:	Power BI
Topic:	Analytics
Level:	Relatively easy
Exercise:	Using Average and Constant line analytics in Power BI.

Show this exercise

Software:	Power BI
Topic:	Analytics
Level:	Relatively easy
Exercise:	Using Max, Min and Trend lines in Power BI charts.

Show this exercise

Software:	Power BI
Topic:	Analytics
Level:	Average difficulty
Exercise:	Load sleep data and add minimum, maximum and trend lines.

Show this exercise

Software:	Power BI
Topic:	Decomposition tree
Level:	Relatively easy
Exercise:	Decomposition tree visual showing box office takings for films.

Show this exercise

Software:	Power BI
Topic:	Decomposition tree
Level:	Average difficulty
Exercise:	Use a decomposition tree visual to analyse box office takings for films.

Show this exercise

Software:	Power BI
Topic:	Other visuals
Level:	Relatively easy
Exercise:	Using Cards to show key data.

Show this exercise

Software:	Power BI
Topic:	Other visuals
Level:	Relatively easy
Exercise:	Using Explain Increase/Decrease in Power BI charts.

Show this exercise

Software:	Power BI
Topic:	Other visuals
Level:	Relatively easy
Exercise:	Using Text box values and Smart narratives in Power BI.

Show this exercise

Software:	Power BI
Topic:	Other visuals
Level:	Average difficulty
Exercise:	Adding a Gauge visual with a Target and Conditional formatting.

Show this exercise

Software:	Power BI
Topic:	Other visuals
Level:	Average difficulty
Exercise:	Analyse total film Oscars won using breakdowns in a waterfall chart.

Show this exercise

Software:	Power BI
Topic:	Other visuals
Level:	Average difficulty
Exercise:	Using a KPI visual with a Slicer.

Show this exercise

Software:	Power BI
Topic:	Other visuals
Level:	Average difficulty
Exercise:	Using the new Card visual to show various items of key data.

Show this exercise

Software:	Power BI
Topic:	Tooltips
Level:	Relatively easy
Exercise:	Adding basic Tooltips in Power BI Desktop.

Show this exercise

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

Show this exercise

Software:	Power BI
Topic:	Tooltips
Level:	Average difficulty
Exercise:	Adding a Visual header and Dynamic Tooltip in Power BI Desktop.

Show this exercise

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

Show this exercise

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

Show this exercise

Software:	Power BI
Topic:	Bookmarks
Level:	Relatively easy
Exercise:	Using Bookmarks in Power BI Desktop.

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

Software:	Power BI
Topic:	Bookmarks
Level:	Average difficulty
Exercise:	Using Bookmarks in Power BI Desktop.

Show this exercise

Software:	Power BI
Topic:	Quick measures
Level:	Average difficulty
Exercise:	Creating Quick measures in Power BI.

Show this exercise

Software:	Power BI
Topic:	Quick measures
Level:	Average difficulty
Exercise:	Creating Quick measures in Power BI.

Show this exercise

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

Show this exercise

Software:	Power BI
Topic:	Quick measures
Level:	Average difficulty
Exercise:	Using a quick measure list out all the filters applied to a given page.

Show this exercise

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

Show this exercise

Software:	Power BI
Topic:	Dynamic display
Level:	Relatively easy
Exercise:	Make a table title dynamic using a quick measure.

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

Software:	Power BI
Topic:	Advanced data sources
Level:	Relatively easy
Exercise:	Use Power BI import option to connect and import entire folder of contents.

Show this exercise

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

Show this exercise

Software:	Power BI
Topic:	Advanced data sources
Level:	Average difficulty
Exercise:	Use the Merge option to combine two tables in Power BI into one.

Show this exercise

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

Show this exercise

Software:	Power BI
Topic:	Basic parameters
Level:	Average difficulty
Exercise:	Creating a Field Parameter in Power BI Desktop.

Show this exercise

Software:	Power BI
Topic:	Basic parameters
Level:	Average difficulty
Exercise:	Use parameters to filter data before it enters the data model.

Show this exercise

Software:	Power BI
Topic:	Column transforms
Level:	Relatively easy
Exercise:	Load data showing gun ownership rates by country and tidy it up.

Show this exercise

Software:	Power BI
Topic:	Column transforms
Level:	Average difficulty
Exercise:	Transforming a dataset showing the followers of different religions.

Show this exercise

Software:	Power BI
Topic:	Combining queries
Level:	Relatively easy
Exercise:	Combine four files containing Big Bang Theory episodes into a single query.

Show this exercise

Software:	Power BI
Topic:	Combining queries
Level:	Harder than average
Exercise:	Merging 3 separate files of data, including unpivoting and other transforms.

Show this exercise

Software:	Power BI
Topic:	Manipulation transforms
Level:	Average difficulty
Exercise:	A long exercise loading a list of tube stations, transforming and grouping data.

Show this exercise

Software:	Power BI
Topic:	Normalising tables
Level:	Relatively easy
Exercise:	Divide a single table of dinosaurs into 3 separate tables (normalisation).

Show this exercise

Software:	Power BI
Topic:	Normalising tables
Level:	Harder than average
Exercise:	Transforming a list of book sales and normalising into different tables.

Show this exercise

Software:	Power BI
Topic:	Simple parameters
Level:	Relatively easy
Exercise:	Create a parameter and apply it to crime statistics to filter the data.

Show this exercise

Software:	Power BI
Topic:	Dropdown parameters
Level:	Average difficulty
Exercise:	Create a drop list of hair treatments for users to filter their data model by.

Show this exercise

Software:	Power BI
Topic:	Stored procedures
Level:	Harder than average
Exercise:	Pass parameters from a query to a stored procedure in a books database.

Show this exercise

Software:	Power BI
Topic:	Dynamic connections
Level:	Average difficulty
Exercise:	Create a parameter which controls which song playlist you load.

Show this exercise

Software:	Power BI
Topic:	Dynamic connections
Level:	Harder than average
Exercise:	Use a dropdown parameter to choose different sets of buildings in M.

Show this exercise

Software:	Power BI
Topic:	Custom functions
Level:	Relatively easy
Exercise:	Write a custom function to parse dates, and apply it to the rows of a query.

Show this exercise

Software:	Power BI
Topic:	Custom functions
Level:	Average difficulty
Exercise:	Use a custom function to combine all of the worksheets in a workbook.

Show this exercise

Software:	Power BI
Topic:	Custom functions
Level:	Harder than average
Exercise:	Use a custom function to extract and combine the external links from websites.

Show this exercise

Software:	Power BI
Topic:	APIs
Level:	Relatively easy
Exercise:	Use the NASA API to show a random image of somewhere in the Universe.

Show this exercise

Software:	Power BI
Topic:	APIs
Level:	Average difficulty
Exercise:	Use an API to deal a hand of cards to yourself and show this in Power BI.

Show this exercise

Software:	Power BI
Topic:	APIs
Level:	Average difficulty
Exercise:	Use the UK government crime statistics API to show crimes in your area.

Show this exercise

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

Show this 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 Power BI training courses? You can attend our online training classes wherever you are in the world!

This page has 0 threads

Add a new post

EXERCISE TOPIC

POWER BI EXERCISES

POWER BI EXERCISES

Free Power BI exercises

Head office

London

Manchester