Convert Excel sheet into Analytics Dashboard in python - Dash Plotly

Create a powerful interactive dashboard from an excel sheet, using Dash Plotly in pure Python. In this introduction tutorial we'll automate your excel reports, using pandas, Plotly Express figures, the callback, and the layout properties of a Dash app. Download the code below to follow along.

My GitHub Code: https://github.com/Coding-with-Adam/Dash-by-Plotly/tree/master/Analytic_Web_Apps/Excel_to_Dash_Animal_Shelter

Data Source: https://www.dallasopendata.com/Services/Animals-Inventory/qgg6-h4bd

Dash Components: https://dash.plotly.com/dash-core-components

Plotly Express Docs: https://plotly.github.io/plotly.py-docs/plotly.express.html

Video layout: 00:00 - What you will learn and code 02:35 - Import libraries and get Data 05:43 - App Layout 11:42 - Callback Decorator 14:02 - Callback Function and Graphs 25:02 - Return section of Callback Function 27:32 - Final Remarks

👉 If you appreciate these tutorials and would like to support their existence while getting access to my GitLab members-only code: Patreon: https://www.patreon.com/charmingdata YouTube: https://www.youtube.com/channel/UCqBFsuAz41sqWcFjZkqmJqQ/join

... https://www.youtube.com/watch?v=eolV2X1YCBw