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:

Code:

Excel Data:

Plotly Graphs and documentation:

Dash documentation:

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:

[CharmingData]

👉 Never give up. Keep practicing. And we're better together, so help each other out!

[pinakpaninath]

I have finally released a dashboard for my supply chain team from your tutorials.. Thanks alot

[PSEVDONIM]

dude you're the best. greatest guides

[vmohakrish]

I came here for dash tutorial and learnt a thing or two I did not know about Pandas.Kudos to you for making these videos.

[oddzhang]

the tutorial is definitely useful. The session is clear and easy for beginner.

[originalkundukulangara]

Your way of explaining the concept of python makes anyone to start learning python. I will check other videos.

[brucelee]

Love the way you coding! Follow your instruction I can makeDash app in 3 days from zero knowledge of plotly. Thank you.

[Yingshio]

Thank you so much. This is certainly the best Dash Tutorial I have come across!

[GeronimoAlbornoz]

Adam this is definitively your best video. The hole path from and excel sheet to a dash dashboard 👏🏼👏🏼

[TonoMillanbcn]

Thanks for the great job friend... I start in this wonderful world of python and your explanation has been very motivating.

[TheSoonAnn]

excelllent video, appreciate the effort that u made it ez for beginners to follow

[mohammedalbatati]

Loved it, its a good way to add it to one of my djngo project pages.
Many thanks

[ramseynoah]

Fantastically clear explanations all around - thank you for making this! 🙏🏼

[blociot]

Fantastic! Thank you Adam for sharing this.

[yefovar]

Great job! My final project will look amazing with this

[martynsnwaokocha]

Hi, you are a very good teacher. Well done

[geoalexander]

alright, i will mark this incase i need this for my final essay

[kjjosker]

Excellent tutorial! very easy to follow.

[lbasavaraj]

Adam, love these tutorials. You are a legend.
Please keep up the great work.

[KunaalNaik]

Thank You for this video. Helped get an idea about how to execute!