Collaboration 55042-SharePoint 2013 Business Intelligence

55042-SharePoint 2013 Business Intelligence


Date of Class:


Last Day To Enroll:

1785.00 1,785.00

  • Course Delivery: Virtual Classroom

Chat Live | Contact Us | Toll Free: (888) 360-8764



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 Objectives

After completing this course, students will be able to:

  • 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

Topics Covered

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
  • Labs
  • Lab 1: The Business Intelligence Stack
  • SQL 2012 Multidimensional and Tabular Model Basics
  • Lab 2: SharePoint 2013 Central Administration and BI Center
  • Lab 3: SharePoint 2013 Excel Services
  • Create a library storage for Excel Workbooks
  • Power View add-in for Excel
  • Add an Excel Web App to a Webpage
  • Lab 4: SharePoint 2013 PerformancePoint 2013
  • KPIs, Visual Reports
  • PerformancePoint filters (cascading and time intelligence)
  • Scorecard Settings and filters
  • PerformancePoint Dashboards
  • Lab 5: SharePoint 2013 Visio Services
  • Lab 6: PowerPivot
  • Lab 7: SharePoint 2013 Business Connectivity Services (BCS)
  • Content types
  • Lab 8: Dashboards
  • Report Builder 3.0
  • Dashboard Web Apps


Before attending this course, students must have:

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

Subject Matter Expert

Productivity Point Global is led by a team of individuals with world-class experience in professional development skills and leading edge technologies. These established professionals collaborate to drive PPG's business forward through entrepreneurial innovation, strategic partnerships, brand management and sales growth.

Productivity Point Global, previously ExecuTrain of Florida, began in 2003 and evolved out of a desire to increase our outreach both nationally and internationally. Utilizing the highest standard in customer service combined with our subject matter experts and high-end training venues, PPG has carved a niche by consistently expanding our corporate and government client base, originally hosted in the southeastern region of the US.

By consistently setting quality as the benchmark of our value system, PPG combines strategic partnerships and cutting edge technology with our determined efforts to branch out into other regions. PPG's combination of technology and professional skills training, IT outsourcing, and event hosting enables us to place a focused emphasis on the diversified business needs of our clients.
For more info please visit:

Got questions? Contact us below or call 877-881-2235

Why Choose

  • Fast and easy courses completion
  • Get an education faster than at traditional colleges!
  • 100% online - No classroom attendance required.
  • Unlimited 24x7 online customer support
  • Over 500,000+ certified nationwide.