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.
Course info
Rating
(85)
Level
Beginner
Updated
Jun 7, 2016
Duration
2h 29m
Table of contents
Course Overview
Getting Started
Understanding the Business Intelligence Ecosystem
Understanding Star Schema Design
Modeling Your Data into a Star Schema
Choosing a Business Process
Defining the Grain
Identifying Facts
Identifying Dimensions
Querying a Star Schema
Description
Course info
Rating
(85)
Level
Beginner
Updated
Jun 7, 2016
Duration
2h 29m
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.

About the author
About the author

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.

More from the author
What's New in Tableau 10
Intermediate
1h 51m
Aug 30, 2016
Force Layout Graphs in D3
Intermediate
2h 33m
Aug 29, 2016
D3: The Big Picture
Beginner
1h 27m
Aug 16, 2016
More courses by Ben Sullins
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone, my name is Ben Sullins, and welcome to my course, Star Schema Foundations. Providing data for analytics to improve your business can be a daunting task. Our application databases just aren't designed for easy access by analysts. This is why you need a star schema. By creating a star schema, modeled after a business process, maintenance will be low because it'll be representing how the business person wants to think about data, and how to use it for their business process. And it'll eliminate the complex sequel they need to write in order to get the answers that they seek. Now in this course I get you started with understanding how to build start schemas, as well as the context behind them, and what types of problems they can really help with. Some of the major topics that we'll cover include: the process of modeling our transactional databases into a star schema, building fact and dimension tables for easy analysis, and querying our star schema to make it easy for our analysist to use. By the end of this course you'll have a fully functioning star schema built on top a of real world example. This method has been tried and tested for over 30 years, and is still today the most popular way to deliver analytics to our business users. I hope you'll join me on this journey to learn the foundations of star schemas.