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

Course Non-relational Data: Non-relational Databases
Rating 4.5 of 41 users Rating 4.5 of 41 users (41)
Book Beginning Database Design Solutions: Understanding and Implementing Database Design Concepts for the Cloud and Beyond, Second Edition
Book SQL Server Analytical Toolkit: Using Windowing, Analytical, Ranking, and Aggregate Functions for Data and Statistical Analysis

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Designing & Implementing Dimensions
Rating 4.5 of 13 users Rating 4.5 of 13 users (13)
Course Business Reporting: Getting Started with Power BI Desktop for Data Analysis
Rating 4.6 of 1028 users Rating 4.6 of 1028 users (1028)
Course Managing Reporting Services
Rating 4.4 of 11 users Rating 4.4 of 11 users (11)