Skip to content
CBT Nuggets

Designing and Implementing Enterprise Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI (DP-500)

This training is designed to show you exactly how to plan an enterprise-level data analytics solution with Azure and Power BI. You can learn how to use the tools and features that make data solutions possible and harness them to advance your career with this course. It is now replaced by the DP-600 certification. After finishing the videos in this DP-500 training, you'll know how to take full control of a data analytics solution at the largest possible scale using Microsoft Power BI and Azure.

Updated September 2022

22Skills
143Videos
21h 5mTotal
143 videos21h 5m

Who This Course Is For

This DP-500: Microsoft Azure and Microsoft Power BI training is considered associate-level Microsoft 365 training, which means it was designed for data analysts and data engineers. This Power BI skills course is designed for data analysts and data engineers with three to five years of experience with data analysis and data visualization tools.

Skills Your Team Will Gain

  • Understanding the Power BI REST API and PowerShell cmdlets
  • Querying advanced data sources, including JSON and Azure Machine Learning models
  • Creating R and Python visuals in Power BI
  • Using DirectQuery and DAX variables and functions

Course Curriculum

  • Premium skill.Govern a Data Landscape with Microsoft Purview1h 3m
  • Premium skill.Administer Power BI with Powershell and REST APIs1h 2m
  • Premium skill.Integrate Power BI into an Existing Infrastructure1h 1m
  • Premium skill.Utilize Source Control with Power BI Resources54m
  • Premium skill.Deploy and Manage Datasets Using XMLA Endpoints53m
  • Premium skill.Implement Power BI Deployment Pipelines1h 3m
  • Premium skill.Understand ETL and Data Warehouse Concepts47m
  • Premium skill.Implement, Load, and Query a Dedicated SQL Pool in Azure Synapse57m
  • Premium skill.Query Data with Serverless SQL Pools53m
  • Premium skill.Query and Visualize Data Using Apache Spark in Azure Synapse1h 5m
  • Premium skill.Use the ML PREDICT T-SQL Function58m
  • Premium skill.Query Advanced Data Sources using Power BI1h 1m
  • Premium skill.Understand Enterprise Data Model Scalability Concepts1h 6m
  • Premium skill.Deploy Power BI Dataflows52m
  • Premium skill.Optimize Power Query and Report Performance52m
  • Premium skill.Create Calculation Groups in Tabular Editor50m
  • Premium skill.Create Queries, Functions, and Parameters by using the Power Query Advanced Editor55m
  • Premium skill.Implement Row and Object Level Security53m
  • Premium skill.Leverage DirectQuery and Composite Data Models58m
  • Premium skill.Optimize Data Models Using Third-Party Tools1h 4m
  • Premium skill.Use Advanced Visuals in Power BI59m
  • Premium skill.Create Power BI Paginated Reports59m

Readiness check

Confirm prerequisite knowledge before training begins

A short placement assessment on the CBT Nuggets assessments platform measures whether a learner already has the foundation this course assumes. IT Directors use it to put the right people in the right training — and any learner can take it right now to make sure they'll get full value from day one.

  • Questions generated from this course's own lesson transcripts — what gets measured is exactly what gets taught
  • Instant, per-learner results that show whether the prerequisite foundation is in place
  • Results roll up into team readiness reporting, so training hours go where they change outcomes

Runs on assessments.cbtnuggets.com — sign in with an Adept account so results roll up into team readiness reporting. Need one? Create an Adept account.

This course is included with every subscription

Get your team access to all 559 courses, virtual labs, and practice exams.

Most Popular

Team

$749per seat / year

5+ learner seats

Get Started

Enterprise

Customannual contracts

Any size

Contact Enterprise Sales

Just need this course?

Single-course enrollment — $199 for 1 year of access to (DP-500).

Enroll in This Course
Calculate the ROI of training your team

Trusted by 23,000+ organizations

Frequently Asked Questions

Ready to upskill your team?

Talk to our sales team to find the right plan for your organization.