DP-500: Microsoft Azure and Microsoft Power BI Online Training

Focused View

Knox Hutchinson

20:17:36

303 View

1 Govern a Data Landscape with Microsoft Purview

1 Introducing Microsoft Purview.mp4

01:56

2 The Point of Purview.mp4

12:47

3 Deploy the Purview Resource.mp4

12:06

4 Configure a User Assigned Managed Identity.mp4

05:30

5 Register and Scan Data.mp4

18:55

6 Browse and Edit Catalog Assets.mp4

09:43

2 Administer Power BI with Powershell and REST APIs

7 Automate Power BI Administration.mp4

03:12

8 A Primer on PowerShell.mp4

14:07

9 Login and Get Power BI Data.mp4

13:32

10 Change Power BI Admin Data.mp4

09:35

11 Prepare for REST API Administration.mp4

05:49

12 Use the REST API (with PowerShell).mp4

13:12

3 Integrate Power BI into an Existing Infrastructure

13 Integrating Power BI In An Existing Infrastructure.mp4

01:55

14 Plan for Power BI Integration.mp4

12:18

15 Configure Capacity Settings.mp4

05:49

16 Deploy and Use an On-Premises Data Gateway.mp4

21:30

17 Connect to Azure Data Lake Storage Gen 2.mp4

09:18

18 Work with Azure Synapse Analytics Workspaces.mp4

08:00

4 Utilize Source Control with Power BI Resources

19 Introducing Source Control in Analytics.mp4

02:22

20 The Github Crash Course.mp4

22:23

21 Using OneDrive for Version Control.mp4

05:58

22 Extract a Data Model.mp4

11:48

23 Leveraging Source Control in Azure Synapse.mp4

10:06

5 Deploy and Manage Datasets Using XMLA Endpoints

24 Introducing the XMLA Endpoint.mp4

01:15

25 The Point of the XMLA Endpoint (and APIs).mp4

09:35

26 XMLA Endpoint Governance and Management.mp4

05:18

27 Querying and Processing with SSMS.mp4

08:45

28 Deploying Data Models with Tabular Editor 3.mp4

09:46

29 Connecting to XMLA with DAX Studio.mp4

05:23

30 Schema Compare and Deployment with ALM Toolkit.mp4

10:19

6 Implement Power BI Deployment Pipelines

31 Introducing Power BI Pipelines.mp4

01:22

32 How Pipelines Work.mp4

09:18

33 Create the Premium Workspaces.mp4

06:39

34 Deploy a Report through Production.mp4

11:04

35 Manage Deployment Options.mp4

07:34

36 Automate Pipelines with Azure DevOps.mp4

23:11

37 Summarizing Power BI Pipelines.mp4

01:17

7 Understand ETL and Data Warehouse Concepts

38 Introducing Data Warehouse Concepts.mp4

03:46

39 Data Warehouse Designs.mp4

21:09

40 ETL Concepts.mp4

18:42

41 Other Data Warehouse Resources.mp4

05:48

8 Implement, Load, and Query a Dedicated SQL Pool in Azure Synapse

42 Introducing Managing a Dedicated SQL Pool.mp4

01:59

43 Create Tables.mp4

23:41

44 Stage Data into Staging Tables.mp4

06:31

45 Load Data into a Dimension Table.mp4

09:40

46 Query Data in a Data Warehouse.mp4

12:00

47 Summarizing Data Warehouse Implementation.mp4

00:56

9 Query Data with Serverless SQL Pools

48 Introducing Querying with Serverless SQL Pools.mp4

01:55

49 Understand the Point of SQL Pools.mp4

11:41

50 Perform a Basic Serverless Query.mp4

12:11

51 Query JSON Files.mp4

10:09

52 Query Into a Filepath.mp4

07:00

53 Create a Database of External Sources.mp4

08:03

10 Query and Visualize Data Using Apache Spark in Azure Synapse

54 Introducing Apache Spark Pools.mp4

01:05

55 Deploy an Apache Spark pool.mp4

14:06

56 Perform a basic Pyspark Query.mp4

17:06

57 Define a Schema and Filter Query Results.mp4

12:27

58 Create a Catalog.mp4

06:03

59 Query Data with Apache Spark.mp4

07:20

60 Visualize Data in the Results Pane.mp4

04:37

11 Use the ML PREDICT T-SQL Function

61 Introducing the PREDICT Function.mp4

02:22

62 Set Up an ML Dev Environment.mp4

12:45

