Power Query et Power Pivot : modélisation et transformation des données
Start date
—
Duration
30h
Mode
—
Level
Advanced
Overview
Ce thème couvre l'import, le nettoyage et la transformation de données avec Power Query, puis la modélisation relationnelle et le calcul avancé avec Power Pivot et le langage DAX, directement dans Excel.
Target audience
Analystes de données, contrôleurs de gestion, RAF, gestionnaires, responsables reporting
Learning objectives
- Importer des données de sources multiples avec Power Query
- Nettoyer et transformer les données automatiquement
- Construire un modèle de données relationnel dans Power Pivot
- Maîtriser les fonctions DAX essentielles (CALCULATE, SUMX, RELATED)
- Créer des mesures calculées pour l'analyse décisionnelle
Training program30h
Fundamentals and framing
- Introduction and training objectives
- Assessment of current practices
- Theoretical and methodological framework
Deep dive and hands-on practice
- Case studies and practical exercises
- Group work and presentation
- Operational tools and templates
Application and action plan
- Professional role-play scenarios
- Individual action plan development
- Assessment and training wrap-up
Your trainer
GRH-Services Expert
Experienced trainer with over 10 years of corporate practice. Certified in their field of expertise, they support Guinean professionals in developing their skills.
What our participants say
“Very hands-on training. I was able to apply the tools as soon as I returned to work. The trainer is a true expert in the field.”
Participant
Mining sector
“Excellent teaching quality. The case studies are contextualized for Guinea, making the training immediately useful.”
Participant
Industrial sector
Frequently asked questions
This training as in-house
Want to organize this training as a private session for your team? We adapt the content and schedule to your needs.
Similar programs
