Watch Real-Time Dashboard with Python & SQL | Build Live Charts Using Streamlit + PostgreSQL Video Tutorial

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-time-dashboard 🔗 To download visual studio: https://code.visualstudio.com/ 🔗 Video on how to download postgresql: https://youtu.be/IcJvVUln-KY?si=9J0eXtc5JQCsJm3s ============================= *Support my channel* 🔔 *Don’t forget to LIKE & SUBSCRIBE for more Python & Data Analysis tutorials!* ☕ *Want to Buy Me A Coffee:* https://buymeacoffee.com/datageekismyname 💎 *Donate on PayPal* : https://www.paypal.com/donate/?hosted_button_id=ZCL24X55R9C5G ============================= *FREE Python Starter Course* 👉 https://www.datageekismyname.com/free-python-course 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!