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

Published: 14 April 2024
on channel: Coding Is Fun

20,827

634

👉 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

On this page of the site you can watch the video online Turn An Excel Sheet Into An Interactive Dashboard Using Python (Taipy Tutorial) with a duration of hours minute second in good quality, which was uploaded by the user Coding Is Fun 14 April 2024, share the link with friends and acquaintances, this video has already been watched 20,827 times on youtube and it was liked by 634 viewers. Enjoy your viewing!

8,844,643

73K