Using Microsoft Fabric Lakehouse to Ingest and Analyze Data
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
About the author
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.