Course Outline
Review and Data Model Design Fundamentals
- Exploring 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 supported data types
- Distinguishing between calculated columns and measures
- Essential DAX functions: SUMX, CALCULATE, FILTER, RELATED
Advanced DAX and Business Logic Implementation
- Time intelligence functions (YTD, MTD, QTD)
- Incorporating conditional logic and dynamic computations
- Implementing rankings, running totals, and comparative metrics
Data Transformation and Performance Optimization
- Utilizing Power Query for complex transformations
- Efficiently integrating multiple data sources
- Enhancing performance via query folding and relationship optimization
Advanced Visualizations and Interactivity
- Incorporating custom visuals and marketplace extensions
- Leveraging drill-downs, bookmarks, and what-if parameters
- Generating paginated and dynamic reports
Performance Management and Governance in Power BI
- Best practices for dataset administration
- Optimizing refresh schedules and query execution speed
- Configuring row-level security (RLS)
Practical Project: Creating a Sales Intelligence Dashboard
- Building KPIs using DAX measures
- Designing a model-driven dashboard for actionable business insights
- Applying governance and sharing best practices
Conclusion and Future Steps
Requirements
- Familiarity with the Power BI interface and report creation processes
- Practical experience in constructing 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