2: Build a live sales dashboard using MySQL as the backend and Streamlit as the frontend
In this hands-on tutorial, you’ll learn how to build a real-time dashboard using Python, MySQL, and Streamlit. We’ll connect to a MySQL database using mysql-connector, pull in live data, and create interactive charts with Plotly.
What You’ll Learn:
• How to fetch live data from MySQL using Python
• How to create a dynamic dashboard with Streamlit
• How to visualize sales using Plotly (bar, pie charts)
• How to auto-refresh your dashboard every 60 seconds
🧰 Tools: Python, Streamlit, MySQL, Plotly, mysql-connector-python, pandas
==============================
Support my channel
🔔 Don’t forget to LIKE & SUBSCRIBE for more Python & Data Analysis tutorials!
☕ Want to Buy Me A Coffee: https://buymeacoffee.com/datageekismy...
Or 💎 Donate on PayPal : https://www.paypal.com/donate/?hosted...
==============================
How to download Anaconda to use Jupyter Notebook for Python coding: • How to Download Anaconda for Jupyter Noteb...
Download MySQL with XAMPP, full video : • 1: Connect Python to MySQL with XAMPP | Fu...
Get Full Code for this tutorial here :
https://github.com/data-geek-lab/mysq...
_______________________________________
⏳ Timestamps ⏳
00:00 Intro
00:25 Open phpMyAdmin
00:56 Create a Database in phpMyAdmin
01:28 Create a table in the Database and columns
03:22 Upload the csv file in the database
04:54 How to fix the error message "Invalid column count in CSV input on line 1.
06:25 How to fix the first column names from showing in the table.
07:35 Open Anaconda Navigator to use Visual Studio
08:09 Create a New Folder in VS code for Python code & txt files
09:45 Pasting the code into the files that was created in VS code
12:17 Running the python code to run the app (live dashboard)
15:15 Pasting the code for insights.py to create a more AI-generated insight of the dashboard
17:34 That is it! Outro statement.
===== Continue your learning ========
Get the Data Analytics Kickstart eBook—your all-in-one beginner guide to Python, SQL & Power BI.
Includes real-world examples, cheat sheets, 3 real-world data project ideas, and video walkthroughs! -- https://www.datageekismyname.com/ebook
Disclaimer: This content is for educational purposes only. Affiliate links may be included, and I may earn a small commission at no extra cost to you. Thank you for supporting the channel!