Skip to content

Latest commit

 

History

History
186 lines (130 loc) · 6.1 KB

README.md

File metadata and controls

186 lines (130 loc) · 6.1 KB
Raw

Contributors Forks Stargazers Issues LinkedIn


Real-Time Dashboard

Real-Time transaction analysis dashboard
Report Bug · Request Feature

Table of Contents
  1. About The Project
  2. Getting Started
  3. Usage
  4. Roadmap
  5. Contact
  6. Acknowledgements

About The Project

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
    Dashboard

Data Extraction

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
    Past-Time

  • Adjust SQL based on observation different sports
    Sports

Data Processing

Appropriately change the data structure according to the Plotly graph.

Visualization

Display analysis results according to selection.

  • Transaction Accumulation
    Transaction-Accumulation

  • Transaction Success Ratio

    • A period
      Peroid

    • Pre day
      Day

  • Error Codes Accumulation
    Error-Code-Accumulation

  • Error Codes Distribution
    Error-Code-Distribution

Evaluation

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.

Built With

Getting Started

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')

Prerequisites

  1. Required data has stored in the MySQL
  2. Install plotly python package

Usage

Plotly Dashboard is an interactive interface, which has great advantages for analyzing the whole data and explaining a certain part of the data separately.

Roadmap

See the open issues for a list of proposed features (and known issues).

Contact

Yu-Chieh Wang - LinkedIn
email: angelxd84130@gmail.com

Acknowledgements