self-service business intelligence with sql server 2008 r2
DESCRIPTION
This the PowerPoint presentation used for my session at Microsoft Momentum 2009 which took place in November 26, 2009 in Nicosia Cyprus. The session was about the new features in SQL Server 2008 R2 and more specifically on SQL Server PowerPivot for Excel 2010.TRANSCRIPT
What's new in SQL Server 2008 R2
Why Business Intelligence
Traditional Business Intelligence
Introducing SQL Server PowerPivot
The PowerPivot Client Architecture
Working With SQL Server PowerPivot for Excel
Summary
Database Engine - Manageability Enhancements
Connectivity to SQL Azure
Data-tier Application Upgrade
SQL Server Utility
Network Connectivity
Service Broker
Master Data Services
StreamInsight
Reporting Services SharePoint integration
Shared datasets and cache refresh plans
New data visualization report items
Enhancements to Reporting Services features
Business Intelligence Development Studio support for SQL Server 2008 reports and Report Server projects
New Web Service endpoint
Analysis Services PowerPivot for Excel
PowerPivot for SharePoint
Raw vs. Processed Data Organizations keep collecting business data
Raw data is just data
Processed data = Knowledge
Business Intelligence (BI) Methodology for transforming raw data into knowledge
Examples of people doing BI
Production managers
Engineers
Accountants
Sales managers
Data Warehouses
Cubes
Dimensions
Multidimensional Expressions (MDX)
Shortcomings
Advanced technical knowledge
Higher cost to solution
Solutions are hard to customize
Increased cost of ownership and friction
An Add-on for Excel 2010 / SharePoint 2010
Brings the full power of SQL Server Analysis Services right into Excel
In-memory column based compression
Millions of rows of data can now be stored, sorted & aggregated
Support for a wide variety of sources
Rich set of mathematical functionally
Existing functions already in Excel
+
Data Analysis eXpressions (DAX)
An Add-on for Excel 2010 / SharePoint 2010
Designed for Business Users
Brings the full power of SQL Server Analysis Services right into Excel
Vertipaq: In-Memory Column-based Compression
No Disk I/O Utilization
Data Stored in the Excel Workbooks
Support for Virtually any Source
SQL Server PowerPivot: The Future in BI
http://blogs.msdn.com/powerpivot/
http://powerpivotpro.com/
http://blogs.technet.com/dataplatforminsider/default.aspx
http://www.powerpivot.com/
http://www.powerpivot-info.com/
www.microsoft.com/sqlserver/2008/en/us/r2.aspx
http://social.msdn.microsoft.com/Forums/en-US/sqlkjpowerpivotforexcel/threads
http://www.ssas-info.com/forum/viewforum.php?f=9
https://cmg.vlabcenter.com/default.aspx?moduleid=ad3bd3e9-8d2b-498d-94fa-e41e1b09730d
Demo 1
Using Copy-Paste
Demo 2
Using Excel as a Data Source
Demo 3
Using RSS Feeds
Demo 4
Using SQL Server and Millions of Records
Demo 5
Mashing-up Various Data Sources
© 2009 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.
The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation.
MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.