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
Course locations >>

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 Solutions Partner - Cloud - Training Services Logo

Microsoft at Lumify Work

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.


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


Prerequisites

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

Awaiting course schedule

If you would like to receive a notification when this course becomes available, enter your details below.

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.



Loading