Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Recap and Data Model Design Principles
- Understanding the data modeling layer in Power BI
- Star and snowflake schema concepts
- Creating and managing relationships between tables
Introduction to DAX (Data Analysis Expressions)
- DAX syntax and data types
- Calculated columns vs. measures
- Common DAX functions: SUMX, CALCULATE, FILTER, RELATED
Advanced DAX and Business Logic
- Time intelligence functions (YTD, MTD, QTD)
- Conditional logic and dynamic calculations
- Ranking, running totals, and comparative metrics
Data Transformation and Optimization
- Working with Power Query for advanced transformations
- Combining multiple data sources efficiently
- Improving performance through query folding and relationships
Enhanced Visualizations and Interactivity
- Custom visuals and market extensions
- Drill-downs, bookmarks, and what-if parameters
- Creating paginated and dynamic reports
Performance and Governance in Power BI
- Best practices for dataset management
- Optimizing refresh schedules and query performance
- Implementing row-level security (RLS)
Hands-on Project: Building a Sales Intelligence Dashboard
- Developing KPIs with DAX measures
- Designing a model-driven dashboard for business insights
- Applying governance and sharing best practices
Summary and Next Steps
Requirements
- An understanding of Power BI interface and report creation
- Experience building dashboards in Power BI
- Basic familiarity with data relationships and filters
Audience
- Business intelligence professionals
- Data analysts and reporting specialists
- Developers working with data visualization and analytics
14 Hours
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 (5)
The manner in which the presenter addressed questions. The method of delivering the course was very beneficial to the students. A very good teacher indeed.
ROSE BALOYI - National Transmission Company South Africa
Course - Power BI: Basics to Advanced
The content was tough but that extra effort I had to put helped me remember and understand power BI better.
Melvin - TLI Group
Course - Power BI DAX Fundamentals
the clear and concise explanations
Georgiana - Everience
Course - Power BI Basic
Discussing about our issues
Rr Dwi Putri Periska Sari - PT. Becton Dickinson Indonesia
Course - Power BI for Developers
What I liked the most was the coach's openness regarding the change in content as well as the approach that was previously prepared to accommodate our real needs
