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

👉 Explore All My Excel Solutions: https://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: https://taipy.salesdashboard.pythonan...
► Source Code: https://github.com/Sven-Bo/taipy-sale...
► MyToolBelt Excel Add-in: https://pythonandvba.com/mytoolbelt
► Taipy Documentation: https://docs.taipy.io/en/latest/
► Pandas Tutorial:    • Become a Pandas Pro: Learn Data Analy...  

⭐ 𝗧𝗜𝗠𝗘𝗦𝗧𝗔𝗠𝗣𝗦:
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 (𝗠𝘆𝗧𝗼𝗼𝗹𝗕𝗲𝗹𝘁): 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