1 / 16

Deliver Rich Analytics with Analysis Services SQL Server

Deliver Rich Analytics with Analysis Services SQL Server. Donald Farmer Group Program Manager Microsoft Corporation. Agenda. Analysis Services Overview and What’s new Demo Data Mining Demo Managing and Deploying Analysis Services Scalability, Availability, Serviceability, Manageability

kaipo
Download Presentation

Deliver Rich Analytics with Analysis Services SQL Server

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. Deliver Rich Analytics with Analysis Services SQL Server Donald Farmer Group Program Manager Microsoft Corporation

  2. Agenda • Analysis Services Overview and What’s new • Demo • Data Mining • Demo • Managing and Deploying Analysis Services • Scalability, Availability, Serviceability, Manageability • Summary

  3. Analysis ServicesWhy OLAP and Data Mining Matter • Powerful business information modeling • Cross platform data integration • Integrated Relational & OLAP views • The best of MOLAP to ROLAP • Data enrichment and advanced analytics • Key Performance Indicators and Perspectives • Real-time, high performance • Real-time data in OLAP Cubes • Very fast and flexible analytics • XML standards for Data Access and Web Services integration • Cost and time savings for customers integrating with other systems

  4. What Is SQL Server 2005 Analysis Services? Analysis Services Spreadsheets SQL Server Datamart • Data enrichment and advanced analytics • Real-time and high performance • Mission critical BI Front Ends DW Teradata Ad Hoc Reports Rich Reports Oracle DB2 LOB Dashboards

  5. UDM XML/A or ODBO Analysis ServicesHigh-level Architecture Analysis Services Spreadsheets SQL Server Datamart BI Front Ends DW Teradata Ad Hoc Reports Rich Reports Oracle DB2 LOB Cache Dashboards

  6. Business Intelligence Enhancements Auto generation of time and other dimensions based on type KPIs, MDX scripts, translations, currency… Data Mining 10 Mining Algorithms Smart applications XML standards for Data Access & Web services integration $$ saving for customers integrating our solution with other systems Unified Dimensional Model Powerful business information modeling Cross platform data integration Integrated Relational & OLAP views KPIs & Perspectives Proactive caching Real-time data in OLAP Cubes Very fast and flexible analytics SQL Server Analysis ServicesNew Paradigm for the Analytics Platform

  7. The Unified Dimensional Model

  8. 8 new algorithms, 10 in total Graphical tools/wizards 12 embeddable viewers SQL Server 2005 makes it easier Tightly integrated with AS, DTS, Reporting Integration with Web/Office apps Business Knowledge Relative New Business Insight Data Mining OLAP Reports (Ad Hoc) Reports (Static) Easy Difficult Usability Value of Data Mining SQL Server 2005

  9. Decision Trees Clustering Naïve Bayes Time Series Sequence Clustering Neural Net Association Logistic Regression Complete Set of Algorithms Introduced in SQL Server 2000 Linear Regression Text Mining

  10. Mining for Meaning

  11. Production Prod Server Prod Server Prod Server BI App lifecycle Dev/Test • Deploy • Inspect • Automate: • data updates • permission updates • Monitor • Version Design Develop DebugBuild Deploy Version BI Dev Studio Management Studio Dev Server Test Server

  12. Scalability • Fully centralized calculations on the server • No calculations done on client • No excess data transported to the client • Cached calculation • Ability to cache calculation on disk • Disk based dimension storage • Dimension size is not constrained by memory limits • 150 million members already tested • Role playing dimensions remove need for duplicating dimension storage • Attribute-based hierarchies • Remove need for duplicate info among hierarchies sharing common attributes

  13. Availability • Failover Clustering • Multi-Instances • Very easy deployment – no registry entries needed • Server Synching • Designed for dual machines configurations – number cruncher machine and end-user facing machine • Allow: • Processing the calculations isolated from user interactions • Isolated verification of the results • Incremental and transactional synching of the query machine with the new results • Enhanced backup and restore • Unlimited partition sizes

  14. Serviceability • Trace events (with Profiler Integration) • Flight recorder (repro-less diagnostics) • Records server activity and metrics at all times • Provides diagnostics in the event of system failure • Allows replay of a failure condition • ON by default • Capture and Replay • Customers use to diagnose performance • Provides PSS a simple means to repro problems • Test exploit in Labs • Dr Watson

  15. Manageability • Integrated management experience with SQL Server • Single management shell • SQL profiler support • Query analyzer support • Strong integration with IS (DTS) for management tasks automation • Deployment packages to manage system life cycle • Dev → Test → Production • Source control integration for system versioning • Team development facilities • Fine grain administration roles • Database level administration • Permissions: Creation, R/O, Processing • XML-based DDL for easy scripting • Auto referential integrity handling for dealing with dirty input data

  16. Summary • Large investment in abilities in SSAS: • Manageability • Supportability • Security • Availability • Unified tools with SQL Server • SQL DBAs skill set can be applied to administering Analysis Server • BI platform for 24/7 operations

More Related