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.

🌍 𝗟𝗜𝗡𝗞𝗦:

📝 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦:

✅ 𝗧𝗜𝗠𝗘𝗦𝗧𝗔𝗠𝗣𝗦:
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

𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?

[CodingIsFun]

💬I will be here in the comments section. For any issues, please provide your exact error message, and I will try to help.

[techtbe]

Hi, Spent 2 days to cover all the things you did in 16 mins. Great explanation, thank you so much. Subscribed.

[Ravichawla]

Probably THE BEST tutorial on streamlit! Great info, very precise and easy to follow. Thanks a lot man.

[santhoshreddykesavareddy]

Wow! 🤩 this is really fun to learn and implement. I’m sorry restating my sentence “ You made it easy and fun to get started” thank you so much for the detail course.

[mohammedalbatati]

Great work chief 👏🏼, love your work and it helps me learn more tricks in python.
I loved the cashing to memory method which is nice to do for better performance.

[RicardoPorteladaSilva]

Your tutorials are simply fantastic, from the content to the video editing, congratulations!

[jonathanacuna]

This is such a great project! So relevant for automating reporting for small business

[musickmann]

Absolutely awesome demonstration. Thorough explanations and easy to follow. This gives me ideas for trying to quickly create dashboards around community data in my city. Can’t wait to see if I can figure out including geo data to create hotspot maps too!

[athump]

people like you are the reason why humans have reached this far. Thank you much. i wish you good health and good luck my frind

[bobtucker]

Wow you are a genius! love the simple style and this is a great project for me to do since i want to keep practicing my python skills. Keep up the good content.

[chuchaftw]

This is amazing! Thank you for this I’m going to use this to better my personal project

[BlueSkyGoldSun]

Because of your simplicity, your the best one in YouTube .
Keep going

[hnclienteshn]

hey man, thank you very much for your tutorials, they are quite useful, you are very practical, simple and direct, I learn in an easy and simple way .... Thanks again !!

[futuregootecks]

Brilliant! Just found out about streamlit yesterday, thanks for this!

[fredhare]

Very useful video which gives a lot of ideas how to solve my own project issues. Appreciate this work !

[harisprabowo]

Thank you so much for this tutorial. Your explanation so clear and give me inspiration to learn python + stramlit.

[Ayotundejerry]

I'm so going to binge watch your videos... You've got the contents I need.. Thanks

[babatundeomotayo]

Great content! very simple and easy to follow. Keep up the good work 👍

[Gareth.W]

Great video. Thanks for creating and uploading it. I learnt a lot in such a short space of time!

[fahminsk]

Wow... This is the first video I watched and I immediately fell in love and then subscribed to this channel. I'll take a look and learn from this channel. Greetings from Indonesia