This five-day instructor-led course teaches students 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.
Instructor did a great job, from experience this subject can be a bit dry to teach but he was able to keep it very engaging and made it much easier to focus.
Excellent presentation skills, subject matter knowledge, and command of the environment.
Instructor was outstanding. Knowledgeable, presented well, and class timing was perfect.
Click here to print this page »
Before attending this course, students must have:
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Working knowledge of Transact-SQL, such as that taught in 20761C.
Detailed Class Syllabus
Module 1: Introduction to Reporting Services
Introduction to reporting services
Reporting services components
Reporting services tools
Module 2: Reporting Services Data Sources
Module 3: Creating Paginated Reports
Creating a report with the report wizard
Creating a report
Publishing a report
Module 4: Working with Reporting Services Data
Implementing report filters and parameters
Module 5: Visualizing Data with Report Services
Images and charts
Databars, sparklines, indicators, gauges, and maps
Module 6: Summarizing Report Data
Sorting and grouping
Drilldown and drill through
Module 7: Sharing Reporting Services Reports
Report caching, snapshots, and comments
Report subscription and delivery
Module 8: Administering Reporting Services
Administering reporting services
Reporting services configuration
Reporting services performance
Module 9: Extending and Integrating Reporting Services
Expressions and embedded code
Extending reporting services
Integrating reporting services
Module 10: Introduction to Mobile Reports
Overview of mobile reports
Preparing data for mobile reports
Mobile report publisher
Module 11: Developing Mobile Reports
Designing and publishing mobile reports
Drillthrough in mobile reports