Course Description
The main purpose of the course is to give students a good understanding of data analysis with Power BI. The course includes perform data transform, develop data modelling, create the visualizations for report and dashboard, and implement the Power BI Service.
Audience
The primary audience for this course is for individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises. The secondary audiences for this course are technically proficient business users.
Prerequisites
Student enrolling in this course should understand the basics of Windows.
They should already have experience working with Microsoft Excel.
Learning Objectives
After completing this course, students will be able to:
Perform DAX to manipulate filter context.
Model data for performance and scalability.
Create a Power BI visualization for report
Course Outline :: Power BI Intermediate::
Module 1: Create Model Calculations using DAX in Power BI
Introduction to DAX
DAX context
Advanced DAX
After completing this module, students will be able to:
Understand DAX
Use DAX for simple formulas and expressions
Create calculated tables and measures
Build simple measures
Work with Time Intelligence and Key Performance Indicators
Module 2: Optimize Model Performance in Power BI
Optimze the model for performance
Optimize DirectQuery Models
Create and manage Aggregations
After completing this module, students will be able to:
Understand the importance of variables
Enhance the data model
Optimize the storage model
Implement aggregations
Module 3: Create Reports in Power BI
Design a report
Enhance the report
After completing this module, students will be able to:
Design a report page layout
Select and add effective visualizations
Add basic report functionality
Add report navigation and interactions
Improve report performance
Design for accessibility
Programme scope, delivery arrangements and suitability are confirmed during enquiry.