SharePoint Training Courses Icon

SharePoint for Business Intelligence


3 Days
Classroom Session   |  
3 Days
Live Online

IIBA (CDU)

ASPE is an IIBA Endorsed Education Provider of business analysis training. Select Project Delivery courses offer IIBA continuing development units (CDU) in accordance with IIBA standards.

NASBA (CPE)

NASBA continuing professional education credits (CPE) assist Certified Public Accountants in reaching their continuing education requirements.

PMI (PDU)

Select courses offer Leadership (PDU-L), Strategic (PDU-S) and Technical PMI professional development units that vary according to certification. Technical PDUs are available in the following types: ACP, PBA, PfMP, PMP/PgMP, RMP, and SP.

NASBA
NASBA
25.00 CPEs
PMI
PMP/PgMP
21.00 T-PDUs

Expertise Level: Intermediate
Certification
Classroom Registration Fees
Individual:
$1995.00
Group Rate:
$1795.00
(per registrant, 2 or more)
GSA Individual:
$1456.35
Live Online Registration
Live Online:
$1995.00
Private Onsite Package

This course can be tailored to your needs for private, onsite delivery at your location.

Request a Quote for Group Onsite Pricing

Overview

This 3-day course will teach how to use SharePoint as your business intelligence platform. You'll learn how to implement solutions using the SharePoint Business Intelligence Center, Excel Services, SQL Reporting Services, Analysis Services, PerformancePoint, PowerPivot, Power View, Business Connectivity Services, and the KPI and chart web parts.

Companies today generate enormous amounts of valuable information, but often have poor reporting capabilities – inhibiting the sharing of key information. This course will teach you how to provide executives, managers and your entire staff with insights into your data through state-of-the-art business intelligence solutions built on the SharePoint platform. Business intelligence has never been more accessible and capable before! This courses teaches you everything you need to know to implement business intelligence solutions using Excel Services, SQL Reporting Services, Analysis Services, PerformancePoint, Power View, PowerPivot and other web parts and tools that are part of the SharePoint platform. Make better decisions and provide strategic information to the entire organization with the solutions you build.

This class is designed for SharePoint 2013, SharePoint 2016 and SharePoint 365 users. Labs are conducted in SharePoint 2016.

Need help with your SharePoint problems? Talk with one of our SharePoint Experts today!

Understand SharePoint full feature set of Business Intelligence Features
Learn what Excel Services provides and how to build Excel Services solutions
Integrate SQL Reporting Services with SharePoint to build dynamic reports and share information
Surface Analysis Services cubes via SharePoint BI features
Implement scorecards, dashboards, and KPIs using PerformancePoint
Understand the capabilities of PowerPivot and how to analyze data with PowerPivot
Integrate data from many different external data sources utilizing Business Connectivity Services
Implement out-of-box BI web parts such as the KPI and chart web parts
Build interactive dashboards that support filtering, reports, KPIS, scorecards, and more
Learn best practices for implementing effective, high-performing BI solutions
Upcoming Dates and Locations
Guaranteed To Run
Oct 30, 2017 – Nov 1, 2017    8:30am – 4:30pm San Francisco, California

Learn IT
33 New Montgomery St.
Suite 300
San Francisco, CA 94105
United States

Register
Oct 30, 2017 – Nov 1, 2017    11:30am – 7:30pm Live Online Register
Nov 28, 2017 – Nov 30, 2017    8:30am – 4:30pm Madison, Wisconsin

Hyatt Place Madison Downtown
333 West Washington Ave
Madison, WI 53703
United States

Register
Nov 28, 2017 – Nov 30, 2017    9:30am – 5:30pm Live Online Register
Dec 18, 2017 – Dec 20, 2017    8:30am – 4:30pm Saint Louis, Missouri

Please call ASPE for location details
at 1-877-800-5221
Saint Louis, MO 63101
United States

Register
Dec 18, 2017 – Dec 20, 2017    9:30am – 5:30pm Live Online Register
Course Outline

1. What is Business Intelligence

  • What Is Business Intelligence
    • Who is your Audience?
    • Where is your Data?
    • How Do I Present My Data?
  • What's New in Business Intelligence
  • Server Requirements
  • Licensing Options and Requirements

