We may earn an affiliate commission when you visit our partners.
Thomas LeBlanc

Data is the substance to all reports in Reporting Services (SSRS). From configuring Data Sources to options in Data Sets, this course provides the ins and outs of data in SSRS. Many common data sources are demonstrated throughout this course.

Read more

Data is the substance to all reports in Reporting Services (SSRS). From configuring Data Sources to options in Data Sets, this course provides the ins and outs of data in SSRS. Many common data sources are demonstrated throughout this course.

SQL Server Reporting Services (SSRS) is the gold standard for reporting data. In this course, SQL Server Reporting Services 2014: Data Sourcing Playbook, you will learn about how the data source is the foundation of creating reports with SQL Server Reporting Services. First, you will explore embedded and shared data sources, and data sets to populate report objects. Next, you will learn about non-database data sources such as csv and xml. Finally, you will discover how to source data from Azure and Analysis Services, and how to use custom expressions in data sources and sets. By the end of this course, you'll know where to go to create data sources and data sets in reporting services.

Enroll now

What's inside

Syllabus

Course Overview
Introduction
Learning Data Sources
Creating a Data Set
Read more
Using a SQL Server Database
Exploring File Data Source Types
Implementing Other Data Sources
Tackling Advanced Concepts with Data Sets

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
This course emphasizes data sources, which is essential to data reporting
Explores multiple data source types and demonstrates how to source data from Azure and Analysis Services
Helps learners understand how data sources are the basis for creating reports in SQL Server Reporting Services
Intended for learners who want to create effective reports with accurate data sources
Teaches how to configure data sources and use data sets to populate report objects

Save this course

Save SQL Server Reporting Services 2014: Data Sourcing Playbook 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 SQL Server Reporting Services 2014: Data Sourcing Playbook with these activities:
Review Data sets in Reporting Services (SSRS)
Refresh understanding of data sets in Reporting Services to build a strong foundation for this course.
Browse courses on Data Sets
Show steps
  • Review the role of data sets in SSRS
  • Review the different types of data sets in SSRS
Review Data Sources
Review the facets of data in SQL Server Reporting Services to prepare for success in this course.
Browse courses on Data Sources
Show steps
  • Review the embedded and shared data sources
  • Review the data sets populated in report objects
Seek out Tutorials on data sources
To better assimilate the information from this course, explore tutorials on data sources.
Browse courses on Data Sources
Show steps
  • Explore beginner tutorials on data sources in SSRS
  • Explore intermediate tutorials on data sources in SSRS
Five other activities
Expand to see all activities and additional details
Show all eight activities
Practice using data sources in SSRS
Hone the skills of using data sources in SSRS through practice drills.
Browse courses on Data Sources
Show steps
  • Practice creating data sources and data sets
  • Practice using data sources and data sets in reports
Seek out Tutorials on data sets in SSRS
Expand understanding of data sets in SSRS by exploring tutorials.
Browse courses on Data Sets
Show steps
  • Explore beginner tutorials on data sets in SSRS
  • Explore intermediate tutorials on data sets in SSRS
Create a Report using Data Sources
Solidify understanding of data sources in SSRS by creating a report.
Browse courses on Data Sources
Show steps
  • Gather and prepare data
  • Create a report layout
  • Publish the report
Practice using data sets in SSRS
Practice using data sets in SSRS to reinforce the concepts learned in this course.
Browse courses on Data Sets
Show steps
  • Practice creating and using data sets
  • Practice using data sets in reports
Create a Presentation on Data Sources and Data Sets
Reinforce understanding of data sources and data sets by creating a presentation.
Browse courses on Data Sources
Show steps
  • Gather information on data sources and data sets
  • Organize and structure the presentation
  • Record and edit the presentation

Career center

