• 100 Queen St W, Brampton, ON L6X 1A4, Canada
  • +1-800-961-0337
START DATE END DATE CLASS TIMINGS MODE LOCATION ACTION
10/22/2018 10/24/2018
  • VLT
Live Online
11/19/2018 11/21/2018
  • VLT
Live Online
12/17/2018 12/19/2018
  • VLT
Live Online

About the course

55057: SharePoint 2013 PerformancePoint Services three-day educator drove course gives understudies the essential learning to work with PerformancePoint 2013 Service. The as good as ever Business Intelligence Center is investigated, and all the energizing new elements inside the SharePoint 2013 discharge are secured. 

The concentrate of this course is on the SharePoint 2013 business insight stage and not on the SQL business knowledge administrations. 

PowerPivot and Dahboards have included modules

Audience Profile

55057: SharePoint 2013 PerformancePoint Services course is proposed for control clients, business knowledge engineers and IT experts that will be included with the outline, improvement and support of SharePoint 2013 business insight arrangements.

At Course Completion

In the wake of finishing this course, understudies will have the capacity to: 

  • Peruse the information inside the 3D shape utilizing SQL Server Management Studio. 
  • Peruse information utilizing Visual Studio 2013. 
  • Interface with a forbidden source, import tables, and investigate the information. 
  • Investigate the alternatives and settings accessible inside the new SharePoint 2013 Central Administration. 
  • Make another web application and business insight website while investigating the elements of both. 
  • Make a SharePoint library to hold Excel exercise manuals and investigate trusted document areas. 
  • Use the Power View include for Excel. 
  • Make an Excel exercise manual with a parameter and spare it to a SharePoint report library. 
  • Add Web Apps to a website page. 
  • Investigate the Dashboard Designer interface and know how to make and arrange an information source. 
  • Make and design a standard KPI and a scorecard. 
  • Make and design a leaf KPI and a scorecard. 
  • Make two clear KPI's and after that move them into a goal KPI. 
  • Make and design a systematic graph and a logical framework, add them to a dashboard, convey them to SharePoint, and investigate the alternatives accessible. 
  • Make and design a channel, and tie the channel into both the systematic graph and logical framework made before. 
  • Make and design a falling channel and afterward tie it into another investigative diagram and framework. 
  • Make a Time Intelligence information association, a Time Intelligence channel, and make a report utilizing both. 
  • Make four duplicates of the Objective Scorecard, design settings in each of the four duplicates, and send them to SharePoint in a dashboard. 
  • Make another leaf KPI and utilize that KPI in two new scorecards, one with a channel arranged, and one without. 
  • Make a target scorecard and coordinating system outline, them in a dashboard, and afterward transfer the dashboard to the Student BI Site. 
  • Utilize PowerPivot inside Excel to import a table from SQL Server. 
  • View the connections existing inside the transported in tables from SQL Server and after that import an extra table and arrange a connection amongst it and the current. 
  • Shroud sections they don't need reflected in the subsequent PivotTable. 
  • Make a PivotTable inside a current worksheet. 
  • Explore the Report Builder 3.0 interface. 
  • Make an implanted information source associating into a database. 
  • Make an implanted information source associating into an OLAP database. 
  • Make a common information source utilizing the Report Manager. 
  • Make a common dataset utilizing the mutual association they made in the past exercise. 
  • Make another dashboard and investigate three diverse approaches to interface the Web Apps.

Module 1: Overview 

55057: SharePoint 2013 PerformancePoint Services module clarifies how the class will be organized and presents course materials and extra regulatory data. 

Lessons 

  • Introduction
  • Course Materials
  • Facilities
  • Prerequisites
  • What We'll Be Discussing

After completing this module, students will be able to:

  • In the wake of finishing this module, understudies will have the capacity to: 
  • Effectively sign into their virtual machine. 
  • Have a full comprehension of what the course expects to cover. 

Module 2: The Business Intelligence Stack 

In 55057: SharePoint 2013 PerformancePoint Services module we will initially take a gander at the three distinctive routes in which business knowledge can be seen. At that point, we will take a gander at the administrations SQL 2012 gives us and how they apply to business insight. We will then move to SharePoint 2013 and take a gander at the SharePoint administrations to look at their pertinence and how we can utilize them in business knowledge to surface information. In this segment we will likewise cover the new business insight highlights accessible inside the SharePoint 2013 discharge. At last, we will investigate PowerPivot, analyzing the new components and their noteworthiness. PowerPivot is shrouded in more detail in a later module. 

Lessons 

  • Business Intelligence in Three Ways 
  • SQL 2012 Business Intelligence 
  • New 2013 SharePoint Business Intelligence Features 
  • New 2013 PowerPivot in Excel Features 

