This session: 12–16 Jul 2027
This Advanced Excel: Mastering Power Query and Power Pivot session in Barcelona (Spain) runs from Monday 12 July to Friday 16 July 2027 (week 28, Q3 2027). It is the only date in Barcelona (Spain) in 2027, at a fee of 5,900 £. Registration is open for this date. It is held in person.
| Dates | Monday 12 Jul – Friday 16 Jul 2027 |
|---|---|
| Week | 28 of 2027 |
| Duration | 5 days |
| Fee | 5,900 £ |
| Status | Open for registration |
| Format | In person |
Course Overview
Course Description
This comprehensive 1-week course focuses on advanced Excel techniques using Power Query and Power Pivot. Participants will learn to efficiently import, clean, and transform data from various sources, create robust data models, and perform complex analysis. The course combines theoretical concepts with hands-on exercises to ensure practical application of learned skills.
Learning Objectives
- Master data import and transformation using Power Query
- Develop advanced data models with Power Pivot
- Create complex calculations using DAX formulas
- Design interactive dashboards and reports
- Implement best practices for large-scale data analysis
Course Modules
Day 1: Introduction to Power Query
- Overview of Power Query capabilities
- Connecting to various data sources
- Basic data transformation techniques
- Combining multiple data sources
Day 2: Advanced Power Query Techniques
- Complex data cleansing and shaping
- Creating custom functions
- Handling errors and exceptions
- Optimizing query performance
Day 3: Power Pivot Fundamentals
- Introduction to data modeling concepts
- Creating relationships between tables
- Basic DAX formula writing
- Time intelligence functions
Day 4: Advanced Power Pivot and DAX
- Complex DAX calculations
- Working with hierarchies and parent-child relationships
- Implementing role-playing dimensions
- Advanced filtering techniques
Day 5: Reporting and Dashboards
- Creating interactive PivotTables and PivotCharts
- Designing dynamic dashboards
- Implementing drill-through functionality
- Best practices for large-scale models
Practical Wins for Participants
- Automate data import and cleansing processes, saving hours of manual work
- Create powerful data models capable of handling millions of rows efficiently
- Develop complex calculations and KPIs for deeper business insights
- Build interactive dashboards for effective data visualization and decision-making
Have Questions About This Event?
We understand that choosing the right training program is an important decision. Our comprehensive FAQ section provides answers to the most common questions about our courses, registration process, certification, payment options, and more.
- Course Information - Duration, format, and requirements
- Registration & Payment - Easy booking and flexible payment options
- Certification - Internationally recognized credentials
- Support Services - Training materials and post-course assistance
Register Your Interest
Fill out the form below and our team will get back to you shortly