Difference between revisions of "Reporting Tool"

From RFF Wiki
Jump to: navigation, search
Line 15: Line 15:
 
The reports are used for strategic decisions and potentially for smart data based services.
 
The reports are used for strategic decisions and potentially for smart data based services.
  
[[File:Reporting_phases|200px|thumb|left|Reporting phases]]
+
[[File:Reporting_phases.png|200px|thumb|left|Reporting phases]]
  
 
=== Use cases ===
 
=== Use cases ===
Line 31: Line 31:
 
* trigger for performance analysis and measurements
 
* trigger for performance analysis and measurements
 
* Smart services based on aggregated data
 
* Smart services based on aggregated data
 +
 +
[[File:Reporting_usecases.png|200px|thumb|left|Reporting phases]]
  
 
=== Enablers ===
 
=== Enablers ===
Line 40: Line 42:
 
* Content Based Reporting
 
* Content Based Reporting
 
* Tickets
 
* Tickets
 +
 +
[[File:Reporting_enablers.png|200px|thumb|left|Reporting phases]]
  
 
=== Objects ===
 
=== Objects ===
Line 49: Line 53:
 
* removal at end of lifecycle
 
* removal at end of lifecycle
 
* store eternally
 
* store eternally
 +
 +
[[File:Reporting_objects.png|200px|thumb|left|Reporting phases]]
  
 
=== Systems ===
 
=== Systems ===
Line 54: Line 60:
 
* Elastic stack for phase 1 at Xrail  
 
* Elastic stack for phase 1 at Xrail  
 
* Influx/Grafana at RailData  
 
* Influx/Grafana at RailData  
 +
 +
[[File:Reporting_systems.png|200px|thumb|left|Reporting phases]]
  
 
=== Principles ===
 
=== Principles ===
Line 61: Line 69:
 
* Data Lake?
 
* Data Lake?
 
* Easy access for all and reports can be found for all services
 
* Easy access for all and reports can be found for all services
 +
 +
[[File:Reporting_priniciples.png|200px|thumb|left|Reporting phases]]

Revision as of 14:56, 30 April 2021

Analysis

Report phases

The analysis detected three phases with specific requirements.

  • Operative Support & Monitoring

The first phase focus on supporting the operation of a service. It includes near real time reports and monitoring of characteristic figures per Service.

  • Short term reports & DataQuality analysis

The second phase delivers the necessary data for data quality analysis and checks for data improvements. This happens on the tactical level.

  • Long term Analysis

The third and last phase tackles long term reports from one or several sources. The reports are used for strategic decisions and potentially for smart data based services.

Reporting phases

Use cases

The use cases are grouped in the three phases.

  • analysis of specific messages and the actual situation
  • follow up on errors, incidents and technical issues
  • Trigger for DQ assurance cycle
  • publish KPI indicators per service
  • Dashboard per service
  • Analysis of development
  • Strategic decision
  • Management Reporting
  • trigger for performance analysis and measurements
  • observe and alarm for abnormal states
  • trigger for performance analysis and measurements
  • Smart services based on aggregated data
Reporting phases

Enablers

  • Message
  • Performance Indicators
  • KPI
  • Forecasts
  • Benchmarks
  • Content Based Reporting
  • Tickets
Reporting phases

Objects

  • drill down to individual message and its state (new)
  • aggregate data and hand over
  • drill down to a time slot (h/d/w/m/y) per state (aggregate)
  • message removal at end of lifecycle
  • drill down to specific message and its state (not all)
  • removal at end of lifecycle
  • store eternally
Reporting phases

Systems

  • Power BI for phase 2 and 3 at Xrail
  • Elastic stack for phase 1 at Xrail
  • Influx/Grafana at RailData
Reporting phases

Principles

  • Sensor/Measurement beside the service
  • Aggregation per step from operative data to reporting data
  • One reporting tool to RUs / stakeholders
  • Data Lake?
  • Easy access for all and reports can be found for all services