1 / 21

Business Intelligence in SharePoint 2013

Business Intelligence in SharePoint 2013. September 9, 2014. Deliver Solutions, Deliver Careers, Deliver Results. Today’s Speaker. Elizabeth Hutson Mitchell Consultant 1 CTS ehutson@askcts.com. @ CTSHutson. http://www.linkedin.com/pub/elizabeth-hutson/15/52b/883. CTS Overview.

Download Presentation

Business Intelligence in SharePoint 2013

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. Business Intelligence in SharePoint 2013 September 9, 2014 Deliver Solutions, Deliver Careers, Deliver Results

  2. Today’s Speaker Elizabeth Hutson Mitchell Consultant 1 CTS ehutson@askcts.com @CTSHutson http://www.linkedin.com/pub/elizabeth-hutson/15/52b/883

  3. CTS Overview • Regional IT professional services firm • Established in 1993 • Six offices in the Southeast • Leveraged, local delivery • 250+ employees • 325+ clients in various industry verticals • +/- 150 projects completed per year

  4. Agenda • Why BI? • Tools Available • SP2010, SP Online Considerations • Technical Installation Guide • Demo

  5. Why BI in SharePoint 2013? Self-Service Interactive Mobile OSNeutral

  6. Tools Available • Dashboards, KPIs Charts, Scorecards, Strategy Maps • Drill down/drill through capabilities • One-click install app - Dashboard Designer PerformancePoint

  7. Tools Available • Mobile support • Requires deployed Tabular BI Semantic Model • Requires Silverlight • Limited custom branding PowerView

  8. Tools Available • External Data Connections • Get your users out of File Shares • Mac OS users can have ODBC connections in browser • Mobile Support Excel Services

  9. Tools Available • Lives in Excel / Excel Services, but must be additionally configured • Browser refresh • Scheduled data refresh • Interactive data refresh PowerPivot

  10. Tools Available • Mobile Support • Less Self-Service • Higher Data Manipulation Ability Reporting Services

  11. Tool Strengths

  12. SharePoint Online vs. On-Premises

  13. What about 2010? • Same toolset, different features • Aesthetically different • Options to upgrade/migrate

  14. Installation & Set Up Considerations

  15. How to Set Up Business Intelligence: SharePoint Basics

  16. How to Set Up Business Intelligence: PowerPivot SQL Instance

  17. PowerPivot for SP2013 Configuration Tool

  18. How to Set Up Business Intelligence: Service Application Configuration

  19. How to Set Up Business Intelligence: Site Setup

  20. Demo

  21. Questions? Elizabeth Hutson Mitchell Consultant 1 ehutson@askcts.com 615.224.0448

More Related