SQL Server Reporting Services 2014: Data Sourcing Playbook

Focused View

Thomas LeBlanc

2:23:04

32 View

00. Course Overview

00. Course Overview.mp4

01:29

01. Introduction

00. Introduction to Data Sourcing Playbook.mp4

03:13

01. How to Use Files in This Course.mp4

04:20

02. Learning Data Sources

00. Introduction to Data Sources.mp4

02:48

01. Demo - Adding Data Sources.mp4

03:14

02. Shared Data Sources.mp4

02:26

03. Demo - Shared Data Source.mp4

06:56

04. Using Multiple Data Sources.mp4

01:20

05. Demo - Multiple Data Source.mp4

04:08

06. Dynamic Data Source Connection String.mp4

01:51

07. Demo - Dynamic Data Source Connection String.mp4

02:44

03. Creating a Data Set

00. Introduction to Data Sets.mp4

02:08

01. Demo - Creating a Data Set.mp4

03:39

02. Data Set Options.mp4

01:17

03. Demo - Data Set Options.mp4

02:01

04. Data Set Filters and Parameters.mp4

01:29

05. Demo - Data Set Filters and Parameters.mp4

04:14

06. Data Set Summary.mp4

00:47

04. Using a SQL Server Database

00. Intro to SQL Server T-SQL.mp4

03:13

01. Demo - SQL Server T-SQL.mp4

05:36

02. Querying SQL Server Tables or VIews.mp4

01:06

03. Demo - Table and Views.mp4

04:16

04. Using Stored Procedures.mp4

00:40

05. Demo - Stored Procedure.mp4

03:26

06. Options for Using Synonyms.mp4

01:25

07. Demo - Synonym.mp4

02:13

08. Linked Servers in SQL Server.mp4

02:31

09. Demo - Linked Server.mp4

01:58

05. Exploring File Data Source Types

00. Intro and CSV Files.mp4

04:35

01. Demo - CSV File.mp4

00:15

02. XML Data Source.mp4

03:05

03. Demo - XML Data.mp4

04:57

04. Sharepoint List.mp4

04:43

05. File Data Source Summary.mp4

01:22

06. Implementing Other Data Sources

00. Introduction and Tabular Analysis Services.mp4

06:04

01. Demo - Tabular Analysis Services.mp4

06:15

02. Multidimensional Cube Analysis Services.mp4

04:19

03. Demo - Multidimensional Cube.mp4

04:59

04. Azure SQL Database.mp4

02:47

05. Demo - Azure DB.mp4

02:28

06. Other Data Sources Summary.mp4

00:46

07. Tackling Advanced Concepts with Data Sets

00. Introduction of Advanced Concepts with Filters.mp4

04:57

01. Demo - Filters.mp4

08:33

02. Expressions and Lookup.mp4

02:28

03. Demo - Expressions and Lookup.mp4

04:03

Description

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.

What You'll Learn?

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL Server

Microsoft SQL

Thomas LeBlanc

Instructor's Courses

Thomas LeBlanc (Microsoft Data Platform MVP) is a Data Enthusiast in Baton Rouge, La. He started his IT career as a COBOL programmer in 1989 while at LSU. Since then he has spent years as a developer, DBA and Data Warehousing/Business Intelligence Architect. Community involve includes the local SQL Server and Analytics User Groups as well as SQLSaturday. Speaking engagements have been a blessing at SQL Pass Summit, Live 360, VSLive and IT Dev Connections.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.