Discover Data Analysis with Power BI : Level 2 – Advanced


In this course, participants will build upon their foundational knowledge of Power BI and delve deeper into its advanced features and functionalities.

The course aims to empower learners with the ability to leverage Power BI’s advanced data manipulation capabilities to handle complex datasets effectively. Participants will learn how to create and customize sophisticated visualizations, design interactive reports, and develop insightful dashboards to gain meaningful insights from their data.

Throughout the course, emphasis is placed on mastering advanced data modeling techniques, such as DAX formulas and relationships, to perform calculations and create dynamic measures. Moreover, participants will explore the integration of various data sources, enabling them to consolidate data from multiple origins for comprehensive analysis.

By the end of the course, attendees will have a proficient understanding of the tool’s advanced features, empowering them to conduct in-depth data analysis and produce compelling, data-driven reports and visualizations.

Out of stock

Sorry, the course is fully booked. If you are interested in getting notifications for available spots in case other participants cancel, please leave your name and email address below

SKU: 9931 Categories: ,

Start date

October 5, 2023

End date

October 6, 2023

Language(s) of the training


Languages spoken by the coach(es)

English, French


Yassine Mekdour


  • Power BI: Pricing & Architecture
  • Power BI in Power Platform
  • Workspaces & Apps
  • Power BI Security (RLS & OLS)
  • Power Query: Advanced
  • DAX Measures: Advanced
  • Power BI Service: Guide Tour
  • Bookmarks: Overview & Concept
  • DataSet vs DataFlow vs DataMart
  • Themes in Power BI
  • Create Bookmarks
  • Create and Personalize Themes in Power BI
  • Publish & Share Reports in Power BI Portal
  • Data Gouvernance
  • External tools
  • Performance Analyzer
  • Metrics Usage & Activity Monitoring
  • Create Power BI Mobile Application


The main objectives are:

  • Understanding and effectively utilizing Power BI’s advanced data transformation capabilities to clean, shape, and prepare data for analysis.
  • Exploring advanced visualization options, customizing visual elements, and using interactive features to enhance data storytelling.
  • Learning how to create calculated columns, measures, and calculated tables using DAX to perform complex calculations and support data analysis needs.
  • Applying best practices for data modeling and optimizing data relationships to improve report performance and accuracy.
  • Understanding how to collaborate and share reports securely with others using Power BI’s collaboration and sharing capabilities.
  • Addressing real-world data analysis challenges and case studies to apply the acquired skills in practical scenarios.
  • Staying up-to-date with the latest features and updates in Power BI, enabling participants to adapt and leverage new functionalities effectively.

The combination of these objectives ensures that participants are equipped with a comprehensive skill set to become proficient Power BI users capable of conducting advanced data analysis and generating valuable insights for their organizations.

Learning Outcomes

The learning outcomes include:

  • Proficiency in advanced data manipulation techniques: Participants will be able to efficiently clean, transform, and prepare complex datasets for analysis within Power BI, ensuring data accuracy and reliability.
  • Mastery of advanced data modeling: Learners will gain expertise in creating and managing relationships between data tables, designing optimized data models, and using DAX formulas for creating calculated columns, measures, and calculated tables.
  • Advanced visualization skills: Participants will develop the ability to design visually compelling reports and dashboards, customize visual elements, and implement interactive features.
  • Integration of diverse data sources: Learners will understand how to connect and integrate data from various sources.
  • Complex calculation and analysis: Through DAX formulas, attendees will learn to perform intricate calculations, implement business logic, and conduct advanced data analysis to uncover trends, patterns, and outliers.
  • Collaboration and sharing: Learners will understand how to collaborate with colleagues and securely share reports and dashboards, promoting effective teamwork and data-driven decision-making across the organization.
  • Practical application: By working on real-world data analysis challenges and case studies, attendees will be able to apply their knowledge and skills in practical scenarios, reinforcing their understanding of Power BI’s advanced capabilities.
  • Overall, the learning outcomes of this training will equip participants with the knowledge and skills to become proficient Power BI users.


This course has a total duration of 13 hours and takes place over 2 days:

  • 05-10-2023: 09:00 – 16:30
  • 06-10-2023: 09:00 – 16:30

Format and Location

This course takes place ON-SITE
Terres Rouges building
14, porte de France
L-4360 Esch/Alzette




  • Advanced knowledge of Microsoft Excel or a similar tool
  • First-level knowledge of Power BI (1st Course: Discover Data Analysis with Power BI : Level 1 – Getting Started)
  • Power BI Pro or Premium license
  • The training could be adjusted if Power BI Premium is already installed

Additional Info


This training does not have any assessment or exams; a certificate of participation will be issued to participants.

Esco Skills

Esco Occupations