Chapter 8. Analyzing the Sources
Identifying the right information from the correct source is the key to the success and reputation of the business intelligence and data warehouse project. There can potentially be many different sources for the same information within the organization. If an incorrect source for information is chosen, the level of trust and acceptance for the project will be decreased greatly. This chapter outlines how to analyze data sources to gain a deeper understanding of the information, and how it maps to the requirements and the data model. The recipes help to define the road map of information and how it is used with the project:
Validating and enhancing a conceptual data model
Creating a business process matrix
Creating a report requirements matrix
Creating a source matrix
Developing the data lineage
Defining the detailed transformations
Introduction
Analyzing the data sources and identifying the correct information is essential. In the previous chapters, we looked at a...