• 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

About the Course

55058: PowerPivot and Report Builder Combo Pack four-day teacher drove course focuses on PowerPivot and Power View in Excel 2013. The participants will figure out how to surface the exercise manuals and representations utilizing the Business Intelligence Center in SharePoint 2013. 

Quite far each of the modules is remained solitary taking into account customization of the course for those groups of onlookers that might not have an enthusiasm for a specific administration. 

This course likewise gives understudies the essential information to create reports utilizing Microsoft Report Builder 3.0. The preparation condition incorporates SQL 2008R2, SQL Express 2012 and SQL 2012 Standard and Enterprise with the goal that the understudies can use Report Builder 3.0 and produce reports from numerous sources to examine the diverse components of each discharge. 

The course covers the Report Builder 3.0 wizards, fundamentals of report configuration, transitional reports with report parameters and report articulations, report perceptions including diagrams, outlines, pictures, and gages, propelled revealing including the use of maps, intuitive reports, Report Parts and subreports. 

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

Audience Profile

55058: PowerPivot and Report Builder Combo Pack course is proposed for investigators, business insight (BI) engineers and IT experts that will be included with the outline, advancement, and upkeep of Excel exercise manuals using PowerPivot and Power View 2013 to be surfaced on SharePoint.This course is additionally expected for control clients, designers, and IT experts that will be included with the plan, improvement, and support of reports made with Report Builder 3.0. 

At course completion

In the wake of finishing 55058: PowerPivot & Report Builder Combo Pack course, understudies will have the capacity to: 

  • Utilize PowerPivot inside Excel to import a table from SQL Server. 
  • Utilize PowerPivot inside Excel to import extensive datasets. 
  • Utilize PowerPivot inside Excel to import with an inquiry. 
  • Make connections between tables. 
  • Make a falling relationship. 
  • Make a connection between two tables from various sources. 
  • Shroud sections they don't need reflected in the subsequent PivotTable. 
  • Change information sorts. 
  • 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. 
  • Make a PivotTable inside a current worksheet. 
  • Add a computed field to a table from the PivotTable. 
  • Utilize the FILTER work. 
  • Utilize the CALCULATE work. 
  • Fabricate a date table in exceed expectations. 
  • Relate a table to the date table made in Excel. 
  • Make and design points of view. 
  • Make and design pecking orders. 
  • Make and design KPIs. 
  • Explore and effectively utilize Power View. 
  • Make a table. 
  • Make a graph. 
  • Spare and offer their work. 
  • Investigate the alternatives and settings accessible inside the new SharePoint 2013 Central Administration. 
  • Get to and survey the Secure Store. 
  • Make another web application and business knowledge webpage while investigating the components of both. 
  • Make custom applications to store representations and additionally exercise manuals in SharePoint 2013 Business Intelligence Center. 
  • 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 diagrams. 
  • Utilize pictures in reports. 
  • Utilize report records. 
  • Utilize report tables. 
  • Utilize the lattice. 
  • Make maps in reports. 
  • Make subreports. 
  • Utilize Report Parts. 
  • Make intuitive reports. 
  • Utilize console alternate ways. 

Module 1: Course OverviewLessons 

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

Lab : Course Overview 

  • 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 plans to cover. 

Module 2: PowerPivot

In this module we will investigate PowerPivot and its explanatory abilities. PowerPivot is an information investigation add-on for Microsoft Excel that enables a lot of information to be gathered, accumulated, and dissected in one exercise manual. Sound capable? It is! We'll cover all that you have to know to get you up, running, and examining. 

