Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

SQL Server: Reporting Services

via LinkedIn Learning

Overview

Discover how to build, edit, and publish interactive reports using Reporting Services in SQL Server.

Syllabus

Introduction
  • Present SQL data with Reporting Services
  • What you should know
  • Set up the example database
1. Get Started with SSRS
  • What is SQL Server Reporting Services (SSRS)?
  • Install SSRS
  • Configure the report server
  • Access the web portal
  • Install Report Builder
2. Build a First Report
  • Components of a report
  • Create a report data source
  • Create a dataset
  • Add a data table with the wizard
  • Joining data tables
  • Format a report
  • Reviewing report properties
  • View, print, and export a report
3. Work with Data
  • Create a shared data source
  • Create a shared dataset
  • Filtering data
  • Grouping data in a report
  • Understand matrixes
  • Use aggregate functions
4. Build Interactive Reports
  • Convert filters into parameters
  • Report parameter properties
  • Make a dynamic report title
  • Add a parameter manually
  • Report actions
  • Sort records in a table
5. Create Charts
  • Introduction to charts
  • Create a chart
  • Add additional data series
  • Format charts
6. Additional Data Visualizations
  • Gauges
  • Indicators
  • Data bars
  • Create a sparkline dataset
  • Display a sparkline
  • Maps
7. Improve the Presentation
  • Include header and footer details
  • Add graphics and logos
  • Align page elements
  • Insert page breaks
8. Build a Web Portal Dashboard
  • Add a key performance indicator (KPI)
  • Create a dynamic KPI
  • Organize the web portal with folders
  • Customize the web portal branding
9. Mobile Report Publisher
  • What is Mobile Report Publisher?
  • Tour Mobile Report Publisher
  • Exploring visuals and themes
  • Connect visuals to data
  • Add a time chart
  • Create device-specific layouts
  • View reports in the Power BI mobile app
10. SSRS Tips and Tricks
  • Reuse report parts
  • Subscribe to a report
Conclusion
  • Next steps

Taught by

Adam Wilbert

Reviews

4.8 rating at LinkedIn Learning based on 859 ratings

Start your review of SQL Server: Reporting Services

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.