Facts vs. Dimensions in Data Warehousing

Based on “The Microsoft Data Warehouse Toolkit” by Joy Mundy and Warren Thornthwaite,

“It may help to think of dimensions as things or objects. A thing such as a product can exist without ever being involved in a business event.”

Continue Reading →

What’s Data Warehousing

Consider an example where business analyst uses the systems containing operational data (the data that runs the daily transactions of your business). Analysts can use information about, which products were sold in which regions at what time of the year, to look for anomalies or to project future sales. However, there are several problems if analyst accesses operational data directly:

Continue Reading →