YoVDO

SQL Server: Reporting Services

Offered By: LinkedIn Learning

Tags

Business Intelligence Courses Data Analysis Courses Data Visualization Courses Server-Side Request Smuggling (SSRS) Courses KPIs (Key Performance Indicators) Courses

Course Description

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

Related Courses

Organizational Analysis
Stanford University via Coursera
Introduction to Business in Asia
Griffith University via Open2Study
Introduction to Enterprise Architecture
Enterprise Architects via Open2Study
Business Processes: Modeling, Simulation, Execution
openHPI
BI 4 Platform Innovation and Implementation
SAP Learning