This is an example of a simple banner

Training: Power BI – Intensive Preparation for the PL-300 Certification

Ref. MPB-E1
Duration:
2
 jours
Exam:
Not certifying
Level:
Expert

Power BI – Intensive Preparation for the PL-300 Certification

Effectively prepare for your PL-300 certification with an intensive and structured approach

Already using Power BI and looking to validate your skills with a recognized certification? This two-day intensive training is designed to efficiently prepare you for Microsoft’s PL-300 certification. With a hands-on approach, you’ll strengthen your knowledge while adopting best practices in the field.

The program is built around practical exercises, guided labs, and real-world exam scenarios. Each module helps you become confident and independent in key Power BI areas: data connectivity, modeling, visualization, DAX, performance tuning, governance, and security. Everything is structured to give you the best possible chance of passing the certification.

A focused, results-driven format

Designed to go straight to the point, this course offers a short but intensive format. In just two days, you’ll review all the core competencies assessed in the PL-300 exam. You’ll save time, gain efficiency, and boost your confidence.

Participant Profiles

  • Data analysts
  • Business analysts
  • Advanced Power BI users
  • BI professionals preparing for the PL-300 certification

Objectives

  • Connect and interact with various data sources
  • Clean and transform data using Power Query
  • Model data effectively for analysis
  • Create DAX calculations tailored to business needs
  • Optimize model and report performance
  • Build interactive and readable reports
  • Use advanced visualization features
  • Implement security and governance rules

Prerequisites

Course Content

Module 1: Connecting to data sources

  • Types of data sources and connection options
  • Import vs DirectQuery vs Live connection
  • Source parameters and configurations
  • Practice: Data connection scenarios, semantic model connections

Module 2: Data profiling and cleaning

  • Assessing data quality and statistics
  • Handling null values, inconsistencies, and import errors
  • Practice: Data cleaning lab with Power Query

Module 3: Data transformation and loading

  • Column transformations, aggregations, and pivoting
  • Creating fact and dimension tables
  • Using reference queries vs duplicated queries
  • Merge/append operations, load settings

Module 4: Data modeling fundamentals

  • Table properties, relationships, cross-filtering, cardinality
  • Role-playing dimensions, date tables
  • Calculated tables vs calculated columns
  • Practice: Modeling based on real datasets

Module 5: DAX calculations

  • Measures vs calculated columns
  • Time intelligence (YTD, MTD, same period last year)
  • Quick measures, semi-additive metrics
  • Calculation groups and statistical functions

Module 6: Performance optimization

  • Identifying and removing model inefficiencies
  • Using Performance Analyzer and DAX query view
  • Reducing granularity and simplifying models
  • Review: Performance optimization checklist

Module 7: Report creation and analysis

  • Selecting and formatting visuals
  • Filtering, slicing, drillthrough, tooltips
  • Mobile view, export settings, customization
  • Practice: Report creation with storytelling logic
  • Mini-challenge: Rebuild a report using UX/UI best practices

Module 8: Advanced visuals and insights

  • Bookmarks, grouping, selection pane
  • Forecasting, AI visuals, anomaly detection
  • Sync slicers and navigation logic

Module 9: Governance and security

  • Workspaces, apps, distribution
  • Gateways, refresh scheduling
  • Row-level security, access control
  • Practice: RLS configuration lab and workspace setup

Documentation

  • Digital course material included

Complementary Courses

Eligible Funding

ITTA is a partner of a continuing education fund dedicated to temporary workers. This fund can subsidize your training, provided that you are subject to the “Service Provision” collective labor agreement (CCT) and meet certain conditions, including having worked at least 88 hours in the past 12 months.

Additional Information

An intensive training to structure your business intelligence skills

Mastering Power BI goes far beyond building charts. This intensive program is designed to structure your knowledge, refine your analytical methods, and give you a complete understanding of what the tool offers in a professional setting. In just two days, participants receive targeted, results-oriented guidance aligned with the PL-300 certification standards.

This condensed format allows you to focus on the essentials: understanding the core principles of a data visualization project from start to finish. From data collection to report sharing, each step is addressed through concrete examples based on real-world business scenarios. The goal is not only to pass an exam but to confidently apply best practices on the job.

Developing a structured analytical mindset

One of Power BI’s strengths is making analysis accessible without sacrificing technical depth. This training offers an immersive experience in modeling, calculations, and data representation through a logical approach. You’ll learn how to build reliable models, identify meaningful relationships between tables, and design indicators that clearly speak to end users.

