Power BI | Calculated columns exercise | Create simple data model combining four tables

This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

Software ==> Power BI  (111 exercises)
Version ==> Latest update
Topic ==> Calculated columns  (8 exercises)
Level ==> Average difficulty
Subject ==> Power BI training
Before you can do this exercise, you'll need to download and unzip this file (if you have any problems doing this, click here for help).

You need a minimum screen resolution of about 700 pixels width to see our exercises. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Create a new Power BI report, and load data from the workbook in the above folder:

World events data

Load all four worksheets (the data gives a list of famous events in history).

 

In Model View, create the obvious relationships between the tables:

Relationships

Link the Event table to the Country and Category tables by the obvious columns.

Using the RELATED function, create calculated columns in the Event table to bring in the country, continent and category for each event to get this:

Columns in events table

By hiding the other columns in the events table (and hiding the other tables), this should be the only thing you see in Report View.

 

The syntax of the RELATED function is =RELATED(TableName[ColumnName]).

Create a matrix (it doesn't have to be formatted at all) to show the number of events by category and continent:

Matrix of events

A slight European bias, perhaps ...

Save this report as Tidy data model, then close it down.

You can unzip this file to see the answers to this exercise, although please remember this is for your personal use only.
This page has 0 threads Add post