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

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.

Key features

40 hours of instructor-led training

40 hours of high-quality eLearning content

5 simulation exams (250 questions each)

8 domain-specific test papers (10 questions each)

30 CPEs offered

98.6% pass rate

Report Builder 3 Training Duration:- 2 Days

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 & 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 & 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

Venue is finalized few weeks before the training and you will be informed via email. You can get in touch with our 24/7 support team for more details. Contact us Mob no:- 8447121833, Mail id: [email protected] . If you are looking for an instant support, you can chat with us too.