INTRODUCTION

In today’s data-driven landscape, organizations are collecting massive amounts of data from various sources. However, without the right tools and techniques, this wealth of data remains largely untapped. That’s where Power Query and Power BI come into play. These robust tools empower you to efficiently transform, cleanse, and integrate diverse datasets, unleashing the true potential of big data analytics.

This module is designed to equip you with the fundamental skills needed to handle and analyze big data seamlessly. Whether you are a business analyst, data professional, or an aspiring data scientist, this course will cater to your learning needs, taking you from the basics to advanced data manipulation and visualization techniques.

Throughout the module, you will discover how Power Query serves as a powerful ETL (Extract, Transform, Load) tool, enabling you to connect to various data sources, apply data transformations, and prepare data for analysis. Moreover, we will delve into the magic of M, the powerful formula language behind Power Query, and learn how to write custom functions and queries to tackle complex data challenges.

Once your data is refined and ready, we will introduce you to Power BI – Microsoft’s cutting-edge business intelligence platform. Power BI allows you to create stunning interactive visualizations and insightful reports, providing you with the ability to communicate your findings effectively and make data- driven decisions.

 

LEARNING OUTCOME

Master Power Query Fundamentals: Understand the core concepts of Power Query and utilize its data transformation capabilities to clean, shape, and integrate data from various sources effectively.

Leverage Advanced Power Query Techniques: Apply advanced data transformation techniques, custom functions, and the M formula language to handle complex data challenges and prepare data for analysis.

Combine and Merge Data with Confidence: Seamlessly merge and append data from multiple sources, ensuring data integrity and consistency in the resulting datasets.

Create Interactive Visualizations: Build compelling and interactive visualizations in Power BI to effectively communicate data insights and make data-driven decisions.

Understand Data Modeling: Design efficient and optimized data models in Power BI, establishing relationships between tables and utilizing calculated columns and measures to support analysis.

Harness the Power of DAX: Utilize the Data Analysis Expressions (DAX) language to create sophisticated calculated columns and measures, enabling advanced data analysis and business intelligence.

Implement Time Intelligence Functions: Effectively use DAX time intelligence functions to perform date-based analysis and gain deeper insights from time-series data.

 

COURSE CONTENT

Welcome and Introduction

• Workshop objectives and agenda overview
• Brief review of Power Query basics for context

MODULE 1 : ADVANCED DATA TRANSFORMATIONS

• Recap of basic data transformations
• Advanced filtering techniques (date filtering, advanced text filters)
• Conditional columns and custom expressions

MODULE 2 : MERGING AND APPENDING QUERIES

• Combining data from multiple sources using merging and joining
• Appending queries vertically and horizontally
• Handling data inconsistencies during merging

MODULE 3 : INTRODUCTION TO FUNCTIONS IN POWER QUERY

• Understanding built-in functions
• Creating custom functions with the M formula language
• Practical applications of functions in data transformation

MODULE 4 : ADVANCED ERROR HANDLING AND QUERY REFINEMENT

• Handling errors and invalid data in queries
• Query diagnostics and troubleshooting techniques
• Refining queries for optimal performance

MODULE 5 : INTRODUCTION TO QUERY PARAMETERS

• Working with parameters in Power Query
• Parameterizing queries for dynamic data refresh
• Use cases and benefits of query parameters

MODULE 6 : POWER QUERY BEST PRACTICES AND TIPS

• Guidelines for efficient and maintainable query design
• Summary of key takeaways and final Q&A session

Welcome And Introduction

• Workshop objectives and agenda overview
• Recap of Power BI basics for context

MODULE 7 : DATA MODELING IN POWER BI

• Understanding Power BI data models
• Creating relationships between tables
• Using calculated columns and measures

MODULE 8 : ADVANCED DATA VISUALIZATION TECHNIQUES

• Enhancing visuals with formatting options
• Customizing interactions between visuals
• Drillthrough and drilldown capabilities

MODULE 9 : INTRODUCTION TO DAX (Data Analysis Expressions)

• Understanding DAX basics and syntax
• Creating calculated columns and measures with DAX
• Time intelligence functions for date-based analysis

MODULE 10 : ADVANCED DAX FUNCTIONS AND TECHNIQUES

• Using advanced DAX functions (FILTER, ALL, etc.)
• Working with iterators and row context
• Solving complex business problems with DAX

MODULE 11 : POWER BI SERVICE & COLLABORATION FEATURES

• Publishing reports to Power BI Service
• Creating and sharing dashboards
• Collaborating with colleagues on shared reports

MODULE 12 : POWER BI BEST PRACTICES AND PERFORMANCE TIPS

• Guidelines for creating efficient and optimized reports
• Summary of key takeaways and final Q&A session

 

METHODOLOGY

An adult learning approach using a combination of lectures and simulation, exercises, hands-on with close supervision by the trainers, presentation, management games & group discussions

 

TRAINER (either one of them)

Fakhrul Syahmi (either one of them)

Hazry Hidzir

Shamsiyah Abd Kadir

Suhaily Georga Abdullah

Adila Diyana Erwan

Kamil Rohman

 

FEES (WITHOUT ACCOMODATION)

RM1,100.00 per pax

Early Bird RM1,000.00 per pax

(20 days before program)

2 pax RM 1,050.00 per pax

3 pax > RM1,000.00 per pax

(This fees is inclusive of 2 morning tea breaks, 2 lunch , 2 afternoon tea breaks, notes and certificate of attendance for the participants)