Special attention is given to report design, incorporating principles of readability, navigation, and interactivity. You’ll build dashboards that make sense—both in content and presentation—using realistic business use cases and datasets.

Boosting performance and mastering governance

Once the fundamentals are in place, it’s time to go further. Power BI includes many tools to assess model performance, identify bottlenecks, and optimize complex queries. This training teaches you how to troubleshoot and resolve issues before they affect production environments.

Governance is a key focus. In a business context, managing access, securing data, and distributing reports are critical responsibilities. You’ll learn to set up workspaces, schedule data refreshes, and implement row-level security to control information sharing across your organization.

Learning by doing: a practical, hands-on format

One of the highlights of this training is its active, practical format. At every step, you apply what you’ve learned through targeted exercises and mini-projects. This approach helps you retain concepts and develop real-world habits. You won’t just follow along—you’ll build your expertise through hands-on practice.

Each participant leaves with a clear methodology, immediately applicable tools, and a solid preparation for the PL-300 exam. The training provides both technical and strategic support to help you become more efficient in your day-to-day work.

FAQ

Is this training suitable for self-taught users?
Yes. If you’ve been using Power BI independently and want to structure your knowledge, this training is a great fit.

Do I need a previous Microsoft certification?
No. There are no certification prerequisites. You just need practical Power BI experience and basic knowledge of data modeling.

Is the content focused only on passing the exam?
No. The program also aims to strengthen your professional skills and help you apply best practices to real-world projects.

Is there support after the training?
You’ll receive course materials, exercises, and guidance to plan your certification exam, but the training itself ends after the two intensive days.

Does this course cover the latest Power BI features?
Yes. It is regularly updated to reflect important new features and evolving standards of the Microsoft Power BI platform.

Prix de l'inscription
CHF 1'700.-
Inclus dans ce cours
  • Training delivered by a subject matter expert
  • Digital documentation and learning materials
  • Completion badge
Mois actuel

lun19Mai(Mai 19)09:00mar20(Mai 20)17:00VirtuelVirtual Etiquettes de sessionMPB-E1

lun19Mai(Mai 19)09:00mar20(Mai 20)17:00Genève, Route des Jeunes 35, 1227 Carouge Etiquettes de sessionMPB-E1

lun23Juin(Juin 23)09:00mar24(Juin 24)17:00VirtuelVirtual Etiquettes de sessionMPB-E1

lun23Juin(Juin 23)09:00mar24(Juin 24)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMPB-E1

lun28juil(juil 28)09:00mar29(juil 29)17:00VirtuelVirtual Etiquettes de sessionMPB-E1

lun28juil(juil 28)09:00mar29(juil 29)17:00Genève, Route des Jeunes 35, 1227 Carouge Etiquettes de sessionMPB-E1

lun01Sep09:00mar02(Sep 2)17:00VirtuelVirtual Etiquettes de sessionMPB-E1

lun01Sep09:00mar02(Sep 2)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMPB-E1

lun06Oct(Oct 6)09:00mar07(Oct 7)17:00VirtuelVirtual Etiquettes de sessionMPB-E1

lun06Oct(Oct 6)09:00mar07(Oct 7)17:00Genève, Route des Jeunes 35, 1227 Carouge Etiquettes de sessionMPB-E1

lun10Nov(Nov 10)09:00mar11(Nov 11)17:00VirtuelVirtual Etiquettes de sessionMPB-E1

lun10Nov(Nov 10)09:00mar11(Nov 11)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMPB-E1

lun15Déc(Déc 15)09:00mar16(Déc 16)17:00VirtuelVirtual Etiquettes de sessionMPB-E1

lun15Déc(Déc 15)09:00mar16(Déc 16)17:00Genève, Route des Jeunes 35, 1227 Carouge Etiquettes de sessionMPB-E1

Contact

ITTA
Route des jeunes 35
1227 Carouge, Suisse

Opening hours

Monday to Friday
8:30 AM to 6:00 PM
Tel. 058 307 73 00

Contact-us

ITTA
Route des jeunes 35
1227 Carouge, Suisse

Make a request

Contact

ITTA
Route des jeunes 35
1227 Carouge, Suisse

Opening hours

Monday to Friday, from 8:30 am to 06:00 pm.

Contact us

Your request