Description
Duration: 2 days
*This course is also available for in-house sessions.
Course Overview:
This programme provides intermediate-level training in Microsoft Power BI, focusing on data transformation using Power Query, data modelling, DAX measures including time intelligence, and the creation of interactive reports and dashboards to support effective data analysis and business decision-making.
Learning Outcomes:
By the end of the course, participants will be able to:
- Master the Power Query Editor for advanced data transformations.
- Learn how to build data models, create relationships, and structure data for reporting.
- Gain proficiency in using DAX to create measures and calculated columns.
- Develop interactive reports and dashboards with slicers, filters, and bookmarks.
- Understand and apply time intelligence functions in Power BI.
Target Audience:
This course is designed for:
- Intermediate users of Power BI who wish to improve their data modeling and transformation skills.
- Business analysts, data analysts, and IT professionals looking to develop interactive reports and dashboards.
Course Outline
Module 1: Introduction to Power Query Editor and Data Transformation
- Cleaning and shaping data in Power Query.
- Merging and appending queries.
- Removing duplicates, splitting columns, and filtering data.
Module 2: Building a Data Model
- Understanding relationships and cardinality.
- Introduction to star and snowflake schema models.
- Best practices for structuring data models.
Module 3: DAX Basics: Measures vs. Calculated Columns
- Introduction to DAX and its role in Power BI.
- Difference between measures and calculated columns.
- Using basic DAX functions: SUM, AVERAGE, COUNT.
Module 4: Handling Time Intelligence with DAX
- Using basic time intelligence functions like YTD, QTD, and MTD.
- Creating custom time calculations.
Module 5: Advanced Data Transformations in Power Query
- Creating conditional columns and unpivoting data.
- Using parameters for dynamic transformations.
Module 6: Creating Interactive Reports and Dashboards
- Using slicers, filters, and bookmarks.
- Implementing drill-downs and drill-through options.
Reviews
There are no reviews yet.