Lee Donaldson - PowerPoint PPT Presentation

1 / 29

About This Presentation

Title:

Lee Donaldson

Description:

Reporting - Information Publishing. The best PDF generation in the BI marketplace ... Navigate (drilldown) within a single compound document ... – PowerPoint PPT presentation

Number of Views:113

Avg rating:3.0/5.0

Slides: 30

Provided by: serv430

Category:

more less

Transcript and Presenter's Notes

Title: Lee Donaldson

1
WebFOCUS 7 Overview

Lee Donaldson
Jeff BlackmonInformation Builders, Atlanta

2
WebFOCUS 7Overview

Comprehensive Enterprise Business Intelligence
Suite
Built on the Best-In-Class integration platform
Accesses ALL enterprise data
Provides thin client Information Access
Delivery
Report, Analyze, Visualize, Deliver, Transform
(ETL), Transact
For Strategic, Tactical and Operational
information Systems throughout your organization
and beyond

3
WebFOCUS 7 Technology
4
WebFOCUS 7 Overview

5
WebFOCUS 7Overview

Enterprise Standard For Reporting and Business
Intelligence
Management Alerts, Scorecards and KPI Dashboards
Financial and Compliance Reporting
Outward Facing Self-Service Information Systems
Operational Reporting
Analytic Dashboards, GIS, and Advanced
Visualization

DATA SOURCES
Data Mart/Cubes
DataWarehouse
OperationalData Stores
TransactionalSystems
WebServices
Documents
Applications
INTEGRATION
DEVELOPMENT
ADMINISTRATION
SECURITY
METADATA
INTELLIGENCE
USERS
USERS
Customer/Partner
Customer/Partner
Power User
Power User
Executive
Executive
Analyst
Business User
Analyst
Business User
8
WebFOCUS 7Overview

DATA SOURCES
Data Mart/Cubes
DataWarehouse
OperationalData Stores
TransactionalSystems
WebServices
Documents
Applications
INTEGRATION
DEVELOPMENT
ADMINISTRATION
SECURITY
METADATA
INTELLIGENCE
SOLUTIONS
USERS
Customer/Partner
Power User
Executive
Analyst
Business User
10
WebFOCUS 7Data Sources
Teradata TOTAL TurboIMAGE UFAS ULTRIX/SQL UNI
FY UX C-ISAM VSAM WDS WIIS Packages SAP
R/3 SAP BW Siebel PeopleSoft Baan J.D.
Edwards Walker Interactive DB Shared
Medical Hogan Web Services and more!
Access ADABAS ALLBASE/SQL ALL-IN-1 C-ISAM CA-
Datacom/DB CA-IDMS DB2 DB2/400 DB2
UDB DBMS dBASE DL/1 DMS ENSCRIBE ESSBASE FO
CUS IDMS IMS INFOMAN Informix
Ingres ISAM KSAM MODEL 204 MUMPS NetISAM Non
Stop SQL OMNIDEX Oracle PACE Private
Files Progress QSAM Rdb Red Brick RMS
ShareBase SQL/DS SQL/Server Analysis
Services SUPRA Sybase SYSTEM 2000

Over 280 Native Data and Applications Adapters
Enhances Data Warehouse Potential
Reduces Data integration costs
Accelerates Time To Information

11
WebFOCUS 7Overview

DATA SOURCES
Data Mart/Cubes
DataWarehouse
OperationalData Stores
TransactionalSystems
WebServices
Documents
Applications
INTEGRATION
INTEGRATION
DEVELOPMENT
ADMINISTRATION
SECURITY
Adapters
Web Services
ETL
Real-Time Transformation
EII
METADATA
INTELLIGENCE
USERS
Customer/Partner
Power User
Executive
Analyst
Business User
13
WebFOCUS 7Integration
RealTime
Point in Time
Adapters
ETL
R/T Transformation
EII
XML Web Service
XML Web Service
Process/ Transaction/ Web Service/ Documents
Data Marts
Data Warehouse
Operational Data Store (ODS)
Operational Data

Data Warehouse
Real-time Data Warehouse (trickle feed
transactions)
Operational Data Access
EII - Hybrid approach (drill through)
Process-Driven (Alerts from operational systems)
Web Services

14
WebFOCUS 7Overview

DATA SOURCES
Data Mart/Cubes
DataWarehouse
OperationalData Stores
TransactionalSystems
WebServices
Documents
Applications
INTEGRATION
DEVELOPMENT
ADMINISTRATION
SECURITY
METADATA
INTELLIGENCE
Report
Transact
Analyze
Visualize
Published
On-Demand
Portal
Microsoft Office
Custom Application
USERS
Customer/Partner
Power User
Executive
Analyst
Business User
16
WebFOCUS 7 Intelligence (i.e. Business
intelligence)Reporting Parameter-driven

Large Railroad 1,000 MS Access Reports and
nearly 100 Access Databases replaced by just 50
WebFOCUS Report Templates accessing a single data
warehouse
Financial Services Company 3,000 Impromptu
Reports replaced by 30 WebFOCUS Reports
High Tech Manufacturing 4 WebFOCUS Report
templates generate 350,000 different report
permutations
Bank 1 WebFOCUS Report Template replaces 150
Hummingbird queries

Parameter-driven Reporting (a.k.a. Structured
Ad-hoc)
Provides tremendous end user flexibility and
requires virtually no training
Parameterize anything on a report
Dimensions, Measures, Filters Groups,
Drillpaths, Output Formats, etc.
One report template can replace thousands of
existing reports
Users get more but need to know less about
business intelligence

