Sales Performance Dashboard with Python and excel
The project's purpose is to show how we can build and automate an interactive dashboard with Excel and python.
Steps:
1_ Get data from a Kaggle CSV file
2_ Transform data
3_ Create an interactive dashboard with data and an Excel template
4_ Share the report via Outlook mail
Bonus: using .bat file to automate de production of the report
The project should be run on Windows OS.
SOURCE KAGGLE >> Supermarket sales https://www.kaggle.com/datasets/aungpyaeap/supermarket-sales
Full Description in Medium article: https://medium.com/@nellytchiengue/interactive-excel-dashboard-and-how-to-automate-with-python-a-beginners-guide-5d760307ca67