SQL Server: Reporting Services
Offered By: LinkedIn Learning
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
- What is SQL Server Reporting Services (SSRS)?
- Install SSRS
- Configure the report server
- Access the web portal
- Install Report Builder
- 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
- Create a shared data source
- Create a shared dataset
- Filtering data
- Grouping data in a report
- Understand matrixes
- Use aggregate functions
- Convert filters into parameters
- Report parameter properties
- Make a dynamic report title
- Add a parameter manually
- Report actions
- Sort records in a table
- Introduction to charts
- Create a chart
- Add additional data series
- Format charts
- Gauges
- Indicators
- Data bars
- Create a sparkline dataset
- Display a sparkline
- Maps
- Include header and footer details
- Add graphics and logos
- Align page elements
- Insert page breaks
- Add a key performance indicator (KPI)
- Create a dynamic KPI
- Organize the web portal with folders
- Customize the web portal branding
- 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
- Reuse report parts
- Subscribe to a report
- Next steps
Taught by
Adam Wilbert
Related Courses
Organizational AnalysisStanford 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