Business Intelligence in Microsoft SharePoint 2013 Course

Available: Live Online or Onsite. Private Training For Groups.

Attend Our Classes From Home - No Software Needed - Learn More...

Microsoft SharePoint TrainingBusiness Intelligence in Microsoft SharePoint 2013

by Certstaffix® Training

Length: 5 day(s)      Public Class Price: $2925/person (USD)      Group Class Price: Request Quote      Course Category: Microsoft SharePoint


Microsoft SharePoint Training
Dive into the business intelligence features in SharePoint 2013—and use the right combination of tools to deliver compelling solutions.

In this course you will learn how to take control of business intelligence (BI) with the tools offered by SharePoint 2013 and Microsoft SQL Server 2012. You’ll get step-by-step instructions for understanding how to use these technologies best in specific BI scenarios—whether you’re a SharePoint administrator, SQL Server developer, or business analyst.

This course will show you how to: Manage the entire BI lifecycle, from determining key performance indicators to building dashboards, Use web-based Microsoft Excel services and publish workbooks on a SharePoint Server, Mash up data from multiple sources and create Data Analysis Expressions (DAX) using PowerPivot, Create data-driven diagrams that provide interactive processes and context with Microsoft Visio Services, Use dashboards, scorecards, reports, and key performance indicators to monitor and analyze your business and Use SharePoint to view BI reports side by side, no matter which tools were used to produced them.
Course Description: Print It | Download PDF | Email It

  Public Classes - Live Online at Your Location or OursHow It Works

Certstaffix® Training public classes are instructor-led, live online training you attend from your home or work or in one of our local computer labs. Our live online instructors teach you from a remote location while being able to interact with students as in a traditional classroom setting.

  • A real, live instructor teaching you from another location
  • Hands-on learning with the software/skills you are being taught
  • Interaction with all students in the class at other locations
  • Any needed software for class provided in online lab environment
  • Easy assistance from the instructor

* All Public Classes are Running Live Online as Scheduled *

Click a class date below to register & view location/attendance options.
Registrations received less than 15 days before start will be provided an eBook while print book ships.

 Register ➥   June 22, 2020     

  Group Classes for Organizations - Onsite or Online How It Works

Have a group of employees needing the same training? Onsite training at your office or group live online classes are great solutions.  

  • An expert Instructor will either come to your office or deliver a private live online class to your students
  • Course can be customized to your training needs
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 4 weeks lead time to arrange a training session

  Detailed Course Topics

Course Description: Print It | Download PDF | Email It

Course Topics

Chapter 1 Business intelligence in SharePoint
Leading up to BI
Beware of losing sight of what matters most
What is BI?
Microsoft’s vision for BI and self-service BI
What SharePoint does for BI
The BI stack: SQL Server + SharePoint + Office
Examples of BI in SharePoint 2013
Creating a report by using an Odata feed from a SharePoint list

Chapter 2 Planning for business intelligence adoption
Business user communities
The progression of BI
Tool selection
An action plan for adoption: Build it and they might come

Chapter 3 The lifecycle of a business intelligence implementation
Working together: SQL Server 2012 + SharePoint 2013 + Office 2013
SQL Server 2012 features
The lifecycle of a BI implementation

Chapter 4 Using PowerPivot in Excel 2013
The Data Model
PowerPivot 2013
Calculations with DAX
Importing data from Windows Azure Marketplace
Paving the ground

Chapter 5 Using Power View in Excel 2013
Introducing Power View
What’s new in Power View
Using Power View
Creating visualizations
Filtering data
Saving a Power View workbook

Chapter 6 Business intelligence with Excel Services 2013
A brief history of Excel Services
When to use Excel Services
The Data Model in Excel Services
Configuring the server
Opening an Excel workbook in the browser
Extending Excel Services

Chapter 7 Using PowerPivot for SharePoint 2013
A brief history
When do I use PowerPivot for SharePoint?
Getting started
Publishing to SharePoint
Scheduling data refreshes
Workbooks as a data source
Monitoring with PowerPivot for SharePoint

