WebFOCUS: Because Everyone Makes Decisions

1. WebFOCUS:Because Everyone Makes Decisions October 22, 2014 Rivo Uibo

2. Information Builders’ WebFOCUS What Do We Do? Our technology allows you to leverage every data asset To make your systems, people and processes more efficient

3. Information Builders’ WebFOCUSBusiness Drivers for Business Intelligence • Improve business processes • Eliminate bottlenecks – accelerate or automate • Real-time visibility into enterprise operations • Monitor and track performance of business initiatives • Corporate governance • Drive down costs • Improve customer satisfaction • New sources of revenue driven by information availability • What are your drivers?

4. Experience Shows… • Timely information is needed by everyone • Yet most companies use only 20% of their data • And provide access to only 10% of the people Data People We help companies achieve better results! 20% 10%

5. 3 % Developers 7 % Analysts & Power Users 90% Non-Technical Business Users So - Why Do So Few People Receive The Benefit of BI? Many BI Solutions concentrate on putting tools in the hands of advanced users Typical Organization People People People WebFOCUS BI Applications provide ease of use & flexibility at all levels 10% • Extending the audience for BI • And promoting wide user adoption Customers & Partners 10%

6. How Do You See Business Intelligence? WebFOCUS At Zurich Financial Services WebFOCUS At Freightliner WebFOCUS At Target WebFOCUS At Elie Tahari Any BI Tool vs

7. Information Builders’ WebFOCUS Customer Examples • Hillman Group • Medium-sized business • 1,000 daily users • Real-time production data from 4 different systems • 2 Developers • Verizon • Over 200 Applications • Running on All platforms • For Example… • Process and Operational Efficiency Management System (POEMS) • Used by Execs to Field Technicians • Target • 40,000 Users • 6,700 Stores • 4.4 Million Report requests/month • NASA • 600 Contractors • 30 Million Parts • 1 Simple Management System Data Connections • DB2 (mainframe) • DB2 UDB (AIX) • Oracle • AS400 • Informix • FOCUS Files • SQL Server • Essbase • MS Access • MS Excel • Flat files • Peoplesoft

8. The Best user to developer ratio in the BI Market! Information Builders’ WebFOCUS Big Impact With Few Resources Online Brokerage Analytics 85,000 investment professionals 5 developers Asset-based Lending 7,000 Users 5 Developers 1,500 Users 5 Developers Target 40,000 Users Inventory Mgmnt -85,000 Users -Payroll & HR -3 Developers 60,000 Users Warranty Mgmnt 1.5 Full 20,000 Users 4 Developers 2,000,000 users Credit Card Billing 3 developers University of North Carolina 16 Campuses 200,000 users 2 developers

9. Why Choose Information Builders? • We have a unique project based approach • We solve business problems with information • It’s not about putting a BI tool in an end users hands • Our approach ensures early and rapid, success • Measured by broad user adoption • Low cost, low maintenance, low risk, • …with an agile infrastructure that can be applied to many business problems • Based on a partnership with the customer

10. Why Choose Information Builders?Technology Differentiators • 300+ Data Sources • Leverages all platforms • Windows, Linux, UNIX, system-i, system-p, system-z • Scalability to the hundreds of thousands • Solves more problems that other BI Tool sets… • 7 Unique Integration patterns • Active Reports – provides portable business intelligence to unlimited users at a low one time server price • Leverages common “day to day” tools for delivery • Email, excel, web browser, search, Adobe PDF, etc.

11. Information Builders’ WebFOCUS Two Core Competencies: Intelligence and Integration

12. Information Builders’ WebFOCUSBusiness Intelligence and Integration Function Visualization Formats Mobile Vehicles Analysis Office Information Delivery Dashboards eMail Search Reporting Location Intelligence Applications & Portals Documents Intelligence Integration Data Warehouse Staged Operational Applications & Data Near Real-time Messages, Transactions & Services Real-time

13. WebFOCUS for Business Managers

14. Why Choose Information Builders?Business Managers • WebFOCUS dashboards, reports and analysis will give you real-time visibility into your business • Ease of use of WebFOCUS applications will promote wide user adoption • Creating a measurement culture • Users spend less time finding or creating information and more time solving problems • Spreadsheets become the source for proven, auditable, consistent, information – NOT an error prone, inconsistent data mart • Little or NO end user training required!

