The sales report is generated at the end of each month for the current month. In this notebook I create a simple sales report and save results as excel and html files. I have parameterized this notebook so that papermill allows me to execute the same Jupyter notebook with different variables (different sales data for each month).
This Jupyter notebook is also converted to html file by nbconvert so it can be used as a final report and submitted to the customer.
GREEN color means the highest sales RED means the lowest sales
GREEN color means the sales above mean RED means the sales below mean
Mean is counted by each product