Advanced Microsoft Power BI Training in France

  • Learn via: Classroom
  • Duration: 2 Days
  • Price: Please contact for booking options

Power BI Desktop is part of the suite of tools from Microsoft which enable data to be analysed and published from a variety of sources.This course covers the use of Power BI Desktop to connect to data, create Visualizations, query the data and publish reports. You are already using Microsoft’s cloud reporting and business analytics suite, Power BI, to analyze your organizations data and share insights and are now ready to learn the advanced techniques that you, your business analysts, and your stakeholders need to create complex information from projects, program, and portfolio reporting to utilizing time-phased data and, potentially, data from your enterprise’s other line-of-business tools. Attendees of this course will gain practical examples from the experienced instructor who has deployed and configured Power BI reporting in a wide variety of businesses.

Read more +
We can host this training at your preferred location.

Prerequisites

The Power BI boot camp course is a pre-requisite for the course. Alternatively, delegates should have at least 3 months experience in using Power BI Desktop for creating reports and dashboards.

Read more +

What You Will Learn

  • Create Advanced Power BI Reports
  • Advanced understanding of the data schemas and extracting data
  • Perform advanced transformations of data or any data schema
  • Utilize time-phased data in the creation of complex analyses
  • Create new measures using DAX
  • Filter data using row-level security
  • Create and deploy content packs
  • Explore Data Visualizations
  • Create and publish Reports
Read more +

Outline

1.  Introduction

  • What you should know 
  • Our project: Creating an advanced Power BI dashboard

2. Working with Data

  • Importing online data sources
  • Uploading from a folder of data 
  • Querying a database
  • Importing and transferring data imported from an Excel, CSV, or TXT file

3. Query Editor 

  • Introducing Query Editor steps  
  • Transposing data tables 
  • Splitting fields and columns         
  • Formatting data with text formulas
  • Creating conditional formulas
  • Creating calculated formulas

4. DAX Language              

  • Introducing DAX               
  • Introducing DAX measures          
  • Understanding DAX measure logic           
  • Evaluating DAX measures             
  • Leveraging the CALCULATE functionality               
  • Understand how filters work in CALCULATE function       
  • Leveraging the ALL function
  • Understanding the FILTER functionality

5. Introduction to DAX Formulas               

  • Creating a separate table for measures 
  • Creating a table using GENERATESERIES formula
  • Leveraging the POWER function
  • Leveraging the DIVIDE function
  • Utilizing the X factor (SUMX, COUNTX, etc.) for ranges
  • Utilizing quick measures

6. Advanced DAX Calculations

  • Creating a date table using a formula
  • Filtering between tables               
  • Utilizing IF statements with conditional functions
  • Introducing the DATEDIFF measure         
  • Working with disconnected tables           
  • Leveraging the BLANK function 
  • Using variables in formulas
  • DATESBETWEEN and the X functions       
  • Introducing the DATEADD date calculations         
  • Introducing the MTD, QTD, and YTD date calculations
Read more +

Training Reviews

Contact us for more detail about our trainings and for all other enquiries!

Avaible Training Dates

Join our public courses in our France facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

09 mai 2025 (2 Days)
Paris, Lyon, Lille, Nice
Classroom / Virtual Classroom
24 juillet 2025 (2 Days)
Paris, Lyon, Lille, Nice
Classroom / Virtual Classroom
25 juillet 2025 (2 Days)
Paris, Lyon, Lille, Nice
Classroom / Virtual Classroom
01 août 2025 (2 Days)
Paris, Lyon, Lille, Nice
Classroom / Virtual Classroom
02 août 2025 (2 Days)
Paris, Lyon, Lille, Nice
Classroom / Virtual Classroom
04 août 2025 (2 Days)
Paris, Lyon, Lille, Nice
Classroom / Virtual Classroom
11 août 2025 (2 Days)
Paris, Lyon, Lille, Nice
Classroom / Virtual Classroom
23 août 2025 (2 Days)
Paris, Lyon, Lille, Nice
Classroom / Virtual Classroom
Advanced Microsoft Power BI Training Course in France

The French Republic, or République Française, is a country of northwestern Europe. Having suitable agricultural lands, more than half of the land, makes France Europe's most important agricultural producer. The country's capital and the largest city is Paris. Other major and famous cities are Marseille, Lyon, Toulouse, Lille, Bordeaux, and Nice.

France is a popular destination for tourists. While you can skii at the Alps, Côte d'Azur is a perfect destination in spring and summer time. The country attracts millions of tourists also during the Cannes Festival time. The Cannes Film Festival, is an annual film festival held in Cannes, a city located on the French Riviera, which previews new films of all genres from all around the world.

Bilginç IT Academy is committed to aligning with the demands of France, utilizing state-of-the-art training methodologies. Discover a wide selection of Certification Exam preparation courses and accredited corporate training offerings in our catalog, designed to reshape your perspective on IT training.

Bilginç IT Academy All Rights Reserved

By using this website you agree to let us use cookies. For further information about our use of cookies, check out our Cookie Policy.