Business Intelligence with Excel

Inter and intra-company training

Who is the training for?

All audiences.

Level reached

Specialisation

Duration

2,00 day(s)

2 days of 6 hours with a break of 1 hour. Timetable to be defined with the students.

Language(s) of service

EN FR

Prerequisites

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

Goals

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.

Contents

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)

Points covered

  • 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

Teaching methods

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

Evaluation

Practical case corrected together.

Certificate, diploma

Certificate of participation issued at the end of the course.

Mode of organisation

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

Organization contact details

Frédéric Michotte