Turn An Excel Sheet Into An Interactive Dashboard Using Python (Streamlit)

This video will show you how to build interactive Excel dashboards with Python using the Streamlit library. Streamlit allows us to create interactive Dashboards with a few lines of code. We will start by installing the necessary Python libraries. Afterwards, we will dive into building an interactive dashboard with Streamlit, which will be easy to customize and provide excellent user interaction.

🌎 𝗪𝗘𝗕𝗦𝗜𝗧𝗘 𝗗𝗘𝗠𝗢:
► https://www.salesdashboard.pythonandvba.com/

📝 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦:
► Download all files from GitHub: https://github.com/Sven-Bo/streamlit-sales-dashboard
► Download the Add-in ‘My Tool Belt here’: https://pythonandvba.com/mytoolbelt
► Deploy your streamlit app for free on Heroku: https://youtu.be/nJHrSvYxzjE
► Deploy your streamlit app for free on Render: https://youtu.be/4SO3CUWPYf0
► More Streamlit tutorials: https://youtube.com/playlist?list=PL7QI8ORyVSCaejt2LICRQtOTwmPiwKO2n

✅ 𝗧𝗜𝗠𝗘𝗦𝗧𝗔𝗠𝗣𝗦:
00:00 | Intro
00:46 | Exploring the dataset
01:13 | Convert Excel Data into a Pandas Dataframe
02:28 | Install Dependency’s
02:55 | Getting started with Streamlit
04:17 | Building the Sidebar (Filter Selection)
06:27 | Building the KPI Section
08:53 | Building the Visualizations (Bar Charts)
12:37 | A brief digression: Enhance App Performance
13:22 | Continue Building the Visualizations
14:22 | Styling the Web App
15:51 | Wrap-Up

◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️
𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘:
🌎 Website: https://pythonandvba.com
📝 GitHub: https://github.com/Sven-Bo
⭐ Discord: https://pythonandvba.com/discord
▶️ Subscribe: https://youtube.com/c/CodingIsFun?sub_confirmation=1

🎉 𝗙𝗥𝗘𝗘 𝗘𝘅𝗰𝗲𝗹 𝗔𝗱𝗱-𝗶𝗻 𝘁𝗼 𝗯𝗼𝗼𝘀𝘁 𝘆𝗼𝘂𝗿 𝗽𝗿𝗼𝗱𝘂𝗰𝘁𝗶𝘃𝗶𝘁𝘆
Get it here: https://pythonandvba.com/mytoolbelt

📚 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀 𝗳𝗼𝗿 𝗹𝗲𝗮𝗿𝗻𝗶𝗻𝗴 𝗩𝗕𝗔 & 𝗣𝘆𝘁𝗵𝗼𝗻
Check out my recommendations: https://pythonandvba.com/resources

☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲❓
If you want to support this channel, you can buy me a coffee here:
https://pythonandvba.com/coffee-donation