Analyzing Data with SQL Server Reporting Services (MOC 10990)

This three-day instructor-led course teaches students how to implement a SQL Server 2016 Reporting Services solution for data analysis in an organization. The course discusses how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions.

Kursusmål


• Describe key features of data modelling within business intelligence
• Describe various report services data sources and how these are configured
• Create reports with report designer and/or report designer
• Configure reports with report designer and/or report builder
• Create SQL Server mobile reports

Kurset henvender sig til

The primary audience for this course is database professionals who need to fulfil a BI developer role to create reports. Primary responsibilities will include implementing reports and mobile reports.

and mobile reports.
The secondary audiences for this course are power information workers.

Forudsætninger


Kursusindhold

Module 1: Introduction to Business Intelligence and Data Modelling
In this module students will be introduced to the key concepts in business intelligence, and the Microsoft BI product suite.

Lessons
Introduction to business intelligence
The Microsoft business intelligence platform
Introduction to reporting services

Lab : Exploring an enterprise BI solution
After completing this module, you will be able to:
• Describe key concepts in business intelligence
• Describe the Microsoft BI platform
• Describe key concepts in reporting services

Module 2: Reporting Services Data
Describe various Report Services data sources and how these are configured.

Lessons
Data connections
Connection strings
Filters and parameters

Lab : Configuring a data connection
After completing this module, you will be able to:
• Describe data connections and connection strings
• Describe filters and parameters

Module 3: Implementing reports
Create reports with report designer or report builder.

Lessons
Creating a report with the report wizard
Creating a report
Showing data graphically

Lab : Creating a report
After completing this module, you will be able to:
• Create a report using the report wizard
• Show data graphically

Module 4: Creating a Map Report
This module describes how to configure reports with report builder or report designer.

Lessons
Implementing filters and parameters
Implementing sorting and grouping
Publishing a report

Lab : Creating a map report
After completing this module, you will be able to:
• Implement filters and parameters
• Implement sorting and grouping
• Publish a report

Module 5: Creating Mobile Reports
This module describes how to create SQL Server mobile reports.

Lessons
Overview of SQL Server mobile reports
Preparing data for mobile reports
Mobile report publisher

Lab : Mobile reports
After completing this module, you will be able to:
• Describe SQL Server mobile reports
• Prepare data for mobile reports
• Publish mobile reports


Praktiske oplysninger

Pris: kr. 12.995,- (ex. moms)
Varighed: dag
Bemærk: Du har i alt adgang til din kursus-pc i 3 uger

Afholdelsesdatoer

Ring til IDG Kurser på +45 77 300 300
eller mail på kursus@idg.dk
for nærmere info angående datoer.


Er I flere fra samme virksomhed, som skal på kursus? Så kan der være penge at spare med et virksomhedskursus

Læs mere om virksomhedskurser her

Andre populære kurser


Aktuelt

Tips og Tricks med Excel
Vores Excel-ekspert Ernst Lohse indvier deltagerne i nemme tricks til at løse øjensynligt svære opgaver. Vi samler deltagerne i vores kantine og byder på lidt forfriskninger samtidig med at de lettere løsninger lanceres.
Det koster kun kr. 295 for 2 inspirerende timers læring.
Er du interesseret? - så tilmeld dig her


Persondata og datasikkerhed for praktikere - GDPR kursus
Med EU's nye persondataforordning indføres en række krav til virksomheders behandling af personoplysninger. På kurset får du praktisk anvendelig viden og metoder til at udarbejde og implementere politikker og dokumenter, så din virksomhed overholder persondataforordningen. Læs mere her!

NYHED - Robotic Process Automation

Hvad hardware-robotter har gjort i mange år for industrien, er for alvor ved at ske på kontorgangen hos virksomheder verden over for administrative arbejdsgange også. Software-robotter eller Robotic Process Automation er en effektiv og billig måde, at frigøre kræfter og ressourcer i virksomheder og organisationer. Samtidigt vil det påvirke den måde vi organiserer os på og hvilke kompetencer, der vil blive eftertragtede i fremtiden. IDG Kurser har designet dette kursus, så du kan lære at identificere områder og opgaver, som med fordel kan løses af software robotter. Derudover vil du få en bred forståelse af, hvad RPA betyder for dig og din organisation. Læs mere her!


Hørkær 18
2730 Herlev
Tlf: 77 300 123
Email: kursus@idg.dk
CVR: 65970414