• Online, Self-Paced
Course Description

SQL Server Reporting Services or SSRS enables developers to create robust reports, which can be accessed from a variety of sources. To create reports, SQL Server Reporting Services needs to be installed in either Native mode or SharePoint mode. The topology that is chosen depends on if you need to integrate the reports with SharePoint. The first step in creating reports is deciding what data is required and from where and which tool you will use to create the reports. This course will discuss the Reporting Services topologies and how to install and configure them. It will then discuss and show how to create the data sources and datasets to connect to and retrieve the data for the report. This course is one in a series of Skillsoft courses to help prepare learners for the 70-466 Implementing Data Models and Reports with Microsoft SQL Server certification exam.

Learning Objectives

Report Design

  • start the course
  • 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 SQL Server Data Tools or SSDT
  • install Reporting Services using different topologies
  • configure reporting services

Data Source Creation

  • 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 the Microsoft Azure Marketplace in a data source

Datasets Creation

  • 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 a Multidimensional Expressions or MDX query to create a dataset using the Multidimensional MDX Query Designer
  • use a Data Access Expressions or DAX query to create a dataset using the DAX Query Designer

Practice: Data Source and Dataset Creation

  • create data sources and datasets in Reporting Services

Framework Connections

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • Data Administration