SQL Server: Reporting Services (2019)

Course details

Discover how to build, edit, and publish interactive reports using Reporting Services in SQL Server. In this course, author Adam Wilbert shows how to create, format, and share reports that leverage a variety of data sources. First, he takes you through the setup process, followed by the step-by-step process of building a report. He covers interactive elements, formatting, charts, sorting, filtering, web viewing, and mobile viewing. Adam also shares best practices, tips, and tricks that you can use to ensure your reports are dynamic.

Learning objectives
What is SQL Server Reporting Services (SSRS)?
Installing and setting up SSRS
Configuring a report server
Joining data tables
Filtering and sorting data
Grouping data in a report
Working with matrixes
Using aggregate functions
Working with parameters
Displaying charts and sparklines
Creating device-specific layouts
Viewing reports in the Power BI mobile app
Reusing report parts

Concepts

0. Introduction

01 - Present SQL data with Reporting Services
02 - What you should know
03 - Set up the example database

1. Get Started with SSRS

04 - What is SQL Server Reporting Services (SSRS)
05 - Install SSRS
06 - Configure the report server
07 - Access the web portal
08 - Install Report Builder

2. Build a First Report

09 - Components of a report
10 - Create a report data source
11 - Create a dataset
12 - Add a data table with the wizard
13 - Joining data tables
14 - Format a report
15 - Reviewing report properties
16 - View, print, and export a report

3. Work with Data

17 - Create a shared data source
18 - Create a shared dataset
19 - Filtering data
20 - Grouping data in a report
21 - Understand matrixes
22 - Use aggregate functions

4. Build Interactive Reports

23 - Convert filters into parameters
24 - Report parameter properties
25 - Make a dynamic report title
26 - Add a parameter manually
27 - Report actions
28 - Sort records in a table

5. Create Charts

29 - Introduction to charts
30 - Create a chart
31 - Add additional data series
32 - Format charts

6. Additional Data Visualizations

33 - Gauges
34 - Indicators
35 - Data bars
36 - Create a sparkline dataset
37 - Display a sparkline
38 - Maps

7. Improve the Presentation

39 - Include header and footer details
40 - Add graphics and logos
41 - Align page elements
42 - Insert page breaks

8. Build a Web Portal Dashboard

43 - Add a key performance indicator (KPI)
44 - Create a dynamic KPI
45 - Organize the web portal with folders
46 - Customize the web portal branding

9. Mobile Report Publisher

47 - What is Mobile Report Publisher
48 - Tour Mobile Report Publisher
49 - Exploring visuals and themes
50 - Connect visuals to data
51 - Add a time chart
52 - Create device-specific layouts
53 - View reports in the Power BI mobile app

10. SSRS Tips and Tricks

54 - Reuse report parts
55 - Subscribe to a report

Conclusion

56 - Next steps