All audiences.
2 days of 6 hours with a break of 1 hour. Timetable to be defined with the students.
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
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).