Lessons 

  • Best Things That PowerPivot Brings to Excel 
  • What Will PowerPivot Do for the Analyst? 
  • Prologue to PivotTables (Optional) 
  • PowerPivot Versions 
  • New 2013 PowerPivot Features 
  • VLOOKUP Not Required (Use Relationships) 
  • Compositional Changes in Excel 2013 
  • PowerPivot and Excel 2013 
  • PowerPivot and SharePoint 
  • Endeavor Business Intelligence and PowerPivot 
  • Bringing in Data 
  • Information Models 
  • Connections 
  • Basic PivotTable Reports 
  • Ascertained Columns and Calculated Fields 
  • Reviving Data 
  • Counts 
  • 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. 
  • Utilize PowerPivot inside Excel to import expansive datasets. 
  • Utilize PowerPivot inside Excel to import with a question. 
  • Make connections between tables. 
  • Make a falling relationship. 
  • Make a connection between two tables from various sources. 
  • Conceal sections they don't need reflected in the subsequent PivotTable. 
  • Change information sorts. 
  • View the connections existing inside the foreign made tables from SQL Server and after that import an extra table and arrange a connection amongst it and the current. 
  • Make a PivotTable inside a current worksheet. 
  • Add a figured field to a table from the PivotTable. 
  • Utilize the FILTER work. 
  • Utilize the CALCULATE work. 
  • Construct a date table in exceed expectations. 
  • Relate a table to the date table made in Excel. 
  • Make and arrange points of view. 
  • Make and arrange orders. 
  • Make and arrange KPIs. 

Module 3: Power View 

In 55058: PowerPivot and Report Builder Combo Pack module we will cover Power View and the detailing that can be made. From tables to outlines and sharing on SharePoint, this module will have you prepared to picture your date in an assortment of ways. 

Lessons 

  • Report Design Principles 
  • New 2013 Power View Features 
  • Microsoft Power View User Interface 
  • Tables 
  • Diagrams 
  • BI Semantic Models 
  • Sparing and Sharing 

Lab : Power View 

  • Subsequent to finishing this module, understudies will have the capacity to: 
  • Explore and effectively utilize Power View. 
  • Make a table. 
  • Make a diagram. 
  • Spare and offer their work. 

Module 4: SharePoint 2013 Business Intelligence Center 

In 55058: PowerPivot and Report Builder 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. Authorizations and parts will be tended to and the included library and rundown applications will be clarified. 

Lessons 

  • Speedy Architecture 
  • New 2013 SharePoint Central Administration 
  • New 2013 Business Intelligence Center 
  • Consents and Roles 
  • Included Document Library and List Apps 
  • Make Custom Apps (Libraries) for Visualizations or Workbooks 

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. 
  • Get to and audit the Secure Store. 
  • Make another web application and business knowledge website while investigating the components of both. 
  • Make custom applications to store perceptions and additionally exercise manuals in SharePoint 2013 Business Intelligence Center. 

Module 5: Introduction to Report Builder 3.0 

55058: PowerPivot and Report Builder Combo Pack module presents the interface of Report Builder 3.0, the diverse components accessible, and fluctuations in information sources and sets. 

Lessons 

  • Plan Your Reports 
  • The Interface 
  • Differences Between SQL Versions 
  • The most effective method to Use Report Builder 3.0 with SQL Express 2012 
  • Information Sources 
  • Datasets 

Lab : Introduction to Report Builder 3.0 

  • In the wake of 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 various sources. 
  • Make inserted and shared information sources and datasets. 

Module 6: Report Builder 3.0 Wizards 

55058: PowerPivot and Report Builder 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 

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

Module 7: Report Builder 3.0 Basic Reports 

55058: PowerPivot and Report Builder Combo Pack module covers report essentials with records, framework, 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 
  • Organizing Reports 

Lab : Report Builder 3.0 Basic Reports 

  • In the wake of 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 lattice. 
  • Make a report utilizing various information districts. 
  • Utilize report parameters. 
  • Utilize report articulations. 
  • Organization the report. 

Module 8: Report Builder 3.0 Graphics 

55058: PowerPivot and Report Builder Combo Pack module is a point by point take a gander at designs including installed and Bing map. 

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 9: Intermediate Reports 

55058: PowerPivot and Report Builder Combo Pack module covers middle of the road revealing with accentuation on noteworthy reports 

Lessons 

  • Time Intelligence 
  • Bore Through 
  • Subreports 
  • Communicating with Actionable Reports 
  • Reuse Report Parts 

Lab : Intermediate Reports 

  • In the wake of finishing this module, understudies will have the capacity to: 
  • Make subreports. 
  • Utilize bore through. 
  • Make a report that permits communication. 
  • Reuse Report Parts. 
  • Utilize Time Intelligence. 

Module 10: Report Builder 3.0 Tips and Tricks 

This 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.
  • Before going to this course, understudies must have: 
  • Involvement with Excel 2007 or higher. 
  • A comprehension of PivotTables. 
  • A fundamental comprehension of social databases.

Awards