Cursusaanbod

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

Vereisten

  • 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 Uren

Leveringsopties

PRIVÉGROEPSTRAINING

Onze identiteit draait om het leveren van precies wat onze klanten nodig hebben.

  • Pre-cursusgesprek met uw trainer
  • Aanpassing van de leerervaring om uw doelen te bereiken -
    • Op maat gemaakte overzichten
    • Praktische, praktische oefeningen met gegevens / scenario's die herkenbaar zijn voor de cursisten
  • Training gepland op een datum naar keuze
  • Gegeven online, op locatie/klaslokaal of hybride door experts die ervaring uit de echte wereld delen

Private Group Prices RRP from €4560 online delivery, based on a group of 2 delegates, €1440 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.

Neem contact met ons op voor een exacte offerte en om onze laatste promoties te horen


OPENBARE TRAINING

Kijk op onze public courses

Reviews (5)

Voorlopige Aankomende Cursussen

Gerelateerde categorieën