63 Generate the ONNX File.mp4

09:10

64 Load the Model into the Data Warehouse.mp4

07:53

65 Load the Data into the Data Warehouse.mp4

16:12

66 Use the PREDICT T-SQL Function.mp4

07:55

12 Query Advanced Data Sources using Power BI

67 Introducing Advanced Data Source Querying in Power BI.mp4

01:14

68 A Primer on JSON Data.mp4

08:36

69 Connect to and Query JSON Files.mp4

06:37

70 Connect to an API.mp4

11:03

71 Connect to Parquet Files.mp4

05:33

72 Set Up a ML Model.mp4

12:52

73 Consume the ML Model in Power Query.mp4

06:33

74 Deploy and Refresh the Model.mp4

05:13

13 Understand Enterprise Data Model Scalability Concepts

75 Understanding Data Model Scalability Designs.mp4

01:46

76 Understand Your Storage Mode Options.mp4

16:01

77 The Import Storage Mode.mp4

17:08

78 The DirectQuery Storage Mode.mp4

11:28

79 The Composite Storage Mode.mp4

07:24

80 Designing with Scalability in Mind.mp4

10:00

14 Deploy Power BI Dataflows

81 Introducing Power BI Dataflows.mp4

01:33

82 How Dataflows Work.mp4

12:20

83 Deploy a Dataflow.mp4

14:00

84 Set up Refresh Schedules.mp4

07:43

85 Edit and Add Additional Datasources.mp4

06:28

86 Maintaining and Endorsing Dataflows.mp4

08:06

15 Optimize Power Query and Report Performance

87 Introducing Power Query Optimization.mp4

01:04

88 Power Query Diagnostic Tracing.mp4

12:36

89 Report Analyzer.mp4

06:19

90 Tracing with SQL Profiler.mp4

08:00

91 Premium Capacity Metrics App.mp4

05:48

92 Fix Native Queries.mp4

08:21

93 Remove AutoDate.mp4

07:16

16 Create Calculation Groups in Tabular Editor

94 Introducing Calculation Groups.mp4

01:33

95 Understand the Problem with Measures.mp4

15:24

96 Explore Calculation Groups.mp4

05:20

97 Create Calculated Items.mp4

06:06

98 Clean Up the Calculation Group.mp4

09:25

99 Summarizing Calculation Groups.mp4

01:37

100 Challenge- Work Through Your Own Lab-.mp4

08:11

17 Create Queries, Functions, and Parameters by using the Power Query Advanced Editor

101 Introducing M in the Advanced Editor.mp4

01:54

102 Understand the Advanced Editor Syntax.mp4

10:19

103 Create a Basic Function.mp4

10:04

104 Use a Built-In Number Function.mp4

09:24

105 Create a Function with Conditions.mp4

08:38

106 Create a Table Function.mp4

06:13

107 Utilize Parameters.mp4

05:47

18 Implement Row and Object Level Security

108 Introducing Row and Object Level Security.mp4

01:21

109 Understand Row and Object Level Security.mp4

12:53

110 Implement Fixed Row Level Security.mp4

09:29

111 Implement Dynamic Row Level Security.mp4

11:12

112 DirectQuery Row Level Security Considerations.mp4

07:34

113 Implement Object Level Security.mp4

08:51

19 Leverage DirectQuery and Composite Data Models

114 Introducing DirectQuery .mp4

01:15

115 Pros and Cons of DirectQuery - Part 1.mp4

09:39

116 Pros and Cons of DirectQuery - Part 2.mp4

09:07

117 Basic DirectQuery Refresher.mp4

10:30

118 Reduce the Query Workload.mp4

11:14

119 Configure Dashboard Refresh Intervals.mp4

04:34

120 Use Composite Models.mp4

07:51

121 Summarizing DirectQuery.mp4

01:15

20 Optimize Data Models Using Third-Party Tools

122 Introducing Data Model Optimizations with Third Party Tools.mp4

02:00

123 Performance Analyzer.mp4

15:29

124 Understand VertiPaq Engine - Part 1.mp4

08:44

125 Understand VertiPaq Engine - Part 2.mp4

05:15

126 DAX Studio Server Timings.mp4

08:31

127 Model Metrics.mp4

09:29

128 Best Practices Analyzer in Tabular Editor.mp4

10:21

129 Summarizing Data Model Optimization.mp4

01:13

21 Use Advanced Visuals in Power BI

130 Introducing Advanced Power BI Visuals.mp4

01:14

131 Visual Best Practices.mp4

