Business Intelligence with Excel

Requires an intermediate level of Excel (pivot tables, advanced formulas, tables).
Requires a computer with Microsoft Excel 2016 or Excel 365.

Discover Business Intelligence with Excel.
Master Power Query and pivot tables.
Design complex data models with Power Pivot.
Exploit them with the power of the DAX language.

Preparing data with Power Query

• Getting started
• Data connection
• Data manipulation
• Manage dates and times
• Advanced manipulations
• Practical case

Creating a data model with Power Pivot

• Fundamental principles
• Pivot table, data models and filter contexts
• Connect Power Pivot to external data
• Practical case

Data analysis with the DAX language

• The DAX language and the evolution of pivot tables
• Excel functions Vs DAX functions
• Overview of main functions
• Key Performance Indicators (KPIs)

• Data preparation with Power Query
• Use of pivot tables, slicers, metrics and KPIs
• Creating a data model with Power Pivot
• Data analysis with the DAX language

Practical exercises carried out together step by step with the trainer.
Possibility to adapt the exercises to the client's environment.

Practical case corrected together.

Certificate of participation issued at the end of the course.

Takes place at the client's premises or by videoconference (Teams or Zoom).