MS55123 Writing Reports with Report Builder and SSRS Level 1 (55123) Active Learning

Type product
Niveau
Startdatum en plaats

MS55123 Writing Reports with Report Builder and SSRS Level 1 (55123) Active Learning

Master it Training
Logo van Master it Training
Opleiderscore: starstarstarstarstar_border 8,0 Master it Training heeft een gemiddelde beoordeling van 8,0 (uit 94 ervaringen)

Tip: meer info over het programma, prijs, en inschrijven? Download de brochure!

Startdata en plaatsen

placeEindhoven
22 apr. 2024 tot 23 apr. 2024
placeOnline
22 apr. 2024 tot 23 apr. 2024
placeEindhoven
23 apr. 2024 tot 24 apr. 2024
placeOnline
23 apr. 2024 tot 24 apr. 2024
placeEindhoven
24 apr. 2024 tot 25 apr. 2024
placeOnline
24 apr. 2024 tot 25 apr. 2024
placeEindhoven
25 apr. 2024 tot 26 apr. 2024
placeOnline
25 apr. 2024 tot 26 apr. 2024
placeOnline
3 jun. 2024 tot 4 jun. 2024
placeVianen
3 jun. 2024 tot 4 jun. 2024
placeOnline
4 jun. 2024 tot 5 jun. 2024
placeVianen
4 jun. 2024 tot 5 jun. 2024
placeOnline
5 jun. 2024 tot 6 jun. 2024
placeVianen
5 jun. 2024 tot 6 jun. 2024
placeOnline
6 jun. 2024 tot 7 jun. 2024
placeVianen
6 jun. 2024 tot 7 jun. 2024
placeCapelle aan den IJssel
17 jun. 2024 tot 18 jun. 2024
placeOnline
17 jun. 2024 tot 18 jun. 2024
placeCapelle aan den IJssel
18 jun. 2024 tot 19 jun. 2024
placeOnline
18 jun. 2024 tot 19 jun. 2024

Beschrijving

Train met korting met het STAP Budget

Alle trainingen van Master IT komen in aanmerking voor subsidie met het STAP Budget. Geef bij je aanmelding aan dat je gebruik wilt maken van het STAP-budget om €1000 korting te krijgen op jouw IT-training!

Volg de MS55123 training Writing Reports with Report Builder and SSRS Level 1. De nadruk zal liggen op het schrijven van rapporten door verbinding te maken met een database en de gegevens te manipuleren voor presentatie, waaronder: het maken van tabel- en matrixrapporten, het opmaken van rapporten, het groeperen van rapportgegevens, het maken van eenvoudige en complexe uitdrukkingen, het weergeven van geaggregeerde gegevens, het sorteren en filteren van gegevens, het in kaart brengen van gegevens en rapporten voorbereiden voor afdrukken en exporteren.

Na afronding van deze training kun je onder andere:

  • Navigeren in de Report Builder-omgeving
  • Tabelrapporten maken
  • Basis- en complexe uitdrukki…

Lees de volledige beschrijving

Veelgestelde vragen

Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.

Train met korting met het STAP Budget

Alle trainingen van Master IT komen in aanmerking voor subsidie met het STAP Budget. Geef bij je aanmelding aan dat je gebruik wilt maken van het STAP-budget om €1000 korting te krijgen op jouw IT-training!

Volg de MS55123 training Writing Reports with Report Builder and SSRS Level 1. De nadruk zal liggen op het schrijven van rapporten door verbinding te maken met een database en de gegevens te manipuleren voor presentatie, waaronder: het maken van tabel- en matrixrapporten, het opmaken van rapporten, het groeperen van rapportgegevens, het maken van eenvoudige en complexe uitdrukkingen, het weergeven van geaggregeerde gegevens, het sorteren en filteren van gegevens, het in kaart brengen van gegevens en rapporten voorbereiden voor afdrukken en exporteren.

Na afronding van deze training kun je onder andere:

  • Navigeren in de Report Builder-omgeving
  • Tabelrapporten maken
  • Basis- en complexe uitdrukkingen maken

Deze training bevat Engelstalig lesmateriaal en kan gegeven worden door een Nederlands- of Engelssprekende trainer.

