Skip to content
hands-on lab

Using Microsoft Fabric Lakehouse to Ingest and Analyze Data

Difficulty: Beginner
Duration: Up to 1 hour
Students: 212
Rating: 3.8/5
Start lab
On average, students complete this lab in35m
Get guided in a real environmentPractice with a step-by-step scenario in a real, provisioned environment.
Learn and validateUse validations to check your solutions every step of the way.
See resultsTrack your knowledge and monitor your progress.
About
Author

Description

A lakehouse in Microsoft Fabric is a unified data platform that combines the best of data lakes and data warehouses. It allows you to store all your data in one place and analyze it using SQL queries, and other tools. It integrates with other data management and analytics tools to provide a comprehensive solution for data engineering and analytics.

In this lab, you will play the role of a data engineer at a fictional retail company called Wide World Importers. You will go from start to finish creating a lakehouse, ingesting data, querying the data and saving Power BI reports.

Learning objectives

Upon completion of this beginner-level lab, you will be able to:

  • Create a new workspace in Microsoft Fabric
  • Create a new lakehouse in your workspace
  • Ingest data into your lakehouse using a data pipeline
  • Query data in your lakehouse using the SQL analytics endpoint
  • Visualize data in lakehouse using Power BI

Intended audience

  • Data Engineers
  • Business Analysts

Prerequisites

Familiarity with the following content is beneficial but not required:

Updates

March 28, 2025 - Addressed known Azure deployment script issues related to assigning Fabric licenses. Updated lab steps to reflect changes in the Azure portal

July 16, 2024 - Resolved an issue causing the lab to fail to deploy

Environment before

Environment after

Covered topics

Analytics
Microsoft Azure
Analytics for Azure
Microsoft Fabric
Hands-on Lab UUID

Lab steps

0 of 5 steps completed.Use arrow keys to navigate between steps. Press Enter to go to a step if available.
  1. Signing in to Microsoft Fabric
  2. Understanding Microsoft Fabric Workspaces
  3. Creating a Lakehouse in Microsoft Fabric
  4. Querying Data in Your Lakehouse
  5. Visualizing Data in Your Lakehouse

Lab Rules