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