MS20466_RS

Ladda ner som PDF

Implementing Reports with Microsoft SQL Server

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.

Audience

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

Prior knowledge

  • 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

The course is taught in Swedish (Contact us if you prefer English).

Courseware

Microsoft dMOC

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 ... Läs mer

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

Utbildningen levereras i samarbete med

Kursfakta

Kurs-ID: MS20466_RS
Längd: 2 dagar
Pris exkl moms: 21 450 kr
Inregistrering: 09.00
Kursstart: 09.30
Kursslut (ca): 17.00

Frågor om kursen?

Har du frågor om kursens innehåll, leveransdatum/ort eller behöver en företagsanpassad variant? Fyll i formuläret nedan!


Kan betalas med:
TRAINING CARD SA-VOUCHER

Ort och datum

Stockholm
14 dec-15 dec
Boka nu!
1 mar-2 mar
Boka nu!
7 jun-8 jun
Boka nu!
Göteborg
14 dec-15 dec
R
Boka nu!
1 mar-2 mar
R
Boka nu!
7 jun-8 jun
R
Boka nu!
Malmö
14 dec-15 dec
R
Boka nu!
Cloud Access
i Läs mer

Delta på kursen från ditt hem, jobb eller annan plats.

14 dec-15 dec
Boka nu!
1 mar-2 mar
Boka nu!
7 jun-8 jun
Boka nu!