In this 2-day course, students will continue their learning on the foundations of report writing with Microsoft® SQL Server® Report Builder and SSRS. The focus will be on report writing by connecting to a database and manipulating the data for presentation including: creating table and matrix reports, formatting reports, grouping report data, creating simple and complex expressions, displaying aggregated data, sorting and filtering data, charting data, and preparing reports for printing and exporting. Report Builder 3.0 is available for Microsoft® SQL Server® versions 2014, 2012, and 2008 R2.
  • Navigate the Report Builder Environment
  • Create table reports
  • Format reports
  • Create basic and complex expressions
  • Group report data
  • Create matrix reports.
  • Sort and filter data.
  • Summarize data with charts.
  • Print and export reports.

Lesmethode

Bij Master IT train je met onze unieke lesmethode Active Learning, hiermee leer je aantoonbaar effectiever!

Wij zjn er namelijk van overtuigd dat je slimmer en met meer plezier leert als je actief met je lesstof omgaat. Onze klassen zijn gevuld met maximaal 8 cursisten. Hierbij luister je niet passief naar een trainer, maar ga je interactief en 1-op-1 met de trainer aan de slag om ervoor te zorgen dat jouw leerdoelen behaald worden. De theorie maak je je zoveel mogelijk zelf eigen, de nadruk van de begeleiding ligt op het begrijpen en toepassen van die theorie in de praktijk. Zo leer je alleen datgene wat je echt nodig hebt.

  • Je bepaalt zelf je leertempo.
  • De trainer coacht je bij het definiëren van jouw leertraject.
  • Je onthoudt en begrijpt je nieuwe kennis beter.
  • Alles draait om toepassing van de stof in jouw praktijk.

Doelgroep

The primary audience for this course are persons who are new to reporting with Microsoft® SQL Server® Report Builder and SSRS, persons who are transitioning from another reporting software application, and persons who are existing Report Builder and SSRS report authors.

The secondary audience for this course are persons who are using Report Designer (SSRS).

Course participants may be business analysts, programmer analysts, data analysts, database administrators, or IT professionals and may or may not have experience with Microsoft® SQL Server® Report Builder and SSRS, programming (Visual Basic), and/or Transact-Structured Query Language (T-SQL) experience.

The primary audience for this course are persons who are new to reporting with Microsoft® SQL Server® Report Builder and SSRS, persons who are transitioning from another reporting software application, and persons who are existing Report Builder and SSRS report authors.

The secondary audience for this course are persons who are using Report Designer (SSRS).

Course participants may be business analysts, programmer analysts, data analysts, database administrators, or IT professionals and may or may not have experience with Microsoft® SQL Server® Report Builder and SSRS, programming (Visual Basic), and/or Transact-Structured Query Language (T-SQL) experience.

Voorkennis

  • Familiarity with Windows.
  • Creating and navigating folders.
  • Opening programs.
  • Manipulating windows.
  • Copying and pasting objects.
  • Formatting text.
  • Saving files.
  • Microsoft® Office Access 2013: Level 1 or have equivalent experience with basic database concepts.
  • Familiarity with Windows.
  • Creating and navigating folders.
  • Opening programs.
  • Manipulating windows.
  • Copying and pasting objects.
  • Formatting text.
  • Saving files.
  • Microsoft® Office Access 2013: Level 1 or have equivalent experience with basic database concepts.

Onderdelen

Module 1: Exploring the Report Builder Environment

This module introduces the Report Builder application and its features. You will explore the Ribbon and its Tabs, Command groups, and Commands, the available Window panes for creating and manipulating reports, and the report design surface using Design and Run modes.

Lessons
  • Introducing the Report Builder Environment
  • Working with Existing Reports
Lab : Exploring the Report Builder Application
  • Navigating the Ribbon and Window panes
  • View Existing Reports in Design and Run modes
  • Describe and navigate the graphical elements of the Report Builder application.
  • Work with existing reports and navigate between Design and Run modes.
Module 2: Adding Data to Table Reports

This module introduces how to populate a report with data and display that data in a table data region on the report. We will begin with defining the data source and continue with query building through data sets to bring data into the report. Next, we will explore the elements of the tablix data region including rows, columns, cells, handles, and field choosers, you will use in displaying your data.

Lessons
  • Create Report Data Sources
  • Create Report Datasets
  • Work with the Tablix Data Region
  • Create a Table Report
Lab : Creating Table Reports
  • Create Queries Using the Report Builder Query Designer
  • Create Queries Using the Report Builder Query Designer
  • Create Table Relationships Using Query Designer
  • Create a Table Report Using Multiple Tables
  • Create report data sources.
  • Create report datasets.
  • Work with the tablix data region.
  • Create a table report
