Skip to content

A simple Flask web app that demonstrates how to store data from an .xlsx file into a SQLite database and then visualise it using Plotly.

Notifications You must be signed in to change notification settings

miketeachestech/example-data-dashboard-flask-app

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Simple Soccer Data Dashboard

This is a simple (work-in-progress) Flask web application example that:

  • Processes an Excel file (dummy_soccer_stats.xlsx) and inserts data into an SQLite database.
  • Generates interactive graphs using Plotly to visualise soccer data.

Screenshot of data visualisation dashboard


🛠 Setup & Installation

1️⃣ Install Dependencies

Ensure you have Python installed, then install the required libraries:

pip install flask pandas sqlite3 plotly

2️⃣ Run the Flask App

Start the server:

python app.py

3️⃣ Open in Browser

  • Home Page: http://localhost:5000/
  • Process File: Click "Process File" to read data from the excel file in the uploads folder and store the data in SQLite.
  • View Graphs: Click "View Graphs" to visualize the data.

About

A simple Flask web app that demonstrates how to store data from an .xlsx file into a SQLite database and then visualise it using Plotly.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published