We may earn an affiliate commission when you visit our partners.
Gerald Britton

This course will teach you the critical skills needed to administer a SQL Server Reporting Services (SSRS) system from installation through management and meta reporting.

Read more

This course will teach you the critical skills needed to administer a SQL Server Reporting Services (SSRS) system from installation through management and meta reporting.

For on-premises reporting based on Microsoft SQL Server, SSRS is the go-to solution. In this course, Managing SSRS Reporting Environments, you’ll learn the skills needed to be an effective SSRS administrator at Globomantics. First, you'll discover how to install and configure an SSRS instance. Next, you’ll explore how reports are deployed, subscribed to, scheduled, executed, and logged. Finally, you’ll learn how to administer a reporting environment, manage jobs, assemblies, certificates, and more. By the end of this course, you'll know how to effectively deploy and manage an SSRS web portal.

Enroll now

What's inside

Syllabus

Course Overview
Getting Started
Customizing for Globomantics Robotics
Setting up Report Subscriptions
Read more
Sharing Schedules and Data Sets, and Preserving Results
Operating Reporting Services
Course Summary

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Develops critical skills essential for administering SQL Server Reporting Services (SSRS) systems in an on-premises setting
Taught by Gerald Britton, an expert in SQL Server Reporting Services
Explores installation, configuration, reporting deployment, scheduling, and execution for SSRS
Covers job management, assembly administration, and certificate management in SSRS
Provides a comprehensive overview of the SSRS ecosystem, including web portal deployment and management

Save this course

Save Managing SSRS Reporting Environments to your list so you can find it easily later:
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 Managing SSRS Reporting Environments with these activities:
Review SQL Server Reporting Services (SSRS) Tutorial
Reinforce the foundational knowledge of SQL Server Reporting Services to enhance your understanding of the course material.
Show steps
  • Access and follow a comprehensive SQL Server Reporting Services (SSRS) tutorial
  • Practice the concepts and examples provided in the tutorial
Review previous SQL courses
Brush up on your knowledge of SQL databases before starting the course to enhance your understanding of SSRS concepts.
Browse courses on SQL Server
Show steps
  • Go over your notes from previous SQL courses.
  • Complete practice exercises to test your understanding.
Create an Annotated Bibliography of Reporting Tools
Develop a deeper understanding of the different reporting tools available and how they compare to SSRS, enhancing your knowledge of reporting solutions.
Show steps
  • Research and identify various reporting tools and their features
  • Create a comprehensive annotated bibliography that includes summaries, evaluations, and comparisons of each tool
One other activity
Expand to see all activities and additional details
Show all four activities
Complete Practice Exercises on SSRS Reporting
Improve your proficiency in SSRS reporting by completing a series of practice exercises, strengthening your practical skills.
Show steps
  • Locate and access practice exercises or quizzes related to SSRS reporting
  • Work through the exercises, testing your knowledge and identifying areas for improvement

Career center

