Administering SSRS 2017 from Pluralsight

The course will teach an administrator how to use the features of SQL Server Reporting Services (SSRS) to manage a service and portal for deployment of reports through security, caching, and scheduled jobs.

Administrating SQL Server Report Services or SSRS involves many aspects in the reporting portal as well as on the service level. In this course, Administering SSRS 2017, you will learn how to use SSRS portal for creating, maintaining, and monitoring user’s permissions for deploying and viewing reports. First, you will discover the portal which will assist you in creating and managing the scheduled jobs to execute reports for end users. Next, you will learn how to create triggers based on data-driven reports. Finally, you will see the steps needed for customizing the portal with branding, extensions, and adding Power BI reports to dazzle the end users and business. When you are finished with this course, you will have the skills to efficiently manage and lock down a SQL Server Reporting Services system.

What's inside

Syllabus

Course Overview

Administering SSRS

Managing Security and Credentials in SSRS

Decreasing Report Rendering Times

Traffic lights

Read about what's good

what should give you pause

and possible dealbreakers

Learn how to safeguard an SSRS using critical security measures and protocols

Become an expert in Administering SQL Server Reporting Services to ensure efficient reporting and data management for optimal decision-making

Enhance your skills in customizing the portal with branding, extensions, and incorporating Power BI reports to enhance user experience and data visualization

Understand the fundamentals of SSRS and its role in data analysis and reporting

Gain proficiency in managing user permissions, creating and monitoring scheduled jobs, and customizing the SSRS portal

Taught by instructor Thomas LeBlanc, who holds expertise and experience in SQL Server Reporting Services

Reviews summary

Administering ssrs 2017: comprehensive management skills

According to learners, Administering SSRS 2017 provides a solid foundation and practical skills essential for IT professionals. Students frequently highlight the instructor's deep knowledge and clear explanations, finding the hands-on labs particularly useful for managing various aspects like security, caching, and scheduled reports. While many found the content highly relevant for daily tasks and a good refresher, a few mentioned the pacing could be fast or desired more advanced troubleshooting depth, suggesting it might be better suited for beginners to intermediate learners. One review noted the course felt somewhat outdated, though most recent feedback remains very positive, indicating its continued value.

One review found content outdated; most recent feedback is positive.

"I found this course somewhat outdated. While it focuses on SSRS 2017, many concepts are better covered in newer versions."

"It needs an update to reflect current best practices and features."

"The course remains highly effective for its stated scope and is well-organized and useful."

Highly relevant for professionals managing SSRS environments.

"This course was exactly what I needed to get up to speed with administering SSRS 2017."

"The course content is highly relevant for anyone working with SQL Server Reporting Services."

"It covered most of the administrative aspects of SSRS 2017 that I use daily."

Course offers valuable hands-on skills for real-world use.

"The labs were practical and hands-on, covering security, scheduled reports, and even Power BI integration."

"I learned so much about optimizing report rendering times and setting up data-driven subscriptions."

"I got a lot out of the sections on caching and scaling SSRS. I can apply these to real-world scenarios."

Instructor's knowledge and clarity are highly praised.

"The instructor was incredibly knowledgeable and explained complex topics clearly."

"Excellent course! The instructor's expertise in SSRS is evident throughout."

"The instructor demystified complex security configurations and made the topic of caching very clear."

Some found pacing fast or depth lacking for advanced users.

"My only minor critique is that some parts felt a bit rushed, especially the Power BI integration."

"I was hoping for more advanced troubleshooting techniques... good for beginners, but not for advanced users."

"The pace was a little fast in some areas, but I could rewatch the videos."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Administering SSRS 2017 with these activities:

Review course materials and notes

Show steps

Reviewing course materials regularly will refresh your memory and improve retention.

Browse courses on SQL Server Reporting Services

Show steps

Go over the course syllabus and key concepts.
Read through the assigned readings and notes.
Take practice quizzes or review assignments.

Review SQL Server Reporting Services (SSRS)

Show steps

Reviewing SSRS concepts will provide a stronger foundation for the course and boost learning outcomes.

Browse courses on SQL Server Reporting Services

Show steps

Review basic SSRS concepts and terminology.
Install and configure SSRS on a local machine or virtual environment.
Create and publish a simple report.

Attend a local user group meeting or conference on SSRS

Show steps

Networking with other professionals in the field can provide valuable insights and career opportunities.

Browse courses on SQL Server Reporting Services

Show steps

Find a local user group meeting or conference.
Attend the event and participate in discussions.
Connect with other attendees and exchange knowledge.

Five other activities

Expand to see all activities and additional details

Show all eight activities

Mentor a junior or novice learner on SSRS

Show steps

Mentoring others will reinforce your understanding and help you develop communication and leadership skills.

Browse courses on SQL Server Reporting Services

Show steps

Find a mentee who is interested in learning about SSRS.
Share your knowledge and experience.
Provide guidance and support.

Follow SSRS tutorials and documentation

