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 (3)
- Charts (10)
- Other types of visualisation (1)
- Overview of maps (5)
- 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)
- BI mobile (1)
- Power BI Templates (1)
Power BI | Power BI Templates exercise | Basic Power BI Template
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 Power BI pbix report file in the above folder - it should look like this:
You may need to apply the JSON custom theme included in the above folder to get this exact look.
Before saving the report as a template (the point of this exercise), delete the original dataset to get the following:
This will appear to have ruined all your hard work, your life and any hope you had at happiness, but not to worry!
It is high time the report became a Power BI template. To make this happen choose Export from the File menu:
Save the template with the name Basic template and add a suitable description.
Open the template (this will have the effect of creating a new report based upon it).
Use the CSV file in the above folder to repopulate the visuals using different data, and watch as they come to life with interesting facts:
Ok so interesting might not mean compatible, but look how fast that bird is!
Optionally save this as Temperamental Templates and close it down.