Data, Analytics & AI Category Banner Image

Microsoft DP-605T00 - Develop Dynamic Reports with Microsoft Power BI

  • Length 1 day
  • Price  NZD 995 exc GST
Course overview
View dates &
book now

Why study this course

Learn how to transform and load data, define semantic model relationships and calculations, create interactive visuals, and distribute reports using Power BI.

Request Course Information

What you’ll learn

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

Microsoft Partner Cloud Logo

Microsoft at Lumify Work

Lumify Work is your best choice for training and certification in any of Microsoft’s leading technologies and services. We’ve been delivering effective training across all Microsoft products for over 30 years, and are proud to be Australia's and New Zealand’s first and largest Microsoft Gold Learning Solutions Partner. All Lumify Work Microsoft technical courses follow Microsoft Official Curriculum (MOC) and are led by Microsoft Certified Trainers. Join more than 5,000 students who attend our quality Microsoft courses every year.

Who is the course for?

  • Data Analysts

Course subjects

  • Get data in Power BI

  • Clean, transform, and load data in Power BI

  • Design a semantic model in Power BI

  • Add measures to Power BI Desktop models

  • Add calculated tables and columns to Power BI Desktop models

  • Design Power BI reports

  • Configure Power BI report filters

  • Create and manage workspaces in Power BI

  • Manage semantic models in Power BI


Basic understanding of Data Analytics and Power BI.

Terms & Conditions

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.

Request Course Information

Personalise your schedule with Lumify USchedule

Interested in a course that we have not yet scheduled? Get in touch, and ask for your preferred date and time. We can work together to make it happen.