Udemy, Coursera, 2U/edX Face Lawsuits Over Meta Pixel Use

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

Go to class Write review

Overview

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

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.

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

Start your review of SQL Server: Reporting Services

Go to class

Never Stop Learning.

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

Sign up for free
Someone learning on their laptop while sitting on the floor.