10990: Analyzing Data with SQL Server Reporting Services

Aveiro
Sob consulta
Pós-Laboral

das 18h30 às 22h00

Chat

This five-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.

After completing this course, students will be able to:

  • Describe reporting services and it’s components
  • Describe reporting services data sources
  • Implement paginated reports
  • Work with reporting services data
  • Visualize data with reporting services
  • Aggregate report data
  • Share reporting services reports
  • Administer reporting services
  • Expand and integrate reporting services
  • Describe mobile reports
  • Develop mobile reports.

Destinatários

  • 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.
  • The secondary audiences for this course are power information workers.

Pré-Requisitos

Before attending this course, students must have:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of Transact-SQL, such as that taught in 20761C.

Programa

  • Introduction to Reporting Services
  • Reporting Services 
  • Creating Paginated Reports
  • Working with Reporting Services Data
  • Visualizing Data with Report Services
  • Summarizing Report Data
  • Sharing Reporting Services Reports
  • Administering Reporting Services
  • Extending and Integrating Reporting
  • Introduction to Mobile Reports
  • Developing Mobile Reports

Introduction to Reporting Services

  • Introduction to reporting services
  • Reporting services components
  • Reporting services tools

Lab : Exploring reporting services

Reporting Services 

  • Data sources
  • Connection strings
  • Datasets

Lab : Configuring data access with report builder

Lab : Configuring data access with report designer

Creating Paginated Reports

  • Creating a report with the report wizard
  • Creating a report
  • Publishing a report

Lab : Creating reports

Working with Reporting Services Data

  • Data filters
  • Report parameters
  • Implementing report filters and parameters

Lab : Create a parameterized report

Visualizing Data with Report Services

  • Formatting data
  • Images and charts
  • Databars, sparklines, indicators, gauges, and maps

Lab : Manage formatting

Summarizing Report Data

  • Sorting and grouping
  • Report sub-reports
  • Drilldown and drill through

Lab : Summarizing report data

Sharing Reporting Services Reports

  • Schedules
  • Report caching, snapshots, and comments
  • Report subscription and delivery

Lab : Sharing reporting services reports

Administering Reporting Services

  • Administering reporting services
  • Reporting services configuration
  • Reporting services performance

Lab : Administering reporting services

Extending and Integrating Reporting

  • Expressions and embedded code
  • Extending reporting services
  • Integrating reporting services

Lab : Extending and integrating reporting services

Introduction to Mobile Reports

  • Overview of mobile reports
  • Preparing data for mobile reports
  • Mobile report publisher

Lab : Introduction to mobile reports

Developing Mobile Reports

  • Designing and publishing mobile reports
  • Drillthrough in mobile reports

Lab : Developing mobile reports

Chat

Quero saber mais informações sobre este curso

10990: Analyzing Data with SQL Server Reporting Services

Microsoft | 35h - Pós-Laboral: das 18h30 às 22h00


Notas

Pretende mais informação sobre este curso?

Preencha o formulário com os seus dados e as suas questões e entraremos em contacto consigo para lhe darmos todas as informações pretendidas.

Obrigado!