SMS-119     Microsoft Power BI (Intermediate to Advanced)

• Overview
• Course Objectives
• Course Content
• For Whom
• Schedule and Hours

<

>

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.

By the end of this training, participants will be able to:

• Build a complete Power BI report from raw data
• Prepare and clean data using Power Query
• Create basic data models and measures
• Design interactive dashboards
• Publish and share reports using Power BI Service

• Section 1: Advanced Error Handling and Query Refinement
• Section 2: Introduction to Query Parameters
  
• Section 3: Power Query Best Practices and Tips
  
• Section 4: Data Modeling in Power BI
  
• Section 5: Advanced Data Visualization Techniques
  
• Section 6: Introduction to DAX (Data Analysis Expressions)
  
• Section 7: Advanced DAX Functions and Techniques
  
• Section 8: Power BI Service and Collaboration Features
  
• ​Section 9: Power BI Best Practices and Performance Tips
  

This training is highly recommended for users with basic Power BI knowledge who want to strengthen data transformation, modelling, DAX, visualization, and performance skills.

This is a 2-days programme.
​
This course runs from 9:00am – 5:00pm with an hour for lunch and periodic short breaks.
 
This is an intensive session designed to include as much discussion as possible. Lunch and breaks provide an opportunity for further questioning and discussion with the instructors.

We are HRD Corp (Human Resource Development Corporation) Registered Training Provider.
​All of our training modules are claimable under HRD Corp.