DP-600: Implementing Analytics Solutions Using Microsoft Fabric Online Training

This intermediate DP-600 training prepares learners to integrate diverse data sources, create and deploy data models, implement advanced analytics, and optimize performance with Microsoft Fabric.

Microsoft Fabric comes equipped with some of the industry's most powerful tools and services for designing, creating and deploying enterprise-scale analytics solutions. But without deliberate and thorough training like this course, those tools are just complicated and expensive buttons that no one really understands.

This course puts the enormous power of Microsoft Fabric into your hands. Learn how to design and deploy powerful data solutions that tackle complex challenges. And all the while prepare for the Fabric Analytics Engineer Associate certification.

For IT managers, this Azure training can be used to onboard new data engineers, curated into individual or team training plans, or as a Azure reference resource.

DP-600: What You Need to Know

This DP-600: Implementing Analytics Solutions Using Microsoft Fabric training has videos that cover topics including:

Integrating diverse data sources for ingest
Creating robust data modules in Power BI
Implementing advanced analytics with Azure
Improving data models with machine learning and AI
Optimizing enterprise-scale data solutions

Who Should Take DP-600 Training?

This PCEP training is considered foundational-level Python training, which means it was designed for junior software developers. This Python skills course is valuable for new IT professionals with at least a year of experience with software development and experienced junior software developers looking to validate their Python skills.

New or aspiring junior software developers. This course gives brand new software developers a perfect foundation for landing your first Python job. It covers essential Python skills and terminology while giving chances to practice writing clean and efficient code. The projects you'll code in this course will look great in a portfolio and the certification will be great on a resume.

Experienced junior software developers.This is a good course for software developers who have a few years of experience but no formal training in coding. You'll be familiar with most of the concepts on this course, but learning them from the ground up will ensure your foundations are thoroughly covered and you're ready to advance to advanced Python courses or start learning other languages.

Skill:
Understand Microsoft Fabric Administration
- 1. Introducing Microsoft Fabric
  1 min
- 2. License and Explore Fabric (And Power BI)
  14 mins
- 3. Explore the Admin Settings
  13 mins
- 4. Other Administrative Dev Tools
  7 mins
- 5. CHALLENGE
  4 mins
Skill:
Perform ETL Ops with Dataflows Gen2
- 1. Introducing Dataflows
  2 mins
- 2. Extract Data
  11 mins
- 3. Aggregate Data
  8 mins
- 4. Merge Data
  5 mins
- 5. Filter Data
  3 mins
- 6. Rank Data
  2 mins
- 7. Publish Data to a Lakehouse
  8 mins
- 8. Schedule Automatic Data Refreshes
  4 mins
- 9. CHALLENGE
  7 mins
Skill:
Perform Complex ETL with Data Pipelines
- 1. Introducing Data Factory Pipelines
  1 min
- 2. Create a Data Source in Azure
  11 mins
- 3. Create Your Dataflow to Transform Data
  7 mins
- 4. Prep the Data Destinations
  10 mins
- 5. Set the Data Destination and Create a Pipeline
  12 mins
- 6. CHALLENGE
  7 mins
Skill:
Implement and Explore Lakehouses
- 1. Introducing Fabric Lakehouses
  1 min
- 2. Recall Why OneLake and Lakehouses Matter
  15 mins
- 3. Get Some Sample Data
  2 mins
- 4. Create a Lakehouse and Upload Data Files
  7 mins
- 5. Load Data Into Delta Tables
  10 mins
- 6. Explore the SQL Analytics Endpoint
  9 mins
- 7. Create a Shortcut
  8 mins
- 8. CHALLENGE
  6 mins
Skill:
Build Queries and Reports on Lakehouse
- 1. Introducing Lakehouse Frontend Data Analysis
  1 min
- 2. Create a Visual Query
  5 mins
- 3. Filter and Organize Data
  5 mins
- 4. Create Reports
  5 mins
- 5. CHALLENGE
  6 mins
Skill:
Work with Spark Notebooks
- 1. Introducing Fabric Notebooks
  1 min
- 2. Load Data Into Spark Notebooks
  15 mins
- 3. Set and Alter Schema Data Types and Columns
  11 mins
- 4. Filter Data
  4 mins
- 5. Aggregate, Group, and Sort Data
  5 mins
- 6. CHALLENGE
  5 mins
Skill:
Work with Data Warehouses
- 1. Introducing Data Warehouses
  1 min
- 2. Creating a Data Warehouse
  8 mins
- 3. Perform DDL Operations
  7 mins
- 4. INSERT and UPDATE Operations
  8 mins
- 5. Alter Tables... Sort of
  6 mins
- 6. Copy Data From External Sources with COPY INTO
  6 mins
- 7. CHALLENGE
  5 mins
Skill:
Integrate Spark Notebooks with Lakehouse
- 1. Introducing Data Querying and Writing in Notebooks
  1 min
- 2. Join Dataframes
  10 mins
- 3. Querying with SQL and Python
  9 mins
- 4. Scheduling and Orchestrating Notebooks
  5 mins
- 5. CHALLENGE
  1 min
Skill:
Begin Work with Semantic Models
- 1. Introducing Semantic Models
  2 mins
- 2. Get Some Data
  9 mins
- 3. Create Semantic Model Relationships
  1 min
- 4. Auto-Generate a Report from Your Model
  4 mins
- 5. Create DAX Measures
  5 mins
- 6. Connect to Fabric with Power BI Desktop
  7 mins
- 7. Connect to the SQL Analytics Endpoint
  4 mins
- 8. Publish Apps
  10 mins
- 9. CHALLENGE
  5 mins
Skill:
Design Semantic Models
- 1. Introducing Semantic Model Design
  1 min
- 2. Dimensions and Facts
  10 mins
