1 / 23

IBM Start Now Business Intelligence Solutions

This agenda provides an overview of business intelligence (BI), discussing who will benefit from BI solutions and why, and introduces the IBM Start Now BI solution. It defines terms such as data warehouse and datamart and explores the importance of data analysis techniques in improving business decisions. The agenda also highlights the motivators and inhibitors of BI implementation, addressing issues such as inconsistent data, inadequate tools, and lack of security. Furthermore, it showcases IBM's offerings, including DB2 Universal Database, DB2 Warehouse Manager, Query Management Facility (QMF) for Windows, and DB2 OLAP Starter Kit, as well as suggested hardware for Windows and AIX scenarios. The agenda concludes by demonstrating how these pieces come together in scenarios such as e-commerce, CRM, and datamart deployment, and emphasizes the benefits of Start Now BI in providing correct and consistent information, new insights, fast data access, and secure data storage.

keil
Download Presentation

IBM Start Now Business Intelligence Solutions

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. IBM Start Now Business Intelligence Solutions

  2. Agenda • Overview of BI • Who will buy and why • Start Now BI solution • Benefit to customer

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

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

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

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

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

  8. Example of BI Report

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

  10. DB 2 U NIVERSAL DATABASE Start Now Business Intelligence Solutions p-Series Scenarios x-Series Windows 2000 AIX Enablement Kit

  11. IBM Software • IBM DB2 Universal Database Enterprise Edition Version 7.2 • Repository for data • Easy to manage • Backup and recovery functions • Security

  12. IBM Software (continued) • DB2 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.

  13. IBM Software (continued) • Query Management Facility (QMF) for Windows Version 7.1 • Built for DB2, the best performing query engine • Most flexible, multi-purpose multi-user, multi-platform query and reporting tool • Cross-industry, multi-language product • Proven track record • Query tools from Brio and BusinessObjects (report example done using BusinessObjects)

  14. IBM Software (continued) • DB2 OLAP Starter Kit • Comes with DB2 UDB V 7.2 • Provides most of function provided in DB2 OLAP Server. • Multidimensional analysis Time Sales Sales Region

  15. Suggested Hardware - Windows

  16. Suggested Hardware - AIX

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

  18. Putting the Pieces Together Start Now e-commerce Start Now CRM QMF Warehouse Mgr Reports OLAP Starter Kit DB2 Datamart

  19. Scenario Descriptions Relavis Sales Force Automation is a component of IBM Start Now CRM Solutions

  20. Deployment Tasks

  21. WebSphere Commerce Analyzer (WCA) • Entry version • Included with of WebSphere Commerce Suite (WCS), Pro V5.1 • WCS V5.1 is key component of Start Now e-commerce • Creates commerce datamart for analysis • Provides many query reports • No customizations • Advanced version • Targeted at large customers

  22. Prerequisite Skills

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

More Related