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.
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.
This course is no longer available. Find something similar by browsing:
SQL Server Reporting Services
Data Sources
Data Sets
Embedded Data Sources
Shared Data Sources
CSV Data Sources
XML Data Sources
Register for this course and see more details by visiting:
OpenCourser.com/course/gzfbi7/sql
What's inside
Syllabus
Course Overview
Introduction
Learning Data Sources
Creating a Data Set
Read more
Syllabus
Course Overview
Introduction
Learning Data Sources
Creating a Data Set
Read more
Traffic lights
Traffic lights
Read about what's good
what should give you pause 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
Create your own learning path.
Save this course to your list so you can find it easily later.
Save
Save
Reviews summary
Ssrs 2014 data sourcing core concepts
According to learners, this course offers a largely positive and comprehensive foundation in SSRS 2014 data sourcing. Students praise its clear explanations, practical hands-on examples, and the instructor's ability to simplify complex topics. It effectively covers various data source types, from SQL Server to Azure and XML, making it highly valuable for report developers. While some note the user interface may appear dated, the core concepts remain relevant and build a solid understanding for professionals. The course is particularly well-suited for those new to SSRS data connectivity, though more experienced users might desire deeper, advanced content.
Ideal for beginners, but less suitable for advanced users seeking depth.
"The content is informative, but the pace felt a bit slow, especially for me, someone with prior experience."
"I felt this course was too basic for my needs; it didn't go into enough depth on complex query scenarios."
"For anyone new to SSRS data connectivity, this is a great starting point, though experienced users might find parts redundant."
Fundamental data sourcing principles remain applicable over time.
"While it's 2014, the core concepts of data sourcing are still highly relevant and the instructor covers them thoroughly."
"Even though it's an older version, I found the principles to be timeless and highly valuable."
"The content remains relevant despite the '2014' in the title, which is a great plus for learning."
Provides valuable examples for real-world application of concepts.
"The hands-on examples were very helpful for understanding how to set up connections."
"I found the examples practical, and I could apply what I learned directly to my projects."
"The focus on practical applications rather than just theory really built my confidence in SSRS."
Instructor simplifies complex data sourcing topics effectively.
"This course provided an excellent deep dive into SSRS data sourcing. I found the explanations... to be incredibly clear and practical."
"The instructor's explanations were concise and easy to follow. I particularly appreciated the detailed walkthroughs."
"The instructor breaks down complex topics into digestible lessons. I learned a lot about best practices for structuring data sets."
The UI shown reflects an older SSRS version, requiring adaptation.
"I noticed that some of the UI screenshots seemed a little dated, reflecting the 2014 version."
"The interface shown is old, and I found myself having to translate some steps to the newer UI."
"I would say it is a bit outdated for current SSRS versions, but the fundamental concepts are still there."
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)
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Review Data sets in Reporting Services (SSRS)
Show steps
Refresh understanding of data sets in Reporting Services to build a strong foundation for this course.
Browse courses on
Data Sets
Show steps
Show steps
Show steps
- Review the role of data sets in SSRS
- Review the different types of data sets in SSRS
Review Data Sources
Show steps
Review the facets of data in SQL Server Reporting Services to prepare for success in this course.
Browse courses on
Data Sources
Show steps
Show steps
Show steps
- Review the embedded and shared data sources
- Review the data sets populated in report objects
Seek out Tutorials on data sources
Show steps
To better assimilate the information from this course, explore tutorials on data sources.
Browse courses on
Data Sources
Show steps
Show steps
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
Show steps
Hone the skills of using data sources in SSRS through practice drills.
Browse courses on
Data Sources
Show steps
Show steps
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
Show steps
Expand understanding of data sets in SSRS by exploring tutorials.
Browse courses on
Data Sets
Show steps
Show steps
Show steps
- Explore beginner tutorials on data sets in SSRS
- Explore intermediate tutorials on data sets in SSRS
Create a Report using Data Sources
Show steps
Solidify understanding of data sources in SSRS by creating a report.
Browse courses on
Data Sources
Show steps
Show steps
Show steps
- Gather and prepare data
- Create a report layout
- Publish the report
Practice using data sets in SSRS
Show steps
Practice using data sets in SSRS to reinforce the concepts learned in this course.
Browse courses on
Data Sets
Show steps
Show steps
Show steps
- Practice creating and using data sets
- Practice using data sets in reports
Create a Presentation on Data Sources and Data Sets
Show steps
Reinforce understanding of data sources and data sets by creating a presentation.
Browse courses on
Data Sources
Show steps
Show steps
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 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 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.
Business Analyst
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.
Database Administrator
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.
Data Architect
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.
Information Security Analyst
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.
Systems Analyst
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.
Operations Research Analyst
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 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
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 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 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 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 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 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.
For more career information including salaries, visit:
OpenCourser.com/course/gzfbi7/sql
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.
Provides comprehensive coverage of SSRS, including data sources.
Provides a comprehensive guide to troubleshooting in SSRS.
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.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/gzfbi7/sql
Share
Similar courses
Similar courses are unavailable at this time. Please try again later.
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 - 2025 OpenCourser