Module 3: Formatting Data and Creating Expressions in Reports

This module introduces report formatting techniques which allow a report writer to control how and where data displays in the report. Additional data may also be required and this can be accomplished by adding data from a source or adding a calculated field to the dataset. Simple and complex expressions will also be introduced in this topic.

Lessons
  • Formatting Reports
  • Sorting and Filtering Report Data
  • Adding Data to a Dataset
  • Creating Simple Expressions
  • Creating Complex Expressions
Lab : Formatting Reports
  • Format Tablix Columns
  • Format Data in a Tablix Cell Using Properties
  • Format Data in a Tablix Cell Using Simple and Complex Expressions
  • Sort Data Using Expressions
  • Use Simple and Complex Expressions to Display Data in a Tablix
  • Format data in a report using the Report Builder Properties dialog boxes.
  • Add data to a report and make changes to column names in the dataset query.
  • Format data in a report using simple and complex expressions.
  • Display data in a report using simple and complex expressions.
Module 4: Grouping Report Data

This module introduces data groupings in reports using dataset fields and using expressions. This module also discusses group hierarchies and adding aggregates to summarize grouped data.

Lessons
  • Group Data in Reports
  • Group Data Using an Expression
  • Creating Subgroups and Group Aggregates
Lab : Creating Reports with Groups and Aggregates
  • Display Grouped Data in a Report
  • Create a Group Hierarchy in a Report
  • Group Data Using a Complex Expression
  • Add Aggregates to Tablix Rows
  • Configuring a Reference Image
  • Group data in reports using fields
  • Group data in reports using expressions.
  • Create group hierarchies.
  • Aggregate grouped data in a report.
Module 5: Matrix Reports

This module introduces matrix data regions which are used in reports to control how crosstabular data can be used. While table reports rely on rows and columns, matrix reports rely on row groupings, column groupings, and aggregated values.

Lessons
  • Creating and Modifying Matrix Data Regions
  • Creating and Modifying Column Groups
Lab : Creating Matrix Reports
  • Create Matrix Reports
  • Create Column Groups
  • Use Expressions to Sort Group Data
  • Use Expressions to Display Group Names
  • Create Matrix Reports with Group Hierarchies
  • Describe the key features of using a matrix in a report.
  • Create and modify matrix reports.
  • Define column group hierarchies.
  • Use expressions to define matrix headings and sort orders.
Module 6: Charts

This module introduces the ability to create and add charts to reports. Whether through wizard or individual effort, chart reports or charts as report components allow us to visualize data with or without the details.

Lessons
  • Create and Modify Chart Wizard Reports
  • Add Charts to Existing Reports
  • Modify Charts in Reports
Lab : Creating Charts and Chart Reports
  • Create a Chart Wizard Report
  • Add a Chart to an Existing Report
  • Use Expressions in Charts
  • Use Expressions in Charts
  • Describe the key features of charts.
  • Create charts using the Chart Wizard and the Ribbon.
  • Modify chart data and the formatting of chart elements.
  • Use expressions in charts.
Module 7: Printing and Exporting Reports

This module introduces report printing and exporting. Reports can be created for electronic display, paper display, or display in another application. This module covers the basics of those three scenarios.

Lessons
  • Print Features and Print Options
  • Export Reports
Lab : Printing and Exporting Reports
  • Exploring Page Layout view, Report Formatting, and Page Setup Options
  • Exporting Reports
  • Describe the key features of electronic reporting vs. print reporting.
  • Prepare a report for paper printing.
  • Export reports in supported formats.
Module 1: Exploring the Report Builder Environment

This module introduces the Report Builder application and its features. You will explore the Ribbon and its Tabs, Command groups, and Commands, the available Window panes for creating and manipulating reports, and the report design surface using Design and Run modes.

Lessons
  • Introducing the Report Builder Environment
  • Working with Existing Reports
Lab : Exploring the Report Builder Application
  • Navigating the Ribbon and Window panes
  • View Existing Reports in Design and Run modes
  • Describe and navigate the graphical elements of the Report Builder application.
  • Work with existing reports and navigate between Design and Run modes.
Module 2: Adding Data to Table Reports

This module introduces how to populate a report with data and display that data in a table data region on the report. We will begin with defining the data source and continue with query building through data sets to bring data into the report. Next, we will explore the elements of the tablix data region including rows, columns, cells, handles, and field choosers, you will use in displaying your data.

