Building a Data Warehouse from the Ground Up
What if you could approach any business process in your organization and quickly design an effective and optimal dimensional model using a standardized step-by-step method? In this session we’ll discuss the steps required to design a unified dimensional model that is optimized for reporting and follows widely accepted best practices. We’ll also discuss how the design of our dimensional model affects a semantic modeling technologies like SQL Server Analysis Services, Azure Analysis Service, or Power BI and how the choices we make during the data warehouse design phase can make or break our reports.
Dustin Ryan is Director, Data & AI Solutions at Microsoft. Dustin has worked in the business intelligence and data warehousing field since 2008, has spoken at community events such as SQL Saturday, SQL Rally, and PASS Summit, and has a wide range of experience using the Microsoft business intelligence stack of products across multiple industries. Prior to his time at Microsoft, Dustin worked as a business intelligence consultant for a Microsoft partner.
Dustin resides outside Jacksonville, Florida with his wife, three children, two cats, two dogs, 8 chickens and enjoys spending time with his family and serving at his local church. You can learn more about him at http://SQLDusty.com.