Lab : The Business Intelligence Stack 

  • In the wake of finishing this module, understudies will have the capacity to: 
  • Peruse the information inside the 3D shape utilizing SQL Server Management Studio. 
  • Peruse information utilizing Visual Studio 2013. 
  • Interface with an unthinkable source, import tables, and investigate the information. 

Module 3: SharePoint 2013 Business Intelligence Center 

In 55057: SharePoint 2013 PerformancePoint Services module, we will investigate the better than ever 2013 SharePoint Central Administration site. We will cover particularly the new 2013 Business Intelligence Center format inside SharePoint. We are additionally going to cover a few things that blandly apply to SharePoint that you can use inside business knowledge. Authorizations and Roles will be enlightened and the included Document Library and List applications will be clarified. 

Lessons 

  • New 2013 SharePoint Central Administration 
  • New 2013 Business Intelligence Center 
  • Authorizations and Roles 
  • Included Document Library and List Apps 

Lab : SharePoint 2013 Business Intelligence Center

Module 4: PerformancePoint 2013 

In 55057: SharePoint 2013 PerformancePoint Services module, we will cover inside and out 2013 PerformancePoint Services highlights. Dashboard Designer is investigated alongside a large number of the articles and associations accessible inside 

Lessons 

  • New 2013 Overview of PerformancePoint Services 
  • Dashboard Designer 
  • Information Sources 
  • Pointers 
  • KPIs 
  • Visual Reports 
  • Channels 
  • Scorecards 
  • Dashboards 

Lab : PerformancePoint 2013 

  • Subsequent to finishing this module, understudies will have the capacity to: 
  • Investigate the Dashboard Designer interface and know how to make and arrange an information source. 
  • Make and design a standard KPI and a scorecard. 
  • Make and design a leaf KPI and a scorecard. 
  • Make two clear KPI's and after that move them into a goal KPI. 
  • Make and design a logical outline and a systematic matrix, add them to a dashboard, convey them to SharePoint, and investigate the choices accessible. 
  • Make and arrange a channel, and tie the channel into both the explanatory graph and scientific network made before. 
  • Make and arrange a falling channel and after that tie it into another scientific graph and framework. 
  • Make a Time Intelligence information association, a Time Intelligence channel, and make a report utilizing both. 
  • Make four duplicates of the Objective Scorecard, arrange settings in each of the four duplicates, and send them to SharePoint in a dashboard. 
  • Make another leaf KPI and utilize that KPI in two new scorecards, one with a channel arranged, and one without. 
  • Make another dashboard with two pages and survey altering choices 

Module 5: PowerPivot 

PowerPivot is not an element of SharePoint business insight, in any case, an Excel exercise manual with PowerPivot can be spared to a SharePoint site and afterward utilized as a part of a business knowledge situation. This module is expected as an outline of the item just and covers all the new elements accessible in the 2013 arrival of the include 

Lessons 

  • New 2013 PowerPivot Features 
  • PowerPivot and Excel 
  • PowerPivot and SharePoint 
  • Endeavor Business Intelligence and PowerPivot 
  • Bringing in Data 
  • Enhancing Data 
  • SharePoint Sharing 

Lab : PowerPivot 

  • Subsequent to finishing this module, understudies will have the capacity to: 
  • Utilize PowerPivot inside Excel to import a table from SQL Server. 
  • View the connections existing inside the foreign tables from SQL Server and after that import an extra table and design a connection amongst it and the current. 
  • Shroud sections they don't need reflected in the subsequent PivotTable. 
  • Make a PivotTable inside a current worksheet. 

Module 6: Dashboards 

55057: SharePoint 2013 PerformancePoint Services module obtains from the three-day Microsoft course on Dashboards number 50596A. Observing, dissecting, and overseeing dashboards are talked about alongside subtle elements on the best way to utilize them generally viably. This module does not cover Dashboard Designer as it is canvassed in more detail in the PerformancePoint Services module. Scope of the Microsoft Report Builder 3.0 instrument is brief as this course concentrates on the SharePoint space. 

Lessons 

  • Dashboard Migration 
  • Three Types of Dashboards 
  • Effective Dashboards 
  • Tables or Graphs 
  • Sorts of Graphs 
  • Picking a Chart Type 
  • Key Performance Indicators 
  • Entanglements In Dashboard Design 
  • Microsoft Report Builder 3.0 
  • Plan Your Reports 
  • Datasets 
  • New 2013 SharePoint Designer Features 
  • SharePoint Web Apps 

Lab : Dashboards 

  • In the wake of finishing this module, understudies will have the capacity to: 
  • Explore the Report Builder 3.0 interface. 
  • Make an inserted information source associating into a database. 
  • Make an inserted information source associating into an OLAP database. 
  • Make a mutual information source utilizing the Report Manager. 
  • Make a common dataset utilizing the mutual association they made in the past exercise. 
  • Make another dashboard and investigate three distinctive approaches to associate the Web Apps.

Awards