Microsoft Report Builder 3.0 with SQL 2008R2, SQL 2012 Express and SQL 2012 Training Course

Course 55005
2 Days

Instructor-Led Live: $1,295
Instructor-Led Remote: $995 - Learn more
Course Overview
Builder 3.0. The training environment includes SQL 2008R2, SQL Express 2012 and SQL 2012 Standard and Enterprise so that the students can utilize Report Builder 3.0 and generate reports from multiple sources to investigate the different features of each release.
The course covers the Report Builder 3.0 wizards, basics of report design, intermediate reports with report parameters and report expressions, report visualizations including graphs, charts, images and gauges, advanced reporting including the utilization of maps, interactive reports, report parts and Sub-Reports.
The course concludes with a special module that includes over 100 tips and tricks for Report Builder 3.0 with step-by-step instructions. All of the examples are available as a take-away for the students after the course.
Audience
The primary audience for Course 55005: Microsoft Report Builder 3.0 with SQL 2008R2, SQL 2012 Express and SQL 2012 includes Power Users, Developers, and IT Professionals that will be involved with the design, development and maintenance of reports created with Report Builder 3.0.
Course Outline
Module 1: Course Overview
This module explains how the class will be structured and introduces course materials and additional administrative information.
Lessons
  • Introduction
  • Course Materials
  • Facilities
  • Prerequisites
  • What We'll Be Discussing
Lab : The training environment
  • Become familiar with the class setup
After completing this module, students will be able to:
  • Log on
  • Run the labs
  • Locate the example files

Module 2: Introduction to Report Builder 3.0
This module explains how the class will be structured and introduces course materials and additional administrative information.
Lessons
  • Plan your reports
  • The Interface
  • Variances between SQL versions
  • How to use Report Builder 3.0 with SQL Express 2012
  • Data Sources
  • Data Sets
Lab : Introduction to Report Builder 3.0
  • Explore Report Builder 3.0
  • Create embedded Data source and sets
  • Create shared Data Source and Sets
After completing this module, students will be able to:
  • Plan the reports
  • Use Report Builder 3.0 and understand the parts of the interface
  • Launch Report Builder 3.0 from multiple sources
  • Create embedded and shared data sources and data sets

Module 3: Report Builder 3.0 Wizards
This module explains how the class will be structured and introduces course materials and additional administrative information.
Lessons
  • Explore the Report Builder 3.0 Wizards
  • Create reports with the Wizards
Lab : Report Builder 3.0 Wizards
  • Use the Wizards to create reports
After completing this module, students will be able to:
  • Use the Wizards to create reports

Module 4: Report Builder 3.0 Basic Reports
This module explains how the class will be structured and introduces course materials and additional administrative information.
Lessons
  • Report Lists
  • Report Tables
  • Report Matrix
  • The Data Region
  • Report Parameters
  • Report Expressions
  • Formatting Reports
Lab : Report Builder 3.0 Basic Reports
  • Create a report using a List
  • Create a report using a Table
  • Create a report using a Matrix
  • Create a report using multiple Data Regions
  • Use Report Parameters
  • Use Report Expressions
  • Format the report
  • Save Report Parts for reuse
After completing this module, students will be able to:
  • Create a report using a List
  • Create a report using a Table
  • Create a report using a Matrix
  • Create a report using multiple Data Regions
  • Use Report Parameters
  • Use Report Expressions
  • Format the report

Module 5: Report Builder 3.0 Graphics
This module explains how the class will be structured and introduces course materials and additional administrative information.
Lessons
  • Report Charts
  • Report Images
  • Report Gauges
  • Report Maps
Lab : Report Builder 3.0 Graphics
  • Create a report with Charts
  • Create a report with Images
  • Create a report with Gauges
  • Create a report with Maps
After completing this module, students will be able to:
  • Create a report with Charts
  • Create a report with Images
  • Create a report with maps
  • Create a report with Gauges

Module 6: Intermediate Reports
This module explains how the class will be structured and introduces course materials and additional administrative information.
Lessons
  • Time Intelligence
  • Sub Reports
  • Interacting with Actionable Reports
  • Reuse Report Parts
Lab : Intermediate Reports
  • Create Sub Reports
  • Create a report that allows interaction
  • Reuse Report Parts
  • Use Time Intelligence
After completing this module, students will be able to:
  • Create Sub Reports
  • Create a report that allows interaction
  • Reuse Report Parts
  • Use Time Intelligence

Module 7: Report Builder 3.0 Tips and Tricks
This module explains how the class will be structured and introduces course materials and additional administrative information.
Lessons
  • Over 100 step-by-step examples for report situations

    Registration

Have a Microsoft Voucher?
Alexandria  |  Atlanta  |  Austin  |  Baltimore  |  Birmingham  |  Buffalo  |  Boise  |  Boston  |  Boulder  |  Charleston  |  Charlotte  |  Chicago  |  Cincinnati  |  Cleveland  |  Columbus  |  Dallas  |  Denver  |  Des Moines  |  Detroit  |  Hartford  |  Houston  |  Indianapolis  |  Jacksonville  |  Kalamazoo  |  Las Vegas  |  Los Angeles  |  Melville  |  Nashville  |  New Orleans  |  New York  |  Orlando  |  Overland Park   |  Palm Beach Gardens  |  Philadelphia  |  Phoenix  |  Pittsburgh  |  Princeton  |  Providence  |  Raleigh  |  Reno  |  Salt Lake City  |  San Antonio  |  San Diego  |  San Francisco  |  Savannah  |  Scottsdale  |  Seattle  |  St. Louis  | Tallahassee  |  Tampa  |  Toronto  |  Washington DC  |  Wichita