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