Designing Reports & Creating Data Sources
SQL Server 2014
| Expert
- 13 videos | 1h 11m 33s
- Earns a Badge
You can access SQL Server Reporting Services (SSRS) reports from a variety of sources. Learn how to install and configure the Reporting Services topologies, plan and create reports, and create the data sources for data retrieval.
WHAT YOU WILL LEARN
-
describe how a report server is interacted with depending on the deployment topology and configuration
describe what needs to be considered during planning to create a report, including the format, structure, data, calculations, and delivery among others
describe the different report components for planning a report, including crosstab, Tablix, design chart, and data visualization components
choose and create a new Reporting Services project in SSDT
install Reporting Services using different topologies
configure Reporting Services
create a shared data source -
create a shared data source that connects to Microsoft Azure Database
create a shared data source that connects to a non-relational database
use custom expressions in a data source
create an embedded data source
configure a parameterized connection string to connect to a database
connect to Microsoft Azure Marketplace in a data source
IN THIS COURSE
-
5m 42sAfter completing this video, you will be able to describe how a report server is interacted with, depending on the deployment topology and configuration. FREE ACCESS
-
5m 31sUpon completion of this video, you will be able to describe what needs to be considered during planning to create a report, including the format, structure, data, calculations, and delivery, among others. FREE ACCESS
-
3. Identifying Report Components6m 29sAfter completing this video, you will be able to describe the different report components for planning a report, including crosstab, Tablix, design chart, and data visualization components. FREE ACCESS
-
4. Creating a Reporting Services Project6m 3sIn this video, learn how to choose and create a new Reporting Services project in SSDT. FREE ACCESS
-
5. Installing Reporting Services6m 59sFind out how to install Reporting Services using different configurations. FREE ACCESS
-
6. Configuring Reporting Services7m 35sFind out how to configure Reporting Services. FREE ACCESS
-
7. Creating a Shared Data Source7m 10sLearn how to create a shared data source. FREE ACCESS
-
8. Creating a Connection to Azure SQL Database5m 1sIn this video, you will learn how to create a shared data source that connects to a Microsoft Azure Database. FREE ACCESS
-
9. Creating a Data Source to a Non-Relational Database4mIn this video, you will learn how to create a shared data source that connects to a non-relational database. FREE ACCESS
-
10. Using Custom Expressions in a Data Source3m 41sIn this video, you will learn how to use custom expressions in a data source. FREE ACCESS
-
11. Creating an Embedded Data Source5mLearn how to create an embedded data source. FREE ACCESS
-
12. Configuring a Parameterized Connection String4m 49sIn this video, learn how to configure a parameterized connection string to connect to a database. FREE ACCESS
-
13. Connection to Azure Marketplace3m 33sIn this video, learn how to connect to Microsoft Azure Marketplace as a data source. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
