Advanced Excel Automation, Power Query Data Transformation & Intelligent Reporting Systems
Venue: Sarova Stanley Hotel, Nairobi-Kenya
Date: 6th - 11th July 2026
Cost: Kshs. 86,000 / USD 850
CPD points: 10
Overview
Take Excel automation to the next level with this program on Power Query data transformation and intelligent reporting systems. Participants will learn to use Power Query to clean, combine, and transform data from diverse sources, creating automated workflows that refresh with new data. The curriculum covers M language, query optimization, and integration with Power Pivot and Power BI. Through hands‑on projects, attendees will build robust, maintainable solutions that deliver timely insights. This program is ideal for data analysts, Excel power users, and reporting professionals seeking to automate and enhance their work.
Objectives
- Master Power Query for data extraction, transformation, and loading (ETL)
- Write M language expressions for custom transformations
- Combine data from multiple sources (databases, web, folders)
- Create parameterized queries for dynamic reporting
- Optimize query performance for large datasets
- Load transformed data into Excel models or Power BI
- Automate data refresh and report distribution
- Troubleshoot and debug complex queries
- Implement data governance in automated reporting
Target Audience
- Data analysts and business intelligence professionals
- Financial and reporting analysts
- Excel power users seeking automation skills
- IT professionals supporting Excel‑based solutions
- Consultants building analytical tools
- Anyone managing large datasets in Excel
Methodology
- Power Query hands‑on labs with real datasets
- M language coding exercises
- Automation workflow design sessions
- Performance optimization workshops
- Case study analyses of automated reporting solutions
- Peer review of queries and models
- Action planning for implementing automation
