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.
Course info
Rating
(15)
Level
Beginner
Updated
Aug 1, 2019
Duration
4h 40m
Table of contents
Course Overview
Understanding the Fundamental Concepts of a Data Warehouse
Dimension Table Techniques
Creating and Working with Hierarchies
Implementing Fact Tables
Loading Data in a Data Warehouse
Setting up an ETL Project with SSIS
Loading a Data Warehouse with SSIS
Visualizing Data from the Data Warehouse
Description
Course info
Rating
(15)
Level
Beginner
Updated
Aug 1, 2019
Duration
4h 40m
Description

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.

About the author
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.

More from the author
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
(Music) Hi everyone. My name is Ana Voicu, and welcome to my course, Designing a Data Warehouse on the Microsoft SQL Server Platform. I am a senior business intelligence developer, and my goal is to give you all the information you need to create data warehouses with the help of SQL Server. So if you ever wondered, what does a data warehouse even mean, what does ETL stand for, or how is it possible to create meaningful reports from data spread over multiple sources, then this course is for you. We live in an age when data is driving everything, and the need to gain insights from data becomes more and more abundant. Data is everywhere: in databases, in Excel files, in the cloud, on the streets, in your phone. This is a good thing, because data is needed to make decisions so being able to put together so much information in an intelligent manner to make it easy for customers to look at data and extract what they need is an essential skill for the twenty-first century. This course will teach you the basic steps for doing that. You will learn what is a data warehouse and what are some of the challenges solved by having a data warehouse in place. You will understand what does dimensional modeling mean, what are its elements, facts, dimensions and dimension attributes, hierarchies, star schemas, and the steps you need to create for creating such a model. Each concept is presented with many practical examples so it will be easy for you to put everything in practice and create a data warehouse in SQL Server. You will work with Integration Services to create the process that populates the data warehouse with correct data. Then you will create an analysis layer in Analysis Services, and you will learn how to create meaningful and interactive reports with Reporting Services and Power BI. By the end of this course, you will be able to design and implement the data warehouse with the help of SQL Server. I hope you will join me on this journey to learn about data warehouse solutions with the Designing a Data Warehouse on the Microsoft SQL Server Platform course at Pluralsight.