SQL Server: Reporting Services
- Offered byLinkedin Learning
SQL Server: Reporting Services at Linkedin Learning Overview
Total fee | ₹1,849 |
Mode of learning | Online |
Difficulty level | Advanced |
Credential | Certificate |
SQL Server: Reporting Services at Linkedin Learning Highlights
- 1 exercise file for practice
- 10 quizzes to test knowledge
SQL Server: Reporting Services at Linkedin Learning Course details
- In this course, author Adam Wilbert shows how to create, format, and share reports that leverage a variety of data sources
- First, the course takes learner through the setup process, followed by the step-by-step process of building a report
- The course covers interactive elements, formatting, charts, sorting, filtering, web viewing, and mobile viewing
SQL Server: Reporting Services at Linkedin Learning Curriculum
Introduction
Present SQL data with Reporting Services
What you should know
Set up the example database
Get Started with SSRS
What is SQL Server Reporting Services (SSRS)?
Install SSRS
Configure the report server
Access the web portal
Install Report Builder
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
Work with Data
Create a shared data source
Create a shared dataset
Filtering data
Grouping data in a report
Understand matrixes
Use aggregate functions
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
Create Charts
Introduction to charts
Create a chart
Add additional data series
Format charts
Additional Data Visualizations
Gauges
Indicators
Data bars
Create a sparkline dataset
Display a sparkline
Maps
Improve the Presentation
Include header and footer details
Add graphics and logos
Align page elements
Insert page breaks
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
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
SSRS Tips and Tricks
Reuse report parts
Subscribe to a report
Conclusion
Next steps