Implementing a Lakehouse with Microsoft Fabric (DP-601)

The primary audience for this course is data professionals who are familiar with data modeling, extraction, and analytics. It is designed for professionals who are interested in gaining knowledge about Lakehouse architecture, the Microsoft Fabric platform, and how to enable end-to-end analytics using these technologies.

Description

 

Students will learn:

  • Introduction to end-to-end analytics using Microsoft Fabric
  • Get started with lakehouses in Microsoft Fabric
  • Use Apache Spark in Microsoft Fabric
  • Work with Delta Lake tables in Microsoft Fabric
  • Ingest Data with Dataflows Gen2 in Microsoft Fabric
  • Use Data Factory pipelines in Microsoft Fabric
  • Organize a Fabric lakehouse using medallion architecture design

 

 

Course Outline

 

Module 1: Introduction to end-to-end analytics using Microsoft Fabric

  • Describe end-to-end analytics in Microsoft Fabric

 

Module 2: Get started with lakehouses in Microsoft Fabric

  • Describe core features and capabilities of lakehouses in Microsoft Fabric
  • Create a lakehouse
  • Ingest data into files and tables in a lakehouse
  • Query lakehouse tables with SQL

 

Module 3: Use Apache Spark in Microsoft Fabric

  • Configure Spark in a Microsoft Fabric workspace
  • Identify suitable scenarios for Spark notebooks and Spark jobs
  • Use Spark dataframes to analyze and transform data
  • Use Spark SQL to query data in tables and views
  • Visualize data in a Spark notebook

 

Module 4: Work with Delta Lake tables in Microsoft Fabric

  • Understand Delta Lake and delta tables in Microsoft Fabric
  • Create and manage delta tables using Spark
  • Use Spark to query and transform data in delta tables
  • Use delta tables with Spark structured streaming

 

Module 5: Ingest Data with Dataflows Gen2 in Microsoft Fabric

  • Describe Dataflow capabilities in Microsoft Fabric
  • Create Dataflow solutions to ingest and transform data
  • Include a Dataflow in a pipeline

 

Module 6: Use Data Factory pipelines in Microsoft Fabric

  • Describe pipeline capabilities in Microsoft Fabric
  • Use the Copy Data activity in a pipeline
  • Create pipelines based on predefined templates
  • Run and monitor pipelines

 

Module 7: Organize a Fabric lakehouse using medallion architecture design

  • Describe the principles of using the medallion architecture in data management.
  • Apply the medallion architecture framework within the Microsoft Fabric environment.
  • Analyze data stored in the lakehouse using DirectLake in Power BI.
  • Describe best practices for ensuring the security and governance of data stored in the medallion architecture.

 

 

 

Prerequisites

 

You should be familiar with basic data concepts and terminology.

Similar courses

The Microsoft Power Platform helps organizations optimize their operations by automating routine tasks and standardizing business best practices.

More Information

This course will review the Dynamics 365 Customer Insights - Journeys application configuration needed to drive business growth.

More Information

Microsoft Dynamics 365 Finance and Operations Apps Developers implement and extend applications to meet the requirements of the business.

More Information

This course is developed for those aspired to be and new to the solution architect role. This course provides the technical information focusing on application architecture and technical skills to start their journey into this role. This course will not cover the industrial skills and delivery skills required for this role.

More Information

This course covers the core features of Dynamics 365 Finance, including core common features, core configuration, data migration, and preparing to go live.

More Information

This course will equip students with the skills necessary to identify and configure the key components that are used to deliver Field Service and mobile solutions.

More Information

Microsoft Dynamics 365 for Sales is an end-to-end application to manage the handling of customers and potential customers; tracking data against sales goals, automating your best practices, learning from your data and more.

More Information

Microsoft Dynamics 365 for Customer Service offers any organization an opportunity for customer success. Using tools such as automatic case creation and queue management frees up your time to dedicate it where you can have a greater impact, directly with your customers.

More Information

In this course, students will learn about decisions a Solution Architect makes during an implementation, covering security, integrations, Power Apps architecture, Power Automate architecture, and more.

More Information

This course provides students with hands-on experience and an in depth understanding of the Microsoft Power Platform.

More Information

This course provides students with an introduction to Microsoft Power BI by building a foundation for all subsequent courses and learning.

