My Workflow for Building any Streamlit Dashboard Project

Tired of manipulating Excel dashboards with complex VBA macros? In this tutorial, you'll discover a comprehensive workflow I use to build most of my Streamlit web dashboards with SQL.
It involves three key steps:
- How I load an Excel workbook into a Pandas DataFrame through a file upload widget, and display it into a Streamlit app with live-reloading
- How I format the dataframe with SQL through DuckDB to build Plotly interactive plots
- How I build the Streamlit app with horizontal layout, sidebar and expanders for easy reading

By the end of this video, you'll be equipped with the skills to quickly recreate Excel dashboards within Python web apps. No more struggling with complex VBA macros – empower yourself to generate interactive and visually appealing dashboards for financial data analysis.

00:00 Dashboard Mockup
00:38 Loading Data
03:57 Transforming Data
05:28 Visualizing Data

---

🗣️ Stay up to date with the Data Web App Ecosystem

- 📑 Follow my socials ➡ https://andfanilo.com
- 📧 Get my latest updates in your inbox ➡ https://newsletter.andfanilo.com
- 💰 Buy me a coffee to stay awake while editing ➡ https://www.buymeacoffee.com/andfanilo

🔗 Links

- Source code + Sample Data: https://github.com/andfanilo/social-media-tutorials/tree/master/20230816-stdashboard

🔧 My tools (Affiliate links to support me)

- 📕 Streamlit Official Book - https://amzn.to/3QuRPwl
- 📷 Main Camera - https://amzn.to/3QvTosB
- 📷 Main Lens - https://amzn.to/3svYCwq
- 🎙️ Microphone - https://amzn.to/47l5ewA
- 🎵 Music & Sound Effects - https://www.epidemicsound.com/referral/a2p22s

---

🪶 ...unexpected life events made me take a break. I hope Youtube keeps momentum even after a one month pause.

⚠️ Links included in this description might be affiliate links. If you purchase a product or service with the links that I provide I may receive a small commission. Thank you for supporting my channel so I can continue providing you with free content!

#streamlit #python #datascience #dataapps