Learners who complete Managing SSRS Reporting Environments will develop knowledge and skills that may be useful to these careers:
Report Developer
Report Developers design and develop reports for businesses. These reports can be used to present data in a variety of formats, such as charts, graphs, and tables. The Managing SSRS Reporting Environments course would be an excellent choice for current or aspiring Report Developers who want to work with SSRS. The course covers all aspects of the SSRS reporting environment, including report creation, deployment, and management.
Data Analyst
Data Analysts build and implement systems to collect, clean, and analyze data. These professionals then use their analytical skills to draw meaningful conclusions from their findings. The Managing SSRS Reporting Environments course may be useful to Data Analysts who wish to optimize their reporting processes by learning how to create and deploy customized reports. The course discusses the setup of job schedules, automated email reports, and more.
Data Engineer
Data Engineers use their expertise in software and data management to design efficient data pipelines. These data pipelines automate the flow of data between source systems and data warehouses. The Managing SSRS Reporting Environments course may be useful for Data Engineers who want to round out their skill set by learning how to create compelling reports. Knowing how to create useful reports in SSRS is an excellent way to convey the results of your data engineering efforts to colleagues.
Database Administrator
Database Administrators (DBAs) implement and maintain databases that store data. They ensure the database is optimized and running properly, as well as recover data in the event of a system failure. The Managing SSRS Reporting Environments course may be useful for DBAs who want to learn how to create reports from the data they manage. The course would be especially helpful for DBAs who support SQL Server databases.
IT Manager
IT Managers lead an organization's IT department. They are responsible for planning, implementing, and maintaining the organization's IT systems. The Managing SSRS Reporting Environments course may be useful for IT Managers who want to learn more about the Microsoft reporting system. The course can teach IT Managers the fundamentals of an SSRS reporting environment, helping them to manage their organization's data more effectively.
IT Specialist
IT Specialists support and maintain the IT systems of an organization. These professionals may also provide technical advice and support to end users. The Managing SSRS Reporting Environments course may be useful for IT Specialists who work with SQL Server and SSRS. The course would help IT Specialists to manage and maintain SSRS reporting environments.
Management Analyst
Management Analysts study the operations of an organization. They identify inefficiencies and recommend solutions to improve the organization's performance. The Managing SSRS Reporting Environments course may be useful for Management Analysts who want to learn how to use data to improve an organization's decision-making. The course covers topics such as report creation, subscription management, and data analysis.
Operations Manager
Operations Managers oversee the day-to-day operations of an organization. They are responsible for ensuring that the organization's processes are efficient and effective. The Managing SSRS Reporting Environments course may be useful for Operations Managers who want to learn how to use data to improve the efficiency of their organization's operations. The course covers topics such as report creation, data analysis, and job scheduling.
Product Manager
Product Managers are responsible for the development and marketing of products. They work with engineering and marketing teams to ensure that products meet the needs of customers. The Managing SSRS Reporting Environments course may be useful for Product Managers who want to learn how to use data to make informed decisions about product development. The course covers topics such as report creation, data analysis, and forecasting.
Quality Assurance Analyst
Quality Assurance Analysts test software to ensure that it meets the requirements of the business. They identify defects and recommend solutions to improve the quality of the software. The Managing SSRS Reporting Environments course may be useful for Quality Assurance Analysts who test software that uses SSRS. The course would help Quality Assurance Analysts to understand the functionality of SSRS and to identify defects in SSRS reports.
Software Architect
Software Architects design and develop the architecture of software systems. They are responsible for ensuring that the system is scalable, reliable, and secure. The Managing SSRS Reporting Environments course can help Software Architects to understand the functionality of SSRS and how it can be used to create scalable, reliable, and secure reporting systems.
Software Developer
Software Developers design, develop, and test software applications. They work with a variety of programming languages and technologies. The Managing SSRS Reporting Environments course may be useful for Software Developers who work with SSRS or who want to learn more about it. The course covers topics such as report creation, data analysis, and deployment.
System Analyst
System Analysts study the needs of businesses and design and implement solutions to meet those needs. They work with a variety of stakeholders, including business users, IT professionals, and vendors. The Managing SSRS Reporting Environments course may be useful for System Analysts who work with SSRS or who want to learn more about it. The course covers topics such as report creation, data analysis, and deployment.
Technical Writer
Technical Writers create documentation for software and hardware products. They work with engineers and other technical professionals to gather information and write clear, concise, and accurate documentation. The Managing SSRS Reporting Environments course may be useful for Technical Writers who need to write documentation for SSRS. The course would help Technical Writers to understand the functionality of SSRS and to write clear and concise documentation about it.

Reading list

We've selected eight 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 Managing SSRS Reporting Environments.
Provides guidance on administering and implementing SQL Server Reporting Services. It covers the core functionalities and best practices, making it valuable for IT professionals.
Provides a practical guide to developing BI applications. It covers a range of topics, including data warehousing, data mining, and reporting.
Classic in the field of data warehousing. It provides a comprehensive overview of the dimensional modeling approach. While not directly related to SSRS, it will be a beneficial resource for anyone who wants a solid foundation in data modeling and data management.
Provides a comprehensive overview of both SQL Server Reporting Services and Power BI. It great resource for those who want to learn about both technologies and how they can be used together.
Though this book doesn't focus specifically on SSRS, it great resource for anyone who wants to learn more about writing effective SQL queries.
Provides a comprehensive overview of SQL Server 2012 administration. It great resource for those who want to learn about the full range of administrative tasks in SQL Server 2012, including managing SSRS.
Provides a comprehensive overview of SQL Server 2014 administration. It great resource for those who want to learn about the full range of administrative tasks in SQL Server 2014, including managing SSRS.
Provides an overview of SQL Server Reporting Services from a business intelligence perspective. It great resource for those who want to learn how to use SSRS to create and deliver business intelligence reports.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Here are nine courses similar to Managing SSRS Reporting Environments.
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