SQL Server: Reporting Services

Go to class
Write Review

Free Online Course: SQL Server: Reporting Services provided by LinkedIn Learning is a comprehensive online course, which lasts for 3-4 hours worth of material. The course is taught in English and is free of charge. Upon completion of the course, you can receive an e-certificate from LinkedIn Learning. SQL Server: Reporting Services is taught by Adam Wilbert.

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