Microsoft Report Builder Training Course

Standard duration: 2 Days
Email course link

Customise this course for your team

We can tailor your syllabus to take into account your group's current skills, technology stack, and specific learning goals - as part of a wider training programme or as a standalone workshop.

Enquire now to find out about our cost-effective options:

Microsoft Report Builder Training Course

"Trainer gave good explanations and good demonstration of knowledge which gave me confidence, ppt is clear and easy to follow"

Root Cause Analysis Training Course
Anon, Business Analyst
Glencore

"I enjoyed the detailed explanations along with good communication during the course."

Root Cause Analysis Training Course
Anon, Business Analyst
Glencore

"One of the best courses that i have undergone in RCA"

Root Cause Analysis Training Course
Anon, Business Analyst
Glencore

About the course:

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

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 and/or Power BI Server 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.

Trusted by:

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

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

Public Courses Dates and Rates

Standard duration: 2 Days

Please get in touch for pricing and availability.

Interested in this course?

If you want to explore how you can tailor this course for your organisation, want to sign up for our newsletter, or have any other questions then please speak to us on 020 3137 3920 or get in touch using this form.

This form requires javaScript to work, please email us at webenquiries@frameworktraining.co.uk if you do not have it enabled.

First Name*

Last Name*

Email*

Phone Number*

Company*

Subject/Tech*

Your message*

Where did you first hear about us?

Get in touch

We use cookies on our website to provide you with the best user experience. If you're happy with this please continue to use the site as normal.
For more information please see our Privacy Policy.

I understand

Ready to take your skills to the next level?

Microsoft Report Builder Training Course

Customise this course for your team

About the course:

Trusted by:

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

Connecting to Data

Retrieving Data

Designing Reports

Manipulating Data Sets

Enhancing Basic Reports

Saving, Sharing and Printing Reports

Public Courses Dates and Rates

Interested in this course?

Related courses