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
As part of Lumify Group, Lumify Work has skilled more people in Microsoft technologies than any other organisation in Australia and New Zealand. We have a campus in the Philippines, too. We offer the broadest range of instructor-led training courses, from end user to architect level. We are proud to be the winner of the Microsoft MCT Superstars Award for FY24, which formally recognises us as having the highest quality Microsoft Certified Trainers in ANZ.
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.
