'Dimension hierarchies' diaporamas de présentation

SQL Server 2008 for Business Intelligence

789 views • 62 slides

Contents of this slideshow :

Contents of this slideshow :. What is a data warehouse? Multi-dimensional data modeling. A star shema datawarehouse has a central table ( the Fact table ) surrouded by dimension tables with on-to-many relationships towards the fact table. An example of a Datawarehouse:.

514 views • 30 slides

Chapter 1 Adamson & Venerable

0. Chapter 1 Adamson & Venerable. Spring 2012. 0. Dimensional Modeling. Dimensional Model Basics Fact & Dimension Tables Star Schema Granularity Facts and Measures Multiple Processes Aggregation. Transaction Systems. They capture critical detailed info about business events:

438 views • 20 slides