50,000+ Free Courses Online to Start Today

Coursesity is supported by learner community. We may earn affiliate commission when you make purchase via links on Coursesity.

Designing a Data Warehouse on the Microsoft SQL Server Platform

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 the customers’ critical questions regarding their business.

In this course, you will :

First, you’ll discover some of the characteristics of a data warehouse project and how such a project can help your customers to have a better understanding of their business progression.
Next, you’ll explore the dimensional modeling design and will learn about each step in this system in more detail.
Then, you'll delve into creating a data warehouse database and building an SSIS project to load the data warehouse with information essential for data analysis.
Finally, you’ll learn how to create meaningful reports on top of the solution previously created.