DATA SOURCES
Data Mart/Cubes
DataWarehouse
OperationalData Stores
TransactionalSystems
WebServices
Documents
Applications
INTEGRATION
DEVELOPMENT
ADMINISTRATION
SECURITY
METADATA
Independent Research Note WebFOCUS requires
significantly less training for end users than
other leading BI tools. And on average it results
in 2 and ½ times the numbers of users.
INTELLIGENCE
Report
Transact
Analyze
Visualize
Published
On-Demand
Portal
Microsoft Office
Custom Application
USERS
Customer/Partner
Power User
Executive
Analyst
Business User
17
WebFOCUS 7 - IntelligenceReporting - Information
Publishing

The best PDF generation in the BI marketplace
Compound document with multiple reports on a page
Drilldown to other PDF reports and documents
Navigate (drilldown) within a single compound
document
High resolution (SVG) graphics for publish ready
output
It is like a printable, self-contained BI
environment
Perfect for executives and managers on-the-go

Annual Reports
Financial Reports And Statements
Billing Statements
Invoices
18
WebFOCUS 7 - IntelligenceReporting Excel
Integration

WebFOCUS has the best Excel integration of any BI
product
Dynamically generates fully formatted Excel
spreadsheets
W/ Drilldowns, Formulas, Summations, Color-coding
Pages
Generates Excel Pivot Tables
Refreshes server-based Excel templates with new
data
Improves end user productivity reduces errors
Perfect for financial and regulatory reporting

Formulas/Summations
Color-Coding
Pivot Tables
Worksheet Pages
Hyperlinks/Drilldowns
19
WebFOCUS 7 - IntelligenceVisualization

Unique Data Visualization simplifies
interpretation and analysis
Fastest Time to Answer Faster than OLAP or
Ad-hoc Query
Data represented in interactive chart
perspectives
a.k.a. Analytic Dashboards
Thousands of Questions can be asked of the same
data
You never lose site of where you are or where you
came from
Available in web browser for analysis or
Powerpoint for presentation

20
WebFOCUS 7 - IntelligenceVisualization and GIS

Integrated with ESRI GIS components
The only bi-directional mapping interface
Drill Map to Report OR Report to Map
Multi-layered maps expose more detail as you zoom
The best way to represent spatial data

21
WebFOCUS 7 - IntelligenceInformation Delivery

Automated Delivery Of Information
a.k.a. push or casting
On Schedule
Set by administrator
Or by user subscription
On Alert/Event
Initiated by a real-time events
Intelligent bursting
Supports any format
Delivery Destinations
Web Server
Database archive (library)
eMail
Mobile device
Printer/Fax
Save millions in distribution costs
Improve the productivity of information workers

22
WebFOCUS 7Overview

Features and Functions
Non Persistent Connection
Java-based multi-threaded middle-tier
Require less resources Allows more concurrent
users
Built-in Clustering, Load-balancing and
Fail-over
Autonomic (self-aware) functions
Simplified administration guaranteed
performance 24X7
Capacity Planning
Usage Auditing and Analysis
Plan for increases in usage w/ benchmarking and
performance planning utilities
Optimized Native Data Adapters
Leverages native db extensions to provide the
best possible query performance
Integrated LDAP Security with Single Sign-on
Utilize and extend existing LDAP security to
provide safe single sign-on environment that
customizes information for all users

DATA SOURCES
Data Mart/Cubes
DataWarehouse
OperationalData Stores
TransactionalSystems
WebServices
Documents
Applications
Permeating the Enterprise and Supporting
Operational Business Intelligence Transforming
data into information is what a business
intelligence tool is designed to do. However
most were not designed to handle tens of
thousands of users Nor do they have the
management and administration facilities to
handle the 24x7 guaranteed performance needed
for mission critical information systems Ours
Was!
Superior architecture and advanced administration
utilities WebFOCUS requires significantly less
resources (machines, CPUs, and System Support
Personnel) than other leading BI tools according
to independent research. Frank N Magid Assoc.,
Inc. Market Research Firm
ADMINISTRATION
INTEGRATION
DEVELOPMENT
SECURITY
MetadataManagement
UsageManagement
METADATA
LoadManagement
INTELLIGENCE
CapacityPlanning
UserAdministration
USERS
Customer/Partner
Power User
Executive
Analyst
Business User
25
WebFOCUS 7Overview

WebFOCUS 7s Integration platform includes
access to all enterprise data for right time
information systems
Scalability and guaranteed 24x7 services provide
for operational deployments as well
Tools span user skill levels including
non-technical information workers

Strategic
Data Marts
Tactical
Operational
Data Warehouse
CUSTOMERS
PARTNERS
Operational Data Store
AGENTS
SERVICE
SUPPLIER
DISTRIBUTOR
Operational Data
Process/ Transaction/ Web Service/ Documents
29
WebFOCUS 7Enterprise Business Intelligence And
Operational Reporting

DATA SOURCES
Data Mart/Cubes
DataWarehouse
OperationalData Stores
TransactionalSystems
WebServices
Documents
Applications
INTEGRATION
DEVELOPMENT
ADMINISTRATION
SECURITY
MetadataManagement
Data
Adapters
Web Services
ETL
Real-Time Transformation
EII
UsageManagement
METADATA
Application
LoadManagement
Group
INTELLIGENCE
CapacityPlanning
Report
Transact
Analyze
Visualize
Role
UserAdministration
Deliver
Microsoft Office
Portal
Custom Application
USERS
Customer/Partner
Power User
Executive
Analyst
Business User

Write a Comment

User Comments (0)