text.skipToContent text.skipToNavigation

Microsoft Report Builder


RPTBUILD - Report Builder Training

Introduction

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 2012, and SQL 2014 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, a detailed section exploring report expressions and how to properly configure them, filters, report visualizations including graphs, charts, images, and gauges, advanced reporting including the utilization of maps, interactive reports, Report Parts, subreports, subscriptions, and exporting options.

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 2012, and SQL 2014 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, a detailed section exploring report expressions and how to properly configure them, filters, report visualizations including graphs, charts, images, and gauges, advanced reporting including the utilization of maps, interactive reports, Report Parts, subreports, subscriptions, and exporting options.
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 2012, and SQL 2014 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, a detailed section exploring report expressions and how to properly configure them, filters, report visualizations including graphs, charts, images, and gauges, advanced reporting including the utilization of maps, interactive reports, Report Parts, subreports, subscriptions, and exporting options.
Price:
On Request
Duration: 2 days

Course Overview

This module explains how the class will be structured and introduces course materials and additional administrative information.

  • Introduction
  • Course Materials
  • Facilities
  • Prerequisites

Introduction to Report Builder 3.0

This module explains how the class will be structured and introduces course materials and additional administrative information.

  • Plan your reports
  • The Interface
  • Variances between SQL versions
  • How to use Report Builder 3.0 with SQL Express 2012
  • Data Sources
  • Data Sets

Report Builder 3.0 Wizards

This module explains how the class will be structured and introduces course materials and additional administrative information.

  • Explore the Report Builder 3.0 Wizards
  • Create reports with the Wizards

Report Builder 3.0 Basic Reports

This module explains how the class will be structured and introduces course materials and additional administrative information.

  • Report Lists
  • Report Tables
  • Report Matrix
  • The Data Region
  • Report Parameters
  • Report Expressions
  • Formatting Reports

Report Builder 3.0 Graphics

This module explains how the class will be structured and introduces course materials and additional administrative information.

  • Report Charts
  • Report Images
  • Report Gauges
  • Report Maps

Intermediate Reports

This module explains how the class will be structured and introduces course materials and additional administrative information.

  • Time Intelligence
  • Sub Reports
  • Interacting with Actionable Reports
  • Reuse Report Parts

To enable the delegate to Comprehensively use the Microsoft Report Builder Application.

  • Conceptual understanding of OLAP solutions.
  • Experience navigating the Microsoft Windows Server environment.
  • Experience with Windows services (starting and stopping).
  • Experience creating service accounts and permissions.
  • Experience with Microsoft SQL Server, including:
  • SQL Server Agent.
  • SQL Server query language (SELECT, UPDATE, INSERT, and DELETE).
  • SQL Server System tables.
  • SQL Server accounts (users and permissions)

This training is designed for Report Developers and Data Architects.