1 / 15

New technologies for BI and Data Warehousing – they’re cool alright, but how do they fit together?

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

kalista
Download Presentation

New technologies for BI and Data Warehousing – they’re cool alright, but how do they fit together?

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. New technologies for BI and Data Warehousing – they’re cool alright, but how do they fit together? AmitBansal www.PeoplewareIndia.com

  2. 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

  3. 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

  4. Looking back – BI Timeline • SP2 • MOSS • Excel 2007 • SP1 2007 2008 2010 2005 2006

  5. 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

  6. Fast Track & PDW - FAQ PDW • In this slide I will talk about what is FT & PDW technologies, MPP, etc, where to apply it, etc

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

  8. SSRS & Report Builder 3.0 Report Builder 3.0 - FAQ • In this slide I will talk about Report Builder 3.0 enhancements

  9. VertiPaq engine VertiPaq • In this slide I will talk about VertiPaq engine that powers PowerPivot. In Denali, it will power SSAS & ColumnStore indexes

  10. ColumnStore Index ColumnStore Index • We will talk about ColumnStore Index – whatever is public as per Eric’s whitepaper

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

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

  13. Bringing it all together

  14. Summary

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

More Related