Power BI Training
Analysis, data modeling, and business reporting
Training adapted to all levels, from fundamentals to advanced designed to strengthen team autonomy and improve the effective use of data in a professional environment
Target audience
Management controllers, analysts, project managers, and anyone involved in data analysis in a professional environment.
Duration
2 days (14 hours)
3 days (21 hours) – Advanced level
Price
€1,200 excl. VAT per person
€1,900 excl. VAT per person (Advanced)
Location
Remote
(Video conference)
Registration deadline
Registrations are possible up to 7 days before the start date, subject to availability.
Dates
Sessions are organized every month, usually in the middle of the month.
Schedule
9:30 a.m. to 5:00 p.m., with breaks and a lunch break (lunch not included).
Group size
Groups of 4 to 8 participants maximum.
Prerequisites
No prior knowledge of Power BI is required.
A good knowledge of the Windows environment and basic Excel skills are recommended.
Training objectives and skills acquired
- Understand the core concepts and operation of Power BI
- Import and prepare simple datasets
- Create visualizations and dashboards
- Publish and share reports
Programme
Day 1 – Getting started and data preparation
- Introduction of Power BI and use cases
- Exploring the interface
- Data source connections:
- Excel
- CSV
- Folders
- Introduction of Power Query
- Basic data preparation and transformation:
- Remove unnecessary rows and columns
- Handle missing values
- Change data types
Practical exercises
Importing and preparing a real dataset.
Day 2 – Visualization and report sharing
- Creating visualizations:
- Charts
- Tables
- Slicers and filters
- Report layout
- Introduction of table relationships
- Publishing reports to Power BI Service
- Dashboard sharing
Practical exercises
Building and publishing a complete dashboard.
Prerequisites
Training designed for users who already have experience with Power BI and want to go further in modeling, optimization, and analysis.
Training objectives and skills acquired
At the end of the training, participants will be able to:
- Design efficient and well-structured data models
- Master advanced DAX functions
- Optimize report performance
- Create interactive and professional visualizations
- Develop reports aligned with business requirements
Programme
Day 1 — Advanced data modeling and preparation
- Review of Power BI best practices
- Advanced data modeling:
- Star schema
- Complex relationships between tables
- Dimension tables and fact tables
- Data model optimization
- Best practices for scalable data models
Practical exercises:
Building an optimized data model from multiple sources.
Day 2 — Advanced DAX and complex calculations
- Review of measures and calculated columns
- Advanced DAX functions:
- CALCULATE
- FILTER
- ALL / ALLEXCEPT
- Time intelligence functions
- Managing filter and evaluation contexts
Practical exercises:
Creating business KPIs and time-based analyses.
Day 3 — Visualization, performance, and publishing
- Designing professional dashboards
- Advanced navigation and interactions
- Report performance optimization
- Publishing and sharing in Power BI Service
- Best practices for report distribution
Practical exercises:
Building a complete, business-ready dashboard.
Training methods
Click to view details
- Theory and demonstrations
- Guided practical exercises
- Case studies based on real scenarios
- Practical scenarios
Assessment methods
Click to view details
- Continuous assessment throughout the training
- Quizzes and practical exercises
- Case studies
- Final assessment at the end of the training
Technical resources
Click to view details
- A computer with Power BI Desktop installed
- Digital training materials provided
- Datasets based on real business cases
- Screen sharing and discussions via video conference
Follow-up and
assessment
Click to view details
- Feuille d’émargement
- Attestation de fin de formation
- Questionnaire de satisfaction
Looking for customized training tailored to your needs?