Course Outline
Review and Data Model Design Principles
- 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 data type handling
- Distinguishing between calculated columns and measures
- Key DAX functions: SUMX, CALCULATE, FILTER, RELATED
Advanced DAX and Business Logic Implementation
- Utilizing time intelligence functions (YTD, MTD, QTD)
- Implementing conditional logic and dynamic calculations
- Creating rankings, running totals, and comparative metrics
Data Transformation and Performance Optimization
- Executing advanced transformations with Power Query
- Efficiently integrating multiple data sources
- Enhancing performance via query folding and relationship optimization
Enhanced Visualizations and User Interactivity
- Incorporating custom visuals and market extensions
- Utilizing drill-downs, bookmarks, and what-if parameters
- Developing paginated and dynamic reports
Performance Management and Governance in Power BI
- Best practices for dataset administration
- Optimizing refresh schedules and query execution speed
- Implementing row-level security (RLS)
Practical Project: Constructing a Sales Intelligence Dashboard
- Defining KPIs using DAX measures
- Designing a model-driven dashboard for strategic business insights
- Applying governance standards and sharing best practices
Conclusions and Future Directions
Requirements
- Familiarity with the Power BI interface and report creation workflows
- Practical experience in constructing Power BI dashboards
- Foundational knowledge of data relationships and filtering mechanisms
Target Audience
- Business intelligence specialists
- Data analysts and reporting experts
- 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