2. The Business Intelligence Center

  • Understanding the SharePoint Hierarchy
  • Purpose and Functionality of the Business Intelligence Center
  • Overview of BI Option in SharePoint
    • SSRS
    • Power View
    • KPI and Chart Web Parts
    • Excel Services
    • PowerPivot
    • Visio Services
    • PerformancePoint
    • Business Connectivity Services
  • Data Security Overview
    • Managed Accounts
    • Unattended Service Account
    • Office Authentication Options

3. SQL Reporting Services

  • Introduction to SQL Reporting Services
  • SSRS Integration with SharePoint
  • Developing Reports with Report Builder
    • Defining Data Sources and Data Sets
    • Report Design: Basics
    • Report Design: Adding Interactivity and Parameters
  • Deploying and Managing Reports
    • Administering Reporting Services
    • Report Caching and Execution
    • Managing Snapshots and Report History
    • Utilizing SharePoint SSRS Web Part

4. Power View

  • Introduction to Power View
  • Power View Designer and Components
  • Filtering, Highlighting and Slicers

5. KPI web part, Filter web part & Chart web part

  • Key Performance Indicators
  • Charts
  • Filters

6. Excel Services

  • Introduction to Excel Services
  • Developing Excel Services Reports
    • Data Sources
    • Displaying Data
  • Deploying Excel Services Reports
  • Administer Excel Services
    • Creating an Excel Services Application
    • Enabling Excel Services
    • Configuring Excel Services

7. PowerPivot

  • Introduction to PowerPivot
  • Creating a PowerPivot Gallery
  • Developing a PowerPivot Report
  • Enabling and Configuring Data Refreshes

8. Visio Services

  • Introduction to Visio Services
  • Developing Visio Services Diagrams
  • Deploying Visio Services Diagrams
  • Administer Visio Services
    • Creating a Visio Services Application
    • Enabling Visio Services
    • Configuring Security, Reporting, and Caching

9. PerformancePoint Services

  • Introduction to PerformancePoint
  • Developing Analytics Reports
  • Developing Scorecards
  • Developing Dashboards
  • Administer PerformancePoint Services
    • Enabling PerformancePoint Services
    • Configuring Security, Reporting, and Caching Options

10. Business Connectivity Services

  • Introduction to Business Connectivity Services
  • Configuring External Data Connections with SharePoint Designer
  • Administer Business Connectivity Services

11. Summary

  • Choosing the Right Tool for the Job


 

Hands-On Exercises:

Exercise 1: The Business Intelligence Center

  • Configure a Business Intelligence Center
  • Creating SharePoint Pages and using Web Parts

Exercise 2: SQL Reporting Services

  • Developing Reports with Report Builder
  • Build Interactive Dashboard with SSRS and SharePoint

Exercise 3: Power View

  • Creating basic Power View Reports
  • Analyzing Data with Power View

Exercise 4: KPI web part, Filter web part & Chart web part

  • Filtering SSRS Dashboards with Filter Web Parts
  • Displaying a KPI Status List in SharePoint
  • Using the Chart Web Part

Exercise 5: Excel Services

  • Sales Dashboard using Excel and Excel Services
  • PowerPivot
  • Creating a PowerPivot Report
  • Visio Services
  • Creating a Visio Diagram utilizing Visio Services

Exercise 6: PerformancePoint Services

  • Develop PerformancePoint Reports, Scorecards, and Dashboards

Exercise 7: Business Connectivity Services

  • Integrating external database data into SharePoint
Who should attend

Basic understanding of the SharePoint user interface and a basic understanding of database reporting tools. This course will benefit:

  • Analysts
  • Database Administrators
  • Project Managers
  • Senior Business Intelligence Architects and Consultants
  • Senior Business Analysts
  • SharePoint Developers and Administrators
  • Anyone responsible for implementing BI with SharePoint
Bonus Materials

The SharePoint Institute is an organization dedicated to the advancement of SharePoint professionals through real-world business application certificates. This course has been reviewed and approved by the SharePoint Institute as an approved training course for the SharePoint Business Intelligence Certificate. Attendees will have the opportunity to take the SharePoint Business Intelligence Assessment at the end of class, however, the exam is not required for completion of ASPE's training course.

This class is for SharePoint 2013, 2016, and Office 365 Users.

Yes, this course looks perfect for my needs!

Download the brochure