Course Details

Previous Page


Microsoft SQL Server 2014: Design Reports and Create Data Sources and Datasets


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number



Overview/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.

Target Audience
Business intelligence developers who create reporting and analysis solutions and individuals interested in taking the Implementing Data Models and Reports with Microsoft SQL Server certification exam

Prerequisites
None

Expected Duration (hours)
2.1

Lesson Objectives

Microsoft SQL Server 2014: Design Reports and Create Data Sources and Datasets

  • 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
  • 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
  • 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
  • create data sources and datasets in Reporting Services
  • Course Number:
    md_idmr_a09_it_enus