Power BI for Business Analysis Training
PROGRAMME OUTLINES
| Item | Details |
| Duration | 2 days (9.00 am – 5.00 pm) |
| Delivery Mode | Face-to-face / Online / Hybrid (to be confirmed) |
| Suitable For | Executives, supervisors and managers who want to use GenAI & AI tools |
PROGRAMME OVERVIEW
This 2-day, hands-on workshop is designed to help participants move beyond basic reporting and truly unlock the power of Power Query and Power BI. Through practical exercises and guided projects, participants will learn how to clean and combine large datasets, build robust data models, and create insightful, interactive dashboards that support faster, better business decisions.
PROGRAMME OBJECTIVES
By the end of this programme, participants will be able to:
- Use Power Query to clean, transform and combine data from multiple sources in a systematic, repeatable way.
- Apply advanced Power Query techniques, including custom functions, parameters and error handling, to prepare complex datasets for analysis.
- Design effective data models in Power BI, defining relationships, calculated columns and measures that support meaningful analysis.
- Build interactive visual reports and dashboards in Power BI, using best-practice visual design and performance optimisation techniques.
- Write and apply core DAX formulas (including time intelligence and advanced filters) to solve real business questions with data.
PROGRAMME OUTLINE AT A GLANCE
| Day / Session | Theme | Key Focus & Activities |
| Day 1 – Morning | Advanced Power Query for Data Preparation | i. Recap of Power Query basics and workshop objectives
ii. Advanced filtering & conditional columns iii. Merging and appending data from multiple sources iv. Handling inconsistencies in combined data |
| Day 1 – Afternoon | Functions, M Language & Query Optimisation | i. Using built-in functions and creating custom functions in M
ii. Error handling and fixing invalid data iii. Query diagnostics and performance tuning iv. Introduction to parameters for dynamic queries v. Best practices for clean, maintainable queries |
| Day 2 – Morning | Data Modelling & Visual Design in Power BI | i. Recap of Power BI basics
ii. Building data models and relationships between tables iii. Creating calculated columns and basic measures iv. Enhancing visuals with formatting and interactions v. Drill down and drill through for deeper analysis |
| Day 2 – Afternoon | DAX, Time Intelligence & Power BI Service | i. Introduction to DAX syntax and core functions
ii. Using time intelligence for date-based analysis iii. Advanced DAX (FILTER, ALL, iterators) for real business scenarios iv. Publishing to Power BI Service and creating dashboards v. Sharing, collaboration and report performance tips; vi. Final Q&A |
FEE STRUCTURE (INDICATIVE)
| Normal Fee (per pax) | RM 1,899.00 |
| Early Bird | RM 1,699.00 |
| Alumni | RM 1,699.00 |
| Group (min 3 pax) | RM 1,499.00 |
