Difference between revisions of "Reporting Tool"

From RFF Wiki
Jump to: navigation, search
 
Line 35: Line 35:
  
 
=== Enablers ===
 
=== Enablers ===
 +
* 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
 +
 +
[[File:Reporting_enablers.png|border|center|800px|Reporting enablers]]
 +
 +
=== Objects ===
 
* Message
 
* Message
 
* Performance Indicators
 
* Performance Indicators
Line 42: Line 53:
 
* Content Based Reporting
 
* Content Based Reporting
 
* Tickets
 
* Tickets
 
[[File:Reporting_enablers.png|border|center|800px|Reporting enablers]]
 
 
=== 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
 
  
 
[[File:Reporting_objects.png|border|center|800px|Reporting objects]]
 
[[File:Reporting_objects.png|border|center|800px|Reporting objects]]

Latest revision as of 15:35, 3 May 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 usecases

Enablers

  • 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 enablers

Objects

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

Systems

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

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
Reporting principles