SSRS Data Sourcing Playbook from Pluralsight

SQL Server Reporting Services (SSRS) is a powerful reporting tool that is tightly coupled with SQL Server. This course will teach you how to collate, configure, and customize data from various sources to be used in building reports with SSRS.

Data Sourcing is the first step in your journey towards building great reports and dashboards using SQL server. In this course, SSRS Data Sourcing Playbook, you’ll learn to prepare your datasets to be used in the creation of reports and dashboards in SQL Server Reporting Services (SSRS). First, you’ll explore how to connect to various data sources. Next, you’ll discover how to work with embedded and shared data sources and convert them to datasets that can be used in reports and dashboards. Finally, you’ll learn how to customize your SSRS reports by using features like connection strings, custom expressions, and filter locations. When you’re finished with this course, you’ll have the skills and knowledge of SSRS data sourcing needed to create rich and powerful reports. Software required: SQL Server 2019; SQL Server Reporting Services.

What's inside

Syllabus

Course Overview

Connecting to SQL Server Database

Connecting to Other Data Sources

Embedded and Shared Data Sources

Understanding Datasets

Customizing SSRS Report Using Advanced Features

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Teaches skills, knowledge, and/or tools that are highly relevant to industry

Explores advanced features of SQL Server Reporting Services (SSRS)

Builds a strong foundation for beginners in using SSRS

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 SSRS Data Sourcing Playbook with these activities:

Review Data Source Concepts and Terminology

Show steps

Refresh your foundational knowledge of data source concepts and terminology, ensuring a strong understanding of the building blocks of SSRS data sourcing.

Browse courses on Data Sources

Show steps

Revisit course materials on data sources.
Review online resources and tutorials on data source concepts.

Show all one activities

Career center

Learners who complete SSRS Data Sourcing Playbook will develop knowledge and skills that may be useful to these careers:

Systems Analyst

A Systems Analyst may regularly consult with stakeholders and execute data sourcing strategies. The SSRS Data Sourcing Playbook can help you build a solid foundation for this aspect of your role. Through this course, you will learn to connect to various data sources, customize data sources, and build datasets for reporting. This knowledge may be highly valuable to you as a Systems Analyst.

See salaries and explore the career path for Systems Analyst

Technical Architect

Technical Architects will often need to design and implement reporting solutions. Th SSRS Data Sourcing Playbook may be helpful to your career in this role. You will learn to connect to various data sources, customize data sources, and build datasets for reporting. This course may be instrumental to your success as a Technical Architect.

See salaries and explore the career path for Technical Architect

Data Warehouse Architect

A Data Warehouse Architect will often need to design and implement reporting solutions. The SSRS Data Sourcing Playbook can provide you with the skills needed to excel in this role. This course will teach you how to connect to various data sources, customize data sources, and build datasets for reporting. This knowledge may be integral to your success as a Data Warehouse Architect.

See salaries and explore the career path for Data Warehouse Architect

Enterprise Architect

An Enterprise Architect will sometimes need to design and implement reporting solutions. The SSRS Data Sourcing Playbook can provide you with a strong foundation for this aspect of your role. This course will teach you to connect to various data sources, customize data sources, and build datasets for reporting. This knowledge may be key to your success as an Enterprise Architect.

See salaries and explore the career path for Enterprise Architect

Business Analyst

A Business Analyst will commonly use reporting software to present data and analysis to stakeholders. The SSRS Data Sourcing Playbook can provide you with foundational knowledge to enhance your work in this role. Instruction is given in connecting to data sources, customizing data sources, and creating datasets for reporting. These skills may prove useful to you as a Business Analyst.

See salaries and explore the career path for Business Analyst

Database Developer

Database Developers will often be tasked with building reporting functionality into the databases that they create. The SSRS Data Sourcing Playbook may provide you with a useful foundation for this aspect of your job. You will learn how to connect to data sources, customize data sources, and build datasets for reporting. This knowledge may be instrumental to your success as a Database Developer.

See salaries and explore the career path for Database Developer

Software Architect

Software Architects will often need to work closely with reporting systems in order to implement new features. The SSRS Data Sourcing Playbook can provide you with a solid foundation for success in this role. This course can help you to connect to various data sources, customize data sources, and build datasets for reporting. Gaining this knowledge may be essential to your success as a Software Architect.

See salaries and explore the career path for Software Architect

Data Architect

A Data Architect will regularly consult with stakeholders and execute data sourcing strategies. The SSRS Data Sourcing Playbook may help you to build a strong foundation for success in this role. By learning to connect to various data sources, customize data sources, and build datasets, you will gain a valuable advantage in the area of Data Architecture.

See salaries and explore the career path for Data Architect

Information Security Analyst

In order to protect data sources from unauthorized access, an Information Security Analyst must have a good understanding of how data is collected, stored, and used. The SSRS Data Sourcing Playbook may provide you with a foundation for this aspect of your role. The course includes instruction in how to connect to various data sources and customize data sources. This knowledge may be beneficial to you as an Information Security Analyst.

See salaries and explore the career path for Information Security Analyst

Data Scientist

Data Scientists will generally work with reporting software to visualize their findings in a digestible format. The SSRS Data Sourcing Playbook may be helpful to your advancement in this role. It will teach you to connect to various data sources, customize data sources, and build datasets for reporting. This course may provide you with a competitive advantage over other Data Scientists in your field.

See salaries and explore the career path for Data Scientist

Data Engineer

Data Engineers will often need to create customized data sources for use in reporting software. The SSRS Data Sourcing Playbook will help you build a foundation for successful performance in this role. This course will teach you how to connect to data sources, customize data sources, and use these customized data sources in reporting software.

See salaries and explore the career path for Data Engineer

Business Intelligence Analyst

A Business Intelligence Analyst will often rely upon reporting software to provide visualizations and dashboards to executives within a company. The SSRS Data Sourcing Playbook will prepare you for this vital aspect of your job. You will learn to connect to various data sources, customize data sources, and build datasets for reporting. Completion of this course may open doors to new and exciting opportunities as a Business Intelligence Analyst.

See salaries and explore the career path for Business Intelligence Analyst

Database Administrator

As a Database Administrator, you will need to interface with reporting systems in order to extract insights from a database. The SSRS Data Sourcing Playbook will help you build a foundation for successful performance in this role. You will learn how to connect to SQL Server databases and to embed or share data sources. This course can help you to become a well-rounded Database Administrator.

See salaries and explore the career path for Database Administrator

Software Engineer

Software Engineers will often need to build customized reporting functionality for their projects. The SSRS Data Sourcing Playbook will offer you a solid foundation for this aspect of your job. By providing instruction in how to connect to data sources, customize data sources, and convert data sources into datasets, this course may substantially aid you in your work as a Software Engineer.

See salaries and explore the career path for Software Engineer

Data Analyst

A Data Analyst would interface directly with a variety of data sources. The SSRS Data Sourcing Playbook will teach you to collate, configure, and customize data from these sources so that it can be used to inform business decisions. This course may be useful in your career advancement, particularly if you want to transition from a role that is adjacent to Data Analysis but that doesn't require direct interaction with data.

See salaries and explore the career path for Data Analyst

SSRS Data Sourcing Playbook

What's inside

Syllabus

Good to know

Save this course

Activities

Career center

Reading list

Share

Similar courses