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

  • Playable
    1. 
    Creating an Embedded Dataset Using a Text Query
    5m 4s
    UP NEXT
  • Playable
    2. 
    Creating an Embedded Dataset Using a Stored Procedure
    3m 32s
  • Locked
    3. 
    Creating an Embedded Dataset Using a Table Query Type
    2m 37s
  • Locked
    4. 
    Using a Shared Dataset in a Report
    4m 28s
  • Locked
    5. 
    Defining Filters Options for Datasets
    5m 12s
  • Locked
    6. 
    Defining Parameters for Datasets
    3m 51s
  • Locked
    7. 
    Using MDX Queries to Create a Dataset
    5m 26s
  • Locked
    8. 
    Using DAX Queries to Create a Dataset
    4m 8s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.