Master the art of authoring, deploying, and managing SQL Server Reporting Services reports to empower your organization's data analysis capabilities, tailored for database professionals and power users aiming to excel in self-service BI solutions.
EnrollDesign comprehensive reports using SQL Server Reporting Services development tools.
Implement self-service BI solutions utilizing mobile reports and data modeling.
Manage and deploy reports through the SSRS Web Portal for efficient data analysis.
Understand and configure various report services data sources.
This course is an overview of how to implement a SQL Server 2016 Reporting Services solution for data analysis in an organization. The course discusses how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions. It also reviews Data Modeling, mobile reports and report mapping for filtering and sorting parameters and grouping.
What Is SSRS and How Is It Used?
SSRS and Business Intelligence
OLTP and OLAP
SSRS Architecture and Tools
Data Sources
Data Sets
Report Designer Solutions
Data Binding
The Tablix Table and List
Simple Formatting
Working with Expressions
Using Grouping for Formatting and Aggregation
Overview of Report XML
Deployment to the Web Portal
Report Designer vs. Report Builder
Hierarchical Group Objects
Expression Scope
Document Maps
Recursive Hierarchies
The Matrix Data Region
Adjacent Groups
Query Parameters and Report Parameters
Server-Side vs Client-Side Filtering
Parameter Dropdowns
Cascading Parameters
Optional Parameters
Drilldown
Drillthrough
Using Parameters to Sort
Using Parameters to Show/Hide Matrix Groups
Subreports vs Nested Data Regions
Go to Bookmark Action
Headers and Footers
Rich Text Formatting
Placeholders
Conditional Formatting
Repeating and Freezing Column Headers
Formatting for Excel
Charts
Databars
Sparklines
Gauges
Indicators
Maps
KPI Reports
Web Portal Overview
Creating Folders
Managing Shared Objects
Web Portal Report Properties
Report Comments
Branding the Web Portal
Report Processing Steps
Caching Reports & Filtering
Snapshot Reports & Filtering
Historical Snapshots
Simple Subscriptions
Data-Driven Subscriptions
Shared Schedules
Configuration Managers
Securing the Web Portal
Monitoring Performance
Mobile Reports Overview
Understanding and Preparing Mobile Reports Data
Navigators and Visualizations
Parameters and Drillthrough
Your team deserves training as unique as they are.
Let us tailor the course to your needs at no extra cost.
Trusted by Engineers at:
and more...
Aaron Steele
Casey Pense
Chris Tsantiris
Javier Martin
Justin Gilley
Kathy Le
Kelson Smith
Oussama Azzam
Pascal Rodmacq
Randall Granier
Aaron Steele
Casey Pense
Chris Tsantiris
Javier Martin
Justin Gilley
Kathy Le
Kelson Smith
Oussama Azzam
Pascal Rodmacq
Randall Granier