The course provides a fundamental understanding of the components of Reporting Services deployments, exploring its basic architecture and terminology. This course will cover how to create tabular, matrix, chart, and list reports which employ datasets based on ad-hoc queries and stored procedures. Candidates will be exposed to add custom expressions, custom functions, and report formatting. Additionally, students will implement shared data sources, interactive sorting, drill-down capabilities, and create parameter based reports using the Report Designer. Reports including gauges, indicators, spark lines, and maps will also be introduced. The course will introduce SQL Server Data Tools (SSDT) for SSRS 2012 project environment and Report Builder 3.0 applications for creating, saving, and deploying reports.
- Determine report layouts based on reporting nature and needs
- Create matrix, tabular, chart, list, drill-down, and drill-through reports
- Create parameter reports
- Manage report security
- Configure and deploy SSRS reports
- Manage report servers