Show steps

Following tutorials and reading documentation will further enhance understanding of SSRS concepts and features.

Browse courses on SQL Server Reporting Services

Show steps

Find tutorials and documentation on the Microsoft Docs website.
Follow step-by-step instructions to create and manage reports.
Explore the SSRS documentation to learn about advanced features.

Practice creating and managing reports in SSRS

Show steps

Hands-on practice will solidify understanding and build proficiency in SSRS.

Browse courses on SQL Server Reporting Services

Show steps

Create reports using different data sources and data sets.
Apply filters, sorting, and grouping to reports.
Customize report layouts and designs.
Troubleshoot common errors and issues.

Create a blog post or article on SSRS

Show steps

Creating content will enhance understanding and reinforce knowledge by organizing and articulating concepts in a structured manner.

Browse courses on SQL Server Reporting Services

Show steps

Choose a specific aspect of SSRS to focus on.
Research and gather information from reliable sources.
Write a clear and concise blog post or article.
Publish and share your content with others.

Build a real-world reporting application using SSRS

Show steps

Building a real-world application will provide practical experience and demonstrate proficiency in SSRS.

Browse courses on SQL Server Reporting Services

Show steps

Define the scope and requirements of the project.
Design and implement the SSRS reports.
Integrate the reports into the application.
Test and deploy the application.

Career center

Learners who complete Administering SSRS 2017 will develop knowledge and skills that may be useful to these careers:

Systems Analyst

Systems Analysts study an organization's IT systems and business processes to identify areas for improvement. They then develop and implement solutions that improve the efficiency and effectiveness of the organization's systems.

See salaries and explore the career path for Systems Analyst

Business Intelligence Analyst

Business Intelligence Analysts use data analysis to help organizations make better decisions. This involves collecting, cleaning, and analyzing data, and then presenting the results to decision makers.

See salaries and explore the career path for Business Intelligence Analyst

Business Analyst

A Business Analyst studies your organization and builds a deep understanding of its processes and functions. Once an understanding of the organization has been developed, you will participate in either improving existing processes or developing new ones. You will document your findings and recommendations, and you will help develop the training materials and documentation.

See salaries and explore the career path for Business Analyst

Data Analyst

Data Analysts apply analytical methods to large amounts of data to transform this raw data into useful information. This information can then be used to make informed business decisions. Data Analysts use a variety of tools and technologies to extract, clean, and analyze data.

See salaries and explore the career path for Data Analyst

Database Administrator

A Database Administrator implements and maintains an organization's database management systems which is a software that interacts with the database. Database Administrators ensure the security, integrity, availability, and performance of the database system.

See salaries and explore the career path for Database Administrator

Information Security Analyst

Information Security Analysts help an organization reduce the risk of a data or security breach and any harm that may come from these breaches. This involves implementing measures that prevent cyber attacks and data leaks. Information Security Analysts also implement incident response plans should a breach occur.

See salaries and explore the career path for Information Security Analyst

IT Auditor

An IT Auditor is tasked with making sure that an organization's IT infrastructure is secure and operating efficiently. This involves reviewing IT policies and controls, and making sure that they are being followed. IT Auditors also conduct risk assessments, and help organizations develop and implement IT security plans.

See salaries and explore the career path for IT Auditor

IT Consultant

IT consultants provide expertise and advice to organizations on how to best use information technology to achieve their business goals. IT Consultants work with organizations to develop and implement IT strategies, and to solve IT problems.

See salaries and explore the career path for IT Consultant

IT Manager

IT Managers are responsible for planning, organizing, and directing the IT operations of an organization. This involves managing IT staff, developing and implementing IT policies and procedures, and ensuring that the organization's IT systems are running smoothly.

See salaries and explore the career path for IT Manager

Technical Support Specialist

Technical Support Specialists provide technical support to users of computer hardware and software. This involves answering questions, troubleshooting problems, and resolving technical issues.

See salaries and explore the career path for Technical Support Specialist

Network Administrator

Network Administrators are responsible for maintaining and troubleshooting an organization's computer networks. This involves installing and configuring network hardware and software, and monitoring network performance.

See salaries and explore the career path for Network Administrator

Quality Assurance Analyst

Quality Assurance Analysts test software to find and fix bugs. This involves writing test cases, executing tests, and analyzing the results. Quality Assurance Analysts also work with developers to fix bugs and improve the quality of the software.

See salaries and explore the career path for Quality Assurance Analyst

Software Developer

Software Developers design, code, and test software applications. This involves working with users to understand their needs, and translating those needs into software code.

See salaries and explore the career path for Software Developer

Web Developer

Web Developers design and develop websites. This involves working with users to understand their needs, and translating those needs into website code.

See salaries and explore the career path for Web Developer

User Experience Designer

User Experience Designers design the user interface for websites and software applications. This involves creating mockups and prototypes, and testing the user interface with users.

See salaries and explore the career path for User Experience Designer