09:14

132 Use Themes.mp4

07:51

133 Implement Personalized Views.mp4

08:49

134 Implement Perspectives.mp4

05:06

135 Create R Visuals.mp4

10:31

136 Create Python Visuals.mp4

13:35

22 Create Power BI Paginated Reports

137 Introducing Power BI Paginated Reports.mp4

02:11

138 Before You Begin....mp4

08:12

139 Connecting to a Data Source.mp4

09:45

140 Creating a Dataset.mp4

07:01

141 Creating a Table Visual.mp4

08:31

142 Using Parameters.mp4

10:55

143 Adding Charts to the Visual.mp4

05:06

144 Deploying a Paginated Report to Power BI.mp4

04:02

Description

This intermediate DP-500 prepares learners to take full control of a data analytics solution at the largest possible scale using Microsoft Power BI and tools available in Microsoft Azure.

If you're at the point in your career where you're considering a job in data analytics solutions that work at the enterprise level, you may think the skills necessary to be excellent in the field come naturally to some people and not others. But that's not true – designing, creating, and deploying large data analytics solutions are skills you can learn and practice.

More details

This Microsoft Azure and Power BI 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.

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 tools available in Microsoft Azure.

For anyone who manages their Microsoft 365 training, this Microsoft 365 training can be used to onboard new data analytics professionals, curated into individual or team training plans, or as a Microsoft 365 reference resource.

DP-500: What You Need to Know

For any data analysts and data engineers looking to improve their proficiency with data analysis and data visualization tools, this Microsoft 365 course covers topics such as:

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

Who Should Take DP-500: Microsoft Azure and Microsoft Power BI Training?

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.

New or aspiring data analysts and data engineers. This course is an excellent learning opportunity for IT professionals, data analysts, and data engineers. Learn what a robust data solution looks like at any scale and how many tools Microsoft supplies you to do the hardest work automatically.

Experienced data analysts and data engineers. The world runs on data, and if it's a part of your job to plan how your company or network is going to use, store, or process data, you should take this course in designing and implementing enterprise-scale analytics solutions. No matter where you are in your career, master Microsoft's tools for handling the biggest data environments.

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft Azure

Microsoft Power BI

Microsoft Certification

Knox Hutchinson

Instructor's Courses

The personal touch, coupled with the ability to go at your own pace, makes video training far and away the best way to learn.

Knox brings a wealth of data analysis and visualization experience to CBT Nuggets. Knox started off as a CBT Nuggets learner, became a mentor in our Learner Community, and is now a trainer. Having benefited from the CBT Nuggets Learning Experience firsthand, Knox creates training that connects with learners. Knox also has a wide range of IT experience. Prior to joining CBT Nuggets, Knox worked as an IT consultant, advising in a variety of areas including networking, cloud computing, and project management.

Certifications: Microsoft MCSE: Cloud Platform and Infrastructure, Microsoft MCP: Administering SQL Server 2012/2014 Databases, Cisco DevNet Professional, Cisco CCNP: Enterprise, Certified Meraki Network Operator (CMNO), JNCIA-JUNOS, JNCIA-DevOps, Tableau Desktop Qualified Associate, and CompTIA Network+

Areas of expertise: Data analysis and visualization, business intelligence solutions

CBT Nuggets

View courses CBT Nuggets

CBT Nuggets is renowned for providing innovative training that's informative, meaningful, and engaging. We provide a variety of training, primarily in IT, project management, and office productivity topics. Our comprehensive library contains thousands of training videos ranging from Cisco networking to Microsoft Word. Whether you want to pass a certification exam, increase your skills, or simply learn new things, we've got you covered! All of our training is delivered through high-quality online streaming video. Subscribers can train 24 hours a day, seven days a week, from the convenience of a computer or mobile device. CBT Nuggets trainers are the rock stars of training, renowned for their expertise, industry-wide credibility, and engaging personalities. They enable CBT Nuggets to deliver accurate, up-to-date training, using a laid-back whiteboard presentation style. There are no scripts, EVER. Our trainers love to teach, and it shows! CEO and founder Dan Charbonneau was a Microsoft trainer when he began recording CBT Nuggets' very first training videos back in the 1990s. He wanted to help provide large organizations, small teams and individuals with comprehensive and budget-conscious training, and he realized it couldn't be done in a classroom. From the CBT Nuggets World Headquarters in Eugene, Oregon, Dan and his team promise each video will be informative, comprehensive, accurate, and fun to watch.