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

About the Course 

This educator drove course furnishes understudies with the vital learning to create reports utilizing Microsoft Report Builder 3.0. The preparation condition incorporates SQL 2008R2, SQL 2012, and SQL 2014 Standard and Enterprise, with the goal that the understudies can use Report Builder 3.0 and create reports from numerous sources to examine the diverse elements of each discharge. 

The course covers the Report Builder 3.0 wizards, fundamentals of report configuration, middle of the road reports with report parameters, a definite area investigating report articulations and how to appropriately arrange them, channels, report representations including diagrams, outlines, pictures, and gages, propelled revealing including the usage of maps, intuitive reports, Report Parts, subreports, memberships, and sending out choices. 

Audience Profile

  • This course is proposed for control clients, engineers, and IT experts that will be included with the plan, advancement, and support of reports made with Report Builder 3.0. 
  • At Course Completion
  • In the wake of finishing this course, 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 numerous sources. 
  • Comprehend administration alternatives. 
  • Make implanted information sources and datasets. 
  • Make shared information sources and datasets. 
  • Make shared information sources and datasets. 
  • Comprehend and use the Table or Matrix Wizard. 
  • Comprehend and use the Chart Wizard. 
  • Comprehend and use the Map Wizard. 
  • Comprehend and use records. 
  • Comprehend and use tables. 
  • Comprehend and use frameworks. 
  • Comprehend and use information areas. 
  • Comprehend and use parameters. 
  • Comprehend and use articulations. 
  • Comprehend and use report parts. 
  • Comprehend and use organizing choices. 
  • Comprehend perception choices. 
  • Comprehend and use graphs. 
  • Comprehend and use sparklines. 
  • Comprehend and use gages. 
  • Comprehend and use maps. 
  • Comprehend sifting, gathering, and arranging. 
  • Comprehend and use dynamic headers and footers. 
  • Comprehend and use report formats. 
  • Comprehend and use HTML and texboxes. 
  • Comprehend and use records as holders. 
  • Comprehend and use subreports. 
  • Comprehend report membership alternatives. 
  • Comprehend security. 

Module 1: Course Overview 

55005: Microsoft Report Builder 3.0 with SQL 2008R2, SQL 2012, and SQL 2014 module clarifies how the class will be organized and presents course materials and extra regulatory data. 

Lessons 

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

Lab : Course Overview 

  • 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 

55005: Microsoft Report Builder 3.0 with SQL 2008R2, SQL 2012, and SQL 2014 module presents the interface of Report Builder 3.0, the distinctive elements accessible, and changes in information sources and datasets. 

Lessons 

  • Arranging Your Reports 
  • Understanding Variances Between SQL Versions 
  • Investigating The Report Builder 3.0 Interface 
  • Looking at Management 
  • Using Data Sources 
  • Working with Datasets 

Lab : Introduction to Report Builder 3.0 

  • Investigate the Report Builder 3.0 Interface 
  • Make an Embedded Data Source into SQL 2014 Engine 
  • Make an Embedded Data Source into SQL 2014 Analysis Services 
  • Make a Shared Data Source Using the Report Manager 
  • Make a Shared Dataset Using the Shared Data Source 
  • Plan the reports. 
  • Utilize Report Builder 3.0 and comprehend the parts of the interface. 
  • Dispatch Report Builder 3.0 from different sources. 
  • Comprehend administration choices. 
  • Make installed information sources and datasets. 
  • Make shared information sources and datasets. 

Module 3: Report Builder 3.0 Wizards 

55005: Microsoft Report Builder 3.0 with SQL 2008R2, SQL 2012, and SQL 2014 module covers report nuts and bolts investigating records, frameworks, and tables alongside the wizards. Information areas will likewise be clarified. 

Lessons 

  • Investigating Table or Matrix Wizard 
  • Using Chart Wizard 
  • Working with Map Wizard 

Lab : Report Builder 3.0 Wizards 

  • Make Five Shared Data Sources and Two Shared Datasets 
  • Utilize the Table or Matrix Wizard 
  • Utilize the Chart Wizard 
  • Utilize the Map Wizard 
  • Make shared information sources and datasets. 
  • Comprehend and use the Table or Matrix Wizard. 
  • Comprehend and use the Chart Wizard. 
  • Comprehend and use the Map Wizard. 

Module 4: Report Builder 3.0 Basic Reports 

In this module we look at parameters, channels, and the expressionable part of reports. We additionally cover arranging choices. 

Lessons 

  • Using Lists 
  • Utilizing Tables 
  • Investigating Matrix 
  • Acing Data Region(s) 
  • Inspecting Parameters 
  • Working with Expressions 
  • Understanding Report Parts 
  • Organizing Reports 

Lab : Report Builder 3.0 Basic Reports 

  • Making a Report Using Lists 
  • Making a Report Using Tables 
  • Making a Report Using a Tablix 
  • Making a Report with a Query Parameter 
  • Report Parameter with a Shared Dataset 
  • Make Parameters Using a Dataset as a Filter 
  • Utilizing Expressions in Your Report 
  • Making a Report Using Report Parts 
  • Report Formatting 
  • Comprehend and use records. 
  • Comprehend and use tables. 
  • Comprehend and use frameworks. 
  • Comprehend and use information areas. 
  • Comprehend and use parameters. 
  • Comprehend and use articulations. 
  • Comprehend and use report parts. 
  • Comprehend and use designing alternatives. 

Module 5: Report Builder 3.0 Graphics 

55005: Microsoft Report Builder 3.0 with SQL 2008R2, SQL 2012, and SQL 2014 module is a point by point take a gander at illustrations including diagrams, pictures, sparklines, information bars, gages, and Bing maps. 

Lessons 

  • Understanding Visualizations 
  • Using Charts 
  • Investigating Gages 
  • Analyzing Maps 

Lab : Report Builder 3.0 Graphics 

  • Utilizing Sparklines in a Report 
  • Report Builder Chart Borders, Titles, and Legends 
  • Straight Gages 
  • Essential Maps 
  • Essential Maps with Color 
  • Comprehend representation choices. 
  • Comprehend and use outlines. 
  • Comprehend and use sparklines. 
  • Comprehend and use gages. 
  • Comprehend and use maps. 

Module 6: Intermediate Reporting 

55005: Microsoft Report Builder 3.0 with SQL 2008R2, SQL 2012, and SQL 2014 module covers middle of the road revealing with accentuation on significant reports, and an area investigating report memberships and security. 

Lessons 

  • Sifting, Grouping, and Sorting 
  • Using Dynamic Headers and Footers 
  • Imagining Your Company Report Templates 
  • Understanding HTML5 and Textboxes 
  • Utilizing the List Object to Combine Other Items 
  • Making Subreports and Drillthrough Reports 
  • Investigating Subscriptions 
  • Inspecting Security 

Lab : Intermediate Reporting 

  • Report Header and Footer 
  • Making Report Templates 
  • Installing HTML in a Textbox 
  • Records as Containers 
  • Subreports 
  • Comprehend sifting, gathering, and arranging. 
  • •Understand and use dynamic headers and footers. 
  • Comprehend and use report formats. 
  • Comprehend and use HTML and texboxes. 
  • Comprehend and use records as compartments. 
  • Comprehend and use subreports. 
  • Comprehend report membership choices. 
  • Comprehend security.

An essential comprehension of social databases.

Awards