Best Practices for Building a Data Warehouse in Microsoft Fabric
2025TL; DR
Need a data warehouse? Just click a button and it's there. Load some data into a table and the stats are automatically up to date. Need an index? No, you don't because Microsoft Fabric delivers performance by default.
While many of the day-to-day operational aspects of running your data warehouse are taken care of for you in this SaaS environment there are some best practices you should be aware of that can influence the performance and flexibility of your solution. In this session we will walk through those best practices including table design, loading patterns, workload management, security, and workspace architecture.
Session Details
Need a data warehouse? Just click a button and it's there. Load some data into a table and the stats are automatically up to date. Need an index? No, you don't because Microsoft Fabric delivers performance by default.
While many of the day-to-day operational aspects of running your data warehouse are taken care of for you in this SaaS environment there are some best practices you should be aware of that can influence the performance and flexibility of your solution. In this session we will walk through those best practices including table design, loading patterns, workload management, security, and workspace architecture.
While many of the day-to-day operational aspects of running your data warehouse are taken care of for you in this SaaS environment there are some best practices you should be aware of that can influence the performance and flexibility of your solution. In this session we will walk through those best practices including table design, loading patterns, workload management, security, and workspace architecture.
3 things you'll get out of this session
Speakers
Mark Pryce-Maher's other proposed sessions for 2026
New in Microsoft Fabric: The Warehouse and the SQL Analytics Endpoint - 2026
SQL vs. Fabric? Why Not Both! A Practical and Entertaining Guide for All - 2026
Mark Pryce-Maher's previous sessions
From Beginner to Certified: A Fabric Analytics Engineer Workshop
In this full day workshop, we’ll cover the skills and tasks required for a career as a Microsoft Fabric Analytics Engineer and prepare you for the DP-600 Certification Exam.
Nose-Dive Narratives: Slide Karaoke 2024
Get ready to wrap up a serious day of learning with a dash of humor, spontaneity, and friendly competition! SQLBits presents "Slide Karaoke" where SQLBits speakers reveal their hidden talents while vying for bragging rights. This session promises to be a one-of-a-kind experience that will leave you in stitches and awe, and the speakers scrambling for their non-existent notes!
Fabric Product Group - Ask us Anything
Come and join the Fabric Product Group for one of our fireside chats. Bring your questions because we have all the answers!!
Fabric Power Hour
The famous Power BI Power Hour returns, but this time it has expanded to cover the whole of Fabric!
A Deep Dive into Microsoft Fabric Data Warehouse
Deep Dive into Data Warehousing in Microsoft Fabric. Explore the intricacies of Microsoft Fabric Data Warehouse, unraveling its capabilities and demonstrating effective strategies for its utilization.