1 / 23

Self Service BI:

21 st November 2009. Project Gemini. PowerPivot. Self Service BI: . Bob Duffy Database Architect Prodata SQL Centre of Excellence. Speaker Profile – Bob Duffy. SQL Server MVP MCA for SQL Server (aka SQL Ranger) MCM on SQL 2005 and 2008 18 years in database sector, 250+ projects

devika
Download Presentation

Self Service BI:

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. 21st November 2009 • Project Gemini • PowerPivot Self Service BI: Bob Duffy Database Architect Prodata SQL Centre of Excellence

  2. Speaker Profile – Bob Duffy • SQL Server MVP • MCA for SQL Server (aka SQL Ranger) • MCM on SQL 2005 and 2008 • 18 years in database sector, 250+ projects • Senior Consultant with Microsoft 2005-2008 • Regular speaker for TechNet, MSDN, Users Groups, Irish and UK Technology Conferences • On MCM 2008 exam working group • Database Architect at Prodata SQL Centre Excellence, Dublin

  3. Why Self Service BI What is PowerPivot? PowerPivot for Excel PowerPivot for SharePoint Agenda

  4. The BI road so far 2005/8

  5. “Trad” 2005/8 BI Architecture

  6. Problems with Traditional BI ?

  7. “We don’t know what is OLAP and dimensional modeling and we don’t care to know. Even relational modeling is a bit too hard.” “Don’t ask us to design or model anything in advance. We should just be able to load our data in and work. Exactly as do in Excel.” “It has to stay in Excel. We just won’t use another tool.” Can we compare the data to competitors data ? Can we analyze this data by tomorrow ? #1 The Business User

  8. #2 The IT Perspective on using Excel “Spreadmarts” “Rouge Applications” “Data locked in Excel sheets” “Unsanctioned Information” “Stale Data” “Unsecure” “Multiple Versions of the Truth” “Ban Excel!” Arrrggg… #%^$%

  9. Gemini Goals – Match Conflicting Twins… Simple and Smart Tool Business IT Scalable and robust Infrastructure PowerPivot

  10. What is PowerPivot?

  11. PowerPivot for Excel…LoadingFilteringMashups

  12. Introducing DAX • Expression Language based on Excel Syntax • Essential for Calculated Columns and Measures • Converted to MDX by PowerPivot AddIn • Example Functions: • RELATED(), RELATEDTABLE() • Filter(Table, Condition) • Distinct(Column) • Concatenation “&” • Notes: • Works on Columns NOT Rows • Consider “home” sheet carefully

  13. Using DAX:Profit AnalysisTemperature Mashup

  14. Wheres the data?

  15. Sits under Excel Web Access (EWA) Installation Gotchas Read the guides (on blogs) Needs Domain Accounts Easier with “new” farm Use Windows 2008 x64sp2 (patch for R2 released) Uses lots of RAM Limit of 2GB size (blob) Needs Enterprise Edition PowerPivot for SharePoint

  16. PowerPivot for SharePoint

  17. What is PowerPivot?

  18. Step 1 Monitoring Sandboxes

  19. Step 2 Monitoring Servers

  20. Step 3 Monitoring a Solution

  21. Summary • Excel is user tool of choice • Balance between • User Power • IT Management • Bridges the Organizational Divide • Gemini is a part of the MS BI stack • Enables the Self-Service scenario • Enhances existing investments • CTP3 Available now • Ship next year

  22. References/Blogs • Official Blog/Site • http://blogs.msdn.com/powerpivot/ • http://www.powerpivot.com/ • Analysis Services Team Blogs • http://powerpivotgeek.com • http://powerpivottwins.com/ • http://powerpivotpro.com/ • General Site • http://www.powerpivot-info.com/ • Online PowerPivot Labs • https://cmg.vlabcenter.com/default.aspx?moduleid=ad3bd3e9-8d2b-498d-94fa-e41e1b09730d

  23. Thank You!

More Related