Designing Reports & Creating Datasets

SQL Server 2014    |    Expert
  • 8 videos | 34m 18s
  • Includes Assessment
  • Earns a Badge
Rating 4.0 of 6 users Rating 4.0 of 6 users (6)
To create a SQL Server Reporting Services (SSRS) report, you retrieve the data from a data source into a dataset. Explore different methods of dataset creation, including using stored procedures, and MDX and DAX queries.

WHAT YOU WILL LEARN

  • Create an embedded dataset in a report by specifying a text query type
    Create an embedded dataset in a report by specifying a stored procedure in the query designer or selecting a predefined one
    Create an embedded dataset in a report by using a table query type
    Specify a shared dataset in a report
  • Define the filter options for a dataset
    Define parameters for a dataset
    Use an mdx query to create a dataset using the mdx query designer
    Use a dax  query to create a dataset using the dax query designer

IN THIS COURSE

  • 5m 4s
    In this video, find out how to create an embedded dataset in a report by specifying a text query type. FREE ACCESS
  • 3m 32s
    In this video, learn how to create an embedded dataset in a report by specifying a stored procedure in the Query Designer or selecting a predefined one. FREE ACCESS
  • Locked
    3.  Creating an Embedded Dataset Using a Table Query Type
    2m 37s
    To create an embedded dataset in a report using a table query type: FREE ACCESS
  • Locked
    4.  Using a Shared Dataset in a Report
    4m 28s
    Upon completion of this video, you will be able to specify a shared dataset in a report. FREE ACCESS
  • Locked
    5.  Defining Filters Options for Datasets
    5m 12s
    Learn how to set the filter options for a dataset. FREE ACCESS
  • Locked
    6.  Defining Parameters for Datasets
    3m 51s
    In this video, you will learn how to define parameters for a dataset. FREE ACCESS
  • Locked
    7.  Using MDX Queries to Create a Dataset
    5m 26s
    In this video, you will learn how to use an MDX query to create a dataset using the MDX Query Designer. FREE ACCESS
  • Locked
    8.  Using DAX Queries to Create a Dataset
    4m 8s
    During this video, you will learn how to use a DAX query to create a dataset using the DAX Query Designer. 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 SQL Server Analytical Toolkit: Using Windowing, Analytical, Ranking, and Aggregate Functions for Data and Statistical Analysis
Course Creating reports in Project 2022
Rating 4.2 of 17 users Rating 4.2 of 17 users (17)
Course Querying SQL Databases: Using Generative AI Tools to Filter & Group Data
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course AWS Developer Associate: Troubleshooting & Monitoring on AWS
Rating 4.5 of 20 users Rating 4.5 of 20 users (20)
Course AWS SysOps Associate 2021: Managing AWS Costs
Rating 4.6 of 35 users Rating 4.6 of 35 users (35)
Course Designing Reports & Creating Data Sources
Rating 4.6 of 9 users Rating 4.6 of 9 users (9)