Star Schema Foundations

by Ben Sullins

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.

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.

Table of contents

Course Overview
2mins

About the author

As a certified data geek, Ben dedicates his time to helping others use data wisely. He makes information meaningful and has fun doing it. A die-hard Mozillian, he uses his data superpowers to keep the web open and free as well as authors training courses in Big Data, Analytics, Dashboarding, Tableau Software, D3js, and Cloud Business Intelligence. His background affords him a unique set of knowledge that sets him apart in the data geek world. During his 15 years of industry experience, he has o... more

Ready to upskill? Get started