With PowerBI Desktop, you get a report authoring tool that enables you to connect and query data from different sources using the Query Editor. From the datasets you build with Query Editor you can add visualisations and create reports. Reports can then be published.
The course builds on the skills learnt in our Power BI Fundamentals course and introduces you to more features including data modelling, performance optimization and more complex reporting.
Please note that this course does not cover PowerBI Pro, PowerBI accessed via Microsoft 365 or SharePoint Services.
By actively participating in this course, you will learn about the following:
Data Modelling
Create Calculation using DAX
Perform in-depth Reporting
We recommend that you attend our M365PBIF - Power BI Fundamentals course or have equivalent skills and knowledge.
Software Requirements for Virtual Classroom
If you are attending our Virtual Classroom training, you will need a laptop or PC with a working microphone and two screens. A webcam is also recommended for the best experience! You will also need to have both Power BI Desktop and Power BI Service (part of Microsoft 365 Apps), available on your device.
PowerBI Service is what Microsoft call the version of PowerBi found in their M365 subscription list of apps. It wont be there as a default and is something your Microsoft 365 administrator would have to enable. It is free of charge and literally just a tick box. They will need access to this as this is where reports are published to and the only place where Dashboards can be created. Plus, all of the sharing and collaboration options are to be found here.
We strongly recommend that delegates also check that their PC meets the Minimum Requirements as outlined on the Microsoft Website in order to run Power BI effectively. Please note however that although Microsoft recommend 4GB of memory (RAM), in our experience it is advisable to have at least 8GB available to reduce slow upload times and the possibility of a PC crashing during the course.
This course is not suitable for MAC users.
Data Modelling
Introduction to Data Modelling
Joins, Relationships and Cardinality
Many to Many Relationships
Star Schemas
Create a Date Table
Create Calculations using DAX
Create Calculated Columns
Build Quick Measures
Use DAX to Build Quick Measures
Join Types
Reporting
Choose Effective Visualizations
Import a Custom Visual
Interactions and Drill-throughs
Configure Conditional Formatting
Apply Slicing, Filtering and Sorting
Key Perform and Indicators