Microsoft SQL Server Reporting Services

• The primary audience for this course is individuals who want create reports using MS SQL Server Reporting Services

• Describe report lifecycle
• Create report visualisations
• Work with parameters and filters
• Deploy reports
• Automating tasks in Reporting Services
• Reporting Services Maintenance
• PowerView
• PowerMap
• PowerPivot (if time permits)

• Basic knowledge of the Microsoft Windows operating system and its core functionality
• Working knowledge of Transact-SQL

Introduction to Reporting Services

• RS Overview
• Deployment and usage options

Report creation and visualisations

• Table
• Matrix
• Graf
• List
• Picture
• Gauge
• Map
• KPI, sparklines, data bars
• Subreport

Working with parameters and filters

• Parameters vs. filters
• Report parameters
• Query parameters

Report deployment

• How to deploy report
• Server side settings

Automating tasks in Reporting Services

• Reporting services configuration manager
• Database and keys management
• Report snapshots

PowerView

• Introduction to PowerView
• How to create simple visualisation

PowerMap

• Introduction to Power Map

PowerPivot

• How to create data model for PowerView, PowerMap

Previous courses

Implementation of a data warehouse and ETL processes using Microsoft SQL Server Integration Services. [GOC645]

Related courses

Microsoft SQL Server Analysis Services [GOC641]

Microsoft Power BI Data Analyst [MOC PL-300]

Microsoft Power BI Desktop [PBID]