Microsoft Fabric from Udemy

What's inside

Learning objectives

The onelake platform
Fabric lakehouses
Fabric data warehouses
Dataflows gen2

Power bi and direct lake
Data factory (data pipelines)
Shortcuts
Compute engines, querying and working with fabric data

The onelake platform
Fabric lakehouses
Fabric data warehouses
Dataflows gen2
Power bi and direct lake
Data factory (data pipelines)
Shortcuts
Compute engines, querying and working with fabric data

Syllabus

Introduction

Course introduction

What's not covered in this course - Data Science and Real Time Analytics

Microsoft Fabric is generally available.

The Microsoft Fabric Environment - Covering the Basics

What is Microsoft Fabric?

Microsoft Fabric is build upon the concept of OneLake. We discuss OneLake in this lecture.

Here we discuss Direct Lake and its importance to Power BI

A discussion of how lakehouses and data warehouses and similar and different

A discussion of delta lakes

A discussion of delta parquet files and their importance

A discussion of data warehousing in Fabric

A discussion of Data Activator

A discussion of Microsoft Copilot

Microsoft Copilot introduction part 2

Microsoft Copilot introduction part 3

Microsoft Copilot introduction part 4

A discussion of Fabric licensing and pricing

A visual overview of Microsoft Fabric

A continuation of a visual overview of Microsoft Fabric

Am I going to lose my job?

Can Microsoft really make Fabric a success?

Getting Ready to Use Microsoft Fabric

A guide to getting started

Using Microsoft Fabric - Data Engineering

In this lecture we talk about the various options you have with regards to loading data into a Lakehouse

A discussion of Lakehouses in Fabric

Enhancements were made in the July 2023 Fabric update regarding how files are moved from the Files folder to the Tables folder.

We continue our discussion of Lakehouses in Fabric

In this exercise you will create a Lakehouse, upload some CSV files and convert them to delta parquet format to be used later by any number of compute engines.

In this lecture we demonstrate creating DAX measures and visual queries

Exercise #2

In this lecture we explore the capabilities of the new Dataflows Gen2

In this lecture we will demonstrate how to load data into your Lakehouse using Gen 2

An exercise using Dataflows Gen 2

In this lecture we demonstrate how to use Direct Lake

We continue our discussion of Direct Lake

A discussion of Fabric data warehouses

In this lecture we discuss Query Insights and how it allow you to track queries run in your Fabric environment

In this lecture we discuss zero-copy clones of data warehouse tables

In this lecture we talk about the ability to share a Lakehouse and Data Warehouses

In this exercise you will be creating a data warehouse containing New York City taxi data

This exercise builds on the prior exercise to test the performance of the data warehouse

Using Microsoft Fabric - Data Factory

In this lecture we being our demonstration of Data Pipelines

We continue our discussion of Data Pipelines

We wrap up our discussion of Data Pipelines

Data Factory exercise #1

Using Microsoft Fabric - Miscelleanous

Supported data types in Microsoft Fabric

In this lecture we discuss the Lakehouse Explorer

In this lecture we begin a discussion on shortcuts

We continue our discussion on shortcuts

We begin a light discussion of Apache Spark and it's integration into Microsoft Fabric

An exercise using Apache Spark

In this lecture we discuss the ability to perform data wrangling inside a notebook

An exercise in using data wrangline

Another exercise in using data wrangling

In this lecture we briefly talk about Semantic Link

In this lecture we do a little deeper dive into the default dataset that is created when you create a data warehouse or Lakehouse.

We discuss real-time analytics with KQL

In this lecture we discuss how to load Snowflake data into a Fabric Lakehouse

Here we discuss Fabric domains and roles

We talk more about capacities along with bursting and smoothing

In this lecture we discuss how Fabric will influence the Power BI experience

In this lecture we discuss the impact Fabric will have on Azure Synapse Analytics

Comparing and contrasting Fabric and Databricks

Icons for use in architectural diagrams

Microsoft Fabric July 2023 Monthly Update

Discussion about the new features released in the July 2023 timeframe

Monitoring Hub

Sharing

Updates related to Fabric Data Warehouse

Updates to the data engineering experience

Microsoft Fabric August 2023 Monthly Update

Significant new features added to Fabric in August 2023

Significant new features added to Fabric in September 2023

