The Microsoft Power BI - Advanced course is designed to deepen participants' expertise in Power BI by focusing on advanced data modeling, DAX calculations, evaluation contexts, and integration with various data sources. The course aims to equip learners with the skills necessary to create high-performance reports and dashboards that support complex business intelligence needs.
Learning Outcomes
Upon successful completion of this course, participants will be able to :
- Protect and share workbooks securely by using password protection, cell locking, and change tracking.
- Perform sophisticated data analysis using built-in tools such as Goal Seek, Solver, Scenario Manager, and Data Tables.
- Automate repetitive tasks by creating and running simple macros.
- Master advanced DAX functions and understand evaluation contexts to perform complex calculations.
- Implement dynamic Row-Level Security (RLS) using DAX to control data access.
- Utilize advanced filtering techniques for optimized data analysis.
- Integrate and work with API and real-time streaming data sources.
- Customize reports with advanced features such as drill-throughs and tooltips.
- Apply advanced Power Query M Language for sophisticated data transformations.
Who Should Take This Course?
This course is ideal for :
- Data analysts and business intelligence professionals seeking to enhance their Power BI skills.
- Individuals responsible for creating and managing complex Power BI reports and dashboards.
- Professionals aiming to implement advanced data security and real-time data integration within Power BI.
Pre-requisites
Participants are expected to have :
- A solid understanding of Power BI fundamentals, including data modeling and basic DAX functions.
- Experience with Power Query for data transformation tasks.
- Familiarity with creating reports and dashboards in Power BI.
-
Module 1: Advanced Data Modeling
- Refine data models for performance and scalability.
- Understand best practices for relationships, star schemas, and data granularity.
-
Module 2: Introduction to DAX (Data Analysis Expressions)
- Learn DAX fundamentals for building complex analytical expressions.
- Differentiate between calculated columns and measures.
-
Module 3: DAX - Measures and Filters
- Create and apply advanced measures.
- Utilize filter functions to control data visibility and calculations.
-
Module 4: DAX - The CALCULATE Function
- Master the use of the CALCULATE function for context modification.
- Apply CALCULATE in nested and multi-condition scenarios.
-
Module 5: DAX - Evaluation Contexts
- Understand row context, filter context, and how they interact.
- Explore how context influences measure results.
-
Module 6: DAX - Rules of Evaluation
- Grasp the order and logic Power BI uses to evaluate expressions.
- Troubleshoot complex calculations with confidence.
-
Module 7: Working with a Date Dimension
- Build and implement a custom date table.
- Use the date dimension for time intelligence (YTD, QTD, MTD)
-
Module 8: Extended Topic A: API Data Sources
- Connect to and extract data from APIs.
- Parse JSON and other API response formats using Power Query.
-
Module 9: Extended Topic B: Streaming Data Sources
- Set up and integrate real-time data sources in Power BI.
- Understand scenarios for streaming datasets and dashboards.
-
Module 10: Extended Topic C: Files in Folders
- Import and transform multiple files from a folder.
- Automate file ingestion processes with Power Query.
-
Module 11: Extended Topic D: Query Parameters (Dynamic Web Queries)
- Use query parameters to build dynamic, user-driven web data extractions.
- Apply parameters for flexible data access and automated updates.
Upon successfully passing the examination for this course, participants will be awarded a certificate, an example of which is shown below.
Microsoft Power BI - Advanced
.jpg)
Microsoft Power BI - Advanced
-
Physical Class 2 Days
-
Online Class 2 Days
-
Language English, Malay