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 purposes only. Microsoft makes no warranties, express or implied, in this summary.
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
- Slides: 53