Hosted by Facing Todays Data Warehouse Challenges W

Hosted by Facing Today’s Data Warehouse Challenges W H Inmon Father of Data Warehousing

Hosted by ERP BW Non. ERP BW with an ERP source BW with a heterogeneous source BW One of the issues of today

Hosted by What the end user gets out of a data warehouse…. Frustration! New requirements Quick analysis Reconcilability Inexpensive analysis Single source of data Historical data Integrated data Easy to access data

Hosted by Characteristics of the best implementations Data at the finest level of granularity Data coming from a wide variety of sources Ability to handle large volumes of data

Hosted by Characteristics of the best implementations Data quality Editing, cleansing of data

Hosted by SAP’s infrastructure: - Complete - Proven - Not in release 1. 0 - Continuing to improve

Hosted by Management and organizational buy in because SAP presents a solution

Hosted by Benefits of Implementation Extreme flexibility! The granular data that is at the heart of the DW

Hosted by Benefits of Implementation The cost of information is lowered dramatically by having a data warehouse…. .

Hosted by Benefits of Implementation Traceability of data which leads to greater accountability

Hosted by Achieving The Implementation Day 1 Day 2 Day 3 Day n Iterative development

Hosted by Achieving The Implementation An infrastructure and architectural roadmap

Hosted by Where The Industry Is Headed Much greater volumes of data

Hosted by Where The Industry Is Headed Analytics – direct business payoff

Hosted by Where The Industry Is Headed Into the public sector

Hosted by Final Word At long last, real business advantage is a reality

Hosted by Final Word Churn analysis

Hosted by Final Word Elasticity analysis

Hosted by Final Word Profitability analysis

Hosted by Final Word Global inventory management

Hosted by Final Word The 360 -degree view of the customer

Hosted by Non-SAP data warehouse What happens when there are two data warehouses? SAP BW

Hosted by Non-SAP data warehouse SAP BW It all depends on the extent of the business overlap