Simple play icon Course

Designing a Data Warehouse on the Microsoft SQL Server Platform

by Ana Voicu

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.

What you'll learn

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 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. When you’re finished with this course, you’ll have the skills and knowledge of designing a robust data warehouse on the SQL Server platform needed to create an effective solution that helps your customers by gaining insights from the data accumulated.

Table of contents

Course Overview

About the author

Ana Voicu is a software developer passionate about databases, Business Intelligence, and data science. She works on developing enterprise level Business Intelligence solutions for various types of industries, with a focus on performance optimization, pattern recognition, efficient analysis of the business processes, and interactive visualizations. What Ana loves most is overcoming challenges related to database performance, mostly related to data warehouse solutions. Ana discovered a while ago t... more

Ready to upskill? Get started