SharePoint 2013 Business Intelligence (M55042) M55042

Days: 3 day
Price: $2195

Course Details

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.

Course Agenda

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

Details

Options