Microsoft SQL Server 2014 - Designing BI Solutions: Reporting Services

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

---

Overview/Description
The primary goal of a Business Intelligence solution is the delivery of meaningful data to the business users to make informed decisions required the business. During the planning of the BI solution, you need to include the design and creation of the Reporting Services solution to create and deliver the reports. In this course, you will explore how to design and create a reporting services solution to create reports for delivery. This course is one of a series in the Skillsoft learning path that helps individuals prepare for the Designing Business Intelligence Solutions with Microsoft SQL Server exam (70-467).

Target Audience
Database and business intelligence administrators and developers who are responsible for designing a BI infrastructure, IT professionals interested learning how to design BI infrastructures and how they're related to data systems, and individuals interested in taking the Designing Business Intelligence Solutions with Microsoft SQL Server exam (70-467)

Prerequisites
None

Expected Duration (hours)
2.8

Lesson Objectives

Microsoft SQL Server 2014 - Designing BI Solutions: Reporting Services

start the course

describe how reporting and analysis fit into a BI solution and how data sources are used

describe the key characteristics of common reporting scenarios used for BI solutions

describe the tools offered to create and delivery reports

describe how SharePoint can be used for reporting and describe the guidelines for choosing the correct reporting tool

describe the Reporting Services infrastructure

describe the key considerations for reports in a BI solution

describe the Reporting Services modes and when to choose a mode, given a scenario

plan for report delivery, including planning for security

design for specific report types, including interactive, graphical, and report rendering

describe the requirements, hardware and software, for the different SSRS configurations

describe the considerations for designing data source and datasets for a report

design a data movement strategy and profile source data

create a shared or embedded data source

create stored credentials to determine who can access the data in the report

design for data retention

customize data acquisition using DAX with reporting services data sources

create a dataset using query parameters

manage datasets using store procedures

create appropriate DAX queries for an application

extract data from analysis services by using MDX queries

manage data rights and security for a dataset

design and create a report template to ensure report consistency

design and create linked reports, including sub-reports

design and create a drill-through report

design map visualization and create a report with a map

design a Reporting Services solution, including designing and planning the infrastructure, data sources, datasets, and different report types

Course Number:
md_dbis_a04_it_enus

Expertise Level
Expert