Lessons
  • Create Report Data Sources
  • Create Report Datasets
  • Work with the Tablix Data Region
  • Create a Table Report
Lab : Creating Table Reports
  • Create Queries Using the Report Builder Query Designer
  • Create Queries Using the Report Builder Query Designer
  • Create Table Relationships Using Query Designer
  • Create a Table Report Using Multiple Tables
  • Create report data sources.
  • Create report datasets.
  • Work with the tablix data region.
  • Create a table report
Module 3: Formatting Data and Creating Expressions in Reports

This module introduces report formatting techniques which allow a report writer to control how and where data displays in the report. Additional data may also be required and this can be accomplished by adding data from a source or adding a calculated field to the dataset. Simple and complex expressions will also be introduced in this topic.

Lessons
  • Formatting Reports
  • Sorting and Filtering Report Data
  • Adding Data to a Dataset
  • Creating Simple Expressions
  • Creating Complex Expressions
Lab : Formatting Reports
  • Format Tablix Columns
  • Format Data in a Tablix Cell Using Properties
  • Format Data in a Tablix Cell Using Simple and Complex Expressions
  • Sort Data Using Expressions
  • Use Simple and Complex Expressions to Display Data in a Tablix
  • Format data in a report using the Report Builder Properties dialog boxes.
  • Add data to a report and make changes to column names in the dataset query.
  • Format data in a report using simple and complex expressions.
  • Display data in a report using simple and complex expressions.
Module 4: Grouping Report Data

This module introduces data groupings in reports using dataset fields and using expressions. This module also discusses group hierarchies and adding aggregates to summarize grouped data.

Lessons
  • Group Data in Reports
  • Group Data Using an Expression
  • Creating Subgroups and Group Aggregates
Lab : Creating Reports with Groups and Aggregates
  • Display Grouped Data in a Report
  • Create a Group Hierarchy in a Report
  • Group Data Using a Complex Expression
  • Add Aggregates to Tablix Rows
  • Configuring a Reference Image
  • Group data in reports using fields
  • Group data in reports using expressions.
  • Create group hierarchies.
  • Aggregate grouped data in a report.
Module 5: Matrix Reports

This module introduces matrix data regions which are used in reports to control how crosstabular data can be used. While table reports rely on rows and columns, matrix reports rely on row groupings, column groupings, and aggregated values.

Lessons
  • Creating and Modifying Matrix Data Regions
  • Creating and Modifying Column Groups
Lab : Creating Matrix Reports
  • Create Matrix Reports
  • Create Column Groups
  • Use Expressions to Sort Group Data
  • Use Expressions to Display Group Names
  • Create Matrix Reports with Group Hierarchies
  • Describe the key features of using a matrix in a report.
  • Create and modify matrix reports.
  • Define column group hierarchies.
  • Use expressions to define matrix headings and sort orders.
Module 6: Charts

This module introduces the ability to create and add charts to reports. Whether through wizard or individual effort, chart reports or charts as report components allow us to visualize data with or without the details.

Lessons
  • Create and Modify Chart Wizard Reports
  • Add Charts to Existing Reports
  • Modify Charts in Reports
Lab : Creating Charts and Chart Reports
  • Create a Chart Wizard Report
  • Add a Chart to an Existing Report
  • Use Expressions in Charts
  • Use Expressions in Charts
  • Describe the key features of charts.
  • Create charts using the Chart Wizard and the Ribbon.
  • Modify chart data and the formatting of chart elements.
  • Use expressions in charts.
Module 7: Printing and Exporting Reports

This module introduces report printing and exporting. Reports can be created for electronic display, paper display, or display in another application. This module covers the basics of those three scenarios.

Lessons
  • Print Features and Print Options
  • Export Reports
Lab : Printing and Exporting Reports
  • Exploring Page Layout view, Report Formatting, and Page Setup Options
  • Exporting Reports
  • Describe the key features of electronic reporting vs. print reporting.
  • Prepare a report for paper printing.
  • Export reports in supported formats.

Blijf op de hoogte van nieuwe ervaringen

Er zijn nog geen ervaringen.

Deel je ervaring

Heb je ervaring met deze cursus? Deel je ervaring en help anderen kiezen. Als dank voor de moeite doneert Springest € 1,- aan Stichting Edukans.

Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.

Download gratis en vrijblijvend de informatiebrochure

(optioneel)
(optioneel)
(optioneel)
infoEr is een telefoonnummer vereist om deze informatieaanvraag in behandeling te nemen. (optioneel)