Chapter 8 Using PerformancePoint Services
A brief history of PerformancePoint Services
An overview of PerformancePoint Services components
What’s new in PerformancePoint Services 2013
The PerformancePoint Services architecture
PerformancePoint Services configuration
Providing a performance solution

Chapter 9 Using Visio and Visio Services
Background
What’s new in Visio 2013
Six reasons to include Visio 2013 in your BI suite
When do I use Visio and Visio Services?
Incorporating Visio into a BI solution
Visio Services: Example 1
Visio Services: Example 2

Chapter 10 Bringing it all together
Dashboards
Tools in SharePoint for authoring dashboards
Which dashboard tool should I use?
Dashboard (Web Part) pages in SharePoint
Using Excel Services in the dashboard (Web Part page)
Preparing the workbook for the dashboard: adding parameters
Adding to the dashboard (Web Part page)
Course Description: Print It | Download PDF | Email It

Public Class Format

Certstaffix® Training public classes are instructor-led live online training you attend either from your home/work location or in one of our computer labs. Our live online instructors teach you from a remote location while being able to interact with you like in a traditional classroom.


Quality Instructors

Our instructors have many years of experience teaching adult learners in person and online.

Complete Lab Environment

Access to software required is provided in a lab environment during class.

Hands-on Learning

Most classes are not all lecture - you can learn by actually doing.


Small Classes

You get more attention from the instructor and classes flow more smoothly.

Post-Class Lab Access*

Access practice lab environment for 180 days after most classes*.


Low Cancellation Rate

Most classes run as scheduled.



*These courses do not have post-class lab environment access: Adobe, Salesforce, QuickBooks Online Edition, Google, HTML, WordPress, ITIL, Six Sigma, CompTIA, Project Management, SEO, Social Media.


Group Training

Have a group of employees needing the same training? Onsite training at your office or group live online classes are great solutions.

How Group Training Works





  • An expert Instructor will either come to your office or deliver a private live online class to your students
  • Course can be fully customized to your training needs
  • Each student receives a Course Manual with Practice Files (Materials provided before the class date)
  • If a course has a hands‐on lab, we provide access to the configured course software and files.
    (Requires a high‐speed internet connection and certain open ports on your firewall. You can perform a Connection Assessment Test here)
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 4 weeks lead time to arrange a training session
  • Training is completed in a convenient session(s) of your choosing
  • Two 15 minute breaks and one hour long break for lunch daily

Request a Free Quote

Business Intelligence in Microsoft SharePoint 2013 Class Reviews

Here are a sample of Microsoft SharePoint class reviews from past students that have attended our Microsoft SharePoint training courses.



Dive into the business intelligence features in SharePoint 2013—and use the right combination of tools to deliver compelling solutions.

In this course you will learn how to take control of business intelligence (BI) with the tools offered by SharePoint 2013 and Microsoft SQL Server 2012. You’ll get step-by-step instructions for understanding how to use these technologies best in specific BI scenarios—whether you’re a SharePoint administrator, SQL Server developer, or business analyst.

This course will show you how to: Manage the entire BI lifecycle, from determining key performance indicators to building dashboards, Use web-based Microsoft Excel services and publish workbooks on a SharePoint Server, Mash up data from multiple sources and create Data Analysis Expressions (DAX) using PowerPivot, Create data-driven diagrams that provide interactive processes and context with Microsoft Visio Services, Use dashboards, scorecards, reports, and key performance indicators to monitor and analyze your business and Use SharePoint to view BI reports side by side, no matter which tools were used to produced them.


Certstaffix® Class Reviews

Student Average:
4.79 out of 5 from 50 students

4.70 out of 5

Was really surprised. I was skeptical going in on the first day because I had not done an online class before, but I really feel like it was better than a classroom setting. I will definitely take an online class again.


- attended our SharePoint for End Users class

4.89 out of 5

Very well organized


- attended our SharePoint for End Users class

4.83 out of 5

This course was more elementary than my company had anticipated but overall useful. Please have a site manager course!


- attended our SharePoint for End Users class

5.00 out of 5

The instructor was extremely knowledgeable and patient. I really appreciate him answering all of my questions, and walking me through the steps to achieve the desired results.


