Advanced SSRS and Report Builder Level 2 Course (Microsoft 55128)

Advanced Report Builder and SSRS skills are what separate a basic table from a report people genuinely use. Parameters, subreports, drilldowns and indicators turn static output into interactive reports that answer questions on the spot, which is exactly what business analysts, data analysts and database professionals are asked to deliver. Holding both Level 1 and Level 2 skills shows you can build complete, professional reporting solutions rather than simple lists.

With Logitrain this course is instructor led and hands on, delivered live in real time whether you attend in person or online. You keep your digital course material for ongoing reference, practise questions are included to reinforce the key concepts, and the price beat guarantee means if you find the same course advertised for less we will beat it. You can train in person in Melbourne, Sydney and Brisbane, in person on request in Adelaide, Perth and Canberra, or live online anywhere in Australia, with full time, part time weeknight and part time weekend timings to suit your schedule.

Before this course you should already be able to build, format and group basic reports in Report Builder and SSRS. The recommended starting point is the SSRS and Report Builder Level 1 course (Microsoft 55123), or equivalent hands on experience.

Basic knowledge of Microsoft Windows is assumed, along with some familiarity with basic database concepts. No programming experience is required.

There is no certification exam associated with this course.

The Logitrain 55128 Writing Reports with Report Builder and SSRS Level 2 course material is included in digital format for flexibility and ease of use.

After this course you will be able to:

• Create single value and multi value parameter reports, with default and available values
• Build list data region reports, including multi column and nested data layouts with rectangles
• Apply conditional formatting to data and use complex expressions in charts
• Calculate running values and create Top N reports for groups and datasets
• Add images to reports and retrieve images stored in a database
• Add subreports and parameterised subreports, and use the SSRS Report Server
• Add drilldown functionality to text boxes, groups and group hierarchies
• Add drillthrough and parameterised drillthrough navigation
• Add and modify sparklines, data bars and indicators to summarise data visually

This course is likely to add to the employment-related skills of the participants. The skills developed are likely to be used in the course of being an employee or working in a business.

This course suits report authors who want advanced, interactive reporting skills, including:

• Existing Report Builder and SSRS report authors
• People who have completed Level 1 or have equivalent report building experience
• Report Designer users
• Business analysts and programmer analysts
• Data analysts
• Database administrators
• IT professionals who build interactive business reports

• Parameter Reports: creating and modifying report parameters, default and available values, and single value and multi value parameter reports
• List Data Regions: building list region reports, multiple column reports, and reports with rectangles and nested data
• Enhancing Reports with Complex Expressions: conditional formatting, complex expressions in charts, running values, Top N reports and row banding
• Images and Subreports: adding images, retrieving images from a database, the SSRS Report Server, and adding subreports and parameterised subreports
• Drilldown and Drillthrough Reports: adding drilldown to text boxes, groups and hierarchies, and adding drillthrough and parameterised drillthrough navigation
• Sparklines, Data Bars and Indicators: adding and modifying sparklines, data bars and indicators to present data at a glance

These related courses and programs sit either side of Level 2:

• SSRS and Report Builder Level 1 course (Microsoft 55123): the prerequisite foundation course, recommended before this one.
• Microsoft training courses: the full category this course belongs to.
• Tableau training courses: a related data visualisation and reporting skill set.
• Data Analytics Job Ready Program: training, internship and career counselling for a data career.

Got a team to train? Logitrain can deliver the Microsoft 55128 Report Builder and SSRS Level 2 course in house at your premises anywhere in Australia, with the same features as the public course, including a skilled and experienced trainer, digital course material and practise questions. In house delivery suits teams who want everyone trained together on dates that suit the business, with the content tuned to your data and reports. Contact us to plan a schedule and group size that works for you.

What is Microsoft course 55128?

It is the Level 2 course in the Writing Reports with Report Builder and SSRS series. It teaches advanced, interactive reporting, including parameters, list regions, subreports, drilldowns and indicators.

Do I need to complete Level 1 first?

It is strongly recommended. You should be able to build, format and group basic reports before this course. The Level 1 course (55123) is the recommended starting point, or equivalent hands on experience.

Is there a certification exam for this course?

No. Microsoft 55128 is a training course with no associated certification exam. You receive a Certificate of Attendance and keep your digital course material.

What is the difference between Level 1 and Level 2?

Level 1 covers the foundations such as tables, matrices, formatting, grouping and charts. Level 2 covers advanced techniques such as parameters, list regions, subreports, drilldowns, drillthroughs and indicators.

How long is the course?

The full time course runs over two days. Delivered part time it runs over two weeks.

Where can I take the course?

You can train in person in Melbourne, Sydney and Brisbane, in person on request in Adelaide, Perth and Canberra, or live online anywhere in Australia, with every session delivered live in real time by a trainer.