Please enable JavaScript.
Coggle requires JavaScript to display documents.
Building the Datawarehouse (OLAP Cube (Terminology (Facts (Numbers),…
Building the Datawarehouse
Datawarehouse & Datamart
ETL
Extract Transform Load
OLAP Cube
OnLine Analytical Processing
Converts data into usable information
Allows aggregation of data
Helps answer business questions
Terminology
Facts (Numbers)
Dimensions
Hierarchies (collection of levels within a dimension)
Members (labels)
Slicing and dicing (filter and combine dimensions)
Values
Flexibility
Speed
Drill-down capability
Data Mining
Process of sorting through large amount of data to pick relevant information