Overview
This 3-day instructor-led course teaches students how to implement a SQL Server 2016 Reporting Services development tools to create and manage reports and implement self-service BI solutions.
Prerequisites
In addition to their professional experience, students who attend this training should have technical knowledge equivalent to the following course:
- 20761 Querying Data with Transact-SQL
Who Should Attend?
This course is highly recommended for database professionals who need to fulfil a BI developer role to create reports. Primary responsibilities will include implementing reports and mobile reports. The course is also recommended for power information workers.
Course Outline
- Introduction to business intelligence
- The Microsoft business intelligence platform
- Introduction to reporting services
- Data sources
- Connection strings
- Datasets
- Filters and parameters
- Creating a report with report designer or report builder
- Creating a report
- Showing data graphically in a report
- Implementing filters and parameters
- Implementing sorting and grouping
- Publishing a report
- Overview of SQL Server mobile reports
- Preparing data for mobile reports
- SQL Server Mobile report publisher
