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

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

The course covers the Report Builder 3.0 wizards, basics of report design, intermediate reports with report parameters and report expressions, report visualizations including graphs, charts, images and gauges.

PREREQUISITES
Before attending this course, students must have:
•A basic understanding of relational databases.
Top
TARGET AUDIENCE
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

COURSE OBJECTIVES
After completing this course, 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.
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.
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.
Understand visualization options.
Understand and utilize charts.
Understand and utilize sparklines.
Understand and utilize gauges.
Understand and utilize maps.
Understand filtering, grouping, and sorting.
Understand and utilize dynamic headers and footers.
Understand and utilize report templates.
Understand and utilize HTML and texboxes.
Understand and utilize lists as containers.
Understand and utilize subreports.
Understand report subscription options.
Understand security.

Top
COURSE OUTLINE
1 - EXPLORING THE REPORT BUILDER ENVIRONMENT
Introducing the Report Builder Environment
Working with Existing Reports
Lab: Exploring the Report Builder Application

2 - ADDING DATA TO TABLE REPORTS
Create Report Data Sources
Create Report Datasets
Work with the Tablix Data Region
Create a Table Report
Lab: Creating Table Reports

3 - FORMATTING DATA AND CREATING EXPRESSIONS IN REPORTS
Formatting Reports
Sorting and Filtering Report Data
Adding Data to a Dataset
Creating Simple Expressions
Creating Complex Expressions
Lab: Formatting Reports

4 - GROUPING REPORT DATA
Group Data in Reports
Group Data Using an Expression
Creating Subgroups and Group Aggregates
Lab: Creating Reports with Groups and Aggregates

5 - MATRIX REPORTS
Creating and Modifying Matrix Data Regions
Creating and Modifying Column Groups
Lab: Creating Matrix Reports

6 - CHARTS
Create and Modify Chart Wizard Reports
Add Charts to Existing Reports
Modify Charts in Reports
Lab: Creating Charts and Chart Reports

7 - PRINTING AND EXPORTING REPORTS
Print Features and Print Options
Export Reports
Lab: Printing and Exporting Reports

Actual course outline may vary depending on offering center. Contact your sales representative for more information.