DP-600 Implementing Analytics Solutions Using Microsoft Fabric

Focused View

11:21:13

0 View

1. Understand Microsoft Fabric Administration

1. Introducing Microsoft Fabric.mp4

01:19

2. Understand OneLake Architecture.mp4

14:23

3. License and Explore Fabric - And Power BI.mp4

14:12

4. Explore the Admin Settings.mp4

12:31

5. Other Administrative Dev Tools.mp4

06:35

6. CHALLENGE.mp4

03:11

2. Perform ETL Ops with Dataflows Gen2

1. Introducing Dataflows.mp4

02:42

2. Extract Data.mp4

11:17

3. Aggregate Data.mp4

07:52

4. Merge Data.mp4

05:07

5. Filter Data.mp4

03:17

6. Rank Data.mp4

02:37

7. Publish Data to a Lakehouse.mp4

07:44

8. Schedule Automatic Data Refreshes.mp4

03:46

9. CHALLENGE.mp4

06:23

3. Perform Complex ETL with Data Pipelines

1. Introducing Data Factory Pipelines.mp4

01:01

2. Create a Data Source in Azure.mp4

10:58

3. Create Your Dataflow to Transform Data.mp4

07:05

4. Prep the Data Destinations.mp4

09:40

5. Set the Data Destination and Create a Pipeline.mp4

11:43

6. Validate and Run the Pipeline.mp4

03:40

7. CHALLENGE.mp4

05:58

4. Implement and Explore Lakehouses

1. Introducing Fabric Lakehouses.mp4

00:59

2. Recall Why OneLake and Lakehouses Matter.mp4

14:35

3. Get Some Sample Data.mp4

02:12

4. Create a Lakehouse and Upload Data Files.mp4

07:03

5. Load Data Into Delta Tables.mp4

09:51

6. Explore the SQL Analytics Endpoint.mp4

08:36

7. Create a Shortcut.mp4

07:27

8. CHALLENGE.mp4

04:50

5. Build Queries and Reports on Lakehouse

1. Introducing Lakehouse Frontend Data Analysis.mp4

01:18

2. Understand Where Frontend Analytics Comes In.mp4

06:27

3. Create a Visual Query.mp4

04:44

4. Filter and Organize Data.mp4

04:56

5. Transform and Add Columns.mp4

05:13

6. Work with Semantic Models.mp4

14:19

7. Create Reports.mp4

04:50

8. CHALLENGE.mp4

05:16

6. Work with Data Warehouses

1. Introducing Data Warehouses.mp4

01:26

2. Creating a Data Warehouse.mp4

08:09

3. Perform DDL Operations.mp4

07:24

4. INSERT and UPDATE Operations.mp4

07:38

5. Alter Tables... Sort of.mp4

06:30

6. Update Records with Calculations.mp4

04:59

7. Copy Data From External Sources with COPY INTO.mp4

05:38

8. CHALLENGE.mp4

04:26

7. Work with Spark Notebooks

1. Introducing Fabric Notebooks.mp4

01:28

2. What Spark Really Is.mp4

07:33

3. Load Data Into Spark Notebooks.mp4

15:09

4. Set and Alter Schema Data Types and Columns.mp4

11:22

5. Filter Data.mp4

03:58

6. Aggregate, Group, and Sort Data.mp4

05:20

7. CHALLENGE.mp4

04:08

8. Integrate Spark Notebooks with Lakehouse

1. Introducing Data Querying and Writing in Notebooks.mp4

00:58

2. Join Dataframes.mp4

09:43

3. Write Files to a Lakehouse.mp4

08:45

4. Write Data to Delta Tables.mp4

04:32

5. Querying with SQL and Python.mp4

08:47

6. Scheduling and Orchestrating Notebooks.mp4

05:14

7. CHALLENGE.mp4

04:01

9. Begin Work with Semantic Models

1. Introducing Semantic Models.mp4

01:44

2. Get Some Data.mp4

09:22

3. Create Semantic Model Relationships.mp4

07:58

4. Auto-Generate a Report from Your Model.mp4

03:53

5. Create DAX Measures.mp4

04:38

6. Connect to Fabric with Power BI Desktop.mp4

06:56

7. Connect to the SQL Analytics Endpoint.mp4

03:47

8. Publish Apps.mp4

10:25

9. CHALLENGE.mp4

04:08

10. Design Semantic Models

1. Introducing Semantic Model Design.mp4

01:21

2. Dimensions and Facts.mp4

09:42

3. Star and Snowflake Schema.mp4

05:29

4. 1st Form Normalization.mp4

08:47

5. 2nd and 3rd Form Normalization.mp4

07:30

6. What Works Best for Analytics.mp4

03:24

7. Merge Queries in Power Query.mp4

03:33

8. CHALLENGE.mp4

03:14

11. Learn DAX Fundamentals

1. Introducing DAX and DAX Studio.mp4

01:13

2. Install DAX Studio.mp4

04:56

3. EVALUATE.mp4

08:29

4. ORDER BY and FILTER.mp4

04:39

5. SUMMARIZECOLUMNS.mp4

06:06

6. Basic DAX Aggregations.mp4

04:29

7. DEFINE.mp4

04:22

8. Iterator - or X Functions.mp4

03:34

9. CALCULATE.mp4

03:48

10. Datetime Functions.mp4

04:11

11. CHALLENGE.mp4

03:20

12. Use External Semantic Modeling Apps

1. Introducing External Modeling Tools.mp4

01:49

2. DAX Studio Performance Analysis.mp4

09:46

3. DAX Studio VertiPaq Analyzer.mp4

06:06

4. ALM Toolkit.mp4

07:21

5. Install and Browse Tabular Editor.mp4

06:00

6. Use Tabular Editor Best Practices Analyzer.mp4

04:06

7. Object Level Security.mp4

05:20

8. Row Level Security.mp4

11:21

9. CHALLENGE.mp4

04:30

13. Implement Calculation Groups

1. Introduction.mp4

02:47

2. Understand Measure Sprawl.mp4

07:20

3. Create a Calculation Group.mp4

04:04

4. Create Calculation Items.mp4

07:20

5. Use Calculation Groups in a Report.mp4

09:44

6. Add Field Parameters to Switch Measures.mp4

05:31

7. Create Calculation Groups in Power BI.mp4

04:05

8. CHALLENGE.mp4

04:29

14. Leverage the XMLA Endpoint

1. Introducing the XMLA Endpoint.mp4

01:09

2. Understand the Point of XMLA.mp4

07:28

3. Governance and Configuration.mp4

04:07

4. Connect and Query with SSMS.mp4

06:30

5. Download and Deploy Models with Tabular Editor.mp4

06:57

6. Query Models with DAX Studio.mp4

04:20

7. Compare and Ship Models with ALM Toolkit.mp4

06:39

8. CHALLENGE.mp4

04:41

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Data Science

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.