- attended our SharePoint 2016 for End Users class

4.33 out of 5

The instructor was easy to understand and very helpful when participants had a question. Pace of the class was good for my level of understanding.


- attended our SharePoint 2013 for End Users class

4.91 out of 5

The instructor did an excellent job explaining the course material and ensuring everyone on the call was able to keep up with each slide. He was outstanding.


- attended our SharePoint for End Users class

5.00 out of 5

My instructor Ali was outstanding! He was extremely knowledgeable and very patient. And answered all of the students questions including mine.


- attended our SharePoint 2013 for End Users class

4.87 out of 5

Instructor was very professional and answered all questions that arose in a patient manner. Extremely easy to follow; highly recommended.


- attended our SharePoint for End Users class

4.94 out of 5

Instructor was very easy to follow and kept up a great pace. Easy to talk to and understood all of the questions that were presented.


- attended our SharePoint 2016 for End Users class

4.89 out of 5

I have been a Sharepoint lead for 3.5 years and didn't realize how powerful a tool it was until today. This class has been invaluable. The instructor was knowledgeable, patient, and helpful.


- attended our SharePoint for End Users class

5.00 out of 5

Ali was a fabulous instructor who made the content understandable. He was very concerned that we were all following at the same pace and paused often for questions.


- attended our SharePoint for End Users class

5.00 out of 5


- attended our SharePoint for End Users class

5.00 out of 5


- attended our SharePoint for End Users class

5.00 out of 5


- attended our SharePoint for End Users class

5.00 out of 5


- attended our SharePoint for End Users class

4.65 out of 5


- attended our SharePoint for End Users class

4.65 out of 5


- attended our SharePoint for End Users class

4.39 out of 5


- attended our SharePoint for End Users class

4.17 out of 5


- attended our SharePoint for End Users class

5.00 out of 5


- attended our SharePoint for End Users class

4.94 out of 5


- attended our SharePoint for End Users class

5.00 out of 5


- attended our SharePoint 2013 for End Users class

4.65 out of 5


- attended our SharePoint for End Users class

4.83 out of 5


- attended our SharePoint for End Users class

4.57 out of 5


- attended our SharePoint for End Users class

5.00 out of 5


- attended our SharePoint for End Users class

5.00 out of 5


- attended our SharePoint for End Users class

4.72 out of 5


- attended our SharePoint for End Users class

4.48 out of 5


- attended our SharePoint for End Users class

4.64 out of 5


- attended our SharePoint for End Users class

4.82 out of 5


- attended our SharePoint 2016 for End Users class

4.47 out of 5


- attended our SharePoint 2013 for End Users class

4.76 out of 5


- attended our SharePoint 2013 for End Users class

4.65 out of 5


- attended our SharePoint 2013 for End Users class

4.82 out of 5


- attended our SharePoint 2016 for End Users class

5.00 out of 5


- attended our SharePoint 2013 for End Users class

5.00 out of 5


- attended our SharePoint 2016 for End Users class

4.00 out of 5


- attended our SharePoint 2016 for End Users class

4.41 out of 5


- attended our SharePoint 2016 for End Users class

5.00 out of 5


- attended our SharePoint 2016 for End Users class

4.76 out of 5


- attended our SharePoint 2016 for End Users class

5.00 out of 5


- attended our SharePoint 2013 for End Users class

4.88 out of 5


- attended our SharePoint 2013 for End Users class

5.00 out of 5


- attended our SharePoint 2013 for End Users class

5.00 out of 5


- attended our SharePoint 2013 for End Users class

5.00 out of 5


- attended our SharePoint 2016 for End Users class

4.24 out of 5


- attended our SharePoint 2013 for End Users class

4.88 out of 5


- attended our SharePoint 2013 for End Users class

4.94 out of 5


- attended our SharePoint 2013 for End Users class

5.00 out of 5


- attended our SharePoint 2016 for End Users class



Please contact us if we do not yet have any reviews or you would like more.


View all Microsoft SharePoint training reviews

Microsoft SharePoint Courses By City:

