• 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/26/2018
  • VLT
Live Online
12/17/2018 12/21/2018
  • VLT
Live Online

About the Course

55060: Report Builder and PerformancePoint 2013 Combo Pack five-day teacher drove course additionally furnishes understudies with the fundamental learning to create reports utilizing Microsoft Report Builder 3.0. The preparation condition incorporates SQL 2008R2, SQL Express 2012 and SQL 2012 Standard and Enterprise so the understudies can use Report Builder 3.0 and produce reports from various sources to research the diverse components of each discharge. 

The course covers the Report Builder 3.0 wizards, nuts and bolts of report configuration, middle reports with report parameters and report articulations, report representations including diagrams, outlines, pictures, and gages, propelled detailing including the use of maps, intelligent reports, Report Parts and subreports. 

The course finishes up with an uncommon module that incorporates more than 100 hints and traps for Report Builder 3.0 with well ordered guidelines. The majority of the cases are accessible as a take-away for the understudies after the course. 

55060: Report Builder and PerformancePoint 2013 Combo Pack course likewise gives understudies the important learning to work with PerformancePoint 2013 Services. The as good as ever Business Intelligence Center is investigated, and all the energizing new components inside the SharePoint 2013 discharge are secured. 

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

PowerPivot and Dashboards have included modules. 

Audience profile

55060: Report Builder and PerformancePoint 2013 Combo Pack course is expected for control clients, engineers, and IT experts that will be included with the outline, advancement, and upkeep of reports made with Report Builder 3.0. 

55060: Report Builder and PerformancePoint 2013 Combo Pack course is additionally proposed for control clients, business insight engineers, and IT experts that will be included with the outline, advancement and upkeep of SharePoint 2013 business knowledge arrangements. 

At course completion

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

  • Plan your reports. 
  • Use Report Builder 3.0 wizards. 
  • Make an implanted information source. 
  • Make an implanted dataset. 
  • Make shared information sources and datasets. 
  • Utilize report parameters. 
  • Utilize report articulations. 
  • Make report gages. 
  • Make report charts. 
  • Utilize pictures in reports. 
  • Utilize report records. 
  • Utilize report tables. 
  • Utilize the framework. 
  • Make maps in reports. 
  • Make subreports. 
  • Utilize Report Parts. 
  • Make intuitive reports. 
  • Utilize console easy routes. 
  • 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. 
  • Investigate the alternatives and settings accessible inside the new SharePoint 2013 Central Administration. 
  • Make another web application and business knowledge webpage 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 logical outline and a scientific lattice, 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 logical outline and scientific lattice made before. 
  • Make and arrange a falling channel and after that tie it into another systematic outline 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 a target scorecard and coordinating procedure 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 foreign made tables from SQL Server and after that import an extra table and design 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. 
  • Explore the Report Builder 3.0 interface. 
  • Make an implanted 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 diverse approaches to interface the Web Apps. 

Module 1: Course Overview 

55060: Report Builder and PerformancePoint 2013 Combo Pack 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 

Lab : Course Overview 

  • 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: Introduction to Report Builder 3.0 

55060: Report Builder and PerformancePoint 2013 Combo Pack module presents the interface of Report Builder 3.0, the distinctive components accessible, and differences in information sources and sets. 

Lessons 

  • Plan Your Reports 
  • The Interface 
  • Changes Between SQL Versions 
  • Step by step instructions to Use Report Builder 3.0 with SQL Express 2012 
  • Information Sources 
  • Datasets 

Lab : Introduction to Report Builder 3.0 

  • Subsequent to finishing this module, understudies will have the capacity to: 
  • Plan the reports. 
  • Utilize Report Builder 3.0 and comprehend the parts of the interface. 
  • Dispatch Report Builder 3.0 from different sources. 
  • Make installed and shared information sources and datasets. 

Module 3: Report Builder 3.0 Wizards 

55060: Report Builder and PerformancePoint 2013 Combo Pack module clarifies the wizards. 

Lessons 

  • Investigate the Report Builder 3.0 Wizards 
  • Make Reports with the Wizards 

Lab : Report Builder 3.0 Wizards 

  • Subsequent to finishing this module, understudies will have the capacity to: 
  • Utilize the wizards to make reports. 

Module 4: Report Builder 3.0 Basic Reports 

55060: Report Builder and PerformancePoint 2013 Combo Pack module covers report fundamentals with records, grid, and tables, at that point goes into parameters and the expresionable part of reports. 

