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

Course Description

This course provides students with the knowledge necessary to develop reports using Microsoft Report Builder 3.0. The training environment includes SQL 2008R2, SQL 2012, and SQL 2014 Standard and Enterprise, so students can use Report Builder 3.0 and generate reports from multiple sources to investigate the different features of each version.

The course covers Report Builder 3.0 wizards, basics of report design, intermediate reports with report parameters, a detailed section exploring report expressions and how to configure them correctly, filters, report visualizations including charts, tables, images and meters, advanced reports including the use of maps, interactive reports, report parts, subreports, subscriptions and export options.

Audience profile

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

Goals

  • Plan reports.
  • Use Report Builder 3.0 and understand the interface parts.
  • Launch Report Builder 3.0 from multiple sources.
  • Understand management options.
  • Create embedded data sets and data sources.
  • Create shared data sources and data sets.
  • Create shared data sources and data sets.
  • Understand and use the Table or Matrix Wizard.
  • Understand and use the Chart Wizard.
  • Understand and use the map wizard.
  • Understand and use lists.
  • Understand and use tables.
  • Understand and use matrices.
  • Understand and use data regions.
  • Understand and use parameters.
  • Understand and use expressions.
  • Understand and use the parts of the report.
  • Understand and use formatting options.
  • Understand display options.
  • Understand and use graphics.
  • Understand and use sparklines.
  • Understand and use indicators.
  • Understand and use maps.
  • Understand filtering, grouping, and sorting.
  • Understand and use dynamic headers and footers.
  • Understand and use report templates.
  • Understand and use HTML and text boxes.
  • Understand and use lists as containers.
  • Understand and use subreports.
  • Understand report subscription options.
  • Understand security


Course outline

Module 1: Course Summary

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

Lessons

  • Introduction
  • Course materials
  • Facilities
  • previous requirements
  • What we will be discussing

Laboratory 1: Course Summary

  • None
After completing this module, students will be able to:
  • Successfully log in to your virtual machine.
  • Have a complete understanding of what the course aims to cover.

Module 2: Introduction to Report Builder 3.0

This module introduces the Report Builder 3.0 interface, the different features available, and variations in data sources and sets.

Lessons

  • Planning your reports
  • Understand variations between SQL versions
  • Exploring the Report Builder 3.0 interface
  • management exam
  • Use of data sources
  • Work with data sets

Lab 1: Introduction to Report Builder 3.0

  • Explore the Report Builder 3.0 interface
  • Create a data source built into SQL Engine 2014
  • Create an integrated data source in SQL 2014 Analysis Services
  • Create a shared data source using Report Manager
  • Create a shared data set using the shared data source
After completing this module, students will be able to:
  • Plan reports.
  • Use Report Builder 3.0 and understand the interface parts.
  • Launch Report Builder 3.0 from multiple sources.
  • Understand management options.
  • Create embedded data sets and data sources.
  • Create shared data sources and data sets.

Module 3: Report Builder 3.0 Wizards

This module covers the basics of reporting that explores lists, arrays, and tables along with wizards. Data regions will also be explained.

Lessons

  • Table or Matrix Exploration Wizard
  • Using the Chart Wizard
  • Working with the Map Wizard

Lab 1: Report Builder 3.0 Wizards

  • Create five shared data sources and two shared data sets
  • Use the Table or Matrix Wizard
  • Use the Chart Wizard
  • Use the map wizard
After completing this module, students will be able to:
  • Create shared data sources and data sets.
  • Understand and use the Table or Matrix Wizard.
  • Understand and use the Chart Wizard.
  • Understand and use the map wizard.

Module 4: Report Builder 3.0 Basic Reports

In this module we examine parameters, filters, and the expressible aspect of reports. We also cover formatting options.

Lessons

  • Using lists
  • Use of tables
  • Exploring matrix
  • Domain data region(s)
  • Examining Parameters
  • Work with expressions
  • Description of the parts of the report
  • Report formatting

Lab 1: Report Builder 3.0 Basic Reports

  • 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 data set
  • Create parameters using a data set as a filter
  • Using expressions in your report
  • Creating a report using report elements
  • Report format
After completing this module, students will be able to:
  • Understand and use lists.
  • Understand and use tables.
  • Understand and use matrices.
  • Understand and use data regions.
  • Understand and use parameters.
  • Understand and use expressions.
  • Understand and use the parts of the report.
  • Understand and use formatting options.

Module 5: Report Builder 3.0 Charts

This module is an in-depth look at charts, including charts, images, sparklines, data bars, gauges, and Bing maps.

Lessons

  • Understanding visualizations
  • using graphics
  • Exploring calibers
  • Examining maps

Lab 1: Report Builder 3.0 Charts

  • Using sparklines in a report
  • Report Builder chart borders, titles, and legends
  • Linear indicators
  • Basic maps
  • Basic Maps with Color
After completing this module, students will be able to:
  • Understand display options.
  • Understand and use graphics.
  • Understand and use sparklines.
  • Understand and use indicators.
  • Understand and use maps.

Module 6: Interim reports

This module covers interim reporting with an emphasis on actionable reports and a section exploring subscriptions and report security.

Lessons

  • Filtering, Grouping and Sorting
  • Using dynamic headers and footers
  • Viewing your company's report templates
  • Understanding HTML5 and text boxes
  • Using the list object to combine other elements
  • Creating subreports and detailed reports
  • Exploring subscriptions
  • examining security

Laboratory 1: Interim reports

  • Report header and footer
  • Creating report templates
  • Embed HTML in a text box
  • Lists as Containers
  • Subreports
After completing this module, students will be able to:
  • Understand filtering, grouping, and sorting.
  • Understand and use dynamic headers and footers.
  • Understand and use report templates.
  • Understand and use HTML and text boxes.
  • Understand and use lists as containers.
  • Understand and use subreports.
  • Understand report subscription options.
  • Understand security.

Module 7: Report Builder 3.0 Tips and Tricks

This module is optional and contains 20 tips and tricks with step-by-step instructions.

Lessons

  • None

Lab 1: Report Builder 3.0 Tips and Tricks

  • None
After completing this module, students will be able to:
  • Use what you have learned throughout this course.


Previous requirements

A basic understanding of relational databases.


Language

  • English course

  • Labs: English

€695.00
| /

Información relacionada a la formación

Soporte siempre a tu lado

Soporte de formación: Siempre a tu lado

Formación presencial y telepresencial

¿Necesitas otra modalidad formativa?

bonificaciones

Bonificaciones para empresas