This course is designed as an introduction to Power BI for data analysis and reporting. Skills include connecting to data and basic data preparation tasks using Power Query, designing report pages for optimal user experience, and exploring how Copilot in Power BI aids the report development process.
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.
This course is intended for professionals interested in transforming data into interactive reports using Power BI to deliver insights and support decision-making.
You should be familiar with data and analytics concepts.
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.
