daily_average median q1 q3 iqr sd
458 320 200 560 360 400

This section shows weekly net revenue after subtracting transport costs, alongside a summary of transactions and liters sold.

Weekly Revenue Table
week net_revenue total_transactions liters_sold
1 410 3 41
2 820 8 65
3 2,420 16 184
4 2,920 17 305
5 2,070 15 168
6 1,800 15 180
7 1,570 13 154
8 3,350 27 271
9 2,670 24 231
10 4,850 39 393
11 5,100 34 463
12 4,910 30 366
13 3,435 35 348
14 3,850 36 347
15 590 9 64
Total 40,765 321 3,580
Monthly Revenue Summary
month_name monthly_net_revenue monthly_transactions liters_sold
Apr 6,570 44 595
May 8,790 70 773
Jun 17,530 127 1,453
Jul 7,875 80 759
Total 40,765 321 3,580
Top 15 Customers by Lifetime Value
name id location visits lifetime_value total_litres
Ian Kimori s022 Kenyatta 10 1,770 220
Githaiga Advocate s031 Kenyatta 3 1,750 190
Viv's Pub s004 New location 5 1,700 130
Peter Ngugi s098 New location 1 1,400 48
Evans Nganga s002 New location 7 1,370 140
Kennedy Maingi (Bonny) s019 Molo 220 7 1,370 85
Susan Kamau s034 Independence church 6 1,350 165
Eunice Nyaa s051 Kenyatta 3 1,220 140
Davis Nyabuto s047 Kenyatta 3 1,130 120
Rose Nyambati s024 Kenyatta 6 1,100 120
Brian Masero s001 Kenyatta 7 1,000 121
Jose Boda s028 Njenga Karume 5 1,000 100
Wangari Naomi s008 New location 11 870 65
Emily Gitundu s029 Kenyatta 4 800 80
Paul Onchoke s012 Treasure 2 650 40