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
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