Leveraging Oracle Maximizing Reporting

1
Leveraging Oracle - Maximizing Reporting
Analysis Four Case Studies

• James Masuoka
• Director of Product Management

August 15, 2003
2
DecisionPointDelivering Enterprise Transparency
3
The DecisionPoint Solution
Financial and operational data from Oracle
Applications, PeopleSoft and other enterprise
applications
Financial performance using consistent reports,
metrics, alerts and flexible analysis tools
Business decision-making and performance
4
Customer Benefits
Corporate transparency, accountability and
performance
Corporate and regulatory reporting and analysis
The value of IT investments
The time, cost and risk of deploying and
maintaining an enterprise data warehouse
5
Answering Business Critical Questions
What is the gross and net margin contribution by
product? What are the TE budget variances by
department?
Is world-wide inventory effectively allocated to
meet customer demand? Who are our top vendors
across the entire organization and by warehouse?
Which employee benefit costs are rising the
fastest? What are the RD costs for developing
this new product?
What are the highest cost manufacturing resources
and operations? Can we see a bill of
materials (BOM) explosion and compare it
to historical explosions?
6
Roadblocks to Answers
High Cost

• Custom projects
• Overworked IT staff
• Other priorities

Chaos

• Constantly changing requirements
• No standard reports and metrics
• Ad-hoc reports hard to reconcile

Complexity

• Heterogeneous data sources
• Non-intuitive tools
• End users rely on data analysts

7
Behind the Scenes - The Analytics Challenge
Multiple/ Custom Data Warehouses
DependantEnd-users and Decision Makers
MultipleSourceSystems
Multiple/Custom ETL
Large Analyst Staff
Disparate Reports
8
A Comprehensive Packaged Solution
DecisionPoints Financial Consolidation, Analysis
and Reporting Software
MultipleSourceSystems
Dashboards, Metrics and Alerts
Independent End-users and Decision Makers
Single Packaged ETL
Enterprise-wide Data Warehouse
Reduced IT Burden
9
DecisionPoint Clears the Path to Answers
Cost Effective

• Packaged solution deploys in weeks
• Reallocated IT staff
• Leverages existing ERP and BI investments

Consistent

• Data / business metrics
• Across division/geography/time
• Enterprise deployment

Simplified

• Unified enterprise data model
• Across sources/business functions/geography
• Ease of use for end-users

10
DecisionPoint Business Suite
AnalyticEnvironments
BusinessDomains
Data WarehouseInfrastructure
DataExtraction
Sources
11
DecisionPoint Source ExpertsTM

• DecisionPoint Source ExpertsTM
• Analyze ERP metadata, Integrates with Oracle
  Flexfields and PeopleSoft Trees
• Auto-configures the data warehouse
• Transforms and loads data

Oracle, PeopleSoft, Other
Business Domain
12
DecisionPoint Warehouse Administrator and
ServerTM

• Point and click interface for managing the data
  warehouse
• Automates system and database administration
• Updates at the speed of your business
• Simplifies ERP upgrades/changes
• Accurate, reliable, consistent, information

13
DecisionPoint Business DomainsTM

• Dozens of auto-configured reports
• Hundreds of useful metrics
• Focused business topics
• Flexible data access
• Fast delivery of end-user data

Finance
Human Resources
Distribution
Manufacturing
14
DecisionCastTM Analytic Application
Development/Deployment Platform

• Dashboards
• Drill down and drill across functionality
• Ad-hoc analysis
• Formatted Reports
• Alerts of Variances and Exceptions

DRILL ACROSS
DRILL DOWN
15
Analytical ApplicationCompliance Dashboard

• Interactive dashboard
• Anomaly detection
• Flexible analysis
• Collaboration environment

16
DecisionPoint Customers
17
Four Case Studies
18
Consolidating Financial Reporting for Executive
Analysis
19
Results and Benefits In 7 Weeks
20
Adjusting to Rapid Organic Growth
The Challenges

• Rapid store growth
• 1500 new stores in 43 states
• New leases every 18 hours/stores in 36
• Limited financial control
• Inconsistent processes
• Minimal visibility

Unpredictable store performance Overpaid
expenses Unaccountable store managers
21
Results and Benefits

• Insight into store financial health at any time,
  for any employee
• Closing books in 10 days instead of 25

Proactive Store Management

• Significant reduction in expense inconsistencies
  and
• Elimination of expensive exceptions

Controlled Costs
Timely and Accurate Visibility

• Internal audits time down 80
• Rapid detection of expense exceptions

22
Managing a Post-Divestiture Business
The Challenges

• Reorganization of new business
• Ancient internal reporting systems
• Inability to provide system support for new
  business model
• New IT team

23
Results and Benefits
EnabledEfficiencies

• Reconciled fixed assets
• Improved access to product line analysis
• Closing books faster

24
Accurate Business Management and Forecasting
25
Results and Benefits
26
Questions?
27
Thank you!
James Masuoka jamesm_at_dpapps.com
www.dpapps.com 800.970.5372