A properly designed dimensional model is essential to delivering large volumes of data in a fast and easily understood manner. In this course, Dimensional Modeling on the Microsoft SQL Server Platform, you’ll learn how to design and efficiently load dimensions, facts, and bridge tables on the Microsoft SQL Server platform. First, you’ll learn about type 1, 2, and 3 slowly changing dimensions and several methods for loading data into these dimensions. Then, you’ll discover how to use SSIS to load data into fact tables along with several options to process data incrementally, including 2 built-in Microsoft technologies: Change Data Capture and Change Tracking. Finally, you’ll explore modeling techniques to handle many-to-many relationships. When you’re finished with this course, you’ll have the skills and knowledge to design a proper dimensional model and load data efficiently using the Microsoft SQL Server platform.
Author Name: Christopher Smith
Author Description:
Christopher is a Business Intelligence Engineer at Strategic Healthcare Programs, a data analytics and benchmarking company in the healthcare industry. He’s worked in BI for over 10 years, focusing primarily on SQL Server’s BI stack. Over the course of his career he’s worked on data warehousing solutions in the banking, auto insurance, and healthcare industries. He is a proud alumnus of Bentley University, where he holds an MBA with concentrations in Information Technology and Quantitative Metho… more