Course Outline
Review and Data Model Design Fundamentals
- Comprehending the data modeling layer within Power BI
- Concepts of star and snowflake schemas
- Establishing and managing inter-table relationships
Introduction to DAX (Data Analysis Expressions)
- DAX syntax and data type structures
- Distinguishing between calculated columns and measures
- Essential DAX functions: SUMX, CALCULATE, FILTER, RELATED
Advanced DAX and Business Logic
- Time intelligence functions (YTD, MTD, QTD)
- Conditional logic and dynamic computation
- Ranking, running totals, and comparative analysis
Data Transformation and Performance Optimization
- Utilizing Power Query for sophisticated transformations
- Efficiently integrating multiple data sources
- Enhancing performance via query folding and relationship management
Advanced Visualizations and User Interactivity
- Implementing custom visuals and market extensions
- Utilizing drill-downs, bookmarks, and what-if parameters
- Generating paginated and dynamic reports
Power BI Performance and Governance
- Best practices for dataset administration
- Optimizing refresh schedules and query efficiency
- Configuring row-level security (RLS)
Practical Project: Constructing a Sales Intelligence Dashboard
- Formulating KPIs using DAX measures
- Designing a model-centric dashboard for strategic insights
- Applying governance standards and sharing protocols
Conclusion and Future Directions
Requirements
- A solid understanding of the Power BI interface and report creation
- Practical experience in constructing dashboards within Power BI
- Fundamental familiarity with data relationships and filtering mechanisms
Target Audience
- Business intelligence professionals
- Data analysts and reporting specialists
- Developers engaged in 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