Microsoft DP-500T00 - Designing and Implementing Enterprise-Scale Analytics Solutions Using Azure and Power BI
Length 4 days
Version A
Course overview
View dates &
book now
Why study this course
This four-day course covers methods and practices for performing advanced data analytics at scale. Students will build on existing analytics experience and will learn to implement and manage a data analytics environment, query and transform data, implement and manage data models, and explore and visualise data. In this course, students will use Microsoft Purview, Azure Synapse Analytics, and Power BI to build analytics solutions.
By submitting an enquiry, you agree to our privacy policy and receiving email and other forms of communication from us. You can opt-out at any time.
What you’ll learn
Implement and manage a data analytics environment
Query and transform data
Implement and manage data models
Explore and visualise data
Microsoft Azure 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 Azure 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.
Stay ahead of the technology curve
Don’t let your tech outpace the skills of your people
Train Anywhere
From our state-of-the-art classrooms to telepresence to your offices, our instructor-led training caters to your needs.
Track Record
We have a 30-year history of driving innovative, award-winning learning solutions.
More Courses, More Often
When you train with Lumify Work you get more courses, more often, in more locations, and from more vendors.
Quality Instructors and Content
Expert instructors with real world experience and the latest vendor-approved in-depth course content.
Partner-Preferred Supplier
Chosen and awarded by the world's leading vendors as preferred training partner.
Ahead of the Technology Curve
No matter your chosen technologies or platforms, we can help you stay one step ahead.
Train Anywhere
From our state-of-the-art classrooms to telepresence to your offices, our instructor-led training caters to your needs.
Track Record
We have a 30-year history of driving innovative, award-winning learning solutions.
More Courses, More Often
When you train with Lumify Work you get more courses, more often, in more locations, and from more vendors.
Quality Instructors and Content
Expert instructors with real world experience and the latest vendor-approved in-depth course content.
Partner-Preferred Supplier
Chosen and awarded by the world's leading vendors as preferred training partner.
Ahead of the Technology Curve
No matter your chosen technologies or platforms, we can help you stay one step ahead.
Train Anywhere
From our state-of-the-art classrooms to telepresence to your offices, our instructor-led training caters to your needs.
Track Record
We have a 30-year history of driving innovative, award-winning learning solutions.
More Courses, More Often
When you train with Lumify Work you get more courses, more often, in more locations, and from more vendors.
Who is the course for?
This course is intended for individuals with demonstrated proficiency in analysing and visualising data using Microsoft Power BI. It is suitable for data and business intelligence professionals who want to learn how to perform data analytics at scale, including cleaning and transforming data, designing and building enterprise data models, incorporating advanced analytics capabilities, integrating with IT infrastructure, and applying development lifecycle practices.
Course subjects
Learning Path 1: Introduction to data analytics on Azure
Explore Azure data services for modern analytics
Understand concepts of data analytics
Explore data analytics at scale
Learning Path 2: Model, query, and explore data in Azure Synapse
Introduction to Azure Synapse Analytics
Use Azure Synapse serverless SQL pool to query files in a data lake
Analyse data with Apache Spark in Azure Synapse Analytics
Analyse data in a relational data warehouse
Learning Path 3: Prepare data for tabular models in Power BI
Choose a Power BI model framework
Understand scalability in Power BI
Create and manage scalable Power BI dataflows
Learning Path 4: Design and build scalable tabular models
Create Power BI model relationships
Enforce model security
Create calculation groups
Use tools to optimise Power BI performance
Learning Path 5: Implement advanced data visualisation techniques by using Power BI
Understand advanced data visualisation concepts
Monitor data in real-time with Power BI
Create paginated reports
Learning Path 6: Implement and manage an analytics environment
Provide governance in a Power BI environment
Facilitate collaboration and sharing in Power BI
Monitor and audit usage
Provision Premium capacity in Power BI
Establish a data access infrastructure in Power BI
Broaden the reach of Power BI
Automate Power BI administration
Build reports using Power BI within Azure Synapse Analytics
Learning Path 7: Manage the analytics development lifecycle
Design a Power BI application lifecycle management strategy
Create and manage a Power BI deployment pipeline
Create and manage Power BI assets
Learning Path 8: Govern data across an enterprise
Introduction to Microsoft Purview
Discover trusted data using Microsoft Purview
Catalog data artifacts by using Microsoft Purview
Manage Power BI artifacts by using Microsoft Purview
Prerequisites
Before attending this course, it is recommended that students have:
A foundational knowledge of core data concepts and how they’re implemented using Azure data services. For more information see Azure Data Fundamentals.
Experience designing and building scalable data models, cleaning and transforming data, and enabling advanced analytic capabilities that provide meaningful business value using Microsoft Power BI. For more information see Power BI Data Analyst.
FREE E-BOOK: The New Era of Cloud Computing
We've created this e-book to assist you on your cloud journey, from defining the optimal cloud infrastructure and choosing a cloud platform, to security in the cloud and the core challenges in moving to the cloud.
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
By submitting an enquiry, you agree to our privacy policy and receiving email and other forms of communication from us. You can opt-out at any time.
