Difference between revisions of "Reporting Tool"

From RFF Wiki
Jump to: navigation, search
Line 32: Line 32:
 
* Smart services based on aggregated data
 
* Smart services based on aggregated data
  
[[File:Reporting_usecases.png|border|center|800px|Reporting phases]]
+
[[File:Reporting_usecases.png|border|center|800px|Reporting usecases]]
  
 
=== Enablers ===
 
=== Enablers ===
Line 43: Line 43:
 
* Tickets
 
* Tickets
  
[[File:Reporting_enablers.png|border|center|800px|Reporting phases]]
+
[[File:Reporting_enablers.png|border|center|800px|Reporting enablers]]
  
 
=== Objects ===
 
=== Objects ===
Line 54: Line 54:
 
* store eternally
 
* store eternally
  
[[File:Reporting_objects.png|border|center|800px|Reporting phases]]
+
[[File:Reporting_objects.png|border|center|800px|Reporting objects]]
  
 
=== Systems ===
 
=== Systems ===
Line 61: Line 61:
 
* Influx/Grafana at RailData  
 
* Influx/Grafana at RailData  
  
[[File:Reporting_systems.png|border|center|800px|Reporting phases]]
+
[[File:Reporting_systems.png|border|center|800px|Reporting systems]]
  
 
=== Principles ===
 
=== Principles ===
Line 70: Line 70:
 
* 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|border|center|800px|Reporting phases]]
+
[[File:Reporting_principles.png|border|center|800px|Reporting principles]]

Revision as of 15:01, 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 usecases

Enablers

  • Message
  • Performance Indicators
  • KPI
  • Forecasts
  • Benchmarks
  • Content Based Reporting
  • Tickets
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
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