Report Builder 3 Training Course

About the course:

Learn to extract value from your data using Report Builder 3

Our Report Build 3 training course is a comprehensive introduction to creating useful reports on varied datasets using Microsoft Report Builder 3.0.

Report Builder 3 is a tool designed for data analysts who need to create and publish engaging business reporting solutions built upon SQL Server Reporting Services, who do not necessarily wish to use Microsoft Business Intelligence Development Studio (BIDS) - which is itself based on Visual Studio.

A Report Builder report can only be created when the appropriate data is available, so the course also includes accessing data using Transact SQL statements, as well as other available tools.

During the course you will gain valuable hands-on experience delivering commercial-quality report solutions, led by an expert SQL Server instructor.

In a nutshell Who should attend On-site Syllabus

By the end of this course, you will have learnt:

Introduction to Report Builder
Connecting to Data
Retrieving Data
Designing Reports
Manipulating Data Sets
Enhancing Basic Reports
Saving, Sharing and Printing Reports

Who should attend

The course is designed for experienced Excel, Access and other Relational Database users wanting to create reports for use with Microsoft Reporting Services without using BIDS.

Prerequisites

Delegates should ideally have a good degree of experience manipulating and presenting data within Microsoft Excel and / or Microsoft Access. Practical knowledge of SQL would be useful too. Other equivalent Relational Database experience (such as Oracle, MySQL) should also be sufficient.

On-site

If you would like to find out about custom / on-site Report Builder 3 training for any size of team, please get in touch – we would be glad to help build a course that meets your learning requirements.

We can take into account your existing technical skills, project requirements and timeframes, and specific topics of interest to tailor the most relevant and focussed course for you.

This can be particularly useful if you need to learn just the new features and Best Practices with Reoprt Builder 3 if you're coming from an earlier version, or need to include extra topics to help with prerequisite skills.

Report Builder 3 Training Course

Introduction to Report Builder 3

Getting to know Report Builder
Overview of tools and functions

Connecting to Data

Types of Data Sources
Shared Data Sources
Report-specific Data Sources
Data Source credentials

Retrieving Data

Data Sets
Query Designer
Stored Procedures

Designing Reports

Report and page properties
Headers and Footers
Data regions
Matrices
Lists
Charts
Gauges
Maps
Other Report Items
Text boxes
Sub Reports
Formatting Report items

Manipulating Data Sets

Sorting Data
Grouping Data
Using parameters with your Data
Creating and using parameters in your Data
Setting default values for parameters
Creating parameter lists
Calculations
Filters

Enhancing Basic Reports

Report item visibility
Interactive sorting
Expressions
Display Report information and parameters
Values
Highlighting Exceptions in Data
To stripe Data rows
Document maps

Saving, Sharing and Printing Reports

Saving local Reports
Sharing Reports
- to a Report Server
- to a SharePoint site
Viewing, printing and exporting Reports from a Report Server or SharePoint
Creating Report subscriptions

"Mixture of lecture and tutorial content. "Learn by doing""

Data Science with Python Training Course
JD, Data Scientist
Winton Capital

" Course was very relevant, and all the basic topics were covered. Good pace. "

Data Science with Python Training Course
MFA, Data Analyst [Remote online course]
ActiveViam

" The Jupyter notebooks were really handy, and I liked the group work using the breakout room feature of Zoom. Although the participants were from different backgrounds, Marco handled this very well by constantly checking if anyone has questions, adding explanations and making sure that the pace is right for the group. "

Data Science with Python Training Course
FSK, Data Analyst [Remote online course]
ActiveViam

" It was very good. In particular the separated chat rooms used for some of the exercises worked very well. "

Data Science with Python Training Course
JHO, Data Analyst [Remote online course]
ActiveViam

"The pace of the course and the instructor's flexibility meant we were able to cover a lot of ground, all of which was directly relevant to our upcoming projects. A number of different Big Data solutions were explored."

Hadoop Training Course
NB, Senior Analyst
University of Oxford

Report Builder 3 Training Course

Course overview

Tailor this course for your business

About the course:

Learn to extract value from your data using Report Builder 3

By the end of this course, you will have learnt:

Who should attend

Prerequisites

On-site

Report Builder 3 Training Course

Introduction to Report Builder 3

Connecting to Data

Retrieving Data

Designing Reports

Manipulating Data Sets

Enhancing Basic Reports

Saving, Sharing and Printing Reports

We would love to hear from you

Report Builder 3 Training Course

Course overview

Tailor this course for your business

About the course:

Learn to extract value from your data using Report Builder 3

By the end of this course, you will have learnt:

Who should attend

Prerequisites

On-site

Report Builder 3 Training Course

Introduction to Report Builder 3

Connecting to Data

Retrieving Data

Designing Reports

Manipulating Data Sets

Enhancing Basic Reports

Saving, Sharing and Printing Reports

Related courses

We would love to hear from you