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

Name: 55005BC Microsoft Report Builder 3.0 with SQL 2008R2, SQL 2012, and SQL 2014
Availability: InStock

More payment options

Modality:

Product Options

€695.00

| /

(5.0)

________________________________________________________________

Do you want to take this course remotely or in person?

Contact us by email: info@nanforiberica.com , phone: +34 91 031 66 78, WhatsApp: +34 685 60 05 91 , or contact Our Offices

________________________________________________________________

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

Goals

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

Language

Audience profile

Goals

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

Language

Customer Review

Be the first to leave your opinion

Write your review

Information related to training

Training support: Always by your side

Always by your side

Do you need another training modality?

Self Learning - Virtual - In-person - Telepresence

Bonuses for companies

For companies

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

Do you want to take this course remotely or in person?

Course Description

Module 1: Course Summary

Lessons

Module 2: Introduction to Report Builder 3.0

Lessons

Module 3: Report Builder 3.0 Wizards

Lessons

Module 4: Report Builder 3.0 Basic Reports

Lessons

Module 5: Report Builder 3.0 Charts

Lessons

Module 6: Interim reports

Lessons

Module 7: Report Builder 3.0 Tips and Tricks

Lessons

Module 1: Course Summary

Lessons

Module 2: Introduction to Report Builder 3.0

Lessons

Module 3: Report Builder 3.0 Wizards

Lessons

Module 4: Report Builder 3.0 Basic Reports

Lessons

Module 5: Report Builder 3.0 Charts

Lessons

Module 6: Interim reports

Lessons

Module 7: Report Builder 3.0 Tips and Tricks

Lessons

Write Your Experience

Information related to training

Training support: Always by your side

Do you need another training modality?

Bonuses for companies

Register here to receive invitations to events and other Nanfor activities

Quick links

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

Do you want to take this course remotely or in person?

Course Description

Write Your Experience

Information related to training

Training support: Always by your side

Do you need another training modality?

Bonuses for companies

Register here to receive invitations to events and other Nanfor activities