close

close

Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.

close

close

Press esc to close

close close

Back to course information

Thank you for your enquiry!

One of our training experts will be in touch shortly to go overy your training requirements.

close close

Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.

Course Information

Analyzing Data with SQL Server Reporting Services Course Outline | SQL Training | M10990

This course includes the following modules:

Module 1: Introduction to Reporting Services

This module introduces Microsoft SQL Server Reporting Services, its components, and the tools used to work with it.

Lessons:

  • Introduction to reporting services
  • Reporting services components
  • Reporting services tools

Lab: Exploring reporting services

  • Exploring reports
  • Reporting services configuration

Module 2: Reporting Services Data Sources

Almost every report published by using SQL Server Reporting Services (SSRS) is built using data obtained from one or more source systems. This lesson explains how to configure SSRS to interact with source data systems by working with data sources.

Lessons:

  • Data sources
  • Connection strings
  • Datasets

Lab: Configuring data access with report builder

  • Configuring data access with report builder

Lab: Configuring data access with report designer

  • Configuring data access with report designer

Module 3: Creating Paginated Reports

In this module, delegates will discover how to create reports. This module demonstrates how to create different types of reports in both applications, in addition to using the Report Wizard.

Lessons:

  • Creating a report with the report wizard
  • Creating a report
  • Publishing a report

Lab: Creating reports

  • Use the report wizard – report designer
  • Use the report wizard – report builder
  • Creating and publishing a report – report designer
  • Creating and publishing a report – report builder

Module 4: Working with Reporting Services Data

It is common for business requirements to change regarding the information they need and how they want data presented. On viewing a detailed report, senior management might ask for higher level, summarised, or filtered versions of the same report. Report Builder and Report Designer support these scenarios via filtering, sorting, drilldowns, grouping and the parameterising of reports. In this module, delegates will learn how to use filters and parameters to make reports more dynamic and useful to business users.

Lessons:

  • Data filters
  • Report parameters
  • Implementing report filters and parameters

Lab: Create a parameterised report

  • Using parameters in report designer
  • Using parameters in report builder

Module 5: Visualising Data with Report Services

As the amount of data being generated continues to grow, the need to make sense of its meaning increases. Delegates will use data visualisation to make data easier to understand, and faster to interpret. Data visualisations highlight comparisons, show trends, and convey scale much faster than a table of numbers could. The detail is important, but visualisations are a highly effective way of conveying meaning and insights quickly and accurately.

Lessons:

  • Formatting data
  • Images and charts
  • Databars, sparklines, indicators, gauges, and maps

Lab: Manage formatting

  • Report designer
  • Report builder

Module 6: Summarising Report Data

In this module, delegates will learn how to create group structures, summarise data, and provide interactivity in your reports, so that users see the level of detail or summary that they need.

Lessons:

  • Sorting and grouping
  • Report sub-reports
  • Drilldown and drill through

Lab: Summarising report data

  • Sorting and grouping in report builder
  • Sorting and grouping in report designer

Module 7: Sharing Reporting Services Reports

This module covers report scheduling, caching, and the report life cycle, and automatic subscription and delivery of reports.

Lessons:

  • Schedules
  • Report caching, snapshots, and comments
  • Report subscription and delivery

Lab: Sharing reporting services reports

  • Create a shared schedule
  • Configure caching
  • Subscribe to a report

Module 8: Administering Reporting Services

System administrators take responsibility for the configuration and day-to-day operations of IT systems. In SQL Server Reporting Services (SSRS), administrative tasks include the configuration of the web portal and web service, branding the web portal, and ensuring that access to sensitive reports is carefully controlled. Administrators also monitor and optimize performance.

Lessons:

  • Administering reporting services
  • Reporting services configuration
  • Reporting services performance

Lab: Administering reporting services

  • Authorise access to reports
  • Web portal branding

Module 9: Extending and Integrating Reporting Services

Although Reporting Services is a powerful tool, its built-in capabilities might not always meet requirements. This module covers the methods for extending the functionality of Reporting Services with expressions and custom code. Delegates will also learn about the methods for working with Reporting Services programmatically, and integrating Reporting Services reports into other applications.

Lessons

  • Expressions and embedded code
  • Extending reporting services
  • Integrating reporting services

Lab: Extending and integrating reporting services

  • Custom code – report designer
  • Custom code – report builder
  • URL access

Module 10: Introduction to Mobile Reports

This module introduces the design and publication of reports that are intended for consumption on mobile devices, such as smartphones and tablets. Microsoft SQL Server Reporting Services (SSRS) includes support for mobile reports, although the tools that are used to design and publish mobile reports are different to the tools used for the paginated reports discussed in the earlier modules of this course.

Lessons:

  • Overview of mobile reports
  • Preparing data for mobile reports
  • Mobile report publisher

Lab: Introduction to mobile reports

  • Format data for a mobile report
  • Create a mobile report
  • Create KPIs

Module 11: Developing Mobile Reports

In this module, delegates will learn about the element types that can be added to Microsoft SQL Server Reporting Services mobile reports. Delegates will also learn about working with dataset parameters, and how to add drillthrough actions to your reports.

