SQL Server 2016 Report Builder Syllabus (BBP0011)

Overview:

This instructor-led course provides students with the necessary knowledge to develop reports using Microsoft SQL Server 2016 Report Builder.

The course covers the Report Builder 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 use of maps, interactive reports, Report Parts, subreports, subscriptions, and exporting options.

Audience:

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

Duration:

3 days

01 Course Overview

• Introduction
• Course materials
• Facilities
• Prerequisites

02 Introduction to SQL Server 2016 Report Builder

• Planning Your Reports
• Understanding Variances Between SQL Versions
• Exploring the Report Builder Interface
• Examining Management
• Utilizing Data Sources
• Working with Datasets

Labs:

• Explore the Report Builder Interface
• Create an Embedded Data Source into SQL 2016 Engine
• Create a Shared Data Source Using the Report Manager
• Create a Shared Dataset Using the Shared Data Source

03 SQL Server 2016 Report Builder Wizards

• Exploring Table or Matrix Wizard
• Utilizing Chart Wizard
• Working with Map Wizard

Labs:

• Create Five Shared Data Sources and Two Shared Datasets
• Use the Table or Matrix Wizard
• Use the Chart Wizard
• Use the Map Wizard

04 SQL Server 2016 Report Builder Basic Reports

• Utilizing Lists
• Using Tables
• Exploring Matrix
• Mastering Data Region(s)
• Examining Parameters
• Working with Expressions
• Understanding Report Parts
• Formatting Reports

Labs:

• Creating a Report Using Lists
• Creating a Report Using Tables
• Creating a Report Using a Tablix
• Creating a Report with a Query Parameter
• Report Parameter with a Shared Dataset
• Create Parameters Using a Dataset as a Filter
• Using Expressions in Your Report
• Creating a Report Using Report Parts
• Report Formatting

05 SQL Server 2016 Report Builder Graphics

• Understanding Visualizations
• Utilizing Charts
• Exploring Gauges
• Examining Maps

Labs:

• Using Sparklines in a Report
• Report Builder Chart Borders, Titles, and Legends
• Linear Gauges
• Basic Maps
• Basic Maps with Color

06 SQL Server 2016 Report Builder Intermediate Reporting

• Filtering, Grouping, and Sorting
• Utilizing Dynamic Headers and Footers
• Visualizing Your Company Report Templates
• Understanding HTML5 and Textboxes
• Using the List Object to Combine Other Items
• Creating Subreports and Drillthrough Reports
• Exploring Subscriptions
• Examining Security

Labs:

• Report Header and Footer
• Creating Report Templates
• Embedding HTML in a Textbox
• Lists as Containers
• Subreports