150 likes | 273 Views
New technologies for BI and Data Warehousing – they’re cool alright, but how do they fit together?. Amit Bansal www.PeoplewareIndia.com. Past Present Future. SQL Server 2005 SQL Server 2008 SSAS (UDM), SSIS, SSRS PPS EXCEL SHAREPOINT. SQL Server 2008 R2 PowerPivot
E N D
New technologies for BI and Data Warehousing – they’re cool alright, but how do they fit together? AmitBansal www.PeoplewareIndia.com
Past Present Future SQL Server 2005 SQL Server 2008 SSAS (UDM), SSIS, SSRS PPS EXCEL SHAREPOINT SQL Server 2008 R2 PowerPivot FastTrack & Parallel DW Report Builder 3.0 VertiPaq Engine ‘Denali’ VertiPaq Column Store Crescent BISM
Looking back DELIVERY COLLABORATION CONTENTMANAGEMENT SharePoint Server SEARCH Reports Dashboards Excel Workbooks Analytic Views Scorecards Plans END USER TOOLS & PERFORMANCE MANAGEMENT APPS Excel PerformancePoint Server BI PLATFORM SQL Server Reporting Services SQL Server Analysis Services SQL Server DBMS SQL Server Integration Services
Looking back – BI Timeline • SP2 • MOSS • Excel 2007 • SP1 2007 2008 2010 2005 2006
Now & Future For EXCEL For SHAREPOINT Crescent SSRS & Report Builder 3.0 ColumnStore Index PDW PowerPivot PowerPivot VertiPaq SSAS BISM StreamInsight VertiPaq ‘DENALI’ and beyond… 2010 2011
Fast Track & PDW - FAQ PDW • In this slide I will talk about what is FT & PDW technologies, MPP, etc, where to apply it, etc
StreamInsight - FAQ StreamInsight • 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
SSRS & Report Builder 3.0 Report Builder 3.0 - FAQ • In this slide I will talk about Report Builder 3.0 enhancements
VertiPaq engine VertiPaq • In this slide I will talk about VertiPaq engine that powers PowerPivot. In Denali, it will power SSAS & ColumnStore indexes
ColumnStore Index ColumnStore Index • We will talk about ColumnStore Index – whatever is public as per Eric’s whitepaper
Project ‘Crescent’ Crescent • We will talk about ‘Crescent’- whatever is public
BI Semantic Model BISM • We will talk about BISM - whatever is public
© 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.