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 relationships between tables
Fundamentals of DAX (Data Analysis Expressions)
- DAX syntax and data type handling
- Differences between calculated columns and measures
- Essential DAX functions: SUMX, CALCULATE, FILTER, and RELATED
Advanced DAX and Business Logic
- Time intelligence functions (YTD, MTD, QTD)
- Conditional logic and dynamic calculation techniques
- Ranking, running totals, and comparative metric analysis
Data Transformation and Optimization
- Utilizing Power Query for sophisticated transformations
- Efficiently integrating multiple data sources
- Enhancing performance via query folding and relationship management
Advanced Visualizations and Interactivity
- Incorporating custom visuals and marketplace extensions
- Implementing drill-downs, bookmarks, and what-if parameters
- Creating paginated and dynamic reports
Performance and Governance in Power BI
- Best practices for dataset administration
- Optimizing refresh schedules and query execution speed
- Configuring row-level security (RLS)
Practical Project: Constructing a Sales Intelligence Dashboard
- Defining KPIs using DAX measures
- Building a model-centric dashboard for actionable business insights
- Applying governance and secure sharing protocols
Conclusion and Future Steps
Requirements
- Familiarity with the Power BI interface and report generation
- Experience creating dashboards in Power BI
- Basic knowledge of data relationships and filtering mechanisms
Target Audience
- Business intelligence professionals
- Data analysts and reporting specialists
- Developers focused on data visualization and analytics
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 3200 € + VAT*
Contact us for an exact quote and to hear our latest promotions
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