The purpose of your data warehouse (DW) is to provide better and faster information to key personnel of the organization, helping them make better decisions, as well as providing management with better tool for understanding how the organization is performing.
The process in trying to describe your business can be summarized with the following processes:
Data source
Data input
Processes
Data output
Analysis
Vision
The most intuitive process would be to start at the top and proceed along to the bottom. This is known as traditional system design and a secure road that will bring to the target.
For business intelligence purposes, we need to turn the process upside down.
What type of analysis do they need to perform to execute this vision?
This determines what types of output will be needed. The outcome of the questions asked above will again provide answers for what type of data you need to feed to the system in order to support he vision.
By taking the controversial approach to designing your needs for data, it is given what data sources you need in order to complete the data warehouse.
Define the Needs for Analysis and Reporting (Business Intelligence)
