2022-08-19 - NTG/S5 - Szkolenie Zarządzanie projektami | 2022-08-22 - Szkolenie Adobe Photoshop - projektowanie i obróbka zdjęć. Poziom zaawansowany. | 2022-08-22 - Szkolenie zgodne z MS 10969 Active Directory Services with Windows Server. | 2022-08-22 - Szkolenie zgodne z MS 20339-2: Zaawansowane technologie SharePoint 2016 | 2022-08-22 - Szkolenie zgodne z MS 10990: Analyzing Data with SQL Server Reporting Services | 2022-08-22 - Szkolenie zgodne z MS 20742 Zarządzanie tożsamością w Windows Server 2016 | 2022-08-22 - Szkolenie zgodne z MS 20345-1 Administrowanie Microsoft Exchange Server 2016/2019 | 2022-08-22 - Szkolenie zgodne z MS 20744 Zabezpieczanie systemu Windows Server 2016 | 2022-08-22 - Szkolenie MD-101T00 Managing Modern Desktops | 2022-08-22 - Szkolenie SC-900T00 Microsoft Security, Compliance, and Identity Fundamentals | 2022-08-22 - Szkolenie MS-100T00 Microsoft 365 Identity and Services | 2022-08-22 - Szkolenie PL-200T00 Microsoft Power Platform Functional Consultant | 2022-08-22 - Szkolenie MB-800 Microsoft Dynamics 365 Business Central Functional Consultant | 2022-08-22 - Szkolenie MS 55244 Javascript for Developers | 2022-08-23 - Szkolenie MS Excel - operacje zaawansowane | 2022-08-23 - Szkolenie MS Access - operacje podstawowe | 2022-08-23 - Szkolenie Skuteczny lider - poziomy przywództwa | 2022-08-24 - Szkolenie Programowanie w Visual Basic for Excel - operacje podstawowe. | 2022-08-24 - Szkolenie MS Excel operacje podstawowe | 2022-08-24 - Szkolenie Power BI Desktop

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.

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

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.

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.

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.

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.

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.

O tym kursie

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 creation by connecting to a database and manipulating the data for presentation including: creating parameter reports, creating list reports, adding complex expressions to reports, adding images and subreports to reports, adding drilldown and drillthrough functionality, and adding sparklines, data bars, and indicators to reports. Report Builder 3.0 is available for Microsoft® SQL Server® versions 2014, 2012, and 2008 R2.

Profil odbiorcy

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.

Czego się nauczysz?

  • Create parameter reports.
  • Create list reports.
  • Format reports with complex expressions.

 

 
  • 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.
  • Course 55123: Writing Reports with Report Builder and SSRS Level 1
  • Certyfikat Microsoft
  • Autoryzowane materiały szkoleniowe w formie elektronicznej (Skillpipe)
  • Gwarancja jakości szkolenia
  • Notatnik, długopis (w przypadku szkoleń stacjonarnych)
  • Kontakt z trenerem po szkoleniu
  • Kawa, herbata, słodki poczęstunek (w przypadku szkoleń stacjonarnych)
  • Obiad (w przypadku szkoleń stacjonarnych)

Firma jest Autoryzowanym Ośrodkiem Szkoleniowym MICROSOFT Silver Learning
Możesz u nas podejść do egzaminu
Pearson VUE

Spółka posiada wpis do ewidencji placówek niepublicznych   Nr ew. ES.VIII.4320-6/p.n./2003 wydany z upoważnienia Prezydenta Miasta Łodzi

 

 

 

Zachęcamy firmy do uzyskania możliwości dofinansowania na szkolenia oferowane przez naszą firmę. W obecnej chwili istnieją dwa sposoby dzięki którym możesz uzyskać dofinansowanie.

  • Szkolenia dofinansowane do 80% z funduszy europejskich  - Baza Usług Rozwojowych (BUR). Dofinansowanie dostępne jest dla wszystkich firm zatrudniających średniorocznie do 250 pracowników (maksymalnie średnie przedsiębiorstwo)
  • Szkolenia dofinansowane z Krajowego Funduszu Szkoleniowego  - dofinansowanie do 100%. Niezależnie od wielkości przedsiębiorstwa oraz kapitału.

Nasi pracownicy pomogą uzyskać dla Twojej firmy dofinansowanie. To naprawdę nie jest trudne. Jeżeli masz pytania  napisz lub zadzwoń do nas.

Zapraszamy!

 

Opinie
  • Brak dodanych opinii
Dodaj opinie
Cena netto
1499.00 zł
Czas trwania (dni / godziny dydaktyczne): 2 d,16 h
Poziom trudności
Język Polski,
Język materiałów Angielski,
Prowadzący Autoryzowany Trener Microsoft,
Możliwe opcje szkolenia