DUNS #: 07-985-4198 | Cage Code: 7F5V0 | NAICS Codes: 611310, 611420

Microsoft Report Builder 3.0 with SQL 2008R2, SQL 2012 Express & SQL 2012

2 Days

Price: $1050

Course Schedule

Overview

Builder 3.0. The training environment includes SQL 2008R2, SQL Express 2012 & SQL 2012 St&ard & Enterprise so that the students can utilize Report Builder 3.0 & 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 & report expressions, report visualizations including graphs, charts, images & gauges, advanced reporting including the utilization of maps, interactive reports, report parts & Sub-Reports. The course concludes with a special module that includes over 100 tips & 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.


Objectives

After completing this course, students will be able to:

  • Utilize Report Builder 3.0 Wizards
  • Create an embedded data source
  • Create an embedded data set
  • Create shared data sources & data sets
  • Use report parameters
  • Use report expressions
  • Create report gauges
  • Create report graphs
  • Use images in reports
  • Use report lists
  • Use report tables
  • Use the matrix
  • Create maps in reports
  • Create sub reports
  • Use report parts
  • Create interactive reports
  • Use keyboard shortcuts

Audience

This course is intended for Power Users, Developers & IT Professionals that will be involved with the design, development & maintenance of reports created with Report Builder 3.0


Prerequisites


Outline

Module 1: Course Overview
This module explains how the class will be structured & introduces course materials & 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 & introduces course materials & 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 & sets
  • Create shared Data Source & Sets

After completing this module, students will be able to:

  • Plan the reports
  • Use Report Builder 3.0 & underst& the parts of the interface
  • Launch Report Builder 3.0 from multiple sources
  • Create embedded & shared data sources & data sets

Module 3: Report Builder 3.0 Wizards
This module explains how the class will be structured & introduces course materials & 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 & introduces course materials & 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 & introduces course materials & 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 & introduces course materials & 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 & Tricks
This module explains how the class will be structured & introduces course materials & additional administrative information.

Lessons

  • Over 100 step-by-step examples for report situations

Lab: Report Builder 3.0 Tips & Tricks

  • Over 100 step-by-step examples for report situations
  • After completing this module, students will be able to:
  • Use the tips & tricks