WISE OWL EXERCISES
POWER BI EXERCISES
POWER BI EXERCISES
- Basic reports (10)
- Data sources (2)
- Query editor (8)
- Multiple tables (1)
- Filtering data (9)
- Drill-through filtering (1)
- Bookmarks (4)
- Charts (10)
- Other types of visualisation (1)
- Overview of maps (6)
- Calculated columns (7)
- 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)
- Power BI mobile (1)
- Power BI Templates (1)
- Tooltips (2)
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!
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:
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:
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:
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:
|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.