self-service business intelligence with sql server 2008 r2

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.