Home / Fabric / Introduction to Fabric Data Warehouses
Introduction to Fabric Data Warehouses
Explore how Fabric Data Warehouses unify data and boost insights. Learn core principles under Austin Libal’s guidance. Perfect for beginners and professionals wanting to get a better understand of Fabric!
In this introductory course, you will explore the foundational concepts of Fabric Data Warehouses, guided by expert instructor Austin Libal. Together, you’ll learn how these specialized data systems bring together information from different sources, allowing organizations to make more confident business decisions. Along the way, you’ll gain insight into why data warehouses are essential for dealing with large amounts of data, as well as how they help streamline analytics and reporting tasks.
By the end of the course, you’ll be equipped with a high-level understanding of the core principles behind setting up and managing a Fabric Data Warehouse. We’ll talk through how data moves in and out of these systems, the key roles and responsibilities involved, and best practices for ensuring smooth operations. Whether you’re new to data warehousing or looking for a friendly introduction, this course will give you a solid overview of the building blocks needed to excel in today’s data-driven environments.
Course Outline ( Free Preview)
Module 00 - What You Need to Get Started
In this module, you’ll find all the class files needed to follow along with the course. These resources will help you practice key concepts and reinforce what you learn in each lesson. Download the files now to ensure you’re ready to dive into Data Warehouses in Fabric!
Module 01 - Introduction
In this opening module, we’ll introduce the overarching concepts of Fabric Data Warehouses and discuss how they fit into the larger data landscape. We’ll also provide a sneak peek of what to expect in upcoming modules so you can see how each piece connects to form a complete picture.
Module 02 - What is a Warehouse?
In this module, we’ll demystify the concept of a data warehouse and highlight why it’s essential in modern data management. You’ll discover how these specialized storage systems centralize information and lay the groundwork for meaningful analytics. By the end, you’ll understand the core benefits and reasons for adopting a warehouse-based approach.
Module 03 - What is a Lakehouse?25 min.
In this module, you’ll discover how a Lakehouse bridges the gap between traditional data lakes and warehouses. You’ll learn how Lakehouses combine the flexibility of raw data storage with the structure needed for robust analytics. By the end, you’ll see why this hybrid model is revolutionizing the way we handle and analyze data.
Module 04 - Ingesting Data to Warehouse30 min.
In this module, you’ll learn how data is brought into a warehouse environment, exploring common tools and techniques used in the ingestion process. We’ll cover best practices for ensuring data consistency and reliability at every step. By the end, you’ll have a clear understanding of how to set up efficient and trustworthy data pipelines.
Module 05 - Connect Warehouse with SSMS8 min.
In this module, you’ll learn how to connect your Fabric Data Warehouse with SQL Server Management Studio (SSMS) for streamlined data access. We’ll walk through the steps to securely establish connections, run queries, and manage data. By the end, you’ll be able to seamlessly bridge your warehouse to the widely used SSMS environment.
Module 06 - Copy Into17 min.
In this module, you’ll learn how the COPY INTO command simplifies data loading into your Fabric Data Warehouse. We’ll go over common use cases, highlight best practices, and walk through the steps for quick and efficient data ingestion. By the end, you’ll have the know-how to seamlessly transfer data from various sources into your warehouse.
Module 07 - Cross Warehouse/Lakehouse Queries13 min.
In this module, you’ll discover how to run queries that span both warehouse and lakehouse environments, combining structured and unstructured data for richer insights. We’ll demonstrate the tools and techniques needed to unify multiple data sources efficiently. By the end, you’ll see how cross-environment queries can empower more comprehensive and agile analytics.
Module 08 - Schemas, Views, and Stored Procedures15 min.
In this module, you’ll discover how schemas, views, and stored procedures help organize and streamline your Fabric Data Warehouse. We’ll discuss how each concept enhances data clarity, security, and performance. By the end, you’ll be equipped to structure and manage data more effectively.
Module 09 - T-SQL Limitations in Warehouse11 min.
In this module, you’ll learn about the key T-SQL features that may be limited or differ in a Fabric Data Warehouse environment. We’ll explore how to navigate these limitations and adapt your queries to ensure smooth operations. By the end, you’ll know how to work effectively with T-SQL, despite any constraints.
Module 10 - Keys and Data Types10 min.
In this module, you’ll explore how keys and data types ensure data consistency and integrity in a Fabric Data Warehouse. We’ll discuss the role of primary and foreign keys in establishing relationships and optimizing queries. By the end, you’ll understand how choosing the right data types sets the foundation for smooth data analysis and storage.
Module 11 - Time Travel9 min.
In this module, you’ll learn about Time Travel capabilities that allow you to access and analyze historical versions of your data. We’ll explore how this feature helps you understand changes and maintain accurate records over specific periods. By the end, you’ll see how Time Travel can aid in auditing, troubleshooting, and deeper historical analysis.
Module 12 - Restore in Place and Closing Tables13 min.
In this module, you’ll learn how to restore data in place to quickly recover from changes or errors without the hassle of extensive migrations. We’ll also explore how and why to “close” tables once data is finalized, ensuring consistent states for analysis. By the end, you’ll understand these crucial steps for maintaining data integrity and simplifying warehouse management.
Module 13 - Spark with Warehouses19 min.
In this module, you’ll explore how Spark can be leveraged to perform large-scale data processing and analytics within Fabric Data Warehouses. We’ll discuss how Spark’s distributed computing capabilities integrate seamlessly with warehouse structures for enhanced performance and flexibility. By the end, you’ll see how combining Spark with a warehouse environment can greatly expand your data analytics toolkit.
Module 14 - Warehouse Semantic Models12 min.
In this module, you’ll explore how semantic models act as a vital interpretive layer in a Fabric Data Warehouse, translating raw data into meaningful business terms. We’ll discuss how these models streamline reporting and ensure consistency across different analytics tools. By the end, you’ll see how a well-designed semantic model can enhance both collaboration and data-driven decision-making.
Module 15 - Securing Fabric Warehouses14 min.
In this module, you’ll learn how to safeguard your Fabric Data Warehouse from unauthorized access and potential data breaches. We’ll explore best practices for encryption, network security, and user access controls. By the end, you’ll have the tools to protect your warehouse’s data while enabling secure collaboration.
Module 16 - Warehouse Performance5 min.
In this module, you’ll learn strategies to optimize and maintain peak performance in a Fabric Data Warehouse. We’ll explore how query tuning, resource allocation, and other best practices can speed up data processing. By the end, you’ll be prepared to keep your warehouse running efficiently and reliably.
Module 17 - Monitoring Fabric Warehouse8 min.
In this module, you’ll discover how to track the health and performance of your Fabric Data Warehouse in real time. We’ll examine common monitoring tools, metrics, and alert systems to help you spot issues quickly and maintain smooth operations. By the end, you’ll be equipped to proactively manage and optimize your warehouse environment.
Module 18 - Class Wrap Up2 min.
Congratulations on reaching the final module of the course! In this wrap-up, we’ll celebrate your progress and reflect on the key insights you’ve gained—from understanding the basics of data warehouses and lakehouses, to exploring performance, security, and more. By revisiting these highlights, you’ll see how each piece fits together and feel prepared to continue growing in your Fabric Data Warehouse journey.
Austin is a Jacksonville native who graduated from The Baptist College of Florida in 2012. He previously worked as a manager in the retail service industry. He enjoys spending time with his wife and two kids. His primary focus at Pragmatic Works is on Azure Synapse Analytics and teaching the best practices for data integration, enterprise data warehousing, and big data analytics. He also enjoys helping customers learn the ins and outs of Power BI and showing people new ways to grow their business with the Power Platform.
