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