Power BI Advanced

Take your dashboards to the next level: advanced DAX, smarter ETL, better performance, and reports that end users will love using.

 

Power BI Advanced

ABOUT THE EDUCATION

Are Power Query, DAX, measures, and data models no longer unfamiliar to you? Then this advanced training course is the logical next step. In two sessions, you’ll learn expert features that improve your ETL and datasetup and optimize the performance of your reports.
In addition, you make your dashboards more user-friendly for end users and cover the more advanced DAX functions. All topics are actively practiced using datasets and examples, and time is provided for participants' questions.

WHAT YOU CAN DO AFTER THE TRAINING

  • Calculating advanced measures writing with variables in DAX
  • Structuring a KPI table and using DAX in calculated tables
  • Modeling activates passive relationships and sets up hybrid data models
  • Parametrization makes Power Query flexible with parameters and variables
  • Design visual tricks, drill down pages and tooltips for a user-friendly dashboard
  • Automate CSV exports to SharePoint and send PDF dashboards automatically
  • Integrate Power BI into PowerPoint, Teams, Excel, and SharePoint
  • Connecting Power BI to Business Central SaaS

FOR WHO

Professionals from marketing, finance, sales, and management who already have extensive experience developing reports and dashboards in Power BI Desktop and want to expand their skills.

CONDITIONS OF PERMISSION

  • Extensive experience with Power BI Desktop: Power Query, Data Model, and basic DAX

  • Own Windows laptop with the latest Power BI Desktop

  • Power BI Pro license recommended for the parts in the Service

WHAT YOU WILL RECEIVE

  • Datasets and detailed examples of all topics
  • Answers to your own questions and practical case studies
  • Streamline to Power BI with Claude for AI-powered building

 

PROGRAMME

SESSION 1 Dax, model & ETL 

  • Setting up a KPI table
  • Focus on measures with DAX
  • Variables in DAX
  • DAX in calculated tables
  • Using passive relationships
  • Parameters and variables in Power Query
  • Hybrid data models

PART 2  User-friendly & integrated

  • Visual tricks for a strong dashboard
  • Drill down pages and tooltips
  • CSV exports from Power BI to SharePoint
  • Automatically send PDF dashboards
  • Embedding in PowerPoint, Teams, Excel, SharePoint
  • Demo: connection with Business Central SaaS
  • Question round tailored to the participants

Address

📍Corda Campus
Kempische steenweg 311
3500 Hasselt

When

🗓️26 November 2026

⏰ 9 AM to 5 PM

Price

💰600€ (excluding VAT) including lunch. 

Trainer

Silvio Rodriguez
Scapta is a Microsoft partner for Data & AI

Your teacher

Meet Silvio Rodriguez, Managing Partner, Scapta.

  • Author of the handbook “Business Intelligence with Power BI”
  • Master in Business Administration with additional MBA studies
  • Professional career at ING Europe and DEME, among others, in the position of Financial Controller
Write in Book Power BI

Need help or more information about your registration?

Feel free to contact Yentl. She will gladly help you further via Email of by phone He/She looks at the best solution with you.