Transcript DB2 Web Query Up Sell

DB2 Web Query and
Taking Reporting on System i to the next level!
Chris Banks
Information Builders
June 17, 2008
Your business. No barriers.
MMSA Meeting – June 17, 2008
Agenda
 Information Builders Corporate Overview
 Introduction to DB2 Web Query
 Introduction to WebFOCUS
 Demonstration
 Questions & Answers
Who is Information Builders?
Copyright 2007, Information Builders. Slide 3
Information Builders
Corporate Background
 A major independent global software vendor
 33 years of experience
 We provide a unique combination
 Enterprise Integration
 Business Intelligence
 Backed by Professional Services
 We are known for:
 Superior engineering
 Top rated customer service
20,000+ customer sites
 We have 12,000+
supporting millions of users
 Significant partnerships
Copyright 2007, Information Builders. Slide 4
Information Builders
Our Customers Are Our Mission
Copyright 2007, Information Builders. Slide 5
Information Builders
2007 Computerworld Smithsonian Honors
Hillman Group
Air Canada
La Barge
Jefferson Medical
City of Richmond PD
Caja General de Ahorros, Spain
Saint George Bank
Information Builders
Our Customers Are Our Mission
2007 TDWI Best Practices Award
2007, Information Builders.
Slide 7
2007 Gartner BICopyright
Excellence
Award
What is DB2 Web Query?
Copyright 2007, Information Builders. Slide 8
Business Intelligence
CIO Priorities
Table 1
Top 10 Business and Technology Priorities in 2008
Top 10 Business Priorities
Business process improvement
Ranking
1
Attracting and retaining new customers
Creating new products and services (innovation)
2
3
Expanding into new markets or geographies
Reducing enterprise costs
Improving enterprise workforce effectiveness
Expanding current customer relationships
Increasing the use of information and analytics
Targeting customers and markets more effectively
4
5
6
7
8
9
Acquiring new companies and capabilities (mergers
and acquisitions)
10
Top 10 Technology Priorities
Business intelligence applications
Enterprise applications (ERP, CRM and
others)
Servers and storage technologies
Legacy modernization, upgrade or
enhancement
Technical infrastructure
Security technologies
Networking, voice and data
Collaboration technologies
Document management
Service-oriented architecture (SOA) and
service-oriented business applications
(SOBA)
Ranking
1
2
3
4
5
6
7
8
9
10
Source: Gartner EXP (January 2008)
Copyright 2007, Information Builders. Slide 9
DB2 Web Query
What is DB2 Web Query?
IBM announced that Query/400 was no longer going to be enhanced/maintained
DB2 Web Query
What is DB2 Web Query?
IBM wanted to:





Web-enable Query/400 reports
Easy for analysts to use
Highly productive report design environment
Take full advantage of DB2 features in V5R4
Attractive price point
Most BI Vendors Today
Don’t take advantage of the System i
System i
DB2/400
Most BI Vendors Today
Don’t take advantage of the System i
System i
Web Server
DB2/400
Windows
WebFOCUS
Optimized access to System i data
System i
System i
Web Server
Java App Server
- WebFOCUS web application
WebFOCUS reporting server
System p
DB2/400
System
z
Query/400
SAP
JD
Edwards
COBOL
RPG
pgms
System x
DB2 Web Query
What is DB2 Web Query?
IBM wanted to:





Web-enable Query/400 reports
Easy for analysts to use
Highly productive report design environment
Take full advantage of DB2 features in V5R4
Attractive price point
Information Builders built:
DB/2 Web Query for System i, a simplified version of
DB2 Web Query
What is DB2 Web Query?
 A Web-based query and report
writing product that replaces
Query/400
 Base Product
 Report and Graph Assistants
 Power Painter
 Spreadsheet integration
 Web-enable existing
Query/400 reports
 Additional IBM Features
 Active Reports
(Disconnected Analytics)
 On Line Analytical Processing
(OLAP)
 Developer Workbench
For more details, refer to:
http://www.ibm.com/systems/i/software/db2/webquery
DB2 Web Query
What is DB2 Web Query?
DB2 Web Query
Report Assistant: Drill Down
DB2 Web Query
Graph Assistant
DB2 Web Query
Preserve Investment in Query/400
Then Modify with
Report
Assistant
DB2 Web Query
Add-on: Active Reports
DB2 Web Query
Add-on: Active Reports
DB2 Web Query
Add-on: Active Reports
 Self-contained analytical reports
 Delivered to users via email* or browser
 Users interact with the data on the report
w/o being connected to a network infrastructure
 Intuitive built-in controls
 Sorting, Filtering, Visualization,


Charting, Dynamic Roll-ups
Export to HTML, CSV or Excel
Export Charts to Word, Excel, or PowerPoint
 Great for mobile users that are not connected
or even defined as a user on the System i
DB2 Web Query
Add-on: On-Line Analytical Processing (OLAP)
DB2 Web Query
Does Information Builders sell DB2 Web Query?
• DB2 Web Query is sold by IBM
and their resellers ONLY
• DB2 Web Query is an internal query and reporting tool
• It is NOT (nor sold as) a BI application
• As an IBM customer, if you had Query/400,
you get a copy of DB2 Web Query
• Ordered by IBM or reseller
• # of users depends on size of machine
• IBM (and their resellers) make $$$
by selling:
• Support (maintenance)
• More Users
• Add on Features: OLAP, Active Reports
DB2 Web Query
Why you want it!
 Easy to acquire, install



and learn
Integrated purely into the
System i environment
Powerful analytical and
reporting capabilities
Information presented in a
variety of formats, via a
browser
 It isn’t green
