Turn An Excel Sheet Into An Interactive Dashboard Using Python (Streamlit)
1 میلیون بار بازدید -
3 سال پیش
-
👉 Explore All My Excel
👉 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-sales-dashboard
► Download the Add-in ‘My Tool Belt here’: https://pythonandvba.com/mytoolbelt
► Deploy your streamlit app for free on Heroku: https://www.seevid.ir/fa/w/nJHrSvYxzjE
► Deploy your streamlit app for free on Render: https://www.seevid.ir/fa/w/4SO3CUWPYf0
► More Streamlit tutorials: • 🌍 Streamlit Tutorials
✅ 𝗧𝗜𝗠𝗘𝗦𝗧𝗔𝗠𝗣𝗦:
https://www.seevid.ir/fa/w/Sb0A9i6d320 | Intro
https://www.seevid.ir/fa/w/Sb0A9i6d320 | Exploring the dataset
https://www.seevid.ir/fa/w/Sb0A9i6d320 | Convert Excel Data into a Pandas Dataframe
https://www.seevid.ir/fa/w/Sb0A9i6d320 | Install Dependency's
https://www.seevid.ir/fa/w/Sb0A9i6d320 | Getting started with Streamlit
https://www.seevid.ir/fa/w/Sb0A9i6d320 | Building the Sidebar (Filter Selection)
https://www.seevid.ir/fa/w/Sb0A9i6d320 | Building the KPI Section
https://www.seevid.ir/fa/w/Sb0A9i6d320 | Building the Visualizations (Bar Charts)
https://www.seevid.ir/fa/w/Sb0A9i6d320 | A brief digression: Enhance App Performance
https://www.seevid.ir/fa/w/Sb0A9i6d320 | Continue Building the Visualizations
https://www.seevid.ir/fa/w/Sb0A9i6d320 | Styling the Web App
https://www.seevid.ir/fa/w/Sb0A9i6d320 | 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-templates
🎓 My Courses: https://pythonandvba.com/go/courses
📚 Books, Tools, and More: https://pythonandvba.com/resources
𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🔗 LinkedIn: https://www.linkedin.com/in/sven-bosau/
📸 Instagram: https://instagram.com/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
3 سال پیش
در تاریخ 1400/06/20 منتشر شده
است.
1,053,152
بـار بازدید شده