Designing a Data Warehouse on the Microsoft SQL Server Platform

Focused View

Ana Voicu

4:39:35

34 View

00. Course Overview

00. Course Overview.mp4

02:09

01. Understanding the Fundamental Concepts of a Data Warehouse

00. Introduction.mp4

01:24

01. Goals of a Data Warehouse Solution.mp4

06:28

02. Introduction to Dimensional Modeling.mp4

03:31

03. Fact Tables and Facts.mp4

03:28

04. Dimension Tables and Dimensions.mp4

02:56

05. Star Schemas.mp4

06:33

06. The Four-step Dimensional Process.mp4

06:33

02. Dimension Table Techniques

00. Introduction.mp4

01:09

01. Requirements for a Dimension Table.mp4

02:39

02. Introducing Surrogate Keys.mp4

02:20

03. Advantages of Using a Surrogate Key.mp4

07:35

04. Business Keys.mp4

02:02

05. Other Dimensional Design Considerations.mp4

03:12

06. Demo - Creating the Date Dimension.mp4

06:43

07. Demo - Creating the Product Dimension.mp4

03:52

08. Module Summary.mp4

01:28

03. Creating and Working with Hierarchies

00. Introduction.mp4

01:10

01. What Is a Hierarchy - .mp4

04:26

02. Drilling Down a Hierarchy.mp4

03:02

03. Fixed-depth Positional Hierarchies.mp4

01:56

04. Demo - Creating and Working with a Fixed-depth Positional Hierarchy.mp4

06:31

05. Variable-depth Positional Hiearchies.mp4

03:32

06. Demo - Creating and Working wit a Slightly Ragged Hierarchy.mp4

05:56

07. Ragged Hierarchies.mp4

05:12

08. Module Summary.mp4

01:40

04. Implementing Fact Tables

00. Introduction.mp4

01:04

01. Structure of a Fact Table.mp4

03:46

02. Identifying the Facts.mp4

07:05

03. Identifying the Keys.mp4

07:04

04. Adding Degenerate Dimensions.mp4

01:06

05. Types of Fact Tables.mp4

03:54

06. Handling Null Values.mp4

02:16

07. Demo - Creating and Working with a Transaction Fact Table.mp4

07:03

08. Module Summary.mp4

02:19

05. Loading Data in a Data Warehouse

00. Introduction.mp4

03:30

01. Overview of an ETL System.mp4

04:44

02. Types of Data Warehouse Loads.mp4

03:13

03. Demo - Creating and Working with the Incremental Loads Table.mp4

04:08

04. Data Lineage.mp4

03:47

05. Implementing Data Lineage.mp4

04:53

06. Demo - Creating and Working with the Lineage Table.mp4

02:32

07. Demo - Populating a Dimension Table.mp4

04:40

08. Summary.mp4

02:09

06. Setting up an ETL Project with SSIS

00. Introduction.mp4

01:26

01. Advantag of Using an ETL Tool.mp4

04:48

02. Overview of SSIS.mp4

08:33

03. Demo - Creating a New SSIS Project.mp4

04:47

04. Demo - Creating Connection Managers.mp4

03:08

05. Demo - Creating Control Flow Elements.mp4

03:41

06. Demo - Creating and Working with Variables.mp4

04:15

07. Demo - Adding Precedence Constraints.mp4

04:10

08. Demo - Executing a SQL Task with Parameters.mp4

05:18

09. Summary.mp4

01:08

07. Loading a Data Warehouse with SSIS

00. Introduction.mp4

01:16

01. Demo - Designing Data Flow Elements.mp4

06:14

02. Demo - Organizing Data in Containers.mp4

05:16

03. Demo - Working with Package Parameters.mp4

07:33

04. Demo - Adding Expressions to Tasks.mp4

06:41

05. Demo - Deploying a Project in SQL Server.mp4

05:52

06. Summary.mp4

01:54

08. Visualizing Data from the Data Warehouse

00. Introduction.mp4

02:00

01. Creating a Semantic Layer.mp4

05:54

02. The Multidimensional and Tabular Models.mp4

02:52

03. Demo - Creating a Multidimensional Database in SSAS.mp4

09:33

04. Demo - Analyzing Data from a SSAS Database.mp4

04:59

05. Creating Interactive Reports.mp4

03:57

06. Demo - Creating and Publishing a Report in Power BI Report Server.mp4

05:16

07. Course Summary.mp4

02:24

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL Server

Data Warehouse

Ana Voicu

Instructor's Courses

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 that she loves sharing with others all of what she knows and learns. You can find her two cents on Twitter (@sqlbythebook) or on her blog, www.sqlbythebook.com

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.