The python script is designed to to make reporting faster and more effective.
The script returns five pivot tables in five different sheets but in one work book. A folder will be created to save these images to be able to easily copy and paste in word document.
The python script performs the following tasks:
It creates pivot tables and stores these tables in a specific sheets in one workbook
It creates and saves beautiful visualizations in a specific folder for easy access
It converts the payment date and purchase date strings to date format
It corrects the worng calculation done on some columns
It orders the columns in an order of my choosing
It deletes some columns that are unnecessary
It splits the woorkbook into several sheets