SharePoint 2013 Business Intelligence



In this course, you will learn the new SharePoint 2013 Business Intelligence platform and how its associated services—PerformancePoint, Excel, Business Connectivity Services (BCS), and Visio—can assist you in designing, developing, and maintaining SharePoint 2013 Business Intelligence solutions.


  • Power users of SharePoint 2013 Business Intelligence solutions
  • Business Intelligence developers and IT professionals who design, develop, and maintain SharePoint 2013 Business Intelligence solutions


Knowledge and familiarity of SharePoint 2013 from a business intelligence point of view

Learning Objectives

  • Browse data using SQL Server Management Studio and Visual Studio 2013
  • Settings and options within the SharePoint 2013 Central Administration
  • Create a new web application and business intelligence site
  • Create a SharePoint library containing Excel workbooks, explore trusted site locations
  • Excel Web Access and how to add Web Apps to a webpage
  • Overview of the new features of PerformancePoint 2013
  • Explore the Dashboard Designer interface to create and configure a data source
  • Create and configure a standard and leaf key performance indicator (KPI) along with a scorecard for each
  • Create and configure analytic charts and grids
  • Create and filter a time intelligence data connection
  • Create, configure, and deploy the objective scorecard
  • Overview of the new 2013 Visio Services features including data connected drawings and viewing drawings within a browser
  • PowerPivot add-in new 2013 features and the relationship with Excel and SharePoint
  • Create and configure in SharePoint 2013 BCS
  • Create and configure the different content types of SharePoint 2013
  • Dashboards and how to connect SharePoint Web Apps

1. The Business Intelligence Stack

  • SQL 2012 Business Intelligence
  • New features of SharePoint 2013 Business Intelligence and PowerPivot 2013 in Excel

2. SharePoint 2013 Business Intelligence Center

  • SharePoint 2013 Central Administration
  • Permissions, roles, document library, and list apps

3. SharePoint 2013 Excel Services

  • Excel Web Access and Web Apps
  • SharePoint Library Workbooks storage
  • Power View add-in for Excel

4. SharePoint 2013 PerformancePoint 2013

  • Dashboard Designer
  • Create and configure KPIs, visual reports, filters, and scorecards

5. SharePoint 2013 Visio Services

  • Visio drawing in the browser
  • Visio Web Access web part
  • Visio drawings with data connections

6. PowerPivot 2013 Add-in

  • PowerPivot and Excel, SharePoint
  • PowerPivot and SharePoint
  • Enterprise Business Intelligence and PowerPivot

7. SharePoint 2013 Business Connectivity Services (BCS)

  • BCS terminology and security
  • BCS and SharePoint Designer 2013

8. Dashboard Monitoring, Analyzing, and Managing

  • Types of dashboards
  • Dashboard migrations
  • Tables, graphs, and charts
  • KPI
  • Microsoft Report Builder 3.0
  • Datasets
  • SharePoint Web Apps