New Data Perspectives: Enhanced Query and Reporting for ShowCase Customers

1
New Data Perspectives Enhanced Query and
Reporting for ShowCase Customers

• Finally...A Solution End Users and IT Can Cheer
  About!

2
Familiar problem?

• Business user
• I cant read this too much detail, I want to
  see a summary of all regions.
• I need more detail, how can I see how my region
  is doing
• How can I make decisions with all this
  information?
• How can I see problem areas more easily?
• This is good, but Id like to see the difference
  between these two columns can you add that to
  the report?
• Why are your numbers different from mine?

3
Webcast Series

• Session 1 Get Answers Faster with Enhanced Query
  ReportingWednesday, March 1, 2006 200PM CT
• Session 2 How to Structure Your Data for Deeper
  Analysis Wednesday, March 8, 2006 200PM CT
• Session 3 Extracting the Right Data from Your
  Operational SystemWednesday, March 15, 2006
  200PM CT
• Session 4 Developing Reports that Deliver
  Greater Insight Thursday, March 23, 2006 200PM
  CT

4
Session 1Get Answers Faster with Enhanced Query
Reporting
5
Analytic Process
Reporting
What happened?

• From your
• ERP system
• CRM system
• Transactional systems
• Data warehouse

Business Value
Time
6
Territory Management Report
Sales by Territory and product
Who is the top Sales Rep?
What customers??
What Sales Reps??
7
First step Query and Report Writer
Security and Performance Optimization
ERP Systems
Report Writer
Warehouse Manager
Query
Transaction Systems

• Access data stored in relational tables
  maintained by transactional systems
• Easier and more flexible than typical query and
  reporting tools
• Complicated database structure
• Users require extensive training

8
Next Step Analytics

• Build an analytic environment
• Central data store
• Analytic applications
• Easily build ad-hoc queries and reports
• Perform simple yet powerful- analytics
• End user tool of choice

Report Writer
Query
9
The Power of Analytics

• Dont have to understand database structure
• Measures calculations pre-defined
• Easy to make changes

10
ShowCase Suite Advanced Analytics

• Essbase
• Industry standard high performance OLAP database
  for decision support
• Build analytical models that consolidate actual,
  projected derived data
• Integrated with ShowCase Suite
• Leverages the power of the iSeries
• Analyzer
• Browser-based speed of thought analysis
• Pivot, link drill into data
• Highlight exceptions
• Perform calculations
• Drill through to detailed operational data

11
Demonstration
12
How do I build that?
2
Warehouse Builder (Extract Cleanse)
4
3
1
13
Session 2 How to Structure Your Data for Deeper
Analysis
14
Session 3 Extracting the Right Data from Your
Operational System
15
Session 4 Developing Reports that Deliver
Greater Insight
16
Webcast Series

• Session 1 Get Answers Faster with Enhanced Query
  ReportingWednesday, March 1, 2006 200PM CT
• Session 2 How to Structure Your Data for Deeper
  Analysis Wednesday, March 8, 2006 200PM CT
• Session 3 Extracting the Right Data from Your
  Operational SystemWednesday, March 15, 2006
  200PM CT
• Session 4 Developing Reports that Deliver
  Greater Insight Thursday, March 23, 2006 200PM
  CT

17
Next SessionHow to Structure Your Data for
Deeper Analysis

• Wednesday, March 8, 2006
• 200PM CT