Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

Star Schema Foundations

via Pluralsight

Overview

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.

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.

Syllabus

  • Course Overview 1min
  • Getting Started 3mins
  • Understanding the Business Intelligence Ecosystem 10mins
  • Understanding Star Schema Design 15mins
  • Modeling Your Data into a Star Schema 15mins
  • Choosing a Business Process 13mins
  • Defining the Grain 17mins
  • Identifying Facts 23mins
  • Identifying Dimensions 39mins
  • Querying a Star Schema 8mins

Taught by

Ben Sullins

Reviews

4.4 rating at Pluralsight based on 148 ratings

Start your review of Star Schema Foundations

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.