fbpx

Microsoft 55123: Writing Reports with Report Builder and SSRS Level 1

Microsoft 55123 Writing Reports with Report Builder and SSRS Level 1 Course

Microsoft 55123 Writing Reports with Report Builder and SSRS Level 1 Training

The Microsoft 55123 training course covers the foundations of report writing with Microsoft SQL Server Report Builder and SSRS.

The focus of the Microsoft 55123 Writing Reports with Report Builder and SSRS Level 1 training course is on report writing by connecting to a database and manipulating the data for presentation.

The training course includes creating table and matrix reports, formatting reports, grouping report data, creating simple and complex expressions, displaying aggregated data, sorting and filtering data, charting data, and preparing reports for printing and exporting.

Basic knowledge of Microsoft Windows.

There is no certification exam associated with this course.

Logitrain 55123 Writing Reports with Report Builder and SSRS Level 1 course material

  • Navigate the Report Builder Environment
  • Create table reports
  • Format reports
  • Create basic and complex expressions
  • Group report data
  • Create matrix reports
  • Sort and filter data
  • Summarize data with charts
  • Print and export reports

 

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.

  • Report Builder and SSRS report authors
  • Report Designer
  • Business analysts
  • Programmer analysts
  • Data analysts
  • Database administrators
  • IT professionals
  • Exploring the Report Builder Environment
  • Introducing the Report Builder Environment
  • Working with Existing Reports
  • Exploring the Report Builder Application
  • Navigating the Ribbon and Window panes
  • View Existing Reports in Design and Run modes
  • Describe and navigate the graphical elements of the Report Builder application
  • Work with existing reports and navigate between Design and Run modes
  • Adding Data to Table Reports
  • Create Report Data Sources
  • Create Report Datasets
  • Work with the Tablix Data Region
  • Create a Table Report
  • Creating Table Reports
  • Create Queries Using the Report Builder Query Designer
  • Create Queries Using the Report Builder Query Designer
  • Create Table Relationships Using Query Designer
  • Create a Table Report Using Multiple Tables
  • Create report data sources
  • Create report datasets
  • Work with the tablix data region
  • Create a table report
  • Formatting Data and Creating Expressions in Reports
  • Formatting Reports
  • Sorting and Filtering Report Data
  • Adding Data to a Dataset
  • Creating Simple Expressions
  • Creating Complex Expressions
  • Formatting Reports
  • Format Tablix Columns
  • Format Data in a Tablix Cell Using Properties
  • Format Data in a Tablix Cell Using Simple and Complex Expressions
  • Sort Data Using Expressions
  • Use Simple and Complex Expressions to Display Data in a Tablix
  • Format data in a report using the Report Builder Properties dialog boxes
  • Add data to a report and make changes to column names in the dataset query
  • Format data in a report using simple and complex expressions
  • Display data in a report using simple and complex expressions
  • Grouping Report Data
  • Group Data in Reports
  • Group Data Using an Expression
  • Creating Subgroups and Group Aggregates
  • Creating Reports with Groups and Aggregates
  • Display Grouped Data in a Report
  • Create a Group Hierarchy in a Report
  • Group Data Using a Complex Expression
  • Add Aggregates to Tablix Rows
  • Configuring a Reference Image
  • Group data in reports using fields
  • Group data in reports using expressions
  • Create group hierarchies
  • Aggregate grouped data in a report
  • Creating and Modifying Matrix Data Regions
  • Creating and Modifying Column Groups
  • Creating Matrix Reports
  • Create Matrix Reports
  • Create Column Groups
  • Use Expressions to Sort Group Data
  • Use Expressions to Display Group Names
  • Create Matrix Reports with Group Hierarchies
  • Describe the key features of using a matrix in a report
  • Create and modify matrix reports
  • Define column group hierarchies
  • Use expressions to define matrix headings and sort orders
  • Create and Modify Chart Wizard Reports
  • Add Charts to Existing Reports
  • Modify Charts in Reports
  • Creating Charts and Chart Reports
  • Create a Chart Wizard Report
  • Add a Chart to an Existing Report
  • Use Expressions in Charts
  • Use Expressions in Charts
  • Describe the key features of charts
  • Create charts using the Chart Wizard and the Ribbon
  • Modify chart data and the formatting of chart elements
  • Use expressions in charts
  • Print Features and Print Options
  • Export Reports
  • Printing and Exporting Reports
  • Exploring Page Layout view, Report Formatting, and Page Setup Options
  • Exporting Reports
  • Describe the key features of electronic reporting vs print reporting
  • Prepare a report for paper printing
  • Export reports in supported formats
Get our expert trainers at your premises. Logitrain Customised Team can tailor the course to meet your organisation's specific learning and development needs and business goals.
  • This field is for validation purposes and should be left unchanged.
Learn More
  • This field is for validation purposes and should be left unchanged.

What is included with the Microsoft 55123 Writing Reports with Report Builder and SSRS Level 1 Course?

Logitrain course includes official certification exam fee.
Certificate of Attendance

Get a Certificate of Attendance to prove your commitment to learning

Logitrain is an Authorised Pearson VUE Test Centre.
No Exam Required

This training course does not have any exam associated with it

Logitrain courses, programs and packages includes course material.
Includes Books & Meals

Course material in hardcopy is included. Full-time classroom courses include meals

Logitrain courses, packages and programs includes sample practise questions.
Includes Practise Questions

Practise questions are provided for better understanding of the key concepts

Logitrain full-time course includes course retake, if you do not pass the official certification exam.
Instructor-led Training

Attend the course with an instructor at our training center or from anywhere

Logitrain courses include price beat guarantee.
Our Price Beat Guarantee

Relax, we will beat competitor’s advertised price. Our course has no extra costs

Dates, Locations & Prices
Logitrain Live Online Training Banner

Location Type Duration Price Dates
Location Type Duration Price Dates

The supply of this course/package/program is governed by our terms and conditions. Please read them carefully before enrolling, as enrolment is conditional on acceptance of these terms and conditions.

OUR ACCREDITATIONS

Find out why we are the leading choice to help boost your career

Prepare to get IT job ready in 8 weeks

Trained 8000+ professionals and counting

Experienced Provider: Operating Since 2004

Trained staff from 1000+ Australian Businesses

We Have Placed Candidates In
SATISFIED CUSTOMERS
SOME OF OUR CLIENTS

Over 1000 organisations have relied on Logitrain to be their trusted training partner.

High-quality, cost-effective training since 2004
Learn More
  • This field is for validation purposes and should be left unchanged.

Dont’ Wait. Fill the form for a free no-obligation information session with our course specialists.

Delivering Classroom and Live Instructor-led Training. Attend at our premises or from anywhere on any device.

COVID discounts on Job Programs end soon, register today.

Open chat