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


Kursusdato


Praktiske oplysninger

Pris: kr. 12.995,- (ex. moms)
Varighed: 3 dage
Bemærk: Du har i alt adgang til din kursus-pc i 3 uger
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

KURSUS NYHEDER
Nyt Machine Learning kursus
Brug data til at estimere, hvad der vil ske i fremtiden. Hvem der misbruger deres beføjelser eller hvilke kunder, der har størst risiko for at opsige deres aftale? Du lærer at bringe data til live og herigennem træffe bedre beslutninger. 
Vil du vide mere, eller tilmelde dig, klikker du her

DevOps kursus - praktisk forløb
Udvikler og vedligeholder du apps eller Cloud-baserede services? Ønsker du højere kvalitet, hurtigere releases og mere effektiv udvikling? Så er dette kursus noget for dig.
Vil du vide mere, eller tilmelde dig, klikker du her


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