Microsoft Fabric in a Day

Introduction to Microsoft Fabric

This chapter introduces the concepts of data lakes and the medallion architecture. It also provides a high-level overview of the core building blocks of Microsoft Fabric.

• Understanding Data Lakes and the Medallion Architecture
• The Core Building Blocks of Microsoft Fabric
• Working with Workspaces in Microsoft Fabric

Storing Data in Microsoft OneLake

Microsoft OneLake provides a single, unified, logical data lake for your entire organization. Similar to OneDrive, Microsoft OneLake is automatically included with every Microsoft Fabric tenant and is designed to be the central location for all your analytics data. To store data in OneLake, you must create either Lakehouses or Warehouses.

• Introducing Microsoft OneLake
• Creating and Using a Lakehouse
• Creating and Using a Warehouse

Getting Started with Data Factory

Data Factory enables you to ingest, prepare, and transform data from a wide variety of sources, including databases, files, and cloud-based services. This chapter demonstrates how to build pipelines that load data into a Lakehouse or Warehouse.

• What is Data Factory?
• Copying Data into a Lakehouse Using Pipelines
• Creating Dataflows to Ingest and Transform Data

Data Engineering Using Apache Spark

Data engineering involves designing and building systems that allow people to collect and analyze raw data from multiple sources and formats. Using popular languages such as Python, SQL, and R, you can load, transform, and analyze data via interactive notebooks.

• Introducing Apache Spark
• Working with Notebooks in Fabric
• Reading and Writing Data Using DataFrames
• Data Cleansing with PySpark

Reporting in Fabric

Power BI transforms your organization's data into rich, interactive visuals, allowing you to monitor your business and quickly gain insights. In this chapter, you will learn how to connect Power BI to data stored in Microsoft Fabric.

• Creating Power BI Reports
• DirectQuery vs. Import with OneLake
• Using Direct Lake Mode