SQL Server Reporting Services: Data Sourcing Playbook

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.
Course info
Level
Intermediate
Updated
Sep 12, 2019
Duration
2h 23m
Table of contents
Course Overview
Introduction
Learning Data Sources
Creating a Data Set
Using a SQL Server Database
Exploring File Data Source Types
Implementing Other Data Sources
Tackling Advanced Concepts with Data Sets
Description
Course info
Level
Intermediate
Updated
Sep 12, 2019
Duration
2h 23m
Description

SQL Server Reporting Services (SSRS) is the gold standard for reporting data. In this course, SQL Server Reporting Services: 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.

About the author
About the author

Microsoft Data Platform MVP specializing in SQL Server, Microsoft Business Intelligence (SSIS, SSAS & SSRS) and Power BI.

Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
(Music) Hello everyone. My name's Thomas LeBlanc. Welcome to my course, Data Sourcing Playbook for SQL Server Reporting Services. I'm a data warehouse architect at Data On The Geaux. The data source is the foundation of creating reports with SQL Server Reporting Services. Knowing where to get an answer about a particular option to a data source or discovering a property on a dataset, this is where this course can be most helpful to you. Some of the major topics that we'll cover include embedded and shared data sources, datasets to populate report objects, discovering non-database data sources, like CSV or XML, diving into SQL Server database data, sourcing data from Azure and Analysis Services, and using custom expression in data sources and datasets. By the end of this course, you'll know where to go to create a data source and to create a dataset in Reporting Services. Before you begin this course, you should be familiar with SQL Server, as well as Management Studio, along with one of the reporting tools, the report builder or the report writer, for SQL Server Data Tools. I hope you'll join me on this journey to learn data sources with SQL Server Reporting Services, here at Pluralsight.