Difference between revisions of "Reporting Tool"

From RFF Wiki
Jump to: navigation, search
 
(4 intermediate revisions by the same user not shown)
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.png|200px|thumb|left|Reporting phases]]
+
[[File:Reporting_phases.png|border|center|800px|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|border|center|800px|Reporting usecases]]
  
 
=== 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 41: Line 54:
 
* Tickets
 
* Tickets
  
=== Objects ===
+
[[File:Reporting_objects.png|border|center|800px|Reporting 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
 
  
 
=== 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|border|center|800px|Reporting systems]]
  
 
=== 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_principles.png|border|center|800px|Reporting principles]]

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