Star Schema Foundations
Pluralsight
Course Summary
The star schema is at the heart of a good business intelligence system. This course will teach you the foundations you need to build a star schema and deliver powerful business intelligence to your users.
-
+
Course Description
At the core of business intelligence is a thorough knowledge of star schema design and architecture. In Star Schema Foundations, you will learn how to model a star schema after a business process and convert your transactional database into an analytics powerhouse. You will learn dimensional modeling, the Kimball Method, dimension table design, and finally fact table design. When you're finished with this course, you will have a foundational knowledge of star schema design and architecture that will help you as you move forward towards developing business intelligence solutions.
-
+
Course Syllabus
Course Overview- 1m 31s
—Course Overview 1m 31sGetting Started- 3m 51s
—Introduction 1m 41s
—Our Story 0m 39s
—Sneak Peek: Final Project 0m 32s
—Where to Find More 0m 57sUnderstanding the Business Intelligence Ecosystem- 10m 10sUnderstanding Star Schema Design- 15m 28sModeling Your Data into a Star Schema- 15m 44sChoosing a Business Process- 13m 52sDefining the Grain- 17m 9sIdentifying Facts- 23m 38sIdentifying Dimensions- 39m 12sQuerying a Star Schema- 8m 42s
