Simple play icon Course
Skills

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
2mins

About the author

Ana Voicu is a seasoned data engineer with a deep passion for databases, business intelligence, and data science. She specializes in developing enterprise-level Business Intelligence solutions across diverse industries, focusing on performance optimization, pattern recognition, efficient business process analysis, and interactive visualizations. Ana thrives on tackling database performance challenges, particularly those involving high data volume applications. Beyond her technical expertise, she... more

Ready to upskill? Get started