Modern Data Warehousing with Microsoft Fabric

In the age of cloud analytics, today’s best practice is tomorrow’s legacy. Microsoft Fabric aims to be the one platform that rules them all, bringing together data engineering, warehousing, and visualization in a single Software-as-a-Service (SaaS) package. At the heart of this platform, Fabric Data Warehouse delivers a familiar yet modern T-SQL–based experience that is scalable, cloud-native, and tightly integrated with the broader Fabric ecosystem. It supports multiple ingestion and transformation paths. It provides practitioners flexibility with how data is landed and shaped whether streaming, batch, or metadata-driven. Just as importantly, Fabric data warehouse is designed to serve not just as a single central repository, but as a collection of purpose-built warehouses that can coexist and scale within an environment, aligning with both technical best practices and business needs. With its seamless integration to Power BI, Fabric empowers data professionals to shorten the path from raw data to actionable insights, while providing the governance and lifecycle tools needed to manage growth and change over time.
The landscape of data roles and technologies is rapidly shifting. Many professionals find themselves as “accidental” data warehouse practitioners that are tasked with designing and implementing warehouses without formal training, simply because the responsibility landed on their desk. At the same time, long-standing on-premises data warehouses are being retired in favor of cloud-native platforms, and Power BI datamarts are being phased out with Fabric Data Warehouse emerging as the recommended successor. Together, these changes are reshaping how organizations think about their data architecture and how individuals must adapt their skills to thrive in a modern analytics environment.
The presenters are experienced data warehousing practitioners who will guide attendees through the patterns, practices, and pitfalls of Microsoft’s modern approach to data warehousing in Fabric. Drawing on real-world expertise, they will highlight both the opportunities and the challenges of adopting Fabric DW, from modeling fundamentals to ingestion strategies and lifecycle management. Attendees will leave the session with a clear understanding of how to design and manage effective warehouses in Fabric, avoid common mistakes, and apply proven techniques that accelerate success in their own environments.

• Part 1 - Patterns: Dimensional data modeling

• Part 2 - Patterns: Data Warehousing fundamentals

• Part 3 - Patterns: Ingestion and medallion architecture

• Part 4 - Practices: Change detection

• Part 5 - Practices: Data warehouse life cycle and CI/CD

• Part 6 - Practices: Monitoring and administration

• Part 7 - Practices: Migrations

• Part 8 - Pitfalls: Tips and tricks on how to avoid them

• "Accidental" data warehousing professionals, or those looking for a refresher on the theory and techniques of data warehousing in Fabric.

• Folks needing to migrate from an on-premises data warehouse or other platforms to Fabric.

• The focus is on data warehouse development and data engineering. The content may be less applicable for those whose primary role is report building and/or data analysis.

• The content is aimed at the doers, not the delegators.

Kristyna Ferris is a solution architect at P3 Adaptive. Her experience includes implementing and managing enterprise-level Power BI instance, training teams on reporting best practices, and building templates for scalable analytics. Passionate about participating and growing the data community, she enjoys co-writing on Data on Wheels (dataonwheels.com) and speaking at various events. She also a co-organizer for Lexington Data Technology Group.

Chris Hyde is a Microsoft Data Platform MVP based in Albuquerque, New Mexico. He works as an independent SQL Server BI and DBA consultant and is the leader of the Albuquerque local Azure Data Technologies group. He loves loud music and cricket, but not usually at the same time.

Info: Breakfast is provided on-site for attendees to enjoy at the start of the day. Please let us know if you have any dietary restrictions, and we will order food accordingly. This time can also be used for networking, asking questions, or getting prepared for the day ahead!

Info: The first half of the precon will be between breakfast and lunch. Coffee and snacks will be available throughout the day for attendees. Breaks will be incorporated into the training to ensure that everyone is feeling great throughout the day.

Info: Lunch is provided on-site for attendees to enjoy at noon. Please let us know if you have any dietary restrictions, and we will order food accordingly. Feel free to use this time for networking, to ask questions, or prepare yourself for the rest of the day.

Info: The second half of the precon will be after lunch. Coffee and snacks will be available throughout the day for attendees. Breaks will be incorporated into the training to ensure that everyone is feeling great throughout the day.

Know what’s Happening Next — before everyone else does.

Get App

Host or Publisher Capital Area SQL Server User Group