Got a question? Call 02 8286 9429 | Login
Learn how to transform and load data, define semantic model relationships and calculations, create interactive visuals, and distribute reports using Power BI.
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 to retrieve data from a variety of data sources, including Microsoft Excel, relational databases, and NoSQL data stores
Simplify a complicated model, change data types, rename objects, and pivot data
Understand why choosing the correct data granularity is important for performance and usability of your Power BI reports
Work with implicit and explicit measures
Add calculated tables and calculated columns to your semantic model. You'll also be able to describe row context, which is used to evaluated calculated column formulas
Select the most appropriate visual type to meet your design and report layout requirements
Navigate the Power BI service, create and manage workspaces and related items, and distribute reports to users
Use a single semantic model to build many reports. Reduce your administrative overhead even more with scheduled semantic model refreshes and resolving connectivity errors
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.