Turn An Excel Sheet Into An Interactive Dashboard Using Python Streamlit
>> YOUR LINK HERE: ___ http://youtube.com/watch?v=Sb0A9i6d320
๐ 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/Sven-Bo/streamlit-... • โบ Download the Add-in ‘My Tool Belt here’: 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 | Wrap-Up • • ๐ง๐ข๐ข๐๐ฆ ๐๐ก๐ ๐ฅ๐๐ฆ๐ข๐จ๐ฅ๐๐๐ฆ • โโโโโโโโโโโโโโโโโโโโโโโโโโ • ๐ใ๐๐ฅ๐๐ใExcel Add-in (๐ ๐๐ง๐ผ๐ผ๐น๐๐ฒ๐น๐): https://pythonandvba.com/mytoolbelt • ๐ Dashboard Excel Add-In (๐๐ฟ๐ฎ๐ณ๐น๐): https://pythonandvba.com/grafly • ๐จ Cartoon Charts Excel Add-In (๐๐๐๐ฒ๐ฃ๐น๐ผ๐๐): https://pythonandvba.com/cuteplots • ๐คช Fun Emoji Excel Add-In (๐๐บ๐ผ๐ท๐ถ๐ณ๐): https://pythonandvba.com/emojify • ๐ Excel Templates: https://pythonandvba.com/go/excel-tem... • ๐ My Courses: https://pythonandvba.com/go/courses • ๐ Books, Tools, and More: https://pythonandvba.com/resources • • ๐๐ข๐ก๐ก๐๐๐ง ๐ช๐๐ง๐ ๐ ๐ • โโโโโโโโโโโโโโโโโโโโโโโโโโ • ๐ LinkedIn: / sven-bosau • ๐ธ Instagram: / codingisfun_official • ๐ป GitHub: https://github.com/Sven-Bo • ๐ฌ 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/coffee-donation
#############################
