WISE OWL EXERCISES
POWER BI EXERCISES
POWER BI DESKTOP EXERCISES
Power BI Desktop | Charts exercise | Show BBC1 viewing figures by genre, using chart grouping
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 the course 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.
Create a new Power BI Desktop file, and load the data from the workbook in the above folder (you can get a link to the figures here, should you be interested in further research!).
Use Query Editor to display the name of each program and its viewing figures:
You'll need to split the program name by the ( symbol. All good practice!
Create a pie chart showing the average number of viewers by program:
This pie chart probably makes sense - it shows the share of each program of total viewing figures (for the top 10 programs on the BBC in the first week of November 2016).
Create four groups for the programs:
Four groups that you could create. You can start the process off by right-clicking on one or more of the pie chart slices and choosing Groups.
Use these to show a far less meaningful (albeit prettier) pie chart:
Is it meaningful to show the average viewing figures by genre? Probably not, but it makes for a good exercise.
Save this as Demelza for PM, and close down the Power BI instance containing it.