We may earn an affiliate commission when you visit our partners.
Pluralsight logo

SSRS Data Sourcing Playbook

Amruta Mahajan

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.

Read more

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.

Enroll now

What's inside

Syllabus

Course Overview
Connecting to SQL Server Database
Connecting to Other Data Sources
Embedded and Shared Data Sources
Read more
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

Save this course

Save SSRS Data Sourcing Playbook to your list so you can find it easily later:
Save

Activities

Coming soon We're preparing activities for SSRS Data Sourcing Playbook. These are activities you can do either before, during, or after a course.

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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.

Reading list

We've selected six 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 SSRS Data Sourcing Playbook.
Provides a deep dive into data sources in SSRS, covering everything from connecting to different types of data sources to using data sets and parameters. It's a valuable resource for anyone who wants to learn more about data sources in SSRS.
This comprehensive guide to SSRS 4 covers all aspects of report design, development, and deployment. It provides in-depth explanations and practical examples, making it a valuable resource for experienced SSRS users.
Provides a comprehensive overview of reporting with SQL Server 2012. It covers all aspects of reporting, from data extraction and transformation to report design and deployment.
Provides a comprehensive overview of reporting with SQL Server 2014. It covers all aspects of reporting, from data extraction and transformation to report design and deployment.
Provides step-by-step instructions for working with SSRS 2012, including data sources, report design, and deployment. It valuable resource for beginners looking to get started with SSRS.

Share

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

Similar courses

Here are nine courses similar to SSRS Data Sourcing Playbook.
SQL Server Reporting Services 2014: Data Sourcing Playbook
Most relevant
Building Interactive SSRS Reports
Most relevant
Administering SSRS 2017
Most relevant
Building Your First SSRS Report
Most relevant
Managing SSRS Reporting Environments
Most relevant
What's New in SQL Server 2016 Reporting Services
Most relevant
SQL Server Reporting Services Part 2 (SSRS)
Most relevant
SQL Server Reporting Services Playbook
Most relevant
Build and Deploy SSRS Mobile Reports
Most relevant
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