ITF 220 - Data Transformation and Modelling with Microsoft Power BI
Course Description
Harness the power of data to unlock meaningful insights key for business success through data preparation and modeling. This intermediate-level course is for business users to go beyond the basics of data utilization. Learn how to structure and transform raw data into a clean, effective model that unlocks meaningful insights to drive impact.
You will learn advanced data transformation techniques using Power Query, identify how to structure data for analytics through normalization, and design effective data models using relationships between tables. The course also introduces Data Analysis Expressions (DAX) to create dynamic calculations and time-based metrics. This course is designed for non-technical business users.
Course Details
By the completion of this course, successful students will be able to:
• Use Power Query to perform advanced data transformations
• Build optimized data models by applying data normalization principles
• Design and manage table relationships to create a single source of truth for reports
• Develop custom DAX measures and use time intelligence functions for advance analysis
Topics
• Data normalization principles: dimension and fact tables
• Data modeling and table relationships
• Advanced transformations in Power Query
• Introduction to DAX
• Time intelligence functions
Prerequisites
There are no mandatory prerequisites for this course. You are expected to have a fundamental understanding of Power BI, including creating reports and visuals. This course does not cover introductory concepts.
Self-assessment for enrolment:
A minimum of 3 months relevant working experience and knowledge in:
- Create dashboard and report using Power BI
- Gather data and apply data transformation and modelling in Power BI
OR
Recommended prerequisites:
- ITF 210 Visualize Data using Microsoft Power BI