• 100 Queen St W, Brampton, ON L6X 1A4, Canada
  • +1-800-961-0337
START DATE END DATE CLASS TIMINGS MODE LOCATION ACTION
11/06/2018 11/09/2018
  • VLT
Live Online
12/04/2018 12/07/2018
  • VLT
Live Online

55042: SharePoint 2013 Business Intelligence Course 

55042: SharePoint 2013 Business Intelligence four-day teacher drove course furnishes understudies with the essential learning to work with all the related SharePoint business insight administrations including PerformancePoint Service, Excel Services, Business Connectivity Services, and Visio Services. The better than 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. 

Beyond what many would consider possible each of the modules is remain solitary taking into account customization of the course for those gatherings of people that might not have an enthusiasm for a specific administration. 

55042: SharePoint 2013 Business Intelligence Audience Profile

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

55042: SharePoint 2013 Business Intelligence At Course Completion

In the wake of finishing 55042: SharePoint 2013 Business Intelligence course, understudies will have the capacity to: 

  • Peruse the information inside the 3D square utilizing SQL Server Management Studio. 
  • Peruse information utilizing Visual Studio 2013. 
  • Interface with an unthinkable 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 knowledge webpage while investigating the components of both. 
  • Make a SharePoint library to hold Excel exercise manuals and investigate trusted record areas. 
  • Use the Power View include for Excel. 
  • Make an Excel exercise manual with a parameter and spare it to a SharePoint record library. 
  • Add Web Apps to a site 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 logical diagram and a scientific matrix, add them to a dashboard, send them to SharePoint, and investigate the alternatives accessible. 
  • Make and design a channel, and tie the channel into both the logical diagram and scientific matrix made before. 
  • Make and design a falling channel and after that tie it into another logical outline and matrix. 
  • 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 alternatives. 
  • Make a drawing, transfer the archive to the Student BI Site records library, and view the attracting a program. 
  • Make an information associated drawing and transfer the report to the Student BI Site archives library. 
  • Make a target scorecard and coordinating methodology delineate, them in a dashboard, and after that 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 afterward import an extra table and arrange a connection amongst it and the current. 
  • Conceal sections they don't need reflected in the subsequent PivotTable. 
  • Make a PivotTable inside a current worksheet. 
  • Dole out overseers and consents on the BDC Metadata Store. 
  • Investigate the distinctive substance sorts accessible in SharePoint 2013 and figure out how to find them and their relating settings. 
  • Make a record library, arrange it to acknowledge particular substance sorts, and after that figure out how to erase the report library. 
  • Make and arrange another outer substance sort. 
  • Make an outside rundown related with the new outer substance sort made earlier. 
  • Make another outer substance sort and another host URL, and afterward make an outside rundown and profile page. 
  • Add a custom activity to an outer rundown. 
  • Explore the Report Builder 3.0 interface. 
  • Make an installed information source interfacing into a database. 
  • Make an installed information source interfacing into an OLAP database. 
  • Make a mutual information source utilizing the Report Manager. 
  • Make a mutual dataset utilizing the common association they made in the past exercise. 
  • Make another dashboard and investigate three distinctive approaches to interface the Web Apps. 

55042: SharePoint 2013 Business Intelligence Course Outline 

Module 1: Course Overview 

55042: SharePoint 2013 Business Intelligence module clarifies how the class will be organized and presents course materials and extra authoritative data. 

Lessons 

  • Presentation 
  • Course Materials 
  • Offices 
  • Requirements 
  • What We'll Be Discussing 

Subsequent to finishing this module, understudies will have the capacity to: 

  • Effectively sign into their virtual machine. 
  • Have a full comprehension of what the course means to cover. 

Module 2: The Business Intelligence Stack 

In 55042: SharePoint 2013 Business Intelligence module we will initially take a gander at the three distinctive courses 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 knowledge. We will then move to SharePoint 2013 and take a gander at the SharePoint administrations to analyze their pertinence and how we can utilize them in business knowledge to surface information. In this area we will likewise cover the new business insight highlights accessible inside the SharePoint 2013 discharge. At long last, we will investigate PowerPivot, looking at the new elements and their criticalness. PowerPivot is canvassed 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 55042: SharePoint 2013 Business Intelligence module, we will investigate the as good as ever 2013 SharePoint Central Administration site. We will cover particularly the new 2013 Business Intelligence Center layout inside SharePoint. We are likewise going to cover a few things that nonexclusively apply to SharePoint that you can use inside business insight. Consents 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 

  • Subsequent to finishing this module, understudies will have the capacity to: 
  • Investigate the choices and settings accessible inside the new SharePoint 2013 Central Administration. 
  • Make another web application and business knowledge website while investigating the elements of both. 

Module 4: SharePoint 2013 Excel Services 

