1 / 14

Overview of SQL Server 2005 Business Intelligence

Overview of SQL Server 2005 Business Intelligence. Introduction to the UDM. 15 February, 2005. Peter Myers – Tenix Connections. Senior Consultant, Trainer BBus, MCSD, MCDBA, MCSE, MCT Microsoft Gold Certified Partner

galya
Download Presentation

Overview of SQL Server 2005 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. Overview of SQL Server 2005 Business Intelligence Introduction to the UDM 15 February, 2005

  2. Peter Myers – Tenix Connections • Senior Consultant, Trainer • BBus, MCSD, MCDBA, MCSE, MCT • Microsoft Gold Certified Partner • Almost all staff certified with a degree in computing and MCSE or MCDBA or MCSD or multiples of above, and average over 10 years in all phases of the software development life cycle • Tenix Connections develops custom solutions in all aspects of the MS DW and BI toolsets and conducts training in the same at a variety of businesses peter@custombizsolutions.com

  3. The Problem “I need to know how many widgets we sold in Victoria by sales rep and by customer for YTD December 2003” - The Manager

  4. Basic BI Concepts Source Systems Staging Systems Data Warehouse Data Mart Cubes UI Tools

  5. BI Core Processes • Integration • Analysis • Reporting Services Services Services SQL Server 2005 is anend-to-end BI platform

  6. Top 10 BI Features • Analysis Services • Integration Services • Data Mining • Reporting Services • Clustering Support

  7. Top 10 BI Features (cont) • Key Performance Indicators • Scalability and Performance • One-Click Cube • Proactive Caching • Integration with the Microsoft Office System

  8. The UDM UDM = Universal Dimensional Model Universal Dimensional Model = Cube Cube = Universal Dimensional Model It provides access to the company’s data

  9. The UDM is a Bridge

  10. UDM Features • Combines relational and OLAP perspectives • Delivers a single end-user query model • Provides high performance queries supporting interactive analysis • Incorporates business rules • Supports ‘closing the loop’

  11. Demonstration • Building an Analysis Services cube • Creating a Report from the cube

  12. Does the UDM replace current DW practices? Possibly…

  13. Training Opportunities • Zero to BI in Two Intense Days for SQL Server 2000 • What’s New in Microsoft SQL Server 2005 Business Intelligence in Two Intense Days31 March – 1 April14 – 15 Aprilhttp://www.microsoft.com/australia/events/sql2005

  14. Additional Resources • www.microsoft.com/sql/2005 • SQL Server 2005 Beta 2 Resource Kit • White Paper: “Introduction to the Unified Dimensional Model (UDM)” by Paul Saunders, July 2004

More Related