Learners who complete SQL Server Reporting Services 2014: Data Sourcing Playbook will develop knowledge and skills that may be useful to these careers:
Data Analyst
Data Analysts use a company's data to help make better decisions. You will learn through SQL Server Reporting Services 2014: Data Sourcing Playbook how to bring together data from many different sources, which is a very useful skill in Data Analysis. Many large companies use SQL Server Reporting Services to make their reporting more efficient.
Software Engineer
Software Engineers are responsible for designing, implementing, testing, and maintaining software systems. As part of that design process, it's necessary to understand how the data for the app will be stored and retrieved. The topics covered in SQL Server Reporting Services 2014: Data Sourcing Playbook lay a foundation for understanding data structures and allows the Software Engineer to make better design decisions about how they will build their application.
Database Administrator
Database Administrators are responsible for the installation, configuration, and maintenance of databases. As part of this role, they will need to work with data that comes from many different sources. Through SQL Server Reporting Services 2014: Data Sourcing Playbook, a Database Administrator will build a foundation for understanding how to manage data from multiple sources. This is a critical aspect of designing scalable data storage.
Business Analyst
Business Analysts are responsible for understanding the business needs of an organization and then translating those needs into technical requirements. SQL Server Reporting Services 2014: Data Sourcing Playbook provides the foundational knowledge to understand the many places that data will come from. With data sources becoming more and more complex, this is an increasingly in-demand skill for the Business Analyst.
Data Architect
Data Architects design and build the systems that store and manage data for organizations. For them to be able to design systems that meet the needs of the business, they must have a deep understanding of data sources and how they integrate. SQL Server Reporting Services 2014: Data Sourcing Playbook covers these topics in-depth, providing Data Architects the opportunity to build a strong foundation in data design.
Systems Analyst
Systems Analysts are responsible for the analysis, design, and implementation of computer systems. As part of this role, they will need to understand how data is stored and managed in order to design systems that can effectively access and use data. SQL Server Reporting Services 2014: Data Sourcing Playbook may be useful because it covers the different types of data sources and how they are used.
Information Security Analyst
Information Security Analysts are responsible for protecting an organization's data from unauthorized access, use, disclosure, disruption, modification, or destruction. As part of this role, they will need to understand how data is stored and managed throughout the organization. SQL Server Reporting Services 2014: Data Sourcing Playbook may be useful for building this understanding by exploring the different types of data sources and how they are used.
Operations Research Analyst
Operations Research Analysts use advanced analytical techniques to help organizations make better decisions. As part of this role, they will need to understand how data is stored and managed in order to access and use it in their analyses. SQL Server Reporting Services 2014: Data Sourcing Playbook may be useful because it covers the different types of data sources and how they are used.
Computer Systems Analyst
Computer Systems Analysts are responsible for the analysis, design, and implementation of computer systems. As part of this role, they will need to understand how data is stored and managed in order to design systems that can effectively access and use data. SQL Server Reporting Services 2014: Data Sourcing Playbook may be useful because it covers the different types of data sources and how they are used.
Statistician
Statisticians use statistical methods to collect, analyze, interpret, and present data. As part of this role, they will need to understand how data is stored and managed in order to access and use it in their analyses. SQL Server Reporting Services 2014: Data Sourcing Playbook may be useful because it covers the different types of data sources and how they are used.
Web Developer
Web Developers design and develop websites and web applications. As part of this role, they may need to work with data from different sources in order to create dynamic and interactive web pages. SQL Server Reporting Services 2014: Data Sourcing Playbook may be useful because it covers the different types of data sources and how they are used.
Database Developer
Database Developers design, develop, and maintain databases. As part of this role, they will need to understand how data is stored and managed in order to design and implement effective database solutions. SQL Server Reporting Services 2014: Data Sourcing Playbook may be useful because it covers the different types of data sources and how they are used.
Data Scientist
Data Scientists use data to solve business problems. As part of this role, they will need to understand how data is stored and managed in order to access and use it in their analyses. SQL Server Reporting Services 2014: Data Sourcing Playbook may be useful because it covers the different types of data sources and how they are used.
Financial Analyst
Financial Analysts use financial data to make investment recommendations. As part of this role, they will need to understand how data is stored and managed in order to access and use it in their analyses. SQL Server Reporting Services 2014: Data Sourcing Playbook may be useful because it covers the different types of data sources and how they are used.
Market Research Analyst
Market Research Analysts conduct research on markets and customers. As part of this role, they will need to understand how data is stored and managed in order to access and use it in their analyses. SQL Server Reporting Services 2014: Data Sourcing Playbook may be useful because it covers the different types of data sources and how they are used.

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 SQL Server Reporting Services 2014: Data Sourcing Playbook.
Presents advanced patterns and practices for designing, developing, and deploying SSRS solutions. Useful for experienced developers seeking to enhance their skills and create high-quality reports.
Provides in-depth coverage of SSRS, including advanced topics such as data sources.
Covers SSRS features introduced in SQL Server 2019, such as embedded Power BI reports, paginated report enhancements, and improved data connectivity.
Although it covers an older version of SSRS, this book provides valuable insights into data source configuration and report design principles that remain relevant in newer versions.
Provides a concise overview of SQL Server Reporting Services, including data sources and data sets. It's suitable as a quick reference or introductory resource for those new to the topic.

Share

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

Similar courses

Here are nine courses similar to SQL Server Reporting Services 2014: Data Sourcing Playbook.
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