An Introduction to WebFOCUS
Copyright 2007, Information Builders. Slide 27
Pervasive Business Intelligence
Opportunity for Improvement
Most organizations access and analyze less
than 20% of their data assets, minimizing the
return on their overall IT investment.
Most organizations have deployed BI capabilities
to fewer than 10% of their internal users.
Documents
Services
Messages
Databases
Transactions
Applications
Copyright 2007, Information Builders. Slide 28
Pervasive Business Intelligence
Are We There Yet ?
 Most vendors create tools for
power users
 Try to simplify these tools and
deploy to non-technical users
 Forces customers to do
extensive data modeling
 Results in unused licenses,
failed projects and low ROI
 Users are limited to static
information at a premium
investment
Intuitive
Ad-hoc
BI applications tools
Business users need information, not tools!
Copyright 2007, Information Builders. Slide 29
Internet Intelligence in Everyday Life
What makes a great web application?
 Internet application characteristics for the consumer:




They are easy to use and can be used with no training
They save a tremendous amount of time
They provide something useful
They are accessible by everyone
 Internet application characteristics for the producer:
 They provide greater value at a lower cost (TCO)
 They grow business on a 24x7x365 calendar
 They provide better management of customer interaction
Copyright 2007, Information Builders. Slide 30
eBay — Knocking Down Barriers to Success
 eBay Online Marketplace
 181 million registered users
 78 million listings worldwide at any given time
 6 million added per day
 Global presence in 33 markets
 eBay average user 1hr 54m
 eBay average user views 280 pages per month
40%
35%
30%
Under 25
25-34
35-49
50-64
65+
25%
20%
15%
10%
Age not a
factor: over
20% of users
are 50+
5%
0%
Age
Copyright 2007, Information Builders. Slide 31
How Do They Do It?
Ease of use
No training required
Copyright 2007, Information Builders. Slide 32
Information Builders’ WebFOCUS
A True Business Intelligence Platform
Windows
All Linux
All Unix
IBM
System i
IBM
System z
CICS
Copyright 2007, Information Builders. Slide 33
Information Builders’ WebFOCUS
Business Intelligence for Executive Management
Dashboards
Performance Metrics,
KPI’s & Scorecards
Financial Reports/
Production Documents
Information Builders’ WebFOCUS
Business Intelligence for Back Office Analysts
Query, Analysis
& Excel Integration
Data Visualization
& Analytical Dashboards
Geographical
Analysis
Enterprise Search
Information Builders’ WebFOCUS
Business Intelligence for Operational Employees
BI Applications
& Self-Service Reporting
Operational Dashboards
& Performance Metrics
MS-Office Integration
PDF Publishing
WebFOCUS Self-service Application
WebFOCUS Self-service Application
WebFOCUS Self-service Application
WebFOCUS Self-service Application
WebFOCUS Self-service Application
Information Builders’ WebFOCUS
Business Intelligence for Field Staff, Partners & Customers
Easy To Use
BI Applications
Statements
& Invoices
Active Reports
& Dashboards
(Portable Analytics)
Dimensions
Measures
Ranking Options
Output Formats
Filters
Drill downs
10 x 7 x 4 x 2 x 4 x 3 x 15 x 15 x 3 = 4,536,000
1 report from IT
4,536,000 reports for end-users
No training involved!
Information Builders’ WebFOCUS
Business Intelligence for Field Staff, Partners & Customers
Easy To Use
BI Applications
Statements
& Invoices
Active Reports
& Dashboards
(Portable Analytics)
Information Builders’ WebFOCUS
Production Distribution
Active Reports
& Analytics
Published Documents,
Statements & Invoices
Excel, Powerpoint,
Adobe PDF & e-mail
All Mobile Devices
Archive
High-scale
distribution.
- Scheduled &
Real time alerts
Information Builders’ WebFOCUS
Delivers Information Users Can Use
Verizon
 Over Hillman
200 Applications
Group
Target
NASA
Running
on
All platforms
Medium-sized business
Example…
For
40,000
600
Contractors
Users
1,000 daily users
Process
andParts
Operational
6,700
30 Million
Stores
Real-time production data
Efficiency
Management
from
4.4
1 Simple
Million
Management
Report
4 different systems
System
requests/month
System(POEMS)

2 Developers
 Used
by Execs to Field
Technicians
Information Builders’ WebFOCUS
Big Impact At The Lowest TCO
1,500 users
5 support personnel
University of North Carolina
16 campuses
200,000 users
2 support personnel
60,000 users
1.5 support personnel
20,000 users
4 support personnel
7,000 users
5 support personnel
85,000 users
3 support personnel
2,000,000 users
3 support personnel
85,000 investment professionals
5 support personnel
The best user to support staff ratio in the industry!
Copyright 2007, Information Builders. Slide 49
Information Builders’ WebFOCUS
Our strategy is a little different
 WebFOCUS makes Pervasive BI a reality
 Ease of Use & Customization
 Minimal/No Training required
 Industry leading Enterprise Integration
 Platform/data agnostic
 Scalability to millions of users
 Flexible Pricing and Low TCO
 Support, Expertise & Best Practices
Everyone is a Decision Maker!
Copyright 2007, Information Builders. Slide 50
So exactly what functionality does WebFOCUS
provide that DB2 Web Query doesn’t have?
Copyright 2007, Information Builders. Slide 51
WebFOCUS vs DB2 Web Query
Differences
WebFOCUS has all the functionality that
DB2 Web Query provides, plus:
•
•
•
•
•
•
Ability to create Self-service applications
Ability to create Dashboards (five types)
Satisfies ANY reporting requirement
Data Visualization
Report Distribution
Connectivity to anything in your enterprise
• ERP, SCM, CRM, legacy data, RDBMS
• Tie Action to Information