1 / 20

Introduction to SQL Server 2005 Analysis Services

Introduction to SQL Server 2005 Analysis Services. Melville Thomson IT Pro Evangelist. What Will We Cover?. New features of Analysis Services Unified Dimensional Model (UDM) Using Analysis Services. Helpful Experience. Experience with SQL Server Familiarity with database analytics

toyah
Download Presentation

Introduction to SQL Server 2005 Analysis Services

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. Introduction to SQL Server 2005 Analysis Services Melville Thomson IT Pro Evangelist

  2. What Will We Cover? • New features of Analysis Services • Unified Dimensional Model (UDM) • Using Analysis Services

  3. Helpful Experience • Experience with SQL Server • Familiarity with database analytics • Familiarity with database reports

  4. Agenda • Introducing Analysis Services • Providing Intelligent Data

  5. SQL Server Business Intelligence Integrate Analyze Report Data acquisition from source systems and integration Data transformation and synthesis Data enrichment with business logic; hierarchical views Data discovery through data mining Data presentation and distribution Data access for the masses

  6. Analysis Services Roadmap Breakthrough • Enter the Game • Entry-level offering • Establish industry application programming interface (API) • Generate mindshare • Focus on total cost of ownership (TCO) • Win Leadership • Feature complete • Penetrate the enterprise • Thought leadership • Market share leadership • Scale

  7. What Is Analysis Services? Analysis Services XML/A or ODBO UDM Cache Spreadsheets SQL Server Datamart BI Front Ends DW Teradata Ad Hoc Reports Rich Reports Oracle DB2 LOB Dashboards

  8. One Version of the Truth • Multiple enterprise data sources • Single business view of the data • Common business terminology • Unified data navigation experience • One version of business analytics • OLAP browser, Reporting Services, BI apps

  9. demonstration Demo • Defining a Cube • Define a Data Source • Define a Data Source View • Explore Data

  10. Agenda • Introducing Analysis Services • Providing Intelligent Data

  11. Data Enrichment and Analytics • Advanced business logic, rules, and calculations • Key performance indicators • Data mining and predictive analytics • What-if modeling

  12. demonstration Demo • Refining an Analysis Cube • Provide Localized Metadata • Use Perspectives • Use Key Performance Indicators

  13. Real-Time and High Performance Real-time data access Isolate back-end sources Accelerated response time

  14. Mission Critical Reliable and available Scalable Designed for 7/24/365 Secure by design Manageable

  15. Common Bet on Analysis Services Analysis Services XML/A or ODBO UDM Cache SQL Server™ Datamart DW Teradata Oracle DB2 LOB

  16. Benefits of UDM • Rich, easily understood model • Supported by BI applications • Powerful calculation engine • Heterogeneous data sources • Interactive query performance over large data volumes

  17. Uses of Relational-Based Reporting Exploit database-level objects Queries outside model Very real time Full text search

  18. Session Summary • A watershed Analysis Services release • Advances in functionality, scalability, manageability, and integration • UDM is a breakthrough technology at the heart of the SQL Server BI architecture

  19. What else does TechNet give you? • FREE TechNet Newsletter” • FREE Events and Webcasts • FREE quarterly “TechNet” magazine • FREE comprehensive technical website • FREE TechNet Radio, Security Centre, Learning Paths and Virtual Labs • TechNet Plus Subscription DVD A range of tools and resources for IT professionals that let you plan, manage ,deploy To subscribe to the newsletter or just to find out more, please visit www.microsoft.com/uk/technet

  20. Thank you for attending this TechNet Event http://www.microsoft.com/uk/technet PS (The evaluation form is now sent out electronically with your thank you e-mail. This can take up to 5 working days. Please do feedback as we read all the comments and use them to shape future event content)

More Related