Extending Business Intelligence with SharePoint 2010

1. Extending Business Intelligence with SharePoint 2010 Presented by: Michael Hinckley, MCITPJose Chinchilla, MCITP

2. Michael Hinckley Program Manager, DSM Twitter: @SharPtContender LinkedIn: http://www.linkedin.com/in/mhinckleyBlog: http://www.sharepointcontender.com Always picked last for kickball in school. Community:President, Tampa Bay SharePoint User Group Organizer, SharePoint Saturday Certifications: MCITP: Microsoft Certified Professional, SharePoint Administration 2010

3. Jose Chinchilla Sr. Business Intelligence Consultant & Data Architect Twitter: @SQLJoe LinkedIn: http://www.linkedin.com/in/josechinchillaBlog: http://www.sqljoe.com BI curious or BI savvy ? Community:President, Tampa Bay Business Intelligence Group Organizer, SQL Saturday Certifications: MCITP: Microsoft Certified Professional, SQL Server 2008 Database Administrator MCITP: Microsoft Certified Professional, Business Intelligence Developer 2008

4. Agenda • SharePoint 2010 • Overview • Deployment & Management Considerations • Edition Comparison • Business Intelligence • Overview • Succesful BI • Business Intelligence + SharePoint 2010

6. SharePoint in 20 words or less anyone? Better yet: 140 characters …and I’ll spot you # (hash marks)

7. CMS Watch ‘09 SharePoint Report IT The Business SharePoint is not a product that can or should be “turned over to business” in a tactic conspiracy between IT and business units so they don’t bother each other.

8. Let’s get a few things straight

9. NUMBER ONE No such thing as a BI/SharePoint expert. (except for these two speakers)

10. NUMBER TWO A BI/SharePoint person who does not speak to your business goals at least 80% is trouble.

12. NUMBER THREE BI/SharePoint will not just Go Viral in your organization. Content / Data on it might.

13. We are Professionals HERE!! • Playing and #SharePoint do not go hand in hand. • Proof of Concept with business goals and requirements do.

14. PLAYING will give you this SCOPE….

15. Become a data decision making organization Turn information into data. De-duplicate and then record. Its not a project. It's a strategy

16. …and architect a foundation and governance to accommodate growth. Write out your goals (business and technology)

17. Follow the Licensing Follow the Licensing Follow the Licensing Follow the Licensing Follow the Licensing Follow the Licensing Follow the Licensing

18. SharePoint 2010 – Edition Comparison http://sharepoint.microsoft.com/en-us/buy/Pages/Editions-Comparison.aspx

19. Zen and SharePoint Deployment Key is to configure to the max and customize to a minimum. This is so frustrating! Patience.Only 100 more candles to go.

20. Business Intelligence

21. What is Business Intelligence ?

22. “BI results when organizational culture, business processes and technologies are designed and implemented with the goal of improving the strategic and operational decision-making capabilities of a wide range of internal and external stakeholders.” - International Data Corporation (IDC) What Is Business Intelligence?

23. “BI results when organizational , business and are designed and implemented with the goal of the strategic and operational capabilities of a wide range of internal and external .” - International Data Corporation (IDC) culture processes technologies improving decision-making stakeholders What Is Business Intelligence?

24. Culture, processes and technologies to improve decision making for stakeholders. What Is Business Intelligence?

25. What is Business Intelligence ? What is it not ?

26. What it is… What it is not… Application Tool Department Project Report Base Archive IT Service Solution Suite Interdepartmental Team Continuous process Knowledge Base Actionable Information Business Asset What Is Business Intelligence?

27. Typical Business Intelligence Lifecycle

28. The Need ForBusiness Intelligence BI Zen 100 Pills

29. The need for Business Intelligence The complaints: • “We need information but all we have is data!”Why Companies Need Business Intelligence by Jose Allan Tans • “Need to make data manageable and actionable in a timely manner”Need for Business Intelligence Grows by Diann Daniel (CIO Magazine) “Information overload” How will BI solve it? …The Snake Oil selling points: • Surface performance & operational efficiencies and deficiencies • Reveal untapped opportunities • Data Mining • Forecasting & Trending • Democratization of the data • Decision Support System (DSS) • Dashboards & Balanced Scorecards • Key Performance Indicators (KPIs) But wait there’s more, if you call in the next 30 minutes… Self-Service BI. (No need for IT)

31. The Microsoft BI Toolset

32. What makes BI successful? Tool? Tool Features? Content!

33. Choosing Right BI Tool

35. The Business Intelligence Continuum Aligned Empowered Organizational BI Team BI Personal BI Our Context BI Solution created by power user. Context is for a small team & it’s managed on a server. My Context BI solution created by user. Context is only for user & exists as document. The Org’s Context BI Solution created by IT, Established corporate context & is reusable, scalable and backed up. PowerPivot for Excel Analysis Services Reporting Services PowerPivot for SharePoint

36. DEMO

40. SharePoint Community & Resources • Florida SharePoint User Group • www.flspug.com • SharePoint Saturday • South Florida 12/10/2011 Nova University (to be confirmed) • Tampa SharePoint User Group • 2nd Tuesday of the Month at MSFT Tampa Offices

41. Business Intelligence Community & Resources • Tampa Bay Business Intelligence User Group • 1st Monday of every month 6pm at MSFT Tampa Offices • SQL Saturday BI Edition • Kforce November 5th, 2011 • PASS Business Intelligence Virtual Chapter • http://www.sqlpass.org • Pragmatic Works Free Webinars • http://www.pragmaticworks.com