15. WebFOCUS for IT

16. Why Choose Information Builders?IT • Rapid development of BI Applications • Low Maintenance, Low Cost, & Solves more problems • BI Apps more widely adopted than BI tools • 300+ Data Sources • Co-existence with current IT infrastructure • Any Data, Any platform, Any App Server, Any Web Server • Windows, Linux, UNIX, system-i, system-p, system-z • New users can be added at little or no cost • Inherent scalability prepares you for success

17. WebFOCUS for The Data Architect

18. Why Choose Information Builders?Data Architecture • 300+ Data Sources • Through Optimized Native Adapters • Solves more problems that other BI Tool sets because • 7 Unique Integration patterns • Leverages all platforms • Windows, Linux, UNIX, system-i, system-p, system-z • Queries can be processed close to the source • Reducing network traffic

19. WebFOCUS:Because Everyone Makes Decisions THE BEGINNING OF DETAILED TECHNOLOGY OVERVIEW

20. WebFOCUS:Because Everyone Makes Decisions Business Intelligence Engine Technology Overview Details

21. WebFOCUS: Because Everyone Makes DecisionsThe Business Intelligence Engine Reporting Analysis Information Delivery Visualization Location Intelligence Dashboards

22. WebFOCUS: Because Everyone Makes DecisionsThe Business Intelligence Engine Reporting • Robust, mature reporting • Operational, • Financial • Analytical • Leading Reporting Technologies • Guided Ad-hoc • Best output formatting • PDF Report Books • Active Reports

23. WebFOCUS: Because Everyone Makes DecisionsReporting: Anatomy Of Guided Ad-hoc • Form based report creation • Recognized as the easiest &most flexible BI deployment method • Make it as simple or as thorough as you like • Allow users to change any aspect of the report • then they can…. • 1 Guided Ad-hoc Template = 1,000 Personal Reports Column Prompts Paramterize Virtually Anything Filters Drilldown Paths Output Formats Save Selections Run it Schedule It Send It

24. WebFOCUS: Because Everyone Makes DecisionsThe Business Intelligence Engine Analysis • Introducing Active Technologies • A new thin output format for disconnected users • Binds report Data and Analytic capabilities into one document • Requires no software • Completely portable • Provides analytic functions to non-technical users • Create it on the fly or email to anyone • As single report or dashboard • Works on mobile devices • *Recipient does not need a license Filter Calculate Visualize Chart Pivot Annotate Send/Share Export to MS Office

25. WebFOCUS: Because Everyone Makes DecisionsThe Business Intelligence Engine Information Delivery • Intelligent “Push” of Relevant Information • True Real-time Alerting • Monitor any type of business event • Transactions, emails, FTP, Messages, etc. • Information Delivered in Context • Reduces the time Spent Searching • Accelerates problem resolution • email Delivery in ANY Format

26. WebFOCUS: Because Everyone Makes DecisionsThe Business Intelligence Engine Visualization • Visualize thousands of data points in a single analytic dashboard • Immediately identify “Outliers” • Hundreds of questions answered visually • With little or No training required

27. WebFOCUS: Because Everyone Makes DecisionsThe Business Intelligence Engine Location Intelligence • Visually & Geographically understand your business • Better understand revenues, risks, costs, opportunities when they are associated with proximity • Plot Report data on a map • Report on adjacent data from a map

28. WebFOCUS: Because Everyone Makes DecisionsThe Business Intelligence Engine Dashboards • Your business at a Glance • Whether your approach is Formal… • Balanced Scorecard • Six Sigma • Activity Based Costing or • Custom… • Data Warehouse based or • Real-time from multiple sources

29. WebFOCUS: Because Everyone Makes DecisionsThe Business Intelligence Engine • So how will your application look? • Anyway you like • All of this delivered to • The WebFOCUS Portal • Or ANY Portal • Your email • Access from Excel • Or your favorite Office product • Or on your Mobile device

30. WebFOCUS:Because Everyone Makes Decisions The Integration Engine Technology Overview Details

31. WebFOCUS: Because Everyone Makes DecisionsThe Integration Engine Data Integration ETL – Data Migrator Process Design & Service Composition

32. Remember This…Experience Shows… • Timely information is needed by everyone • Yet most companies use only 20% of their data • And provide access to only 10% of the people Data People We help companies achieve better results! 20% 10%

