How to build Interactive Excel Dashboard with Python - Dash
In this tutorial we'll automate your excel reports, using pure Python. We'll use Pandas and Plotly to create the graphs, and we'll go over Dash to build the interactive capabilities. Download the excel sheet below to follow along. I recommend you start a new .py file and write the code with me, as you're going through the tutorial. However, if you're encountering difficulties, feel free to download the full code below.
View my book - The Book of Dash:
https://www.amazon.com/Python-Dash-An...
https://github.com/DashBookProject/Pl...
Code:
https://github.com/Coding-with-Adam/D...
Excel Data:
https://drive.google.com/file/d/1MBwS...
Plotly Graphs and documentation:
https://plotly.com/python/
https://plotly.com/python-api-referen...
Dash documentation:
https://dash.plotly.com/dash-core-com...
Video layout:
00:00 - App demo and what you will learn
01:53 - Getting started (libraries, data)
03:28 - Part 1: Data Exploration with Pandas
07:46 - Part 1: Data Visualization with Plotly
14:26 - Part 2: Interactive Graphing with Dash
23:00 - Part 2: Dash Callback
************************************************************************
👉 Your support keeps Charming Data running, which is proudly a 100% member-supported educational channel:
Patreon: / charmingdata
GitHub: https://github.com/sponsors/Coding-wi...
YouTube: / @charmingdata
On this page of the site you can watch the video online How to build Interactive Excel Dashboard with Python - Dash with a duration of hours minute second in good quality, which was uploaded by the user Charming Data 01 November 2020, share the link with friends and acquaintances, this video has already been watched 77,995 times on youtube and it was liked by 1.5 thousand viewers. Enjoy your viewing!
