SSRS and Report Builder Level 1 Course (Microsoft 55123)

Report Builder and SSRS remain a core skill for anyone who turns raw data into reports that people across a business can act on. Strong paginated reporting skills sit behind roles in business analysis, data analysis, database administration and IT, and they complement modern tools used alongside SQL Server. Level 1 gives you the dependable foundation, the ability to connect to data and produce accurate, well formatted, presentation ready reports, before you move into the advanced techniques covered at Level 2.

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.

Basic knowledge of Microsoft Windows is all you need, such as creating and navigating folders, opening programs and saving files. No reporting, SQL or programming experience is assumed, which makes this the right starting point for newcomers.

Some familiarity with the SQL SELECT statement is helpful but not required. If you already build basic reports and want the advanced techniques, start instead with the SSRS and Report Builder Level 2 course (Microsoft 55128).

There is no certification exam associated with this course.

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

After this course you will be able to:

• Navigate the Report Builder environment and work between Design and Run modes
• Create report data sources and datasets, and build queries with the Query Designer
• Build table reports using the tablix data region
• Format reports and format data using properties and expressions
• Create basic and complex expressions to display and calculate data
• Group report data, build group hierarchies and add aggregates
• Create and modify matrix reports with column groups
• Sort and filter report data
• Summarise data visually with charts using the Chart Wizard and the ribbon
• Prepare reports for printing and export them in supported formats

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 people who are new to reporting with Report Builder and SSRS, including:

• People new to reporting with Microsoft SQL Server Report Builder and SSRS
• People transitioning from another reporting tool
• Existing Report Builder and SSRS report authors
• Report Designer users
• Business analysts and programmer analysts
• Data analysts
• Database administrators
• IT professionals who produce business reports

• Exploring the Report Builder Environment: the Report Builder application, ribbon and window panes, working with existing reports, and moving between Design and Run modes
• Adding Data to Table Reports: creating data sources and datasets, building queries with the Report Builder Query Designer, table relationships, and the tablix data region
• Formatting Data and Creating Expressions: formatting tablix columns and cells, adding data to a dataset, sorting and filtering, and creating simple and complex expressions
• Grouping Report Data: grouping by fields and expressions, creating group hierarchies, and adding subgroups and group aggregates
• Creating Matrix Data Regions: building matrix reports, defining column group hierarchies, and using expressions for matrix headings and sort orders
• Charts: creating Chart Wizard reports, adding and modifying charts in existing reports, and using expressions in charts
• Printing and Exporting Reports: page layout and page setup, preparing reports for paper printing, and exporting in supported formats

These related courses and programs help you build on Level 1 and plan a wider data and reporting path:

• SSRS and Report Builder Level 2 course (Microsoft 55128): the direct next step, covering parameters, subreports, drilldowns, sparklines and indicators.
• 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.
• Database Job Ready Program: for those heading toward database focused roles.

Is there a certification exam for this course?

No. Microsoft 55123 is a training course with no associated certification exam, so there is no exam to sit and no exam cost. You receive a Certificate of Attendance and keep your digital course material.

How much does SSRS certification cost?

There is no current Microsoft certification exam for SSRS Report Builder, so there is no separate certification fee. You pay only for the training, which is covered by our price beat guarantee.

Is Microsoft Report Builder free?

The Report Builder application itself is a free download from Microsoft. This course is paid instructor led training that teaches you how to use it to build professional reports quickly and correctly.

Should I do Level 1 or Level 2 first?

Start with Level 1 (55123) if you are new to Report Builder and SSRS. Move to Level 2 (55128) once you can build, format and group reports and want parameters, subreports, drilldowns 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.

Do I need SQL or programming experience?

No. You only need basic Microsoft Windows skills. Familiarity with the SQL SELECT statement is helpful but not required.