hands-on lab

Using Microsoft Fabric Lakehouse to Ingest and Analyze Data

Up to 40m
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.
Lab 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


Familiarity with the following content is beneficial but not required:

Environment before

Environment after

About the author
Logan Rakai, opens in a new tab
Lead Content Developer - Labs
Learning paths

Logan has been involved in software development and research since 2007 and has been in the cloud since 2012. He is an AWS Certified DevOps Engineer - Professional, AWS Certified Solutions Architect - Professional, Microsoft Certified Azure Solutions Architect Expert, MCSE: Cloud Platform and Infrastructure, Google Cloud Certified Associate Cloud Engineer, Certified Kubernetes Security Specialist (CKS), Certified Kubernetes Administrator (CKA), Certified Kubernetes Application Developer (CKAD), and Certified OpenStack Administrator (COA). He earned his Ph.D. studying design automation and enjoys all things tech.

LinkedIn, Twitter, GitHub

Covered topics
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