Ota yhteyttä

Myyntipalvelu

Myynti

010 4321 001 Ota yhteyttä

Kesto: 2 päivää
Veroton hinta (+ alv 24 %): 2 251 €
Voit maksaa:
Koulutuskortti SA-VOUCHER

Haluatko koulutuksen asiakaskohtaisena? Jätä yhteystietosi, niin palaamme asiaan. 

Jaa

Lataa pdf-muodossa

Implementing Reports with Microsoft SQL Server - Optimized

The focus of this 2 day optimized instructor-led course is on creating and delivering reports with Microsoft SQL Server Reporting Services.

The course also gives a brief introduction to Business Intelligence and Data Modeling.

Target audience

  • BI Developers
  • Advanced users who want to pick out and present figures/charts from their systems

Prerequisites

  • At least 2 years’ experience of working with relational databases, including:
  • Querying with Transact-SQL.
  • Some basic knowledge of data warehouse schema topology (including star and snowflake schemas).
  • Some exposure to basic programming constructs (such as looping and branching).
  • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.

Recommended courses before this one;

Language

Training material

Microsoft dMOC

NOTE: The course in 24-25 of August will be held in English

After completing this course, students will be able to:

  • Create reports with Reporting Services.
  • Enhance reports with charts and parameters.
  • Manage report execution and delivery.

Course Outline:

Module 1: Introduction to Business Intelligence and Data Modeling

As a SQL Server database professional, you may be required to participate in, or perhaps even lead, a project with the aim of implementing an effective enterprise BI solution. Therefore, it is important that you have a good understanding of the various elements that comprise a BI solution, the business and IT personnel typically involved in a BI project, and the Microsoft products that you can use to implement the solution.

  • Elements of an Enterprise BI Solution
  • The Microsoft Enterprise BI Platform
  • Planning an Enterprise BI Project

Module 9: Implementing Reports with SQL Server Reporting Services

This module introduces Microsoft SQL Server Reporting Services and discusses the tools and techniques that a professional BI developer can use to create and publish reports.

  • Introduction to Reporting Services
  • Creating a Report with Report Designer
  • Grouping and Aggregating Data in a Report
  • Publishing and Viewing a Report

Module 10: Enhancing Reports with SQL Server Reporting Services

This module describes how to enhance a SQL Server reporting Services report with charts and other visualizations, and how to use parameters to filter data in a report.

  • Showing Data Graphically
  • Filtering Reports by Using Parameters

Module 11: Managing Report Execution and Delivery

This module describes how to apply security and report execution settings, and how to create subscriptions to deliver reports.

  • Managing Report Security
  • Managing Report Execution
  • Subscriptions and Data Alerts
  • Troubleshooting Reporting Services