We may earn an affiliate commission when you visit our partners.
Thomas LeBlanc
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.
Read more
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.
Read more
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.
Register for this course and see more details by visiting:
OpenCourser.com/course/s7d15h/administering
What's inside
Syllabus
Course Overview
Administering SSRS
Managing Security and Credentials in SSRS
Decreasing Report Rendering Times
Read more
Syllabus
Course Overview
Administering SSRS
Managing Security and Credentials in SSRS
Decreasing Report Rendering Times
Read more
Managing the SSRS Portal
Managing the Portal Schedule
Good to know
Good to know
Know what's good ,
what to watch for , 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
Save this course
Save Administering SSRS 2017 to your list so you can find it easily later:
Save
Save
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.
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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 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.
Business Intelligence 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.
Business 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.
Data 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.
Database Administrator
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.
Information Security Analyst
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.
IT Auditor
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.
IT Consultant
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.
IT Manager
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.
Network Administrator
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.
Technical Support Specialist
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.
Quality Assurance Analyst
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.
Software Developer
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.
Web 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.
User Experience Designer
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.
For more career information including salaries, visit:
OpenCourser.com/course/s7d15h/administering
Reading list
We've selected seven books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
Administering SSRS 2017.
Save
Provides a comprehensive overview of Power BI and SSRS, and how to use them together to create powerful and interactive reports.
This guide is ideal for intermediate to advanced database administrators and report developers who want to create and deploy powerful reports using SQL Server Reporting Services. It provides a comprehensive overview of the SSRS architecture, as well as detailed instructions on how to use the various tools and features of SSRS.
Provides a comprehensive overview of SSRS data processing extensions (DPX). DPX powerful tool that allows you to extend the capabilities of SSRS by creating custom data sources and functions.
Save
Practical guide to SSRS administration. It covers all the essential topics of SSRS administration, including security, performance tuning, and report design.
Hands-on guide to administering SQL Server Reporting Services (SSRS). It covers all the basics of SSRS administration, including installation, configuration, security, and performance tuning.
This developer-oriented guide provides detailed instructions on how to use the SSRS APIs to create custom reports and extensions. It is an essential resource for anyone who wants to develop custom SSRS solutions.
Beginner's guide to SSRS. It covers the basics of SSRS, including creating reports, managing data sources, and deploying reports.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/s7d15h/administering
Share
Similar courses
Here are nine courses similar to
Administering SSRS 2017.
Managing SSRS Reporting Environments
OpenCourser.com/course/nql2t0/managing
Managing SSRS Reporting Environments
Most relevant
Building Your First SSRS Report
OpenCourser.com/course/uzbiay/building
Building Your First SSRS Report
Most relevant
SQL Server Reporting Services Part 2 (SSRS)
OpenCourser.com/course/17jzh7/sql
SQL Server Reporting Services Part 2 (SSRS)
Most relevant
SQL Server Reporting Services Playbook
OpenCourser.com/course/vfzybt/sql
SQL Server Reporting Services Playbook
Most relevant
SSRS Data Sourcing Playbook
OpenCourser.com/course/1o5vnp/ssrs
SSRS Data Sourcing Playbook
Most relevant
What's New in SQL Server 2016 Reporting Services
OpenCourser.com/course/a7iksn/what
What's New in SQL Server 2016 Reporting Services
Most relevant
SQL Server Reporting Services 2014: Data Sourcing Playbook
OpenCourser.com/course/gzfbi7/sql
SQL Server Reporting Services 2014: Data Sourcing Playbook
Most relevant
Building Interactive SSRS Reports
OpenCourser.com/course/wo4x2m/building
Building Interactive SSRS Reports
Most relevant
SSRS Report Publishing Playbook
OpenCourser.com/course/wg6mxk/ssrs
SSRS Report Publishing Playbook
Most relevant
Time
102 hours
Level
Advanced
Via
Pluralsight
Instructor
Thomas LeBlanc
Language
English
Good to know
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
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2024 OpenCourser