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
(95)
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
(95)
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
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.