This fast-paced two-day instructor-led course is intended for IT professionals who are interested in quickly learning how to use the Reporting Services development tools to create reports. This course also covers how to use the Reporting Services management and administrative tools to manage a Reporting Services solution.
There are no prerequisites for this course.
This course is intended for SQL professionals, Microsoft Reporting Services administrators and report developers, and business intelligence professionals.
Job role: Developer
After completing this course, students will be able to:
This module explains how the class will be structured and introduces course materials and additional administrative information.
Lab : Course Overview
Introduction to Microsoft SQL Server Reporting Services
Reporting Services is a report design and enterprise-class information delivery tool. In this module, we will explore the version changes, installation, architecture and tools for Reporting Services.
Lab : Introduction to Microsoft SQL Server Reporting Services
Building Basic Reports
In this module, we begin building reports using the basics. We will explore the wizards available and then cover tables, matrices, and lists while demonstrating how to use each of them. Finally, we will take a look at the report items available to help design the report.
Lab : Building Basic Reports
Highlighting Basic Reports with Visualizations
Visualize and present your data using visualizations. In this module, we cover the visualizations available, while demonstrating each, so you can see for yourself just how captivating data can be.
Lab : Highlighting Basic Reports with Visualizations
Developing Advanced Reports
Looking to take reporting to the next level? Then look no further. In this module, we cover what you’ll need to create advanced reports with features such as conditional formatting and interactivity just to name a few.
Lab : Developing Advanced Reports
Managing and Maintaining Reporting Services
To share your report, you need to publish or deploy it to a report server or SharePoint site. In this module, we explain deployment options and follow with an explanation on security and administrative tasks.
Lab : Managing and Maintaining Reporting Services
Microsoft Power Platform App Maker
Designing & Implementing Azure AI Solution
Microsoft Azure Administrator
Developing Solutions For Microsoft Azure
Microsoft Azure Architect Design Exam
Implementing Azure Data Solution
Administering Relational Databases On Microsoft Azure