Featured resource
2026 Tech Forecast
2026 Tech Forecast

Stay ahead of what’s next in tech with predictions from 1,500+ business leaders, insiders, and Pluralsight Authors.

Get these insights
  • Course

Star Schema Foundations

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.

Beginner
2h 29m
(148)

Created by Ben Sullins

Last Updated Jun 17, 2024

Course Thumbnail
  • Course

Star Schema Foundations

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.

Beginner
2h 29m
(148)

Created by Ben Sullins

Last Updated Jun 17, 2024

Get started today

Access this course and other top-rated tech content with one of our business plans.

Try this course for free

Access this course and other top-rated tech content with one of our individual plans.

This course is included in the libraries shown below:

  • Data
What you'll learn

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.

Star Schema Foundations
Beginner
2h 29m
(148)
Table of contents

About the author
Ben Sullins - Pluralsight course - Star Schema Foundations
Ben Sullins
13 courses 4.5 author rating 3276 ratings

I work as a feedback mechanism for organizations and teams to help them understand what’s going on with their products and processes. I do this by collecting and organizing their data, visually exploring it, enriching it with other data and metrics, then presenting my findings using creative information design techniques. This leads to improved business performance and often sparks a data-driven culture throughout my clients organizations.

Get started with Pluralsight