190 likes | 229 Views
IBM Start Now Business Intelligence Solutions. Agenda. Why Business Intelligence Getting the Most from BI Start Now BI Solution Benefits. What Motivates Companies. Need better information to make better decisions More people need access to information Need information faster.
E N D
Agenda • Why Business Intelligence • Getting the Most from BI • Start Now BI Solution • Benefits
What Motivates Companies • Need better information to make better decisions • More people need access to information • Need information faster
Problems experienced • 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
Getting the Most from BI • 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?
Solution Components DB 2 U NIVERSAL DATABASE • Software • IBM DB2 Universal Database • Server running one of • Windows 2000 • IBM AIX • Consulting, installation, implementation, training and project management services
IBM Software DB 2 U NIVERSAL DATABASE • IBM DB2 Universal Database Enterprise Edition • Repository for data • Easy to manage • Backup and recovery functions • Security
IBM Software (continued) DB 2 U NIVERSAL DATABASE • DB2 Warehouse Manager • Extracts data from wide-variety of databases • Transforms data • Using specific transformation instructions • Into format useful for analyses • Transformations are scheduled and automatic
IBM Software (continued) DB 2 U NIVERSAL DATABASE • Query Management Facility (QMF) for Windows • Built for DB2, the best performing query engine • Easy to learn and use • Most flexible, multi-purpose multi-user, multi-platform query and reporting tool • Cross-industry, multi-language product • Proven track record
IBM Software (continued) DB 2 U NIVERSAL DATABASE • DB2 OLAP Starter Kit • Part of DB2 UDB • Performs multidimensional analysis using business dimensions
Other Tools • BusinessObjects • BrioQuery
Putting the Pieces Together Start Now e-commerce Start Now CRM Other Databases Warehouse Mgr OLAP Starter Kit DB2 QMF Data Repository Reports
Getting Started • Select area of business where improved information has the most impact • Decide what information is needed • Determine source of data • Determine the benefits of having the information Executive Assessment can help you get started
Executive Assessment • Requirements gathering • Competitive analysis • Solution definition • Return on investment
Benefits • Accurate information • Available to more people • Faster • With more detail • Secure and safe