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:
Optimizing Model Performance
Create Calculation using DAX
Perform in-depth Reporting
We recommend that you attend Power BI Fundamentals course or have equivalent skills and knowledge.
Introduction to Data Modelling
Joins, Relationships and Cardinality
Many to Many Relationships
Create a Date Table
Optimize Model Performance
Review Performance Results
Optimize Direct Query Models
Create and Manage Aggregations
Create Calculations using DAX
Create Calculated Columns
Build Quick Measures
Use DAX to Build Quick Measures
Choose Effective Visualizations
Import a Custom Visual
Interactions and Drill-throughs
Configure Conditional Formatting
Apply Slicing, Filtering and Sorting
Key Perform and Indicators