Course Outline
Review of Principles and Data Model Design
- Exploring the data modeling layer within Power BI
- Concepts of star and snowflake schemas
- Establishing and managing inter-table relationships
Foundations of DAX (Data Analysis Expressions)
- DAX syntax and supported data types
- Distinguishing between calculated columns and measures
- Key DAX functions: SUMX, CALCULATE, FILTER, RELATED
Advanced DAX Applications and Business Logic
- Time intelligence functions (YTD, MTD, QTD)
- Incorporating conditional logic and dynamic calculations
- Calculating rankings, running totals, and comparative metrics
Data Transformation and Performance Optimization
- Utilizing Power Query for advanced data transformations
- Efficiently integrating multiple data sources
- Enhancing performance through query folding and optimized relationships
Advanced Visualizations and Interactive Features
- Implementing custom visuals and marketplace extensions
- Using drill-downs, bookmarks, and what-if parameters
- Constructing paginated and dynamic reports
Performance Management and Governance in Power BI
- Best practices for maintaining datasets
- Optimizing refresh schedules and query execution
- Enforcing row-level security (RLS)
Practical Project: Constructing a Sales Intelligence Dashboard
- Creating KPIs utilizing DAX measures
- Designing model-driven dashboards to drive business insights
- Applying governance and data sharing best practices
Wrap-up and Future Recommendations
Requirements
- A solid grasp of the Power BI interface and report creation workflows
- Practical experience in building dashboards within Power BI
- Foundational knowledge of data relationships and filtering mechanisms
Target Audience
- Business intelligence professionals
- Data analysts and reporting specialists
- Developers focused on data visualization and analytics
Testimonials (4)
How to use relationships in Power BIand the differences between columns and measurements
LEUNG Chun Hei - HAESL
Course - Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics
The application of Data Modelling and DAX
Rachel KY Wong - HAESL
Course - Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics
Emoji setting. SharePoint data source linkage. Concept of DAX in measure and column.
Lam Chit Wui (Ray) - HAESL
Course - Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics
Calculate, Measure