Collecting representative data samples from the SMEs (Subject Matter Experts) allows our team to dive into the data and determine the best way to organize the information into logical groups, specify primary keys to uniquely identify records, and highlight dimensional tables. After normalization rules are defined, dimensional tables will serve as the links between data with multiple sources, but not necessarily identical terminology, nomenclature, or structure (Example: “A Bee Company”, “AB Co”, and “ABC” all are translated to “A Bee Company”).
After the data has been properly prepared, relationships are built between the fact tables containing the measures to be analyzed and the normalized dimensional tables.
