SQL Server Reporting Services (SSRS) - Authoring, Deploying, and Managing Reports Training Course
SSRS795
MS Subscription
Interface Gold
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 you will learn
With a focus on practical applications, the course covers:
- Use the Reporting Services development tools
- Create and manage reports
- Implement self-service BI solutions
- Data Modeling
- Mobile reports
What products and services will you use and learn about in this course
- SSRS
- OLTP and OLAP
- Report Designer
- Web Portal
- Web Portal Configuration Manager
Prepare for the Microsoft Certification
None
- $2,995
- 5 Days, Labs, Live Q&A
- Replay™ Class Recordings Included
- Included in “all-you-can-eat” Microsoft Live Training Subscription
4:00 AM - 12:00 PM (HI)
7:00 AM - 3:00 PM (PT)
7:00 AM - 3:00 PM (AZ)
8:00 AM - 4:00 PM (MT)
9:00 AM - 5:00 PM (CT)
10:00 AM - 6:00 PM (ET)
Course Outline
Module 1 – Introduction: SSRS
Lessons:
- What Is SSRS?
- SSRS Architecture
- SSRS Tools
Module 2 – An overview of OLTP & OLAP
Lessons:
- OLTP and OLAP databases
- Dimensional Model
- OLTP and OLAP
- OLAP query considerations
Module 3 – Authoring Fundamentals in SSDT
Lessons:
- Report Designer Solutions
- Data objects
- The Tablix object
- Simple Formatting
- Expressions
- Interactivity
- Report XML
- Deployment to the Web Portal
- Report Designer vs. Report Builder
Module 4: Summarized Data
Lessons:
- Data vs report grouping
- Hierarchical Group Objects
- Expression Scope
- Document Maps
- The Matrix Data Region
- Adjacent Groups
- Recursive Hierarchies
Module 5: Formatting
Lessons:
- Headers and Footers
- Test box formatting
- Other formatting
Module 6: Working with Parameters
Lessons:
- Introducing parameters
- Applying parameters
- Displaying parameters values
Module 7: Visualizations
Lessons:
- Charts
- Other chart visualizations
- Maps
- KPI Reports
Module 8: Introducing the Web Portal
Lessons:
- Web Portal basics
- Cached reports
- Snapshots
- Subscriptions
Module 9: Administering Reporting Services
Lessons:
- Configuration manager
- Securing the Web Portal
- Monitoring Performance
Module 10 Mobile Reports
Lessons:
Mobile Reports Overview
Audience
The primary audience for this course is database professionals who want to learn about creating reports. Primary responsibilities will include implementing reports and mobile reports. The secondary audiences for this course are power information workers.
Prerequisites
In addition to their professional experience, students who attend this training should have technical knowledge equivalent to the following course:
or