1 / 24

Microsoft Business Intelligence

Microsoft Business Intelligence. CONNECT, EMPOWER, OPTIMIZE The Microsoft Application Platform. Angelia Leo Group Manager – Server & Tools Microsoft Singapore. Loosely coupled Web Services architecture SOAP/XML/ESB Devices, form factors. Rich UI Connected to suppliers & customers

dandre
Download Presentation

Microsoft Business Intelligence

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. Microsoft Business Intelligence

  2. CONNECT, EMPOWER, OPTIMIZE The Microsoft Application Platform Angelia Leo Group Manager – Server & Tools Microsoft Singapore

  3. Loosely coupled Web Services architecture • SOAP/XML/ESB • Devices, form factors • Rich UI • Connected to suppliers & customers • Internet enabled • Enhanced GUI • Integrated toolsets • LOB apps connected within company • Spreadsheets • Word Processors • Standalone Apps Services Based Applications Internet Connected Applications Connected Applications • Mainframe Apps • Dumb Terminals GUI driven Applications Static-State Applications Composite/Services Based Mid 00s - . . . Monolithic Early - Mid 80s Client Server Late 80s-Mid 90s Internet Enabled Mid 90s

  4. “Application server platforms are the foundation for emerging composite applications” “Application platform suite (APS) products are integrated assemblies of three fundamental runtime technologies” “A Superplatform is a tightly integrated suite of products that provide organizations with a comprehensive platform for enterprise computing” “The platform a customer uses to design, develop, deploy and manage applications to run their business."

  5. More easily connect Heterogeneous systems Create adaptable solutions built for change Cohesive technologies that span the IT Lifecycle Thousands of ISV solutions & partners supporting the platform Enterprise scalability and industry-leading TCO Widely adopted tools & technologies Increase productivity for individuals, teams & organizations Improve resource allocation, prioritization & risk management Speed time-to-market with higher predictability

  6. Microsoft’s Promises to You

  7. Optimize Your Application Platform Near Zero Downtime Lower Costs & Risk Deep Business Insight Deliver Results Faster Faster Time to Value DeliverNew Tools Faster Simplifies Data Management & Analysis • Higher Availability & Scalability • Stronger Security • Ease of Manageability Trusted Platform • Better Insight & Deeper Analytics • Richer End User Analysis & Reporting • Stronger MS Office integration Better Decisions • Faster Application Development • Simplified Application lifecycle management • Enhanced Interoperability Faster Results

  8. Breakthrough Features in SQL Server 2005

  9. Mission Critical Data PlatformOptimizing IT for Growth Upgrading to SS2005 Challenges Needs Right Time Information I Cannot Access Data When I Need It Always On, Always Available My Data and IP Can be Lost or Stolen Secure By Default Reduced Risk My Apps are Hard to Develop and Run Unmatched Programmability Faster and More Flexible Apps I Cannot Turn Data into Actionable Insight When I Need It Faster, Better Decisions Support Deliver Better Results Faster

  10. Deliver Results Faster with Mission Critical Abilities Higher Availability & Security • 35% faster transaction processing • 5x faster failover enabling 99.999% availability • Native data encryption Greater Visibility & Deeper Analysis • Up to 2x performance increase with large OLAP dimensions • Rich End User Analysis & Reporting Enhanced Developer Productivity • Up to 40% faster development time with VS and .NET integration • New Cachesync simplifies web development “Moving to Integration Services for our enterprise ETL needs was the right decision—we were able to immediately capitalize on the team development features and rapid learning curve…” “…already seeing 70 percent faster responses with XML data types, and has found it up to 90 percent faster to create XML-based applications.” “Integrated Microsoft technology helps accelerate our solutions so we can provide more immediate, innovative service to our clients.” Unmatched Performance and Low TCO

  11. SQL Server Feature Comparison – By Key Focus Areas

  12. Microsoft Business Intelligence Vision Improving organizations by providing business insights to all employees leading to better, faster, more relevant decisions • Advanced Analytics • Self Service Reporting • End-User Analysis • Business Performance Management • Operational Applications • Embedded Analytics

  13. Office SQL Analytic Applications Business Scorecarding (BSM) Portal (Office Server) End-user Tools End-user Analysis (Excel) Integrate (SSIS) Analyze (SSAS) Report (SSRS) BI Platform Data Warehouse (SQL RDBMS) Integrated Offering

  14. Analytic Applications Business Scorecarding (BSM) Portal (Office Server) End-user Tools Integrate (ETL) Analyze (OLAP and Data Mining) Report (Reports and Notifications) Analyze (Excel) Collaborate (BI Portal) Manage (KPIs, Scorecard) End-user Analysis (Excel) Integrate (SSIS) Analyze (SSAS) Report (SSRS) BI Platform Data Warehouse (SQL RDBMS) Microsoft BI Offering

  15. Selected SQL 2005 Upgrade Customers 2.5 TB retail BI/DW, end-to-end BI: OLAP, RS, IS running on SQL Server 2005 200GB DB for German paper manufacturer, upgrading 10 servers to SS2005, 400 total users 260+ concurrent SQL Server 2005 BI platform for financial: AS, UDM, RS, IS and DM in ETL. SharePoint Portal Server to host Re-architected business critical Sports Database application using .NET and VS 2005, deployed SS2005 IS and RS Market Data Dissemination System with 5000 Tx/sec and over 100K queries / day

  16. SQL Server 2005 TB+ CustomersData Warehousing • 4.5 TB Retail Data Warehouse on HP Superdome • Uses SQL Server OLAP, SSIS, SSRS • 5.3 TB Credit Card DW, 5 Mil card holders • 300 power users, complex query, OLAP, SSIS, SSRS, Office BSM • 4 TB Consumer Packaged Goods (CPG) DW • 350 users, complex relational query, SSIS & SSRS • 2 TB DW, originally migrated from Informix • 300 users, complex query, OLAP & Data Mining • 2 TB of Clinical Data & growing, 50 TB storage • US Dept of Veterans Affairs, 1200+ facilities, 40+ OLAP Marts

  17. SQL Server 2005 Customers In Singapore • And Many More Singapore Customers from: • Government, Telecom, Manufacturing, Logistics, Retail and Financial Verticals

  18. Oracle: Unbreakable? 74 37 21 20 13 11 2 1 SQL Server Oracle DB Database Security Vulnerabilities 2002 2003 2004 2005 2006 Source: Company web sites, http://www.osvdb.org, http://www.secunia.com (Includes both SQL Server and MDAC)

  19. Make Enterprise Functionality & Scale Mainstream • Includes new Report Builder Application • Includes new SQL Server Integration Services • Reporting, OLAP, & Data Mining Services provided at no extra cost Provide Advanced BI at commodity prices • Free license for passive servers including backup servers and disaster recovery servers • Low cost options for ISVs to embed SQL Server technology in applications Provide Fair & Flexible Licensing Options Delivering Value & Flexibility With SQL Server 2005 Deliver Lowest Cost & Easiest to Use Database • SQL Server Express provides simple free DB • SQL Server WG provides robust database for growing businesses and smaller departments • Enable customer to take full advantage of multi-core • Fully support 64-bit in SQL Server STD & EE • Includes Advanced HA Solution • Includes new DB Partitioning Feature

  20. Introducing SQL Server 2005 Packaging & Pricing Unlimited Scale + Partitioning Adv. DB mirroring, Complete online & parallel operations, DB snapshot Advanced Analysis Tools including full OLAP & Data Mining Customized & High Scale Reporting Adv SSIS 2 CPU 3 GB RAM Management Studio Import/Export Limited Replication Publishing Back-up Log-shipping ReportingServer & ReportBuilder 4 CPU Unlimited RAM(64-bit) Database Mirroring OLAP Server Reporting Server New Integration Services Data Mining Full Replication & SSB Publishing Note: All Higher Editions include same functionality as the edition below it.Does not include Developer Edition and SQL Server Mobile Edition New for SQL Server 2005 Express Workgroup Standard Enterprise Complete data management & analysis platform for medium businesses and large departments Fully integrated data management and analysis platform for business critical enterprise applications Easiest to use & most affordable database solution for smaller departments & growing businesses Fastest way for developers to learn, build & deploy simple data driven applications 1 CPU1 GB RAM4GB DB Size Simple Management Tool ReportingServerNative Encryption Replication & SSB Client $3.9K per proc or $739 (Server + 5 users) *CAL for Workgroup does not work with other editions $6K per proc or $2,799 (Server + 10 users) $25K per proc or $13.5K (Server + 25 users) Free

More Related