Microsoft Fabric Complete Guide – The Future of Data with Fabric

Microsoft Fabric Complete Guide – The Future of Data with Fabric

by HHN Automate Book Inc.
Released December 2023
Publisher(s): Packt Publishing
ISBN: 9781835467831

Watch it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Video description

This course is ideal for those with a grasp of data concepts and cloud computing basics, especially in Microsoft Azure. Programming skills in SQL, Spark, and Python are beneficial but not mandatory. You'll begin with an introduction to Microsoft Fabric, delving into its objectives and success criteria, and explore the contrasting architectures of Lakehouse and Warehouse, along with insights into licensing, workspace creation, and configuration.

Progress to mastering OneLake and Delta Lake, ensuring data security with authentication and authorization, while tackling Spark's complexities, data hub management, and warehouse management. This includes everything from understanding datasets and ingestion methods to utilizing Spark for real-time data processing, exploring SQL and KQL differences, and experiencing data flow architecture and Power BI visualizations in the Data Factory.

The course concludes with a deep dive into Data Science and robust Data Management, ensuring you are equipped with the knowledge to control access, govern data, and monitor your systems effectively in any professional setting.

What you will learn

  • Discover the principles of data engineering in Microsoft Fabric, including Lakehouse and Delta Lake
  • Construct and manage data warehouses with Fabric's tools
  • Perform real-time analytics using SQL, KQL, and Spark
  • Build and execute data pipelines in the Data Factory module
  • Create compelling data stories through Power BI visualizations
  • Explore how to manage access control, governance, and monitoring in the Fabric environment

Audience

This course is perfect for citizen data practitioners and professionals in data infrastructure, offering insights into utilizing Microsoft Fabric for efficient workflows. Business analysts eager to enhance their expertise will find valuable lessons in data engineering practices, data lakes, and leveraging Power BI for dynamic reporting and visualization. Data scientists looking to integrate Fabric into their projects will explore model management and Azure services to elevate their analytical prowess.

About the Author

HHN Automate Book Inc.: Henry Habib is a manager at one of the world's top management consulting firms, he advises F500 companies on growth strategy, operation, and analytics. He has a vast background in applying data-driven solutions to create impact, in both large and small organizations.

Henry is also a big proponent of no-code application development in business. He deploys business application to his clients using No-Code solutions, which are much easier to understand and faster. He believes in the No-Code revolution.

As a professor, Henry is passionate about teaching students on how to succeed, on any topic (case interviews, no-code application development, automation). He does this by creating courses with engaging and helpful content, and always being around to answer any questions.

Table of contents

  1. Chapter 1 : Introduction
    1. Course Introduction
    2. Instructor's Introduction
    3. Learning Objectives
  2. Chapter 2 : Microsoft Fabric
    1. Understanding the Objectives
    2. Success Criteria
    3. Introduction to Fabric
    4. Course Roadmap
    5. Overview of Microsoft Fabric
    6. Comparison of Lakehouse and Warehouse
    7. Fabric License Types
    8. Signing-up to Fabric
    9. Workspaces Concept
    10. Workspace Access Creation and Configuration
    11. Workspace Settings
  3. Chapter 3 : Data Engineering
    1. Introduction to Data Engineering in Fabric
    2. OneLake Introduction
    3. Lakehouse
    4. Delta Lake
    5. OneLake Explorer
    6. Authentication and Authorization
    7. Introduction to Shortcuts
    8. Creating Shortcuts
    9. Monitoring and Data Hubs
    10. Introduction to Lakehouse
    11. Lakehouse Architecture
    12. Lakehouse vs Warehouse
    13. What is Spark?
    14. Notebook Overview
    15. Web based and VS Code Notebooks
    16. Spark and Monitoring Spark Jobs
  4. Chapter 4 : Data Warehouse
    1. Introduction
    2. Default Dataset and Modelling
    3. Ingest Methods
    4. Load Data Introduction
    5. Data loading into Lakehouse
    6. Load Data using Pipeline -Part 1
    7. Load Data using Dataflows
    8. Load Data using Pipeline -Part 2
    9. Models and Power BI Reports
    10. Cross-database Query
    11. Roles and Permissions
    12. Performance Management
  5. Chapter 5 : Real-time Analytics
    1. SQL vs KQL
    2. Create, Process and Monitor
    3. KSQL Queryset
    4. KSQL Database
    5. KSQLMagic
    6. Spark
  6. Chapter 6 : Data Factory
    1. What is Data Factory?
    2. Data Flows and Pipelines
    3. Architecture
    4. Workspace Setup
    5. Control Table and Copy Data
    6. Metadata Copy Pattern
    7. Script Activity
    8. Data Flows Gen2 Introduction
    9. Data Flows Gen2 Continuation
    10. Pipeline Execution
    11. Shortcut to Other Workspaces
    12. Notebooks
    13. Data Flow Gen2 Transformations
    14. Pipelines, Notebooks and Parameters
    15. Notebooks Monitoring in Pipelines
  7. Chapter 7 : Data Visualization with Power BI
    1. Power BI and Fabric
    2. Version Control
    3. Direct Lake
  8. Chapter 8 : Data Science
    1. What is Data Science?
    2. Data Science Process
    3. Items and Models
    4. Exercise
    5. Saving Models
    6. Model Management
  9. Chapter 9 : Data Management
    1. Introduction
    2. Access Control
    3. Governance
    4. Monitoring

Product information

  • Title: Microsoft Fabric Complete Guide – The Future of Data with Fabric
  • Author(s): HHN Automate Book Inc.
  • Release date: December 2023
  • Publisher(s): Packt Publishing
  • ISBN: 9781835467831