230 likes | 256 Views
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.
E N D
Agenda • Overview of BI • Who will buy and why • Start Now BI solution • Benefit to customer
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
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
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
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
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?
Target Customer • Employees 100 to 1,000 • Company has large number of customers and/or products • Competitive market
DB 2 U NIVERSAL DATABASE Start Now Business Intelligence Solutions p-Series Scenarios x-Series Windows 2000 AIX Enablement Kit
IBM Software • IBM DB2 Universal Database Enterprise Edition Version 7.2 • Repository for data • Easy to manage • Backup and recovery functions • Security
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.
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)
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
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
Putting the Pieces Together Start Now e-commerce Start Now CRM QMF Warehouse Mgr Reports OLAP Starter Kit DB2 Datamart
Scenario Descriptions Relavis Sales Force Automation is a component of IBM Start Now CRM Solutions
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
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