MONTHLY SALES REPORT

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.

Quick statistical sales analysis- August 2020

Quantity_prod_A Quantity_prod_B Quantity_prod_C Total
count 5.000000 5.00000 5.000000 5.000000
mean 368.400000 381.00000 344.200000 1093.600000
std 73.937812 72.40511 75.064639 219.521753
min 272.000000 313.00000 251.000000 836.000000
25% 343.000000 342.00000 318.000000 1003.000000
50% 361.000000 349.00000 337.000000 1047.000000
75% 391.000000 405.00000 357.000000 1153.000000
max 475.000000 496.00000 458.000000 1429.000000

Sales by representative and product in August 2020

GREEN color means the highest sales RED means the lowest sales

Name Quantity_prod_A Quantity_prod_B Quantity_prod_C
0 Adam 361 349 337
1 Filip 475 496 458
2 Karolina 272 313 251
3 Katarzyna 391 405 357
4 Robert 343 342 318

Representatives with sales above and below mean

GREEN color means the sales above mean RED means the sales below mean

Mean is counted by each product

Name Quantity_prod_A Quantity_prod_B Quantity_prod_C
0 Adam 361 349 337
1 Filip 475 496 458
2 Karolina 272 313 251
3 Katarzyna 391 405 357
4 Robert 343 342 318

Sales by representative and product in August 2020 on the bar chart