Lessons

  • Designing and publishing mobile reports
  • Drillthrough in mobile reports

Lab: Developing mobile reports

  • Add a dataset with parameters
  • Design a mobile report
  • Publish a mobile report
  • Add a drillthrough to a custom URL

Show moredowndown

Who Should Attend this Course?

The primary audience for this course is database professionals who need to undertake a BI developer role to create reports. Primary responsibilities include implementing reports and creating mobile reports.

The secondary audiences for this course are power information workers. 

Prerequisites

Before attending this course, delegates should possess or be able to demonstrate:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality
  • Working knowledge of Transact-SQL 

Analyzing Data with SQL Server Reporting Services Training | SQL Training | M10990

This 5-day course is designed to help delegates learn how to implement an SQL Server 2016 Reporting Services solution for data analysis in an organisation. The course discusses how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions.

This Analysing Data with SQL Server Reporting Services course is fully accredited by Microsoft through the Microsoft Silver Partnership held by The Knowledge Academy.

After completing this course, delegates will be able to:

  • Describe Reporting Services and its components
  • Describe Reporting Services data sources
  • Implement paginated reports
  • Work with Reporting Services data
  • Visualise data with Reporting Services
  • Aggregate report data
  • Share reporting services reports
  • Administer Reporting Services
  • Expand and integrate Reporting Services
  • Describe mobile reports
  • Develop mobile reports​​

Show moredowndown

What's Included?

  • Delegate pack consisting of course notes and exercises
  • Manual
  • Experienced Instructor
  • Refreshments

 

Show moredowndown

Why choose us

Ways to take this course

Our easy to use Virtual platform allows you to sit the course from home with a live instructor. You will follow the same schedule as the classroom course, and will be able to interact with the trainer and other delegates.

Our fully interactive online training platform is compatible across all devices and can be accessed from anywhere, at any time. All our online courses come with a standard 90 days access that can be extended upon request. Our expert trainers are constantly on hand to help you with any questions which may arise.

This is our most popular style of learning. We run courses in 1200 locations, across 200 countries in one of our hand-picked training venues, providing the all important ‘human touch’ which may be missed in other learning styles.

best_trainers

Highly experienced trainers

All our trainers are highly qualified, have 10+ years of real-world experience and will provide you with an engaging learning experience.

venues

State of the art training venues

We only use the highest standard of learning facilities to make sure your experience is as comfortable and distraction-free as possible

small_classes

Small class sizes

We limit our class sizes to promote better discussion and ensuring everyone has a personalized experience

value_for_money

Great value for money

Get more bang for your buck! If you find your chosen course cheaper elsewhere, we’ll match it!

This is the same great training as our classroom learning but carried out at your own business premises. This is the perfect option for larger scale training requirements and means less time away from the office.

tailored_learning_experience

Tailored learning experience

Our courses can be adapted to meet your individual project or business requirements regardless of scope.

budget

Maximise your training budget

Cut unnecessary costs and focus your entire budget on what really matters, the training.

team_building

Team building opportunity

This gives your team a great opportunity to come together, bond, and discuss, which you may not get in a standard classroom setting.

monitor_progress

Monitor employees progress

Keep track of your employees’ progression and performance in your own workspace.

What our customers are saying

Frequently asked questions

FAQ's

Please arrive at the venue at 8:45am.
Before attending this course, delegates should possess or be able to demonstrate: Basic knowledge of the Microsoft Windows operating system and its core functionality Working knowledge of Transact-SQL
The primary audience for this course is database professionals who need to undertake a BI developer role to create reports. Primary responsibilities include implementing reports and creating mobile reports. The secondary audiences for this course are power information workers.
We are able to provide support via phone & email prior to attending, during and after the course.
Delegate pack consisting of course notes and exercises, Manual, Experienced Instructor, and Refreshments
This course is 5 day(s)
Once your booking has been placed and confirmed, you will receive an email which contains your course location, course overview, pre-course reading material (if required), course agenda and payment receipts
The price for Analyzing Data with SQL Server Reporting Services M10990 certification in the United States starts from $3395
The Knowledge Academy is the Leading global training provider in the world for Analyzing Data with SQL Server Reporting Services M10990.

Why choose us

icon

Best price in the industry

You won't find better value in the marketplace. If you do find a lower price, we will beat it.

icon

Trusted & Approved

Microsoft Silver Learning Partner

icon

Many delivery methods

Flexible delivery methods are available depending on your learning style.

icon

High quality resources

Resources are included for a comprehensive learning experience.

barclays Logo
deloitte Logo
Thames Water Logo

"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"

Joshua Davies, Thames Water

santander logo
bmw Logo
Google Logo
Shell Logo

"...the trainer for this course was excellent. I would definitely recommend (and already have) this course to others."

Diane Gray, Shell

Looking for more information on Microsoft SQL Server Training?

backBack to course information

Get a custom course package

We may not have any package deals available including this course. If you enquire or give us a call on 646-687-6780 and speak to our training experts, we should be able to help you with your requirements.