Designing a Data Warehouse on the Microsoft SQL Server Platform

via Pluralsight

Overview

Ever wonder how it's possible to create meaningful reports from data spread over multiple sources? This course explores how to create a data warehouse project that provides answers to customers’ critical business questions. Data is driving everything and the need to gain insight from data continues to become more abundant. In this course, Designing a Data Warehouse on the Microsoft SQL Server Platform, you’ll gain the ability to design and implement a data warehouse solution with the components provided by SQL Server.

First, you’ll discover some characteristics of a data warehouse project and how such a project can help your customers better understand their business progression. Next, you’ll explore dimensional modeling design in more detail. Then, you'll delve into creating a data warehouse database and building an SSIS project to load the data warehouse with essential information for data analysis. Finally, you’ll learn how to create meaningful reports on top of the solution previously created. When you’re finished with this course, you’ll have the skills and knowledge needed to design a robust data warehouse on the SQL Server platform, creating an effective solution that helps your customers gain valuable insights from accumulated data.

University:

Provider: Pluralsight

Categories: Data Analysis Courses, Business Intelligence Courses, Microsoft SQL Server Courses