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.
Author Name: Amruta Mahajan
Author Description:
Amruta is an experienced Data Analyst with over 12 years of experience in interpreting and analyzing data to drive successful business outcomes. She loves tackling hard problems using data manipulation as her superpower and has worked with market leaders from various fields including Standard & Poors, McDonalds, Mondelez International, General Electric, AMD and Beam Suntory. Amruta is passionate about both teaching and learning and believes “The purpose of life is to discover your gift. The work… more

Table of Contents

• Course Overview
  1min
• Connecting to SQL Server Database
  22mins
• Connecting to Other Data Sources
  24mins
• Embedded and Shared Data Sources
  12mins
• Understanding Datasets
  18mins
• Customizing SSRS Report Using Advanced Features
  20mins