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:
Tags: donaldson | lee

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

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

DATA SOURCES
Data Mart/Cubes
DataWarehouse
OperationalData Stores
TransactionalSystems
WebServices
Documents
Applications
INTEGRATION
DEVELOPMENT
ADMINISTRATION
SECURITY
METADATA
INTELLIGENCE
SOLUTIONS
USERS
Go to Summary
Customer/Partner
Power User
Executive
Analyst
Business User
7
WebFOCUS 7Solutions
  • 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
Go to Summary
Customer/Partner
Power User
Executive
Analyst
Business User
9
WebFOCUS 7Data Sources

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
DEVELOPMENT
ADMINISTRATION
SECURITY
METADATA
INTELLIGENCE
SOLUTIONS
USERS
Go to Summary
Customer/Partner
Power User
Executive
Analyst
Business User
12
WebFOCUS 7Integration

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
SOLUTIONS
USERS
Go to Summary
Customer/Partner
Power User
Executive
Analyst
Business User
15
WebFOCUS 7Intelligence (i.e. Business
intelligence)

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

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

DATA SOURCES
Data Mart/Cubes
DataWarehouse
OperationalData Stores
TransactionalSystems
WebServices
Documents
Applications
INTEGRATION
DEVELOPMENT
ADMINISTRATION
SECURITY
METADATA
INTELLIGENCE
SOLUTIONS
USERS
Go to Summary
Customer/Partner
Power User
Executive
Analyst
Business User
24
WebFOCUS 7Administration Architecture (for
scalable information systems)
  • 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

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

DATA SOURCES
Data Mart/Cubes
DataWarehouse
OperationalData Stores
TransactionalSystems
WebServices
Documents
Applications
INTEGRATION
DEVELOPMENT
ADMINISTRATION
SECURITY
METADATA
INTELLIGENCE
SOLUTIONS
USERS
Go to Summary
Customer/Partner
Power User
Executive
Analyst
Business User
27
WebFOCUS 7 Summary
28
WebFOCUS 7Summary
  • 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)
About PowerShow.com