Real-Time Dashboard with Python & SQL | Build Live Charts Using Streamlit + PostgreSQL
Learn how to build a REAL-TIME dashboard using Python, Streamlit, and PostgreSQL!
In this step-by-step beginner-friendly tutorial, we’ll create a live sales dashboard that pulls data directly from a PostgreSQL database and displays it using interactive charts with Plotly and Streamlit. You’ll also learn how to auto-refresh your dashboard and simulate live data updates with Python.
✅ What You’ll Learn:
How to connect Python to a PostgreSQL database using SQLAlchemy
How to display real-time data in Streamlit
How to build bar and pie charts with Plotly Express
How to add manual and auto-refreshing functionality
BONUS: How to simulate live sales data with Python
💡 Tools used: Python, Streamlit, PostgreSQL, Plotly, SQLAlchemy, Pandas
📁 GitHub Code & Sample Files (FREE):
🔗 https://github.com/data-geek-lab/real...
🔗 To download visual studio: https://code.visualstudio.com/
🔗 Video on how to download postgresql: • Install PostgreSQL on Windows (Beginner Tu...
=============================
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...
💎 Donate on PayPal : https://www.paypal.com/donate/?hosted...
=============================
FREE Python Starter Course
👉 https://www.datageekismyname.com/free...
If you’re learning Python for data analytics and want a structured guide, I put everything into a book with real examples.
📘 Python for Data Cleaning → 👉 https://a.co/d/iiMzQQH
📘 Data Analytics Kickstart eBook :
👉 https://www.datageekismyname.com/ebook
==============================
⏱ Timestamps:
00:00 Intro
00:23 What you will need for this project.
00:51 Who is this video for?
01:27 Open/Connecting to PostgreSQL
01:53 Creating Database in PostgreSQL
03:43 Insert data into the database in PostgreSQL.
05:36 Creating a folder to place the Python .py files
07:02 Creating the two files of python code .py
07:37 Open Terminal in Visual Studio
0744 Download the packages we will need to run the python libraries
09:11 Import libraries for dashboard
10:22 Creating the line of code to connect python code to the PostgreSQL database
12:27: Create the sales code & import libraries for this file
15:31 Enter command in terminal to run the live dashboard
17:50 Outro
#Streamlit #PythonDashboard #SQL #DataVisualization #PostgreSQL #RealTimeDashboard #PythonProjects #learnpython
Thank you for watching!