• Online, Self-Paced
Course 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).

Learning Objectives

Deliver BI Solutions

  • 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

Plan SSRS Architecture

  • 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

Design Data Sources

  • 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

Design Datasets

  • 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 a Reporting Solution

  • 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

Practice: Design Reporting Services Solutions

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

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.