More Information

The main purpose of the course is to give students a good understanding of data analysis with Power BI.

More Information

This course is designed for citizen developers and technical users, providing the skills required to gain insights into data held within the Dataverse, create custom reports, custom visualizations and implement the Artificial Intelligence features in Microsoft Dynamics 365 and the Power Platform.

More Information

This course provides students with detailed hands-on experience of Microsoft Dynamics 365 Sales with the new Copilot AI companion .

More Information

This course covers the financial aspects of Dynamics 365: configure and use essential financial components, accounts payable, accounts receivable, collections, budgeting, fixed assets, and additional functionality.

More Information

This course provides learners with a broad overview of Dynamics 365 applications.

More Information

This course discusses manufacturing in the Dynamics 365 suite of apps: discrete manufacturing, lean manufacturing, and production

More Information

This course discusses supply chain management in the Dynamics 365 suite of apps.

More Information

This course provides students with detailed hands-on experience of Microsoft Dynamics 365 Customer Service with the new Copilot AI companion .

More Information

This course provides end users with an introduction to Microsoft Dynamics 365 and the latest AI tools.

More Information

This course will teach you to use Power Platform solutions to simplify, automate, and empower business processes for organizations in the role of a Functional Consultant.

More Information

In this course you will be guided by an experienced Power Platform MCT to learn everything you need to know to pass the PL-100: Microsoft Power Platform App Maker Exam. This course includes a free exam voucher and exam practice paper.

More Information

This course is designed for experienced IT professionals and developers, providing an insight into development techniques and approaches that can be applied to extend and manage solutions and apps built on Microsoft Dynamics 365 and the Power Platform. This course maps directly to exam PL-400: Microsoft Power Platform Developer.

More Information

In this course you will be guided by an experienced Business Central MCT to learn everything you need to know to pass the MB-800: Microsoft Dynamics 365 Business Central Functional Consultant Exam.

More Information

In the this course, students will learn essential skills to start creating Reports and Dashboards in Microsoft Power BI from data in Microsoft Business Central

More Information

In this course, students will learn advanced concepts build, deploy and support Reports and Dashboards built in Microsoft Power BI that use data in Microsoft Dynamics 365, including the Dataverse, Business Central and Dynamics 365 Finance.

More Information

This course provides students with an introduction to data visualisation in Power BI in an intuitive step by step process.

More Information

This course provides students with an introduction to Model-driven Apps by building a foundational understanding of the key features in the Power Apps Maker Portal.

More Information

This course provides students with an introduction to creating virtual agents and chat bots by building a foundational understanding of the key features in Microsoft Copilot Studio.

More Information

This course provides students with a detailed hands-on experience of setting up, configuring, customizing, extending and maintaining Microsoft Power Pages Portals through the Power Pages Maker Portal, the Portal Management App, and the Power Platform Admin Center.

More Information

This course will provide you with a broad introduction to the customer engagement capabilities of Dynamics 365.

More Information

Do you want to learn more about Dynamics 365? This course will provide you with a broad introduction to the finance and operations capabilities of Dynamics 365. You will become familiar with the concept of enterprise resource management (ERP), as well as each of the finance and operations apps, including Dynamics 365 Supply Chain Management, Dynamics 365 Finance, Dynamics 365 Commerce, Dynamics 365 Human Resources, and the ERP capabilities of Dynamics 365 Project Operations.

More Information

You will learn in this course to design, configure, and manage Dynamics 365 Commerce and provide ongoing support for the app. You will gain a strong understanding of unified commerce business operations as well as experience deploying, using, and maintaining Dynamics 365 Commerce.

More Information

This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will show how to access and process data from a range of data sources including both relational and non-relational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.

More Information

Candidates for this course automate time-consuming and repetitive tasks by using Microsoft Power Automate. They review solution requirements, create process documentation, and design, develop, troubleshoot, and evaluate solutions. Candidates work with business stakeholders to improve and automate business workflows. They collaborate with administrators to deploy solutions to production

More Information

This course is designed to showcase tools designed to help gain insight into data held within Dynamics 365 Apps, as well as increase efficiencies and productivity with the implementation of the Artificial Intelligence features in Microsoft Dynamics 365 and Copilot.

