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.

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.

• 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