Updates pertaining to Synapse Data Warehouse

Changes to Data Engineering experience

Changes to Real-Time Analytics experience

Significant new features added to Fabric in October 2023

Changes to Fabric core

Synapse Data Warehouse changes

Data science updates

Updates to Real-Time Analytics

Enhancements made to Data Engineering

Significant new features added to Fabric in November 2023

Datasets have been rebranded as Semantic Models

Updates to the core Fabric environment

New Features in the Data Science experience

Updates to Real-Time Analytics (KQL)

Enhancements to Dataflows Gen2

Microsoft Fabric December 2023 Monthly Update

Core updates

Data engineering updates

Data Science updates

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Introduces learners to the cutting-edge technologies used in modern data analytics

Explores Microsoft Fabric, a comprehensive platform for managing data and analytics

Delves into the concepts of OneLake, Lakehouses, and Data Warehouses, essential elements of Microsoft Fabric

Provides hands-on experience with Data Factory, Dataflows Gen2, and Direct Lake for efficient data management and analytics

Suitable for professionals seeking to enhance their skills in data analytics using Microsoft technologies

Course Instructor Randy Minder has recognized expertise in the field

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Microsoft Fabric with these activities:

Review concepts of cloud computing and data storage

Show steps

Reinforces foundational knowledge of cloud computing and data storage for better understanding of data lake concepts.

Browse courses on Cloud Computing

Show steps

Review articles and whitepapers on cloud computing and data storage
Attend a webinar or online workshop on cloud computing and data storage

Review concepts of data lake architectures

Show steps

Refreshes understanding of data lake architectures to provide context for the course content.

Browse courses on Data Lakes

Show steps

Review articles and whitepapers on data lake architecture
Attend a webinar or online workshop on data lakes

Write SQL queries to retrieve data from a data lake

Show steps

Provides hands-on practice with SQL and reinforces understanding of data lake querying.

Browse courses on SQL

Show steps

Set up a data lake environment for practice
Write SQL queries to retrieve data from different sources within the data lake
Validate the results of the queries

Two other activities

Expand to see all activities and additional details

Show all five activities

Design a conceptual data model for a data lake

Show steps

Enhances understanding of data lake design principles and provides practical experience.

Browse courses on Data Modeling

Show steps

Gather requirements for the data lake
Identify the entities and relationships in the data
Create a conceptual data model using a modeling tool
Validate the data model with stakeholders

Create a collection of resources on data lake architecture and best practices

Show steps

Organizes and consolidates information to provide a valuable resource for further learning.

Browse courses on Best Practices

Show steps

Gather articles, whitepapers, and other resources on data lake architecture and best practices
Organize the resources into a central location
Create a summary or overview of the resources

Career center

Learners who complete Microsoft Fabric will develop knowledge and skills that may be useful to these careers:

Data Warehouse Architect

A Data Warehouse Architect designs and builds data warehouses. Data Warehouse Architects typically work in collaborative environments alongside individuals in roles such as Data Engineers, Data Analysts, and Data Scientists. This course may be useful to those who wish to pursue a career as a Data Warehouse Architect as it provides a comprehensive overview of the Microsoft Fabric platform, which includes a fully managed data warehousing service.

See salaries and explore the career path for Data Warehouse Architect

ETL Developer

An ETL Developer designs and builds data pipelines that extract, transform, and load data from various sources into a target data store. This course may be useful to those who wish to pursue a career as an ETL Developer as it covers the fundamentals of data engineering, including data ingestion, transformation, and storage.

See salaries and explore the career path for ETL Developer

Power BI Developer

A Power BI Developer designs and develops Power BI reports and dashboards. Power BI Developers typically work in collaborative environments alongside individuals in roles such as Data Engineers, Data Analysts, and Data Scientists. This course may be useful to those who wish to pursue a career as a Power BI Developer as it provides a comprehensive overview of the Microsoft Fabric platform, which includes a fully managed Power BI service.

See salaries and explore the career path for Power BI Developer

Data Architect

A Data Architect designs and builds the data infrastructure that supports an organization's data needs. Data Architects typically work in collaborative environments alongside individuals in roles such as Data Engineers, Data Analysts, and Data Scientists. This course may be useful to those who wish to pursue a career as a Data Architect as it provides a comprehensive overview of the Microsoft Fabric platform, which is a unified platform designed to meet an organization's data and analytics needs.

