Turn An Excel Sheet Into An Interactive Dashboard Using Python (Taipy Tutorial)

Рет қаралды 13,795

Күн бұрын

👉 Explore All My Excel Solutions: pythonandvba.com/solutions
𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
In this video, I'll show you how to start using Taipy to turn an Excel spreadsheet into a web application. We'll start from nothing and step by step, you'll learn how to set up filters, make charts, and add a theme switch to toggle between light and dark modes. This tutorial is perfect for anyone new to Taipy or those wanting to create functional, easy-to-use web apps with Python. By the end, you'll be familiar with building web applications using Taipy and how it can simplify your development process.
🌍 𝗟𝗜𝗡𝗞𝗦:
► Live Website: taipy.salesdashboard.pythonan...
► Source Code: github.com/Sven-Bo/taipy-sale...
► MyToolBelt Excel Add-in: pythonandvba.com/mytoolbelt
► Taipy Documentation: docs.taipy.io/en/latest/
► Pandas Tutorial: • Become a Pandas Pro: L...
⭐ 𝗧𝗜𝗠𝗘𝗦𝗧𝗔𝗠𝗣𝗦:
0:00 - Introduction
0:38 - Turn the Excel Data into a Pandas DataFrame
2:00 - Install the dependencies (Pandas, Openpyxl, Taipy)
2:38 - Creating a very simple app
5:03 - Creating the top KPIs
7:00 - Creating the filter selections
9:00 - Customize the layout
10:38 - Creating the chart DataFrames with Pandas
12:23 - Creating the Charts
13:35 - Interactions (Filter the dataset)
17:31 - Styling the app incl. toggle button
20:43 - The final app
21:07 - Deployment of the app
21:23 - Outro
𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🆓【𝗙𝗥𝗘𝗘】Excel Add-in (𝗠𝘆𝗧𝗼𝗼𝗹𝗕𝗲𝗹𝘁): pythonandvba.com/mytoolbelt
📊 Data Visualization Excel Add-In (𝗚𝗿𝗮𝗳𝗹𝘆): pythonandvba.com/grafly
🤪 Fun Emoji Excel Add-In (𝗘𝗺𝗼𝗷𝗶𝗳𝘆): pythonandvba.com/emojify
📑 Excel Templates: pythonandvba.com/go/excel-tem...
🎓 My Courses: pythonandvba.com/go/courses
📚 Books, Tools, and More: pythonandvba.com/resources
𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🔗 LinkedIn: / sven-bosau
📸 Instagram: / codingisfun_official
💻 GitHub: github.com/Sven-Bo
💬 Discord: pythonandvba.com/discord
📬 Contact: pythonandvba.com/contact
☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?
If you want to support this channel, you can buy me a coffee here:
▶ pythonandvba.com/coffee-donation

Пікірлер: 31

@CodingIsFun 2 ай бұрын

*Hope you liked the Taipy tutorial. I'm here in the comment section, so if you have any questions, comments, or feedback, let me know!* Below are the links I mentioned in the video: ► Live Website: taipy.salesdashboard.pythonandvba.com/ ► Source Code: github.com/Sven-Bo/taipy-sales-dashboard ► MyToolBelt Excel Add-in: pythonandvba.com/mytoolbelt ► Taipy Documentation: docs.taipy.io/en/latest/ ► Pandas Tutorial: kzfaq.info/get/bejne/iL51g5SDxMCyoqc.htmlsi=qh5sSqJ_-zYjzdgY Also, if you're curious about how to create the same dashboard in Streamlit, then check out this video: kzfaq.info/get/bejne/ichgdJyam8qXYmQ.html *That said, probably the easiest way to create a dashboard from Excel data is to use my Excel dashboard add-in 😉 Check it out here:* pythonandvba.com/grafly *Happy Coding! Cheers, Sven* ✌

@ici6308 Ай бұрын

Truthly let me say you that you are one of the best in this field. Be blessed

@CodingIsFun Ай бұрын

It's very kind of you to say so, thank you! Cheers, Sven ✌️

@florianroeseler2404 2 ай бұрын

Absolutely amazing

@CodingIsFun 2 ай бұрын

Thanks, Florian! 🥰🤩

@marcelkummer4329 2 ай бұрын

Thank you for your effort! I really like this 👍

@CodingIsFun 2 ай бұрын

My pleasure! Happy to hear that you liked it! :) Cheers, Sven ✌️

@AiltonBarreto 2 ай бұрын

Oh man! we've been miss you

@CodingIsFun 2 ай бұрын

Yeah, it is been a while 😬

@shinrafahell 2 ай бұрын

Great job

@CodingIsFun 2 ай бұрын

Thanks! 🙏

@MrActiBif 2 ай бұрын

Thx for this vidéo

@CodingIsFun 2 ай бұрын

You're very welcome! Thank you for watching and for the comment! Cheers, Sven ✌️

@nilsonherbert9998 Ай бұрын

Hi, bro. How's going? What´s the big difference that you have realized between Taipy and Streamlit?

@user-jt1qu6nd1h 2 ай бұрын

Amazing

@CodingIsFun 2 ай бұрын

Thank you! Cheers, Sven ✌️

@Jriad 2 ай бұрын

excellent content as always , btw is it me or streamlit is somehow easier and faster i feel it is a lot of effort here

@CodingIsFun 2 ай бұрын

Thanks for the kind words. No, it's not just you-I also feel that Streamlit is more straightforward and possibly quicker for initial development. However, from what I've gathered, despite Taipy's steeper learning curve, the apps developed with it might perform better because they don't require a complete rerun with each interaction, unlike Streamlit.

@nkwachiabel5092 2 ай бұрын

Streamlit has been updated now to allow for partial reruns

@xgodwhitex 2 ай бұрын

The goal of Taipy is to make the creation of a multi-page, multi-user, production-ready app accessible. This is not as easy as Streamlit but seems to be more powerful in the long run

@xgodwhitex 2 ай бұрын

@@nkwachiabel5092 This is still not great, and I had a lot of issues with it. They are just trying to fix the original implementation of Streamlit

@sheikh4awais 2 ай бұрын

Awesome tutorial! Could the Taipy app be converted to a desktop app?

@CodingIsFun 2 ай бұрын

Thanks! I think that is natively not supported. At least, I didn't find anything about that in the docs. So, I am not sure if that would be possible. Cheers, Sven ✌️

@sheikh4awais 2 ай бұрын

@@CodingIsFun I wish there was an easier way to create modern GUIs in Python like the one you showed us in the video with Taipy. It would be great if we could easily convert them into desktop apps that work across multiple platforms. If you know of any solutions, I would greatly appreciate it if you could share them with me.

@davmelchi4308 2 ай бұрын

@@sheikh4awais FLET is very good for multi platform GUI with python and based on flutter. But not really suitable for data analysi.