daily_average median q1 q3 iqr sd
513 400 200 710 510 403

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.0
2 820 8 65.0
3 2,450 16 184.0
4 2,920 17 305.0
5 2,070 15 168.0
6 1,800 15 180.0
7 1,570 13 154.0
8 3,350 27 271.0
9 2,670 24 231.0
10 4,850 39 393.0
11 5,100 34 463.0
12 4,910 30 366.0
13 3,435 35 348.0
14 3,850 36 347.0
15 3,550 33 354.0
16 4,155 37 444.0
17 3,090 28 315.0
18 2,015 20 153.0
19 4,430 31 491.5
20 4,790 36 480.0
21 4,655 45 459.0
22 4,650 38 382.5
23 3,380 37 311.5
24 3,570 35 316.0
25 5,185 49 497.0
Total 83,675 701 7,719.5
Monthly Revenue Summary
month_name monthly_net_revenue monthly_transactions liters_sold
Apr 4,780 34 396
May 10,610 80 972
Jun 18,380 139 1,536
Jul 15,970 149 1,604
Aug 17,400 143 1,730
Sep 16,535 156 1,482
Total 83,675 701 7,720
List of the Top 15 Customers by Lifetime Value
name id visits lifetime_value total_litres
Ian Kimori s022 19 3,070 400
Susan Kamau s034 12 2,850 340
Eunice Nyaa s051 7 2,750 320
Githaiga Advocate s031 4 2,450 280
Rose Nyambati s024 13 2,080 245
Viv’s Pub s004 6 2,000 160
Brian Masero s001 14 1,840 222
Evans Nganga s002 8 1,570 160
Davis Nyabuto s047 4 1,530 160
Ruhumiza Claver s109 21 1,450 145
Reuben Makendo Sese(Mzae) s028 7 1,400 140
Peter Ngugi s098 1 1,400 48
Postbank s026 4 1,340 160
Kennedy Maingi (Bonny) s019 6 1,320 84
Gad Ogutu s173 8 1,250 160