Microsoft Report Builder 3.0 with SQL 2008R2, SQL 2012, and SQL 2014

Session Detail:    Classroom 2 Day

This instructor-led course provides students with the necessary knowledge to develop reports using Microsoft Report 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.

Prerequisites

A basic understanding of relational databases.

Who Can Benefit

This course is intended for power users, developers, and IT professionals that will be involved with the design, development, and maintenance of reports created with Report Builder 3.0.

Session Outline

Class Outline

Module 1: Course Overview

  • Lesson 1: Introduction
  • Lesson 2: Course Materials
  • Lesson 3: Facilities
  • Lesson 4: Prerequisites
  • Lesson 5: What We’ll Be Discussing

After completing this module, students will be able to:

  • Successfully log into their virtual machine
  • Have a full understanding of what the course intends to cover

Module 2: Introduction to Report Builder 3.0

  • Lesson 1: Planning Your Reports
  • Lesson 2: Understanding Variances Between SQL Versions
  • Lesson 3: Exploring The Report Builder 3.0 Interface
  • Lesson 4: Examining Management
  • Lesson 5: Utilizing Data Sources
  • Lesson 6: Working with Datasets

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
  • Understand management options
  • Create embedded data sources and datasets
  • Create shared data sources and datasets

Module 3: Report Builder 3.0 Wizards

  • Lesson 1: Exploring Table or Matrix Wizard
  • Lesson 2: Utilizing Chart Wizard
  • Lesson 3: Working with Map Wizard

After completing this module, students will be able to:

  • Create shared data sources and datasets
  • Understand and utilize the Table or Matrix Wizard
  • Understand and utilize the Chart Wizard
  • Understand and utilize the Map Wizard

Module 4: Report Builder 3.0 Basic Reports

  • Lesson 1: Utilizing Lists
  • Lesson 2: Using Tables
  • Lesson 3: Exploring Matrix
  • Lesson 4: Mastering Data Region(s)
  • Lesson 5: Examining Parameters
  • Lesson 6: Working with Expressions
  • Lesson 7: Understanding Report Parts
  • Lesson 8: Formatting Reports

After completing this module, students will be able to:

  • Understand and utilize lists
  • Understand and utilize tables
  • Understand and utilize matrices
  • Understand and utilize data regions
  • Understand and utilize parameters
  • Understand and utilize expressions
  • Understand and utilize report parts
  • Understand and utilize formatting options

Module 5: Report Builder 3.0 Graphics

  • Lesson 1: Understanding Visualizations
  • Lesson 2: Utilizing Charts
  • Lesson 3: Exploring Gauges
  • Lesson 4: Examining Maps

After completing this module, students will be able to:

  • Understand visualization options
  • Understand and utilize charts
  • Understand and utilize sparklines
  • Understand and utilize gauges
  • Understand and utilize maps

Module 6: Intermediate Reporting

  • Lesson 1: Filtering, Grouping, and Sorting
  • Lesson 2: Utilizing Dynamic Headers and Footers
  • Lesson 3: Visualizing Your Company Report Templates
  • Lesson 4: Understanding HTML5 and Textboxes
  • Lesson 5: Using the List Object to Combine Other Items
  • Lesson 6: Creating Subreports and Drillthrough Reports
  • Lesson 7: Exploring Subscriptions
  • Lesson 8: Examining Security

After completing this module, students will be able to:

  • Understand filtering, grouping, and sorting
  • Understand and utilize dynamic headers and footers
  • Understand and utilize report templates
  • Understand and utilize HTML and textboxes
  • Understand and utilize lists as containers
  • Understand and utilize subreports
  • Understand report subscription options
  • Understand security

Module 7: Report Builder 3.0 Tips and Tricks

  • None

After completing this module, students will be able to:

  • Use what they’ve learned throughout this course

Need to train your team?

All of our sessions can be customized to meet your team’s specific need. Build the perfect program by picking and choosing topics from any of the courses in our catalog. A personalized private session gives you the ultimate flexibility and helps maximize your team’s valuable time!

Requesting Team Training
DateTimeTypePriceAdd To Cart

Microsoft Report Builder 3.0 with SQL 2008R2, SQL 2012, and SQL 2014

2 Day
Classroom

$1,090.00

Chat with a Coach

Chat with a Coach

Have a more immediate need? Why spend the next hour searching online for answers when you can spend just 15 minutes with one of our experts and get accurate and personalized answers to all of your questions. 

$9.99 | 15 Minutes

Book Now