Visio Map Point MS Data Analyzer Business Scorecard

Visio

Map. Point

MS Data Analyzer

Продукты и технологии Приложения Business Scorecard Manager 2005 Excel Add-on for OLAP Reporting BI Portal … Excel 2003 Visio 2003 Project 2003 Data Analyzer OWC, Map. Point Share. Point Portal Server 2003 Project Server 2003 Reporting Services Платформа и технологии MBS BI Visual Studio. Net Analysis Services OLAP & Data Mining Management Tools Windows Server Windows клиент Microsoft Office System

Рынок OLAP 2004 (provisional) 2003 2002 2001 2000 Vendor Market position Share (%) Market position Share (%) Microsoft 1 27. 4% 1 26. 1% 1 24. 4 % 2 21. 1% 3 11. 5% Hyperion Solutions (incl Brio) 2 20. 7% 2 21. 9% 2 23. 3 % 1 24. 0% 1 27. 4% Cognos (incl Adaytum) 3 14. 1% 3 14. 2% 3 14. 7 % 3 13. 7% 2 13. 5% Business Objects (incl Crystal) 4 7. 2% 4 7. 7% 4 7. 4% 4 7. 6% 6 7. 4% Micro. Strategy 5 7. 1% 5 6. 2% 5 5. 4% 6 6. 8% 5 9. 1% SAP 6 6. 0% 6 5. 8% 6 5. 2% 7 5. 4% 8 2. 9% Oracle 7 3. 7% 7 4. 0% 7 4. 7% 5 7. 0% 4 9. 9% Applix 8 3. 1% 9 3. 0% 8 2. 6% 8 2. 5% 7 3. 0% Cartesis 9 3. 1% 8 3. 1% 9 2. 6% 9 2. 4% 11 2. 2% Systems Union/MIS AG 10 3. 0% 12 2. 1% 11 2. 1% 12 2. 1% Geac 11 1. 9% 11 2. 0% 10 2. 2% 10 2. 3% 10 2. 5% SAS Institute 12 0. 9% 13 1. 1% 13 1. 2% 13 1. 6% Источник: http: //www. olapreport. com/Market. htm

Рынок OLAP 2003 2002 2001 2000 Vendor Market positio n Share (%) Market position Share (%) Microsoft 1 26. 1% 1 24. 4% 2 21. 1% 3 11. 5% Hyperion Solutions (incl Brio) 2 21. 9% 2 23. 3% 1 24. 0% 1 27. 4% Cognos (incl Adaytum) 3 14. 2% 3 14. 7% 3 13. 7% 2 13. 5% Business Objects (incl Crystal) 4 7. 7% 4 7. 4% 4 7. 6% 6 7. 4% Micro. Strategy 5 6. 2% 5 5. 4% 6 6. 8% 5 9. 1% SAP 6 5. 8% 6 5. 2% 7 5. 4% 8 2. 9% Oracle 7 4. 0% 7 4. 7% 5 7. 0% 4 9. 9% Cartesis 8 3. 1% 9 2. 6% 9 2. 4% 11 2. 2% Applix 9 3. 0% 8 2. 6% 8 2. 5% 7 3. 0% MIS AG 10 3. 0% 12 2. 1% 11 2. 1% 12 2. 1% Geac 11 2. 0% 10 2. 2% 10 2. 3% 10 2. 5% SAS Institute 12 0. 9% Источник: http: //www. olapreport. com. /Market. htm 13 1. 1% 13 1. 2% 13 1

Спасибо! Вопросы? © 2004 Microsoft Corporation. All rights reserved. This presentation is for informational

Royal Bank of Scotland Credit Card Technical Profile Scenario/Business • Top Global Bank based in UK, 2 nd in Europe, 5 th Worldwide • – 125 K employees, 2300 branches in UK, bought Nat. West (UK) & Citizens Bank (USA) – 200 -400% performance improvement over prior system – – Uses snap data replication at SAN level to clone 3 TB reporting environment 60 business analysts work on system, 15 -20 concurrent queries – ETL: BCP loads, T-SQL transforms, 20 files daily, growth 200 GB /month – – 12 cubes, largest has 106 measures, 22 dimensions Largest dimensions in the 20 K to 60 K members 16 K-18 K OLAP queries per month, 98% handled within 10 seconds Front-ends: many: MS Office, SAS, SPSS, Panorama – – Multiple HP Proliant DL 730 8 -ways, 3 GHz, RAM: 8 -16 GB 17 TB+ storage on HP EVA infrastructure Credit Card DW system, 11 million card holders tracked Workload/Architecture • Several TB+ SQL Server instances • 9 TB Relational Query: • 3 TB Loading and Reporting Instance • Many OLAP cubes, primarily for KPIs, on two separate servers DB Platform • Windows Server 2003 http: //www. microsoft. com/resources/casestudies/Case. Study. asp? Case. Study. ID=12817

ASB Bank FOCIS DW Technical Profile Scenario/Business • Third-largest Bank in New Zealand (3600 employees, 130 branches) • FOCIS DW (Friendly One-on-one Customer Information System) – App is deployed at most business units throughout the bank – ACL (Automated Customer List) application is web-based front end • Over 1000 users access ACL • Bank runs business on SQL Server, customer since pre 7. 0 days Workload/Architecture • 1 TB single SQL Server 2000 instance for customer data • – One billion rows of core data, growing at 40 GB per month. • 30% growth rate per annum – Ad hoc query workload – Data processed (monthly average): 1 million customers, 2. 8 million accounts, 50 million transactions. • Both daily and monthly snapshots are provided to users. Data from 24 sources is aggregated – Monthly load cycle • Extensive use of SQL Server Reporting Services DB Platform • Windows Server 2000 http: //www. microsoft. com/resources/casestudies/Case. Study. asp? Case. Study. ID=11642

Safeco Insurance DW Technical Profile Scenario/Business • Top Ten Auto & Home insurer • Migrated from Informix • Added significantly more data – In production since late summer 2004 Workload/Architecture • Terabyte-scale relational data store Personal Insurance product lines – Used by group of 25 actuaries – Power users issuing massive, complex, ad-hoc relational queries – Typical queries are expected to run for many hours, evaluating detailed premium and loss experience • Populates OLAP cubes with aggregate data used by Product Management • Currently migrating Business product line DW – More users, more queries submitted with MS Access interface – Designing with workload queuing built-in DB Platform • Windows Server 2003, 64 -bit – 64 -Bit Unisys, 8 CPU partition with 32 GB of memory, HDS SAN http: //www. microsoft. com/resources/casestudies/Case. Study. asp? Case. Study. ID=13514

Raymond James Enterprise DW Technical Profile Scenario/Business • Top Financial Services Retailer in the US – 2, 200+ branches, 5, 100+ financial advisors world-wide – 22 Bil in managed assets, 2 Bil in annual revenues • DW for self-service analytics & reporting to financial advisors – Also supports branch, division and execs with performance data – Definitive source of reporting and analysis company-wide Workload/Architecture • 1. 7 TB single-instance of SQL Server, 2900 users – To grow to 5 TB & 5100 users by YE 06 – Daily asset positions and transactions per customer account • Intense OLAP environment –. 8 TB OLAP Cube environment with 300 Proclarity analysis users – Distinct shadow dimensions used for each of the 5000+ users – OLAP UDF creates these dynamically upon login • HTTP access via WAN from outside firewall DB Platform • Windows Server 2003, 64 -Bit HP Superdome host http: //www. microsoft. com/resources/casestudies/Case. Study. asp? Case. Study. ID=14354