introduction to sql server 2005 analysis services melville thomson it pro evangelist
Post on 20-Dec-2015
219 views
TRANSCRIPT
![Page 1: Introduction to SQL Server 2005 Analysis Services Melville Thomson IT Pro Evangelist](https://reader031.vdocuments.us/reader031/viewer/2022032309/56649d4b5503460f94a28f1e/html5/thumbnails/1.jpg)
Introduction to SQL Server 2005 Analysis ServicesMelville Thomson
IT Pro Evangelist
![Page 2: Introduction to SQL Server 2005 Analysis Services Melville Thomson IT Pro Evangelist](https://reader031.vdocuments.us/reader031/viewer/2022032309/56649d4b5503460f94a28f1e/html5/thumbnails/2.jpg)
• New features of Analysis Services
• Unified Dimensional Model (UDM)
• Using Analysis Services
What Will We Cover?
![Page 3: Introduction to SQL Server 2005 Analysis Services Melville Thomson IT Pro Evangelist](https://reader031.vdocuments.us/reader031/viewer/2022032309/56649d4b5503460f94a28f1e/html5/thumbnails/3.jpg)
• Experience with SQL Server
• Familiarity with database analytics
• Familiarity with database reports
Helpful Experience
![Page 4: Introduction to SQL Server 2005 Analysis Services Melville Thomson IT Pro Evangelist](https://reader031.vdocuments.us/reader031/viewer/2022032309/56649d4b5503460f94a28f1e/html5/thumbnails/4.jpg)
• Introducing Analysis Services
• Providing Intelligent Data
Agenda
![Page 5: Introduction to SQL Server 2005 Analysis Services Melville Thomson IT Pro Evangelist](https://reader031.vdocuments.us/reader031/viewer/2022032309/56649d4b5503460f94a28f1e/html5/thumbnails/5.jpg)
SQL Server Business Intelligence
Data acquisition Data acquisition from source from source systems and systems and integrationintegrationData Data transformation transformation and synthesisand synthesis
Data enrichment Data enrichment with business with business logic; hierarchical logic; hierarchical viewsviewsData discovery Data discovery through data through data miningmining
Data Data presentation and presentation and distributiondistributionData access for Data access for the massesthe masses
IntegrateIntegrate AnalyzeAnalyze ReportReport
![Page 6: Introduction to SQL Server 2005 Analysis Services Melville Thomson IT Pro Evangelist](https://reader031.vdocuments.us/reader031/viewer/2022032309/56649d4b5503460f94a28f1e/html5/thumbnails/6.jpg)
Analysis Services Roadmap
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
Breakthrough
![Page 7: Introduction to SQL Server 2005 Analysis Services Melville Thomson IT Pro Evangelist](https://reader031.vdocuments.us/reader031/viewer/2022032309/56649d4b5503460f94a28f1e/html5/thumbnails/7.jpg)
What Is Analysis Services?
Dashboards
Rich Reports
BI Front Ends
Spreadsheets
Ad Hoc Reports
SQL SQL ServerServer
TeradataTeradata
OracleOracleDB2DB2 LOBLOB
DWDW
DatamartDatamart
AnalysisAnalysisServicesServices
UDMUDM
CacheCache
XM
L/A
or
OD
BO
XM
L/A
or
OD
BO
![Page 8: Introduction to SQL Server 2005 Analysis Services Melville Thomson IT Pro Evangelist](https://reader031.vdocuments.us/reader031/viewer/2022032309/56649d4b5503460f94a28f1e/html5/thumbnails/8.jpg)
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 analyticsOLAP browser, Reporting Services, BI apps
![Page 9: Introduction to SQL Server 2005 Analysis Services Melville Thomson IT Pro Evangelist](https://reader031.vdocuments.us/reader031/viewer/2022032309/56649d4b5503460f94a28f1e/html5/thumbnails/9.jpg)
Demo
Defining a Cube
Define a Data Source Define a Data Source View Explore Data
demonstration
![Page 10: Introduction to SQL Server 2005 Analysis Services Melville Thomson IT Pro Evangelist](https://reader031.vdocuments.us/reader031/viewer/2022032309/56649d4b5503460f94a28f1e/html5/thumbnails/10.jpg)
• Introducing Analysis Services
• Providing Intelligent Data
Agenda
![Page 11: Introduction to SQL Server 2005 Analysis Services Melville Thomson IT Pro Evangelist](https://reader031.vdocuments.us/reader031/viewer/2022032309/56649d4b5503460f94a28f1e/html5/thumbnails/11.jpg)
Data Enrichment and Analytics• Advanced business logic, rules, and
calculations
• Key performance indicators
• Data mining and predictive analytics
• What-if modeling
![Page 12: Introduction to SQL Server 2005 Analysis Services Melville Thomson IT Pro Evangelist](https://reader031.vdocuments.us/reader031/viewer/2022032309/56649d4b5503460f94a28f1e/html5/thumbnails/12.jpg)
Demo
Refining an Analysis Cube
Provide Localized Metadata Use Perspectives Use Key Performance Indicators
demonstration
![Page 13: Introduction to SQL Server 2005 Analysis Services Melville Thomson IT Pro Evangelist](https://reader031.vdocuments.us/reader031/viewer/2022032309/56649d4b5503460f94a28f1e/html5/thumbnails/13.jpg)
Real-Time and High Performance
Isolate back-end Isolate back-end sourcessources
Accelerated Accelerated response timeresponse time
Real-time data accessReal-time data access
![Page 14: Introduction to SQL Server 2005 Analysis Services Melville Thomson IT Pro Evangelist](https://reader031.vdocuments.us/reader031/viewer/2022032309/56649d4b5503460f94a28f1e/html5/thumbnails/14.jpg)
Mission Critical
Reliable and Reliable and availableavailable
Designed for Designed for 7/24/3657/24/365
ScalableScalable
Secure by Secure by designdesign ManageableManageable
![Page 15: Introduction to SQL Server 2005 Analysis Services Melville Thomson IT Pro Evangelist](https://reader031.vdocuments.us/reader031/viewer/2022032309/56649d4b5503460f94a28f1e/html5/thumbnails/15.jpg)
Common Bet on Analysis Services
SQL SQL ServerServer™™
TeradataTeradata
OracleOracleDB2DB2 LOBLOB
DWDW
DatamartDatamart
AnalysisAnalysisServicesServices
UDMUDM
CacheCache
XM
L/A
or
OD
BO
XM
L/A
or
OD
BO
![Page 16: Introduction to SQL Server 2005 Analysis Services Melville Thomson IT Pro Evangelist](https://reader031.vdocuments.us/reader031/viewer/2022032309/56649d4b5503460f94a28f1e/html5/thumbnails/16.jpg)
Benefits of UDM
• Rich, easily understood model
• Supported by BI applications
• Powerful calculation engine
• Heterogeneous data sources
• Interactive query performance over large data volumes
![Page 17: Introduction to SQL Server 2005 Analysis Services Melville Thomson IT Pro Evangelist](https://reader031.vdocuments.us/reader031/viewer/2022032309/56649d4b5503460f94a28f1e/html5/thumbnails/17.jpg)
Uses of Relational-Based Reporting
Queries Queries outside outside modelmodel
Full text Full text searchsearch
Very real Very real timetime
Exploit Exploit database-database-
level level objectsobjects
![Page 18: Introduction to SQL Server 2005 Analysis Services Melville Thomson IT Pro Evangelist](https://reader031.vdocuments.us/reader031/viewer/2022032309/56649d4b5503460f94a28f1e/html5/thumbnails/18.jpg)
• 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
Session Summary
![Page 19: Introduction to SQL Server 2005 Analysis Services Melville Thomson IT Pro Evangelist](https://reader031.vdocuments.us/reader031/viewer/2022032309/56649d4b5503460f94a28f1e/html5/thumbnails/19.jpg)
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
![Page 20: Introduction to SQL Server 2005 Analysis Services Melville Thomson IT Pro Evangelist](https://reader031.vdocuments.us/reader031/viewer/2022032309/56649d4b5503460f94a28f1e/html5/thumbnails/20.jpg)
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)
Thank you for attending this TechNet Event