AB - Calgary       FL - Sarasota       NB - Moncton       PA - Scranton-Wilkes Barre      
AB - Edmonton       FL - Tallahassee       NB - Saint John       PA - York      
AK - Anchorage       FL - Tampa       NC - Asheville       PR - Puerto Rico      
AL - Birmingham       FL - Winter Park       NC - Charlotte       QC - Montreal      
AL - Huntsville       GA - Augusta       NC - Greensboro       RI - Providence      
AL - Mobile       GA - Columbus       NC - Raleigh       SC - Greenville      
AL - Montgomery       GA - Peachtree Corners       NC - Winston-Salem       SC - Myrtle Beach      
AR - Bentonville       GA - Savannah       ND - Bismarck       SC - North Charleston      
AR - Little Rock       HI - Honolulu       ND - Fargo       SD - Sioux Falls      
AZ - Phoenix       IA - Des Moines       NE - Lincoln       SK - Regina      
AZ - Tucson       IA - Iowa City       NE - Omaha       SK - Saskatoon      
BC - Vancouver       ID - Boise       NH - Bedford       TN - Chattanooga      
CA - Bakersfield       IL - Chicago       NJ - Bridgewater       TN - Knoxville      
CA - Fresno       IL - Rockford       NM - Albuquerque       TN - Memphis      
CA - Los Angeles       IN - Bloomington       NM - Las Cruces       TN - Nashville      
CA - Merced       IN - Evansville       NM - Santa Fe       TX - Amarillo      
CA - Modesto       IN - Fort Wayne       NS - Halifax       TX - Austin      
CA - Napa       IN - Indianapolis       NV - Henderson       TX - Beaumont      
CA - Oakland       IN - South Bend       NV - Reno       TX - Corpus Christi      
CA - Oxnard       KS - Overland Park       NY - Albany       TX - Dallas      
CA - Rancho Cucamonga       KS - Topeka       NY - Buffalo       TX - El Paso      
CA - Sacramento       KY - Lexington       NY - New York City       TX - Fort Worth      
CA - Salinas       KY - Louisville       NY - Rochester       TX - Houston      
CA - San Diego       LA - Baton Rouge       NY - Syracuse       TX - Killeen      
CA - San Jose       LA - Lafayette       OH - Beaver Creek       TX - Laredo      
CA - Santa Maria       LA - New Orleans       OH - Cincinnati       TX - Longview      
CA - Santa Rosa       LA - Shreveport       OH - Cleveland Heights       TX - Lubbock      
CA - Stockton       MA - Burlington       OH - Columbus       TX - McAllen      
CB - Caribbean       MA - Springfield       OH - Toledo       TX - Midland      
CB - Kingston       MA - Westborough       OH - Youngstown       TX - San Antonio      
CB - Nassau       MB - Winnipeg       OK - Oklahoma City       TX - Tyler      
CO - Boulder       MD - Largo       OK - Tulsa       TX - Waco      
CO - Colorado Springs       MD - Laurel       ON - Ottawa       UT - Ogden      
CO - Denver       ME - Portland       ON - Toronto       UT - Salt Lake City      
CT - Cheshire       MI - Ann Arbor       OR - Beaverton       VA - Charlottesville      
CT - New Haven       MI - Flint       OR - Bend       VA - Glen Allen      
CT - Stamford       MI - Grand Rapids       OR - Eugene       VA - Harrisonburg      
DE - Wilmington       MI - Lansing       OR - Medford       VA - Roanoke      
FL - Daytona Beach       MI - Livonia       OR - Salem       VA - Virginia Beach      
FL - Fort Lauderdale       MN - Minnetonka       PA - Allentown       VT - Burlington      
FL - Fort Myers       MO - Columbia       PA - Erie       WA - Seattle      
FL - Gainesville       MO - St. Louis       PA - Harrisburg       WA - Spokane      
FL - Jacksonville       MS - Biloxi       PA - Malvern       WI - Eau Claire      
FL - Lakeland       MS - Jackson       PA - Philadelphia       WI - Green Bay      
FL - Miami       MT - Billings       PA - Pittsburgh       WI - Madison      
FL - Naples       MT - Montana       PA - Reading       WI - Milwaukee      
FL - Pensacola