Module 1 | Data Warehouse Design
Module 1 has covered quite a bit of ground on data analytics in the context of Business Intelligence. Its content covers a few main topics, namely, Data Warehouse Design & Star Schema Design, Performance Management & Balanced Scorecard, Data Quality Analysis, and Dashboard Design and Analysis. This article overviews the four questions. Data warehouse Design & Star Schema Design The module started off by introducing the notion of data warehouses and data marts, and the data design system known as Dimensional Modeling (Kimball et al. 2016). The essential protocol for dimensional modeling involves (1) defining the business process, (2) declaring the grain of the model (i.e., events where data are collected from), (3) identifying its dimensions (i.e., its context), and (4) identifying its measurable facts. An important characteristic of dimensional modeling is its support of database design where database normalization is largely avoided. As Kimball and Ross (2013) put it, ...