Learn how to transform and load data, define semantic model relationships and calculations, create interactive visuals, and distribute reports using Power BI.
After completing this course, students will be able to:
Understand how Power BI services and applications work together
Understand how to retrieve data from a variety of data sources, including Microsoft Excel, relational databases, and NoSQL data stores
Resolve inconsistencies, unexpected or null values, and data quality issues.
Apply user-friendly value replacements.
Profile data so you can learn more about a specific column before using it
Evaluate and transform column data types
Apply data shape transformations to table structures
Combine queries
Apply user-friendly naming conventions to columns and queries
Edit M code in the Advanced Editor
Create common date tables
Configure many-to-many relationships
Resolve circular relationships
Design star schemas
Select the most appropriate visual type to meet your design and report layout requirements
Design semantic model
Create visuals and reports
Create summaries
Describe end-to-end analytics in Microsoft Fabric
Lumify Work has been delivering effective training across all Microsoft products for over 30 years. We are proud to be both Australia's and New Zealand’s first Microsoft Gold Learning Solutions Partner and the winner of the Microsoft MCT Superstars Award for FY24, which formally recognises us as having the highest quality Microsoft Certified Trainers (MCTs) in ANZ. All Lumify Work Microsoft technical courses follow Microsoft Official Curriculum (MOC) and are led by MCTs.
Data Analysts
Basic understanding of Data Analytics and Power BI.
The supply of this course by Lumify Work is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.