33. WebFOCUS: Because Everyone Makes DecisionsThe integration Engine Data Data Data Integration • Over 7 Styles Of Integration • Data Warehouse • Real-time Data Warehouse • Enterprise Information Management (EII) • Operational Data Access • Process Integration • Search • Web Services • WebFOCUS allows you to leverage all of your data • Providing high-value, real-time visibility into enterprise performance and processes 20%

34. WebFOCUS: Because Everyone Makes DecisionsThe integration Engine

35. WebFOCUS: Because Everyone Makes DecisionsThe integration Engine Over 7 styles of integration Data Integration 1) Data Warehouse Operational Systems Billing Inventory Shipping DW

36. WebFOCUS: Because Everyone Makes DecisionsThe integration Engine Over 7 styles of integration Data Integration 1) Data Warehouse 2) Operational Access Operational Systems Billing Inventory Shipping DW

37. WebFOCUS: Because Everyone Makes DecisionsThe integration Engine Over 7 styles of integration Data Integration 1) Data Warehouse 2) Operational Access Operational Systems Billing Inventory Shipping 3) Enterprise Information Integration (EII) Combine Data From Multiple Enterprise Sources At Report Time

38. WebFOCUS: Because Everyone Makes DecisionsThe integration Engine Over 7 styles of integration Data Integration 1) Data Warehouse 2) Operational Access Transactions Billing Inventory Shipping 3) Enterprise Information Integration (EII) 4) Real-time DW DW Transactions fed in real-time To data warehouse (a.k.a. Trickle-feed)

39. WebFOCUS: Because Everyone Makes DecisionsThe integration Engine Over 7 styles of integration Data Integration 1) Data Warehouse 2) Operational Access Transactions Billing Inventory Shipping 3) Enterprise Information Integration (EII) Generate Packing Slip Create Invoice 4) Real-time DW Debit Inventory 5) Process Integration DW New Order Transactions fed in real-time To data warehouse (a.k.a. Trickle-feed) Alert Supply Manager!

40. WebFOCUS: Because Everyone Makes DecisionsThe integration Engine Over 7 styles of integration Data Integration 1) Data Warehouse 2) Operational Access Billing Inventory Shipping 3) Enterprise Information Integration (EII) Generate Packing Slip Create Invoice 4) Real-time DW Debit Inventory 5) Process Integration 6) Web Services New Order Access 1 or more web services in conjunction with internal data assets Alert Supply Manager! Web Service Web Service Web Service

41. WebFOCUS: Because Everyone Makes DecisionsThe integration Engine Over 7 styles of integration Data Integration 1) Data Warehouse Enriched transaction in HTML 2) Operational Access Transactions Billing Inventory Shipping Sent to Search engine 3) Enterprise Information Integration (EII) 4) Real-time DW 5) Process Integration Search Engine 6) Web Services 7) Search Search results associated with BI Reports Search

42. WebFOCUS: Because Everyone Makes DecisionsThe integration Engine ETL - Data Migrator Data Migrator • ETL productivity tool that will • Extract data from any enterprise data source • Transfer across platforms • Transform data applying business rules • Load to relational database or create files and xml • And is used to • Build a Data Warehouse or stage data for analysis • Prepare data for Application Loading

43. WebFOCUS: Because Everyone Makes DecisionsThe Integration Engine Process Design • Event Monitors • Decision Switches – Business Logic • Service Provisioning • Service Enablement • Service Composition • Service Governing • Works with • Any Message Type • Any Transport • Any Data Source • Any Platform • Any Middleware • Any Application Server

44. Actions: • Caster • WebFOCUS Report • ETL • SQL Input • SQL procedure • Etc. Event Monitors Decision Switch Event Listener: • Transactions • eMail • File (Exists) • FTP • Message Queue • RDBMS Transaction • SAP Transaction • Etc.

45. WebFOCUS: Because Everyone Makes DecisionsThe Integration Engine BI Content & Application Development • Service Composition • Process Design • Decision Switch • Event Management • Service Registration • Service Monitoring • Report Design • Form Creation • Dashboard Layout • User Administration • Metadata Management • Report Scheduling Service Composition & Process Design • Adapter Management • Transformation • Load Management • ETL Scheduling Enterprise Information Management