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