SQL Server: Reporting Services

Course details

Get an introduction to Reporting Services, one of the core add-on components to SQL Server. With Reporting Services, you can create report frameworks that incorporate data tables, charts, maps, and other visualizations to help make sense of the data stored in a database. Instructor Adam Wilbert shows you how to configure all of the components and add them to traditional paginated reports, and how to organize those reports on a centralized web portal.

Learning objectives
Build a report.
Manipulate data.
Create charts.
Create visualizations.
Create a dashboard.

Concepts

0. Introduction

01 - Present SQL data with Reporting Services
02 - What you should know

1. Get Started with SSRS

03 - What is SQL Server Reporting Services (SSRS)
04 - Installing SSRS
05 - Install a SQL Server instance for the report server
06 - Configure the report server
07 - Set up the example database
08 - Access the web portal
09 - Install Report Builder

2. Build Your First Report

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

3. Work with Data

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

4. Build Interactive Reports

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

5. Create Charts

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

6. Additional Data Visualizations

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

7. Improve the Presentation

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

8. Build a Web Portal Dashboard

44 - Add a key performance indicator (KPI)
45 - Create a dynamic KPI
46 - Organize the web portal with folders
47 - Customize the web portal branding
48 - Create an SSRS user account
49 - Subscribe to a report
50 - Save report snapshots with historical data

Conclusion

51 - Next steps