IBM Start Now Business Intelligence Solutions Agenda

IBM Start Now Business Intelligence Solutions

Agenda n Overview of BI n Who will buy and why n Start Now BI solution n Benefit to customer

Definitions Data Warehouse: Safe and secure location for a businesses entire data which everyone in the company can easily find access. Data is put in an format conducive to analyses. n Datamart: Just like a data warehouse except that only some data is kept there, typically to satisfy a specific company business need. n Analyses: Techniques used to gain insight from business data to improve business decisions n

Customer View n Motivators – Need better information to make better decisions – More people need access to information – Need information faster n Inhibitors – BI is Spreadsheet – Cost n Latent motivation – Inaccurate data

Problems with Current Procedures n n n n Many computers, applications, databases Databases designed for fast transactions not analysis Data on individuals’ PCs Example: Inconsistent Data Inconsistent data IBM Corp. Inadequate tools IBM Corporation Inconsistent processes International Business Machines Lack of security and protection

Improving Current Procedures n Single data repository n Security, backup and recovery n Designed for analysis n Rigor in extraction processes n Rigor in analyses processes n Tools to fit the analysis

The Right Tools Online Analytical Processing What has our sales trend been in the West the last few years? Query Tools What were our sales in NY during May? Number of Users Cost and Complexity Data Mining Discover relationships and patterns

Example of BI Report

Target Customer n Employees 100 to 1, 000 n Company has large number of customers and/or products n Competitive market

Start Now Business Intelligence Solutions p-Series Scenario s x-Series Windows 2000 AIX DB 2 2 U NIVERSAL DATABASE Enableme nt Kit

IBM Software n IBM DB 2 Universal Database Enterprise Edition Version 7. 2 – Repository for data – Easy to manage – Backup and recovery functions – Security

IBM Software (continued) n DB 2 Warehouse Manager Version 7. 2 – Supports definition, implementation and management of a business intelligence data mart. – Manages and automates processes such as source data selection, transformation and cleansing, and populating the data mart.

IBM Software (continued) n Query Management Facility (QMF) for Windows Version 7. 1 – Built for DB 2, the best performing query engine – Most flexible, multi-purpose multi-user, multiplatform query and reporting tool – Cross-industry, multi-language product – Proven track record n Query tools from Brio and Business. Objects (report example done using Business. Objects)

IBM Software (continued) n DB 2 OLAP Starter Kit Sales Region Sales Ti m e – Comes with DB 2 UDB V 7. 2 – Provides most of function provided in DB 2 OLAP Server. – Multidimensional analysis

Suggested Hardware - Windows Software Suggested Hardware DB 2 Universal Database with Dedicated Intel® Pentium® DB 2 OLAP Starter Kit and DB 2 733 MHz Warehouse Manager 512 MB RAM 18 GB free disk space DB 2 Administration Client with Reporting Tool Intel® Pentium® 600 MHz or greater 256 MB RAM 5 GB free disk space

Suggested Hardware - AIX Software DB 2 Universal Database with DB 2 OLAP Starter Kit and DB 2 Warehouse Manager DB 2 Administration Client with Reporting Tool Suggested Hardware DB 2 Server: Dedicated RS/6000 333 MHz 512 MB RAM 18 GB free disk space Warehouse Server: Intel® Pentium® 733 MHz or greater 256 MB RAM 9 GB free disk space Intel® Pentium® 600 MHz or greater 256 MB RAM 5 GB free disk space

Scenarios Start Now e-commerce based on IBM Web. Sphere Commerce Suite e-commerce CRM Transform Start Now CRM based on Domino and Relavis e-sales Query Reports Datamart OLAP Cubes

Putting the Pieces Together Start Now e-commerce Start Now CRM Warehouse Mgr QMF Reports DB 2 Datamart OLAP Starter Kit

Scenario Descriptions Acquire, transform, and make analysisready data from an e-commerce Web site that is based on Web. Sphere Commerce Suite v 4. 1 and v 5. 1, and Net. commerce v 3. QMF for Windows, Brio. Query and Business Objects instructions are provided for tool installation and execution of sample reports. Acquire, migrate(from Domino Server to DB 2), transform and make analysisready data from a Web site that is based on Relavis Sales Force Automation*. QMF for Windows, Brio. Query and Business Objects instructions are provided for tool installation and execution of sample reports. Use the OLAP Starter Kit, develop multidimensional cubes in the e-commerce data warehouse to provide business and market insights for querying, reporting, planning and forecasting. Use OLAP Starter Kit, develop multidimensional cubes in the CRM data warehouse to provide business and market insights for querying, reporting, planning and forecasting Relavis Sales Force Automation is a component of IBM Start Now CRM Solutions

Deployment Tasks Time Req. (hrs) Basic Solution Time Req. (hrs) Intermediate Solution Time Req. (hrs) Complex Solution Plan the Solution Develop the Solution Test the Solution Deploy the Solution Train the customer 32 – 58 86 – 136 12 – 18 14 – 20 16 – 24 54 – 82 108 – 186 12 – 18 20 – 28 78 – 132 168 – 268 12 – 18 26 – 36 20 – 32 Approximate Total 160 – 256 214 – 342 304 – 486 Task

Web. Sphere Commerce Analyzer (WCA) n Entry version – Included with of Web. Sphere Commerce Suite (WCS), Pro V 5. 1 – WCS V 5. 1 is key component of Start Now ecommerce – Creates commerce datamart for analysis – Provides many query reports – No customizations n Advanced version – Targeted at large customers

Prerequisite Skills If you know or have… Read Enablement Kit Program Manual and online helps; review tool and product tutorials; pass Specialty Test You can… n. Implement Scenarios n. Implement DB 2 Universal Database n. Implement DB 2 Warehouse Manager n. Implement DB 2 OLAP Starter Kit DB 2 UDB Administration Skill n. Store, access, and protect data, also administer database Data warehouse administration n. Define processes n. Analyze and transform and distribute data n. Use warehouse agents n. Create a Star Schema n. Do reporting and maintaining data warehouse. DB 2 OLAP design and administration n. Create an OLAP cube model n. Manipulate and calculate data n. Do fast and intuitive multidimensional analysis. Reporting tool experience n. Use Reporting Tools to deliver and share the right information to the right users with the right products, right when they need it. .

Start Now BI Provides n Correct and consistent information n New information by using new methods of analyses such as query tools and OLAP. n Fast and easy access to data by all employees n Secure and reliable repository