Get in Touch
 Duration 14 hours

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.
Investment

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)

Provisional Upcoming Courses (Contact Us For More Information)

Related Categories