See salaries and explore the career path for Data Architect

Data Engineer

A Data Engineer develops and maintains the infrastructure and processes that support data analytics. The role of a Data Engineer includes building and managing data pipelines, designing data models, and optimizing data storage systems. This course may be useful to those who wish to pursue a career as a Data Engineer as it provides a comprehensive overview of the Microsoft Fabric platform, which is a unified platform designed to meet an organization's data and analytics needs.

See salaries and explore the career path for Data Engineer

Cloud Data Engineer

A Cloud Data Engineer designs and builds data pipelines and data infrastructure in the cloud. Cloud Data Engineers typically work in collaborative environments alongside individuals in roles such as Data Engineers, Data Analysts, and Data Scientists. This course may be useful to those who wish to pursue a career as a Cloud Data Engineer as it provides a comprehensive overview of the Microsoft Fabric platform, which is a cloud-based data and analytics platform.

See salaries and explore the career path for Cloud Data Engineer

Data Integration Specialist

A Data Integration Specialist designs and builds data pipelines that integrate data from various sources into a target data store. This course may be useful to those who wish to pursue a career as a Data Integration Specialist as it covers the fundamentals of data engineering, including data ingestion, transformation, and storage.

See salaries and explore the career path for Data Integration Specialist

Data Quality Analyst

A Data Quality Analyst ensures that an organization's data is accurate, complete, and consistent. This course may be useful to those who wish to pursue a career as a Data Quality Analyst as it covers the fundamentals of data management, including data storage, security, and governance.

See salaries and explore the career path for Data Quality Analyst

Database Administrator

A Database Administrator manages the day-to-day operations of a database system. This includes tasks such as creating and maintaining user accounts, monitoring system performance, and backing up data. This course may be useful to those who wish to pursue a career as a Database Administrator as it covers the fundamentals of data management, including data storage, security, and performance.

See salaries and explore the career path for Database Administrator

Data Governance Analyst

A Data Governance Analyst develops and implements policies and procedures to ensure that an organization's data is managed in a consistent and compliant manner. This course may be useful to those who wish to pursue a career as a Data Governance Analyst as it covers the fundamentals of data management, including data storage, security, and governance.

See salaries and explore the career path for Data Governance Analyst

Data Security Analyst

A Data Security Analyst protects an organization's data from unauthorized access, use, disclosure, disruption, modification, or destruction. This course may be useful to those who wish to pursue a career as a Data Security Analyst as it covers the fundamentals of data security, including data security threats and countermeasures.

See salaries and explore the career path for Data Security Analyst

Data Analyst

A Data Analyst sets up and executes data collection, storage, and analysis processes to translate raw data into meaningful insights. Data Analysts typically work in collaborative environments alongside individuals in roles such as Data Engineers, Data Scientists, and Software Developers. This course may be useful to those who wish to pursue a career as a Data Analyst as it covers the fundamentals of data analytics, including data ingestion, transformation, and visualization.

See salaries and explore the career path for Data Analyst

Business Intelligence Analyst

A Business Intelligence Analyst uses data to provide insights that can help businesses make better decisions. Business Intelligence Analysts typically work in collaborative environments alongside individuals in roles such as Data Engineers, Data Analysts, and Data Scientists. This course may be useful to those who wish to pursue a career as a Business Intelligence Analyst as it covers the fundamentals of data analytics, including data ingestion, transformation, and visualization.

See salaries and explore the career path for Business Intelligence Analyst

Data Scientist

A Data Scientist uses statistical and machine learning techniques to extract insights from data. Data Scientists typically work in collaborative environments alongside individuals in roles such as Data Engineers, Data Analysts, and Software Developers. This course may be useful to those who wish to pursue a career as a Data Scientist as it covers the fundamentals of data analytics, including data ingestion, transformation, and visualization.

See salaries and explore the career path for Data Scientist

Data Visualization Specialist

A Data Visualization Specialist designs and develops data visualizations that communicate insights from data in a clear and concise way. This course may be useful to those who wish to pursue a career as a Data Visualization Specialist as it covers the fundamentals of data visualization, including data visualization techniques and tools.

See salaries and explore the career path for Data Visualization Specialist