New technologies for BI and Data Warehousing – they’re cool alright,

but how do they fit together?

Amit Bansalwww.PeoplewareIndia.com

Past Present Future

SQL Server 2005SQL Server 2008SSAS (UDM), SSIS, SSRSPPSEXCELSHAREPOINT

SQL Server 2008 R2PowerPivotFastTrack & Parallel DWReport Builder 3.0VertiPaq Engine

‘Denali’VertiPaqColumn StoreCrescentBISM

Looking back

END USER TOOLS & PERFORMANCE MANAGEMENT APPS

ExcelPerformancePoint

Server

BI PLATFORM

SQL Server Reporting Services

SQL Server Analysis Services

SQL Server DBMS

SQL Server Integration Services

SharePoint Server

DELIVERY

Reports Dashboards Excel Workbooks

AnalyticViews Scorecards Plans

Looking back – BI Timeline

2005 2007 20082006

SP1

SP2

MOSSExcel 2007

2010

Now & Future

2010 2011 and beyond…

StreamInsight

SSRS & Report Builder 3.0

PowerPivot

VertiPaq

For EXCEL

For SHAREPOINT

‘DENALI’

VertiPaq

PowerPivot

SSAS

ColumnStore Index

PDW

Crescent

BISM

Fast Track & PDW - FAQ• In this slide I will talk about what is FT & PDW

technologies, MPP, etc, where to apply it, etc

PDW

StreamInsight - FAQ• In this slide I will talk about what is StreamInsight

and why is it shipped with SQL Server? And what does it have to do with BI

StreamInsight

Report Builder 3.0 - FAQ• In this slide I will talk about Report Builder 3.0

enhancements

SSRS & Report Builder 3.0

VertiPaq engine• In this slide I will talk about VertiPaq engine that

powers PowerPivot. In Denali, it will power SSAS & ColumnStore indexes

VertiPaq

ColumnStore Index• We will talk about ColumnStore Index – whatever

is public as per Eric’s whitepaper

ColumnStore Index

Project ‘Crescent’• We will talk about ‘Crescent’- whatever is public

Crescent

BI Semantic Model• We will talk about BISM - whatever is public

BISM

Bringing it all together

BI for Everyone

BI for IW (Self Service) BI for IT Pro

Summary

© 2011 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.