MS20466_RS

Ladda ner som PDF

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.

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

Informator Training Cloud

Our training portal supports your development throughout the training. The portal saves you time and is designed to give you a more effective learning experience - leading to better results and greater knowledge enforcement after the course. Read more >

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

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

Utbildningen levereras i samarbete med

Kurs-ID: MS20466_RS
Längd: 2 dagar
Pris exkl moms: 21 450 kr

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
27 okt – 28 okt
Boka nu!
15 dec – 16 dec
Boka nu!
Göteborg
27 okt – 28 okt R
Boka nu!
15 dec – 16 dec R
Boka nu!
Malmö
27 okt – 28 okt R
Boka nu!
15 dec – 16 dec R
Boka nu!
Cloud Access
i Läs mer

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

27 okt – 28 okt
Boka nu!
15 dec – 16 dec
Boka nu!

Tipsa