Real-Time transaction analysis dashboard
Report Bug
·
Request Feature
Table of Contents
The goal is to design a dashboard to monitor data in real time faster, and make relevant countermeasures based on the analyzed data. This interactive dashboard shows both the transaction results and the error codes of failed transactions of different sports.
Here's why:
- More reflective of real-time data than existing visualization tools
- People who don't use visualization tools can also observe data from the dashboard
- More flexible to modify the content and method of presentation
Using SQL to select data from MySQL.
Since the required data has been processed & stored in MySQL tables in the AirFlow-ETL program,
it's easier to extract the data we need from tables directly.
-
Adjust SQL based on observation time range
-
Adjust SQL based on observation different sports
Appropriately change the data structure according to the Plotly graph.
Display analysis results according to selection.
-
Transaction Accumulation
-
Transaction Success Ratio
-
A period
-
Pre day
-
-
Error Codes Accumulation
-
Error Codes Distribution
The dashboard helps to trace transactions and find errors immediatly in different sports.
Through the interactive layout design, you can quickly compare the data of the past n days and discover transaction changes and trends.
Overall efficiency increased by 90% compared to loading cloud data from visualization tools and analytics.
Start from the main.py
The content will appear on a website that located at the default URL
# in this case, the url is [local computer's ip address]:8050
app.run_server(debug=True, host='0.0.0.0')
- Required data has stored in the MySQL
- Install plotly python package
Plotly Dashboard is an interactive interface, which has great advantages for analyzing the whole data and explaining a certain part of the data separately.
See the open issues for a list of proposed features (and known issues).
Yu-Chieh Wang - LinkedIn
email: angelxd84130@gmail.com