140 likes | 287 Views
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
E N D
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 • 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
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
Basic BI Concepts Source Systems Staging Systems Data Warehouse Data Mart Cubes UI Tools
BI Core Processes • Integration • Analysis • Reporting Services Services Services SQL Server 2005 is anend-to-end BI platform
Top 10 BI Features • Analysis Services • Integration Services • Data Mining • Reporting Services • Clustering Support
Top 10 BI Features (cont) • Key Performance Indicators • Scalability and Performance • One-Click Cube • Proactive Caching • Integration with the Microsoft Office System
The UDM UDM = Universal Dimensional Model Universal Dimensional Model = Cube Cube = Universal Dimensional Model It provides access to the company’s data
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’
Demonstration • Building an Analysis Services cube • Creating a Report from the cube
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
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