Data Warehouse Modeling - Star Schema Design Fundamentals
4.1 (15 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
321 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Data Warehouse Modeling - Star Schema Design Fundamentals to your Wishlist.

Add to Wishlist

Data Warehouse Modeling - Star Schema Design Fundamentals

Learn about Data Modeling, Data Warehouse, and ETL concepts from scratch using a real life Microsoft based dataset.
4.1 (15 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
321 students enrolled
Created by Shafiq Marediya
Last updated 7/2017
English
Curiosity Sale
Current price: $10 Original price: $200 Discount: 95% off
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 1 Article
  • 7 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Understand the Business Intelligence Ecosystem
  • Understand Data Warehouse Architecture
  • Understand Star Schema Design
  • Explain What Dimensional Modeling Is
  • Model Data Into a Star Schema
  • Choose The Correct Business Process
  • Define and Find The Grain at an Atomic Level
  • Identify Types of Facts
  • Identify Types of Dimensions
  • Build a Star Schema
  • Query a Star Schema
View Curriculum
Requirements
  • You should be comfortable writing basic PostgreSQL code
Description

In this course, you will learn all the concepts, terminologies, and history related to data warehousing, data modeling, and especially star schema design. We will start off with the basics and talk about the ETL process and how it fits into big data picture. Then, we will dive deep into the star schema design and talk about the following concepts:

  • ecosystem architecture
  • data warehouse architecture
  • front-end architecture
  • dimensional modeling
  • joining facts and dimensions
  • the Kimball method
  • object action model
  • subject area mapping
  • finding a grain
  • identifying facts and dimensions
  • and much more! 

You will have the opportunity to work with a Microsoft based data set throughout this course so you can apply the knowledge directly to your work! 

Here's everything you will get out of this course.

  • You will learn the fundamentals of the popular star schema design to add this skill/technology to your resume
  • You will work on a real life data set so you directly relate to your work
  • You will receive a BONUS audio copy of this course so you can listen on the go at your own time
  • You will receive a FREE copy of the Kimball's Data Warehouse Toolkit book 
  • You will receive access to monthly office hours hosted by the instructor so you can ask questions and stay engaged
  • NO QUESTIONS ASKED 30-day money back guarantee
Who is the target audience?
  • Anyone that wants to learn about data modeling and data warehouse
Students Who Viewed This Course Also Viewed
Curriculum For This Course
46 Lectures
02:29:15
+
Understanding The Business Intelligence Ecosystem
5 Lectures 10:53
+
Understanding The Star Schema Design
5 Lectures 16:55
Module Overview
00:59

An Overview of Star Schemas
04:48

Why Dimensional Modeling is Important
05:47

The History of Star Schemas
03:58

Joining Facts and Dimensions
01:23
+
Modeling Data Into A Star Schema
4 Lectures 15:35
Module Overview
00:39

What Is The Kimball Method?
04:19

Dimensional Modeling Overview
02:20

Creating A Simple Star Schema
08:17
+
Choosing A Business Process
3 Lectures 15:10
Module Overview
00:53

Choosing A Business Process
03:39

Using A Portfolio Based Approach to Data Modeling
10:38
+
Defining The Grain
5 Lectures 16:19
Module Overview
01:06

Grain Definition Examples
01:48

What Is The Atomic Grain?
05:26

Defining A Grain For Our Project
07:00

Recap
00:59
+
Identifying Facts
7 Lectures 25:08
Module Overview
00:27

An Overview Of Fact Tables
01:07

Transaction Fact Tables
02:57

Periodic Fact Tables
04:42

Accumulating Snapshot Fact Table
04:28

Building A Fact Table
10:29

Recap
00:58
+
Identifying Dimensions
8 Lectures 38:51
Module Overview
00:54

Overview Of Dimension Tables
03:41

Dimension Table Architecture
03:10

Dimensional Hierarchies
02:56

Creating A Date Dimension
05:14

Creating A Customer Dimension
10:12

Creating a Product Dimension
11:02

Recap
01:42
+
Querying A Star Schema
6 Lectures 07:33
Module Overview
00:18

Querying A Single Dimension
01:13

Querying Multiple Dimensions
01:00

Creating A View
00:36

Querying Our Star Schema
03:27

Recap
00:59
About the Instructor
Shafiq Marediya
4.3 Average rating
158 Reviews
1,338 Students
3 Courses
Instructor and Founder of Learn Analytics.io

Hi, my name is Shafiq Marediya! I am the founder of Learn Analytics, where I teach students to become professional data scientist and data analyst. Professionally, I have worked with data in industries like retail, healthcare, non-profit, finance, and technology. Over my years of studying data, I have covered topics like big data, data warehousing, data analysis with SQL, Excel, Python, and R, and visualizations with Tableau.

Many of the topics I cover in my courses are topics I learned on my own, without formal education. My courses are designed for beginners that have no prior knowledge on the topic. I clearly communicate each topic in a way that anyone can pick it up and start learning today by using the step-by-step approach I used when I was in your shoes. I am passionate about data and want to share my enthusiasm and knowledge with you! 

I hope you enjoy my courses!