TimeXtender DiscoveryHub, Agile Business Intelligence for SQL Server
DW - Data Warehousing & Modeling
Bill Inmon is one of the true pioneers of data warehousing and his "Building the Data Warehouse” is an absolute must read for every self-respecting data warehouse professional.
Drilling across different fact tables is a very important technique when analyzing data from a data warehouse. It gives us the possibility to analyze facts from different fact tables using conformed dimensions.
Because of a lack of offerings in the Belgian market, element61 has developed a training on Dimensional Data Modeling.
Poor data quality examples: missing fields, old or inaccurate information, data conflicts, inaccessible data in legacy systems.
Data mapping is a process of defining a link between two distinct data models. It is used in software engineering to describe ideal ways to represent and access any form of information. It is used in data warehousing by linking source data models to target data models and additional for describing any transformations between these two models.