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 the information and knowledge they need to define goal-oriented measures to ensure the success of the company. Data warehousing in BI includes the following functions, which you can apply to data from any source (SAP or non-SAP) and of any age (historic or current):
● Integration (data staging from source systems)
● Transformation
● Consolidation
● Cleanup
● Storage
● Staging for analysis and interpretation
Data warehousing in BI allows you to access data directly at the source or to physically store 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 tools in the BI Suite. If you are storing data physically in BI, you can use the planning and analytical services tools to edit the data.
Data warehousing covers the following areas: