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.

Code: https://github.com/Coding-with-Adam/Dash-by-Plotly/tree/master/Other/Excel_Dash

Excel Data: https://drive.google.com/file/d/1MBwS3h6QEGCbVWsQ2OygUQIcPRFIn3_N/view?usp=sharing

Plotly Graphs and documentation: https://plotly.com/python/ https://plotly.com/python-api-reference/plotly.express.html

Dash documentation: https://dash.plotly.com/dash-core-components/graph

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

👉 If you appreciate these tutorials and would like to support their existence, while enjoying additional Dash Plotly tips: https://www.patreon.com/charmingdata ... https://www.youtube.com/watch?v=acFOhdo_bxw