Transcript 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
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
[email protected]
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 Services
Analysis
Services
Reporting Services
SQL Server 2005 is an
end-to-end BI platform
Top 10 BI Features
1.
2.
3.
4.
5.
Analysis Services
Integration Services
Data Mining
Reporting Services
Clustering Support
Top 10 BI Features (cont)
6.
7.
8.
9.
10.
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
The UDM is a Bridge
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
Does the UDM replace
current DW practices?
Possibly…
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 Days
31 March – 1 April
14 – 15 April
http://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