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.
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.