Designing Reports & Creating Datasets

SQL Server 2014    |    Expert
  • 8 videos | 34m 18s
  • Includes Assessment
  • Earns a Badge
Likes 21 Likes 21
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

Course Working with report tables and charts in Project 2022
Channel MariaDB
Likes 10 Likes 10  
Book Querying MariaDB: Use SQL Operations,Data Extraction, and Custom Queries to Make your MariaDB Database Analytics more Accessible

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Configuring & Using Peripheral Devices in Windows 10 (Fall Creators Update)
Likes 18 Likes 18  
Course PL-300: Working with Filters in Power BI
Course Creating reports in Project 2022