Lessons 

  • Report Lists 
  • Report Tables 
  • Report Matrix 
  • The Data Region 
  • Report Parameters 
  • Report Expressions 
  • Designing Reports 

Lab : Report Builder 3.0 Basic Reports 

  • Subsequent to finishing this module, understudies will have the capacity to: 
  • Make a report utilizing a rundown. 
  • Make a report utilizing a table. 
  • Make a report utilizing a grid. 
  • Make a report utilizing various information districts. 
  • Utilize report parameters. 
  • Utilize report articulations. 
  • Organization the report. 

Module 5: Report Builder 3.0 Graphics 

55060: Report Builder and PerformancePoint 2013 Combo Pack module is a definite take a gander at illustrations including implanted and Bing maps. 

Lessons 

  • Report Charts 
  • Report Images 
  • Report Sparklines 
  • Report Data Bars 
  • Report Gages 
  • Report Maps 

Lab : Report Builder 3.0 Graphics 

  • In the wake of finishing this module, understudies will have the capacity to: 
  • Make a report with outlines. 
  • Make a report with pictures. 
  • Make a report with sparklines. 
  • Make a report with information bars. 
  • Make a report with maps. 
  • Make a report with gages. 

Module 6: Intermediate Reports 

55060: Report Builder and PerformancePoint 2013 Combo Pack module covers moderate announcing with accentuation on significant reports. 

Lessons 

  • Time Intelligence 
  • Penetrate Through 
  • Subreports 
  • Interfacing with Actionable Reports 
  • Reuse Report Parts 

Lab : Intermediate Reports 

  • Subsequent to finishing this module, understudies will have the capacity to: 
  • Make subreports. 
  • Utilize penetrate through. 
  • Make a report that permits cooperation. 
  • Reuse Report Parts. 
  • Utilize Time Intelligence. 

Module 7: Report Builder 3.0 Tips and Tricks 

55060: Report Builder and PerformancePoint 2013 Combo Pack module is a gathering of how-to with illustrations. 

Lessons 

  • Many Step-By-Step Examples for Report Situations 

Lab : Report Builder 3.0 Tips and Tricks 

  • In the wake of finishing this module, understudies will have the capacity to: 
  • Utilize the tips and traps. 

Module 8: The Business Intelligence Stack 

In 55060: Report Builder and PerformancePoint 2013 Combo Pack module we will initially take a gander at the three diverse 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 insight to surface information. In this area we will likewise cover the new business insight highlights accessible inside the SharePoint 2013 discharge. At last, we will investigate PowerPivot, analyzing the new elements and their centrality. 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 

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

Module 9: SharePoint 2013 Business Intelligence Center 

In 55060: Report Builder and PerformancePoint 2013 Combo Pack module, we will investigate the as good as ever 2013 SharePoint Central Administration site. We will cover particularly the new 2013 Business Intelligence Center format inside SharePoint. We are likewise going to cover a few things that nonexclusively 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 

  • 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 webpage 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 archive library. 
  • Add Web Apps to a site page. 

Module 10: PerformancePoint 2013 

In 55060: Report Builder and PerformancePoint 2013 Combo Pack module, we will cover top to bottom 2013 PerformancePoint Services highlights. Dashboard Designer is investigated alongside a 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 

  • 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 graph and a logical network, 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 graph and logical network made before. 
  • Make and design a falling channel and afterward tie it into another logical outline 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 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 11: PowerPivot 

PowerPivot is not a component of SharePoint business insight, nonetheless, an Excel exercise manual with PowerPivot can be spared to a SharePoint site and after that utilized as a part of a business knowledge situation. This module is planned 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 
  • Venture Business Intelligence and PowerPivot 
  • Bringing in Data 
  • Advancing Data 
  • SharePoint Sharing 

Lab : PowerPivot 

  • In the wake of 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 transported in tables from SQL Server and after that import an extra table and design 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 12: Dashboards 

55060: Report Builder and PerformancePoint 2013 Combo Pack 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 adequately. This module does not cover Dashboard Designer as it is shrouded in more detail in the PerformancePoint Services module. Scope of the Microsoft Report Builder 3.0 device is brief as this course concentrates on the SharePoint space. 

Lessons 

  • Dashboard Migration 
  • Three Types of Dashboards 
  • Fruitful 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 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 distinctive approaches to associate the Web Apps.

Before going to this course, understudies must have: 

  • An essential comprehension of social databases.

Awards