Designing Reports & Creating Data Sources

SQL Server 2014    |    Expert
  • 13 videos | 1h 11m 33s
  • Earns a Badge
Rating 4.6 of 9 users Rating 4.6 of 9 users (9)
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 42s
    After 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 31s
    Upon 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
  • Locked
    3.  Identifying Report Components
    6m 29s
    After 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
  • Locked
    4.  Creating a Reporting Services Project
    6m 3s
    In this video, learn how to choose and create a new Reporting Services project in SSDT. FREE ACCESS
  • Locked
    5.  Installing Reporting Services
    6m 59s
    Find out how to install Reporting Services using different configurations. FREE ACCESS
  • Locked
    6.  Configuring Reporting Services
    7m 35s
    Find out how to configure Reporting Services. FREE ACCESS
  • Locked
    7.  Creating a Shared Data Source
    7m 10s
    Learn how to create a shared data source. FREE ACCESS
  • Locked
    8.  Creating a Connection to Azure SQL Database
    5m 1s
    In this video, you will learn how to create a shared data source that connects to a Microsoft Azure Database. FREE ACCESS
  • Locked
    9.  Creating a Data Source to a Non-Relational Database
    4m
    In this video, you will learn how to create a shared data source that connects to a non-relational database. FREE ACCESS
  • Locked
    10.  Using Custom Expressions in a Data Source
    3m 41s
    In this video, you will learn how to use custom expressions in a data source. FREE ACCESS
  • Locked
    11.  Creating an Embedded Data Source
    5m
    Learn how to create an embedded data source. FREE ACCESS
  • Locked
    12.  Configuring a Parameterized Connection String
    4m 49s
    In this video, learn how to configure a parameterized connection string to connect to a database. FREE ACCESS
  • Locked
    13.  Connection to Azure Marketplace
    3m 33s
    In 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.

YOU MIGHT ALSO LIKE

Book HR Reporting with Stories in SAP SuccessFactors People Analytics
Course Creating reports in Project 2022
Rating 4.2 of 17 users Rating 4.2 of 17 users (17)
Course Database Fundamentals: Understanding Relational Database Management Systems
Rating 4.5 of 175 users Rating 4.5 of 175 users (175)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Inserting, Importing & Formatting Data in Access 2019 for Windows
Rating 4.4 of 71 users Rating 4.4 of 71 users (71)
Course Applications in the Cloud: Azure Serverless DevOps Essentials
Rating 4.7 of 25 users Rating 4.7 of 25 users (25)
Course Designing Reports & Creating Datasets
Rating 4.0 of 6 users Rating 4.0 of 6 users (6)