Power BI | Overview of maps exercise | Create a basic map analysing station usage by ticket type

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.

The answer to the exercise will be included and explained if you attend one of more of the courses listed below!

Software ==> Power BI  (88 exercises)
Version ==> Latest update
Topic ==> Overview of maps  (5 exercises)
Level ==> Relatively easy
Courses ==> Introduction to Power BI  /  Fast track Power BI/DAX
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.

Open the report in the above folder:

Train statistics

The report contains data on UK station usage in 2017-18, broken down by ticket type.  The data is genuine!

Create a map showing the usage of stations for the region and passenger numbers chosen in the slicers:

The final map

This is only a suggestion for how your map could look.  Make sure you display the Passengers column on your chart, not the Estimated Passengers one.

Add a tooltip field so that you can see which station you're looking at:

Tooltip on report

This shows that we are looking at Waterloo station (as it happens, the busiest station in the UK).

 

Add a table which shows the data for the pie chart slices you select:

Slices Table of data
If you use the Ctrl key to select these slices ... ... you should see the season ticket travel for the 3 stations in question.

Save this report as Meeting your Waterloo, then close it down.

This page has 0 threads Add post