Fundamental Concepts
- Fact - Represents Action, Something that has happened. Example- No of units sold, No of Repairs completed.
- Dimension - Dimensions are attributes. Example - Product Type, Department Type, Date. Natural key would be product code, department code. Surrogate key is integer number (Identity Column) generated in dimension table. Fact and dimensions relate via surrogate key.
- Slowly Changing Dimensions - Managing dimension attribute changes over time.
- Datamart - Database containing fact and dimension tables
Looking forward for more BI exercises in coming weeks. From MSDN SQL Server Analysis Services Tutorial is my next learning point.
No comments:
Post a Comment