The Microsoft Power BI - Intermediate course aims to deepen participants' understanding of Power BI by focusing on advanced data modeling, transformation, and analysis techniques. The course covers essential concepts such as data normalization, Power Query transformations, DAX fundamentals, and visualization techniques to build interactive and insightful reports.
Learning Outcomes
Upon successful completion of this course, participants will be able to :
- Understand the different Power BI products and determine when to use Power BI Desktop Free, Pro, and Premium.
- Connect Power BI to various data sources, including SharePoint, Excel, and SQL databases.
- Perform data transformations using Power Query Editor, including filtering, renaming, grouping, and merging data.
- Develop a well-structured data model with optimized relationships, utilizing star and snowflake schemas.
- Use DAX to create calculated columns and measures, and apply X functions for row-by-row calculations.
- Apply data visualization techniques to build meaningful reports, including combo charts, small multiples, and drill-down charts.
- Implement basic row-level security and share reports online through Power BI workspaces and apps.
Who Should Take This Course?
This course is ideal for :
- Professionals who have a foundational understanding of Power BI and wish to enhance their skills in data modeling, transformation, and analysis.
- Individuals responsible for creating and managing Power BI reports and dashboards in their organizations.
- Data analysts, business intelligence professionals, and IT personnel seeking to deepen their Power BI expertise.
Pre-Requisites
Participants are expected to have :
- Basic proficiency in Power BI, including familiarity with Power BI Desktop and fundamental concepts of data visualization.
- An understanding of data structures and relationships, such as tables, rows, and columns.
- No prior experience with advanced Power BI features is required, making this course suitable for those transitioning from beginner to intermediate level.
-
Module 1: Overview of Power BI
- Review Power BI tools and their use cases (Desktop, Service, Mobile).
- Understand the Power BI ecosystem and licensing options.
-
Module 2: The Business Intelligence (BI) Process
- Explore the end-to-end BI workflow.
- Learn how Power BI fits into the broader BI strategy.
-
Module 3: Data Modeling & Transformation
- Understand the importance of data modeling in BI.
- Plan and structure models for efficient reporting.
-
Module 4: Getting Data
- Connect to various data sources (Excel, SQL Server, SharePoint, etc.).
- Explore connection types and data import strategies.
- Apply themes and formatting for professional-looking reports.
-
Module 5: Using Power Query Editor
- Navigate the Power Query interface.
- Apply data shaping and cleaning operations.
-
Module 6: Data Transformations
- Perform key transformations: filtering, merging, appending, grouping.
- Implement best practices for data preparation.
-
Module 7: Data Profiling
- Check data quality using Power Query profiling tools.
- Identify and handle missing or inconsistent data.
-
Module 8: Loading Data
- Understand loading options (DirectQuery vs. Import).
- Optimize performance during the load process.
-
Module 9: Data Modeling and DAX
- Create relationships between tables using star/snowflake schemas.
- Write basic to intermediate DAX formulas for measures and columns.
-
Module 10: The X Functions in DAX
- Use functions like SUMX, AVERAGEX, and others for row-wise calculations.
- Apply X functions to solve complex business logic.
-
Module 11: Quick Measures
- Create quick measures without writing full DAX formulas.
- Understand how to customize and extend these measures.
-
Module 12: Time Intelligence
- Apply time-based calculations such as YTD, QTD, MTD.
- Use built-in time intelligence functions for trend analysis.
-
Module 13: Securing and Sharing Reports
- Implement Row-Level Security (RLS) for data access control.
- Share dashboards via Power BI Service and workspaces.
-
Module 14: Extended Visualizations
- Create advanced visuals: combo charts, drill-through, small multiples.
- Use custom visuals and formatting to enhance report clarity.
-
Module 15: Appendix: Database Normalization
- Understand normalization concepts (1NF, 2NF, 3NF).
- Apply normalization to structure source data effectively.
Upon successfully passing the examination for this course, participants will be awarded a certificate, an example of which is shown below.
Microsoft Power BI - Intermediate
.jpg)
Microsoft Power BI - Intermediate
-
Physical Class 2 Days
-
Online Class 2 Days
-
Language English, Malay