CT 150 – Fact Component
What’s Covered
Fact tables contain numeric measures and pointers to related dimensions. Fact components provide a simple interface for common tasks such as setting up dimension relationships, selecting degenerate dimensions, and creating calculations.
Course Notes
Foreign key relationships, accumulated snapshot fact table, and common fact table features will be discussed. After completing this course, you may want to go back to CT 120, PSA Component, and watch the second video where load status updates are discussed.
Goals
- Define fact component
- Demonstrate creating fact components
Prerequisites
- BD 100 – Development Workflow
- BD 110 – Dimensional Modeling Introduction
- BD 120 – Data Flow Diagram
- CT 100 – Connection Component
- CT 110 – Stage Component
- CT 120 – PSA Component
- CT 130 – Transform Component
- CT 140 – Dimension Component
Configuration & Tools
- Visio 2010
- SQL Server 2012 Database Engine
- SQL Server 2012 Management Studio
- SQL Server Data Tools 2012
- Sample Database – AdventureWorks 2012
Training Project
To review the project created during this course log into LeapFrogBI using the following credentials and select the corresponding project from the Training Account project list. Send a request to support@leapfrogbi.com to add a fully editable copy of this course’s project to your LeapFrogBI account.
User Name: Student
Password: leapfrogbi
Project Name: CT 150
Supporting Materials & References
SalesDataModel_v01.vsd – Visio data model diagram created during course BD 110 (attached)
SalesDFD_v05.vsd – Visio ETL data flow diagram initially created during BD 120 (attached)
AdventureWorks 2012 – SQL Server 2012 Sample OLTP Database