A little secret to rock your YouTube subscribers
Get Free YouTube Subscribers, Views and Likes

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

Follow
Coding Is Fun

Explore All My Excel Solutions: https://pythonandvba.com/solutions


▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
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://salesdashboard.pythonandvba.com/

:
► Download all files from GitHub: https://github.com/SvenBo/streamlit...
► Download the Addin ‘My Tool Belt here’: https://pythonandvba.com/mytoolbelt'>https://pythonandvba.com/mytoolbelt
► Deploy your streamlit app for free on Heroku:    • Deploy Your Streamlit Web App on Hero...  
► Deploy your streamlit app for free on Render:    • Deploy Your Streamlit App To Render (...  
► More Streamlit tutorials:    •  Streamlit Tutorials  

✅ :
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 | WrapUp



▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
【】Excel Addin (): https://pythonandvba.com/mytoolbelt'>https://pythonandvba.com/mytoolbelt
Dashboard Excel AddIn (): https://pythonandvba.com/grafly
Cartoon Charts Excel AddIn (): https://pythonandvba.com/cuteplots
Fun Emoji Excel AddIn (): https://pythonandvba.com/emojify
Excel Templates: https://pythonandvba.com/go/exceltem...
My Courses: https://pythonandvba.com/go/courses
Books, Tools, and More: https://pythonandvba.com/resources



▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
LinkedIn:   / svenbosau  
Instagram:   / codingisfun_official  
GitHub: https://github.com/SvenBo
Discord: https://pythonandvba.com/discord
Contact: https://pythonandvba.com/contact


☕ ?
If you want to support this channel, you can buy me a coffee here: https://pythonandvba.com/coffeedonation

posted by traplozec1