More Information

This course is designed to provide an insight into the benefits gained through the implementation of Artificial Intelligence features in the Microsoft Power Platform.

More Information

This course will provide you with the skills needed to support and manage business applications and solutions in Dynamics 365, the Dataverse, Power Pages and the Power Platform.

More Information

This course is designed to introduce candidates to the features and topics of Microsoft Dynamics 365 Human Resources.

More Information

A course to help organizations move from Outbound to the new AI features and Copilot in Real Time Customer Insights (formally Dynamics 365 Marketing).

More Information

Join us for a FREE Copilot for End Users in Microsoft Dynamics 365 Finance webinar.

More Information

Students wishing to Create and manage canvas apps with Power Apps

More Information

The audience for this course includes software developers and data scientists who need to use large language models for generative AI. Some programming experience is recommended, but the course will be valuable to anyone seeking to understand how the Azure OpenAI service can be used to implement generative AI solutions.

More Information

Software engineers concerned with building, managing and deploying AI solutions that leverage Azure AI Services, Azure AI Search, and Azure OpenAI. They are familiar with C# or Python and have knowledge on using REST-based APIs to build computer vision, language analysis, knowledge mining, intelligent search, and generative AI solutions on Azure.

More Information

This course is for IT professionals looking to learn how to build AI solutions in Azure AI Services.

More Information

AI Professionals Database Professionals

More Information

The primary audience for this course is data professionals with experience in data modeling, extraction, and analytics. DP-600 is designed for professionals who want to use Microsoft Fabric to create and deploy enterprise-scale data analytics solutions.

More Information

Machine Learning Professionals Machine Learning Engineers

More Information

Join us for a FREE Copilot for End Users in Microsoft Dynamics 365 Business Central webinar.

More Information

Essential training before starting an AI project based on the Microsoft AI and Copilot framework.

More Information

Explore the data warehousing process and learn how to load, monitor, secure, and query a warehouse in Microsoft Fabric.

More Information

Learn how to create custom copilots with Copilot Studio.

More Information

You will learn how to implement AI Models using the Microsoft AI Hub (previously AI Builder) in the Microsoft Power Platform.

More Information

You will learn how to create and manage model-driven apps with Power Apps and the Dataverse.

More Information

This course has been created for business leaders with knowledge and resources to adopt AI in their organizations.

More Information

In this course, students will learn how to create tables and columns, work with Microsoft Dataverse, and configure the user experience inside a model-driven application.

More Information

This course is designed for IT or sales professionals who want to learn how to leverage Dynamics 365 Sales and Microsoft Copilot for Sales for their organizations.

More Information

In this course, students will learn how to work with key features of Customer Insights – Data and Customer Insights – Journeys.

More Information

In this course you will complete the Dynamics 365 customer experience analyst challenge project and validate your skills.

More Information

Explore the data science process and learn how to train machine learning models to accomplish artificial intelligence in Microsoft Fabric.

More Information

Transform and load data, define semantic model relationships and calculations, create interactive visuals, and distribute reports using Power BI.

More Information

Learn how to build generative AI applications like custom copilots that use language models and prompt flow to provide value to your users.

More Information

In this course, you'll explore options for adopting, using, and creating copilots.

More Information

This course examines the key Microsoft 365 security and compliance features that administrators must prepare in order to successfully implement Microsoft 365 Copilot.

More Information

This one-day course is composed of two parts - Getting started with Microsoft 365 Copilot and Empower your workforce with Microsoft 365 Copilot Use Cases.

More Information

Discover ways to craft effective and contextual prompts for Microsoft 365 Copilot that create, simplify, transform, and compile content across Microsoft 365 applications.

More Information

Learn the knowledge and skills to drive enablement of Microsoft 365 Copilot across your organization.

More Information

Learn how to create Copilot Studio actions that extend the knowledge and capabilities of Microsoft 365 Copilot.

More Information

This training course is designed to help you understand the extensibility options available for Build connectors and plugins for Microsoft 365 Copilot.

More Information

Discover how Microsoft Copilot (available without a Microsoft 365 license) and Microsoft 365 Copilot elevate your productivity.

More Information

This course explores extending Copilot's capabilities with Microsoft Graph connectors and custom engine copilots.

More Information