-
Course
- Data
SSRS Data Sourcing Playbook
SQL Server Reporting Services (SSRS) is a powerful reporting tool that is tightly coupled with SQL Server. This course will teach you how to collate, configure, and customize data from various sources to be used in building reports with SSRS.
What you'll learn
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.
Table of contents
- Version Check | 15s
- Course Introduction | 4m 24s
- Tools and Databases Used | 48s
- Basic SSRS Concepts | 3m 51s
- Connecting to SQL Server (On-premise) | 2m 43s
- Demo: SQL Server Connection Type, Text Query | 4m 7s
- Demo: OLE DB Connection Type, Table Query | 1m 24s
- Demo: ODBC Connection Type, Stored Procedure Query | 2m 6s
- Connecting to Microsoft Azure SQL Database | 45s
- Demo: Connecting to Microsoft Azure SQL Database | 2m 7s
About the author
Amruta is a data Analyst & Excel VBA ninja who's worked with market leaders in Finance & Consumer Goods. She is passionate about sharing her gift for data manipulation and visualization.
More Courses by Amruta