Skip to content
hands-on lab

Using Microsoft Fabric Lakehouse to Ingest and Analyze Data

Difficulty: Beginner
Duration: Up to 1 hour
Students: 44
Rating: 3/5
Start lab
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.

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

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

Lab steps

Signing in to Microsoft Fabric
Understanding Microsoft Fabric Workspaces
Creating a Lakehouse in Microsoft Fabric
Querying Data in Your Lakehouse
Visualizing Data in Your Lakehouse

Lab Rules