Designing Reports & Creating Datasets

SQL Server 2014
  • 8 Videos | 37m 18s
  • Includes Assessment
  • Earns a Badge
Likes 13 Likes 13
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.

YOU MIGHT ALSO LIKE

Likes 26 Likes 26  
CHANNEL MariaDB
Likes 7 Likes 7  
Likes 9 Likes 9