Data warehousing forms the basis of an extensive business intelligence solution that allows you to convert data into valuable information. Integrated and company-specific data warehousing provides decision makers in your company with information and knowledge about goal-oriented measures that will lead to the success of the company. For data from any source (SAP or non-SAP sources) and of any age (historic or current), Data warehousing in BI allows:
· Integration (data acquisition from source systems)
· Transformations
· Consolidation
· Clean up
· Storage
· Retrieval for analysis and interpretation
Data warehousing in BI allows you to directly access source data as well as physically storing data in BI.
The central tool for data warehousing tasks in BI is the Data Warehousing Workbench.
You can analyze, interpret and distribute the data in the data warehouse using the BI suite of tools. When physically storing data in BI, you can use the planning and analytical services tools for editing data.
Data warehousing includes the following areas:
Data Modeling