- 3. Star and Snowflake Schema
  6 mins
- 4. 1st Form Normalization
  9 mins
- 5. 2nd and 3rd Form Normalization
  8 mins
- 6. Merge Queries in Power Query
  4 mins
- 7. CHALLENGE
  4 mins
Skill:
Learn DAX Fundamentals
- 1. Introducing DAX and DAX Studio
  1 min
- 2. Install DAX Studio
  5 mins
- 3. EVALUATE
  8 mins
- 4. ORDER BY and FILTER
  5 mins
- 5. SUMMARIZECOLUMNS
  6 mins
- 6. Basic DAX Aggregations
  4 mins
- 7. DEFINE
  4 mins
- 8. Iterator (or X) Functions
  4 mins
- 9. CALCULATE
  4 mins
- 10. Datetime Functions
  4 mins
- 11. CHALLENGE
  4 mins
Skill:
Use External Semantic Modeling Apps
- 1. Introducing External Modeling Tools
  1 min
- 2. DAX Studio Performance Analysis
  10 mins
- 3. DAX Studio VertiPaq Analyzer
  6 mins
- 4. ALM Toolkit
  8 mins
- 5. Install and Browse Tabular Editor
  6 mins
- 6. Object Level Security
  6 mins
- 7. Row Level Security
  12 mins
- 8. CHALLENGE
  5 mins
Skill:
Implement Calculation Groups
- 1. Create a Calculation Group
  1 min
- 2. Create Calculation Items
  8 mins
- 3. Add Field Parameters to Switch Measures
  6 mins
- 4. Create Calculation Groups in Power BI
  4 mins
- 5. CHALLENGE
  5 mins
Skill:
Understand the Analytics Lifecycle
- 1. Introducing the Analytics Lifecycle
  1 min
- 2. Connect a Workspace to Git
  14 mins
- 3. Implement a Power BI Deployment Pipeline
  10 mins
- 4. CHALLENGE
  7 mins
Skill:
Leverage the XMLA Endpoint
- 1. Introducing the XMLA Endpoint
  1 min
- 2. Governance and Configuration
  4 mins
- 3. Connect and Query with SSMS
  7 mins
- 4. Download and Deploy Models with Tabular Editor
  7 mins
- 5. Query Models with DAX Studio
  5 mins
- 6. Compare and Ship Models with ALM Toolkit
  7 mins
- 7. CHALLENGE
  6 mins
Skill:
Optimize Fabric
- 1. Introducing Fabric Optimization
  1 min
- 2. Profiling Data
  17 mins
- 3. Storage Modes
  6 mins
- 4. File Partitioning
  9 mins
- 5. Partition Existing Tables
  4 mins
- 6. High Capacity Notebook Sessions
  3 mins
- 7. OPTIMIZE and VACUUM
  2 mins
- 8. CHALLENGE
  1 min

Loading transcripts...

Explore the Admin Settings

Access all premium content with a free week!

Start a free week

Explore Features

Course overview

13 HOURS OF TRAINING

16 SKILLS

128 VIDEOS

0 VIRTUAL LABS

0 PRACTICE EXAMS

Knox Hutchinson

Nugget trainer since 2018

Read the full bio

What is it like to train with us?

Our learners say it best.

Helps me learn the skills I need when I need them

THOMAS S. | SYSTEMS ENGINEER & CONSULTANT

Read Reviews

DP-600: Implementing Analytics Solutions Using Microsoft Fabric FAQs: Cost, Training, Value

Is it worth it to learn Microsoft Fabric for implementing analytics solutions?

Yes, what makes learning Microsoft Fabric so worth it is that you can incorporate the range and diversity of all Microsoft's other tools and tie them into your analytics solutions. Microsoft Fabric lets you bring in Microsoft 365, Azure and Power BI insights and apply them to your data engineering – it's a worthwhile investment for a data scientist who works with Microsoft on the regular.

Is this DP-600 course associated with any Microsoft certifications?

Yes, by taking this course you'll be prepared for DP-600, which is the certifying exam for Microsoft's Fabric Analytics Engineer Associate cert. DP-600 costs $165 to take, and covers essential knowledge in designing, creating, and deploying enterprise-scale data analytics solutions with Fabric. This course is designed to cover every section on DP-600 while giving you hands-on practice with the skills-based portions of the exam.

How difficult is it to learn how to implement analytics solutions with Fabric?

It's not especially difficult to learn to use Microsoft Fabric – it has an intuitive interface that's designed to simplify data analysis solutions. But although it's not a hard system to learn to use, mastering it at a professional level is a different question. This course spends time on Fabric's advanced features that require deliberate practice while challenging you to demonstrate real-world data integration and analysis skills.

What is Microsoft Fabric especially good at?

Microsoft Fabric's best feature is its unification of data management, analytics and collaboration across Microsoft 365, Azure and Power BI. For an organization of any size, if other Microsoft products are being used to store and analyze data, Microsoft Fabric is a huge force multiplier. Companies that need seamless data integration with real-time insights love Fabric and need data analysts who know how to navigate it.

Who should take this course on implementing analytics solutions with Fabric?

Data analysts, business intelligence professionals and data engineers with a few years of experience on the job are the best audience for this Microsoft Fabric course. Data professionals who want to accelerate their career and know they'll be working with other Microsoft products are also excellent candidates. Anyone who manages data for an enterprise that's reliant on Microsoft technologies will benefit from learning how Fabric simplifies tasks and enhances decision making.

Microsoft Azure Data Fundamentals (DP-900)

CompTIA Data+ (DA0-001)

What is it like to train with us?

Our learners say it best.

DP-600: Implementing Analytics Solutions Using Microsoft Fabric FAQs: Cost, Training, Value

Let's chat!