In 55042: SharePoint 2013 Business Intelligence module, we will go over all the new 2013 Excel Services elements, and we will investigate the center segments of Excel Services. We will cover Excel Web Access and it's capacities alongside any distinctions you may experience in the program instead of the desktop customer. There is scope of the Power View include for Excel, and after that finally we will clarify the spare and offer process and observe best practices. 

Lessons 

  • New 2013 Excel Services Features 
  • Center Components 
  • Exceed expectations Web Access (EWA) 
  • What Excel Web Access is Not 
  • Contrasts in the Browser versus Desktop 
  • SharePoint Libraries to Store Workbooks 
  • Power View Add-in for Excel 
  • The Save and Share Process 
  • Exceed expectations Web App 
  • Best Practices 

Lab : SharePoint 2013 Excel Services 

  • Subsequent to finishing this module, understudies will have the capacity to: 
  • 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 record library. 
  • Add Web Apps to a page. 

Module 5: SharePoint 2013 PerformancePoint 2013 

In 55042: SharePoint 2013 Business Intelligence module, we will give you an outline of the new 2013 PerformancePoint Services highlights. Dashboard Designer is investigated alongside a considerable lot of the items and associations accessible inside. 

Lessons 

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

Lab : SharePoint 2013 PerformancePoint 2013 

  • In the wake of 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 an investigative outline and a systematic framework, add them to a dashboard, convey them to SharePoint, and investigate the choices accessible. 
  • Make and design a channel, and tie the channel into both the investigative outline and systematic framework made before. 
  • Make and design a falling channel and after that tie it into another expository diagram and lattice. 
  • 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 convey them to SharePoint in a dashboard. 
  • Make another leaf KPI and utilize that KPI in two new scorecards, one with a channel designed, and one without. 
  • Make another dashboard with two pages and survey altering choices. 

Module 6: SharePoint 2013 Visio Services 

Visio drawings can be to a great degree viable and in this module we cover the mutual administration that enables clients to share and view them. We will go over all the new 2013 Visio Services highlights and furthermore examine information associated drawings and how to design them. There is likewise an area on survey drawings inside a browser. 

Lessons 

  • New 2013 Visio Services Features 
  • Visio Graphics Service 
  • Visio Drawings in the Browser 
  • Visio Web Access Web Part 
  • Visio Drawings with Data Connections 

Lab : SharePoint 2013 Visio Services 

  • In the wake of finishing this module, understudies will have the capacity to: 
  • Make a drawing, transfer the record to the Student BI Site reports library, and view the attracting a program. 
  • Make an information associated drawing and transfer the record to the Student BI Site reports library. 
  • Make a target scorecard and coordinating technique delineate, them in a dashboard, and afterward transfer the dashboard to the Student BI Site. 

Module 7: PowerPivot 

PowerPivot is not an element of SharePoint business knowledge, be that as it may, an Excel exercise manual with PowerPivot can be spared to a SharePoint site and after that utilized as a part of a business insight situation. This module is expected as a review of the item just and covers all the new components 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 afterward import an extra table and arrange a connection amongst it and the current. 
  • Conceal segments they don't need reflected in the subsequent PivotTable. 
  • Make a PivotTable inside a current worksheet. 

Module 8: SharePoint 2013 Business Connectivity Services 

In 55042: SharePoint 2013 Business Intelligence module we will investigate the new elements accessible inside SharePoint 2013 Business Connectivity Services, how to arrange the security, and illuminate the phrasing. 

Lessons 

  • New 2013 Business Connectivity Service Features 
  • What is Business Connectivity Services? 
  • BCS Terminology 
  • BCS Security 
  • Utilizing SharePoint Designer 2013 with BCS 
  • Surfacing the BCS Data 

Lab : SharePoint 2013 Business Connectivity Services 

  • In the wake of finishing this module, understudies will have the capacity to: 
  • Dole out overseers and authorizations on the BDC Metadata Store. 
  • Investigate the diverse substance sorts accessible in SharePoint 2013 and figure out how to find them and their relating settings. 
  • Make a record library, arrange it to acknowledge particular substance sorts, and after that figure out how to erase the report library. 
  • Make and arrange another outer substance sort. 
  • Make an outside rundown related with the new outer substance sort made earlier. 
  • Make another outside substance sort and another host URL, and after that make an outer rundown and profile page. 
  • Add a custom activity to an outside rundown. 

Module 9: Dashboards 

55042: SharePoint 2013 Business Intelligence module gets from the three-day Microsoft course on Dashboards number 50596A. Checking, breaking down, and overseeing dashboards are talked about alongside points of interest on the best way to utilize them generally successfully. 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 apparatus 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 
  • Traps In Dashboard Design 
  • Microsoft Report Builder 3.0 
  • Plan Your Reports 
  • Datasets 
  • New 2013 SharePoint Designer Features 
  • SharePoint Web Apps 

Lab : Dashboards 

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

Before going to this course, understudies must have: 

  • A comprehension of the advantages of business insight.

Awards