1 / 41

Extending Business Intelligence with SharePoint 2010

Learn about the deployment, management, and successful implementation of Business Intelligence using SharePoint 2010.

mhorsley
Download Presentation

Extending Business Intelligence with SharePoint 2010

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

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

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

  7. Let’s get a few things straight

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

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

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

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

  12. PLAYING will give you this SCOPE….

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

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

  15. Follow the Licensing Follow the Licensing Follow the Licensing Follow the Licensing Follow the Licensing Follow the Licensing Follow the Licensing

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

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

  18. Business Intelligence

  19. What is Business Intelligence ?

  20. “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?

  21. “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?

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

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

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

  25. Typical Business Intelligence Lifecycle

  26. The Need ForBusiness Intelligence BI Zen 100 Pills

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

  28. The Microsoft BI Toolset

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

  30. Choosing Right BI Tool

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

  32. DEMO

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

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

More Related