Collins Macharia Muturi

Power BI Desktop Sum of number_of_people_served by type_of_water_source Population shared_tap Water Sources (Location) tap_in_home type_of_water_s… river shared_tap tap_in_home tap_in_ho… well Harare Amina Lusaka tap_in_home… river Mrembo Asmara Dahabu Ilanga well Kintampo Isiqalo Zuri Amara Majengo Pwani Water_Sources (Type) Kofi 20K Serowe Bahari 15K Urban Marang Abidjan 10K Bello Cheche Rural 5K Deka Djenne 0K Rural Urban ll we n me ke ro ho _ b _ _in me tap ho _ _in tap p _ta d e ar sh er riv Zanzibar Yaounde 0 500 1,000 1,500 2,000 Power BI Desktop Queue Times Per Day Population Total Time Spend In Queues 246.29 - ay rd tu a S ay nd Su y da on M 52.74 y da Fri 47.08 y da es u T 46.02 ay sd ur h T 42.54 y da es n ed W Queue Composition Average Queue Times for Shared Taps Day_Name 300 Average of percent_child Friday Monday Saturday Average of percent_female Average of percent_male Average of percent_child- Average of percent_male- Sunday 200 Thursday Tuesday Wednesday 100 10 15 Hour_of_Day 20 Average of percent_female- Total time queued (min) 1.0M 0.5M 0.0M Kilimani Akatsi Sokoto Amanzi Hawassa Power BI Desktop Population Gender Disparity Related to Water Collectors Total Provincial Crimes victim_gender victim_gender C F M 20K C F M 20K 10K 10K 3K 4K 2K 2K 0K 1K 0K 0 10 20 M 13 Wednesday 6K F 15 Wednesday 4K C Hawassa 9 Friday M 10 Thursday F 16 Tuesday victim_gender C Amanzi 15 Tuesday victim_gender 12 Friday By Day of Week Sokoto 14 Friday Number of Crimes by Hour of Day Akatsi 16 Monday Kilimani 14 Tuesday 0K 13 Thursday 49.72K (64.39%) er rd mu 9 Monday 19.63K (25.42%) m ult ult on lis ati s sa s sa c da i a a x _ n l_ a e o a r v int xu ve c_ se se bli u p 16 Friday 7.87K (10.2%) eft th 13 Friday Gender Disparity of Crimes t en sm s ra ha 10 Friday 0K Number of wells and their pollution status Power BI Desktop Population results Contaminated: Chemical Contaminated: Biological Clean 4.92K (28.28%) 7.09K (40.8%) 5.37K (30.92%) Power BI Desktop Population Maji Ndogo Water %Pop access to basic water National water survey results 34 PAGE CONTOLS Province Selector Total Budget (USD ) %Improvement $147M +66% Province Image Province Button Sum of number_of_people_served by province_name and lo… location_type Rural Number of Improvements Urban 6K Province Kilimani Akatsi province 4K  Budget Population Qty - Sokoto 2K Amanzi Hawassa 0K 0M 5M Sum of number_of_people_served by type_of_water_source and … location_type Rural i an im Kil to ko So a Ak tsi s wa Ha sa $31,355,075 - 4963 Amanzi $13,428,275 - 3748 Hawassa $22,553,325 - 4384 Kilimani zi an Am Total $39,249,225 - 6700 $146,737,375 - 25398 Sum of Budgeted_improvement_cost by province_… Urban Install RO filter shared_tap 7.1K Repair infrastr… well tap_in_home 5.4K Install public t… tap_in_home_… 5M 10M Akatsi Amanzi Hawassa Kilimani $40.15M (27.36%) $31.36M (21.37%) 3.7K Drill well river province_na… 5.9K Install UV and… 0M Akatsi $13.4… (9.15…) 3.4K 0K 5K $39.25M (26.75%) $22.55M (15.37%) Power BI Desktop Budget Allocation Aggregate… Drill well Install publi… Rural/Urban Spending Install RO fil… $0.38M $4.69M (11.69%) (0.95%) town_name  Count of improvement Rural Urban $8.08M $19.8M (49.3%) $7.07M (17.6%) Population Budget Cost/Citizen - 3852 $32,075,025 8.04 Marang 256826 265 $1,183,900 4.61 Majengo 338162 332 $1,555,550 4.60 Kofi 295438 278 $1,394,350 4.72 Ilanga 420790 415 $1,768,950 4.20 Cheche 213922 207 $969,000 4.53 Bahari 259578 254 $1,204,700 4.64 - 5603 $40,151,475 6.95 Total Rural $32.08M $8.21M (20.46%) Aggregated_improvements Improvements Aggregated_improvements Drill well Install RO fil… Install UV a… Repair infra… Drill well Install publi… Count of improvement Drill well Install public tap(s)* $19,796,500 669 $8,214,000 1301 $7,066,500 Install UV and RO filter 1082 $4,692,800 Total Install RO filter 1709 Install RO filter Repair infrastructure 1709 Budget 842 $381,675 5603 $40,151,475 1301 Install UV and RO filter 1082 Repair infrastructure Total Budget 842 Install public tap(s)* $40,151,475 669 0 500 1,000 1,500 2,000 Power BI Desktop Budget Allocation Aggregate… Install RO fil… Install publi… $2.82M (9%) Drill well Rural/Urban Spending Urban $3.85M $12.17M (38.83%) $5.07M (16.17%) town_name  Population Count of improvement Rural Budget Cost/Citizen - 3545 $27,504,825 5.98 Lusaka 568068 575 $1,540,250 2.71 Kintampo 403222 421 $1,188,800 2.95 Harare 419920 422 $1,121,200 2.67 - 4963 $31,355,075 5.23 Total $10.92M (34.81%) Rural $27.5M Aggregated_improvements Improvements Aggregated_improvements Install RO filter Repair infras… Install publi… Install UV … Drill well Count of improvement Drill well Install public tap(s)* 2.1K $5,070,250 883 $10,916,000 $12,173,700 Install UV and RO filter 703 $2,820,800 Repair infrastructure 910 $374,325 4963 $31,355,075 Total Repair infrastructure - Install RO filter Install RO filter Budget 0.9K Install public tap(s)* 0.9K Install UV and RO filter Total Budget 0.7K Drill well $31,355,075 0.4K 0K 1K 2K Power BI Desktop Budget Allocation Aggregate… Install publi… Install RO fil… $7.68M (19.57%) Rural/Urban Spending Drill well Urban $10.92M $11.78M (30%) town_name  Population Budget Cost/Citizen Zuri 857186 540 $3,357,400 3.92 Rural - 4033 $28,331,025 6.99 Mrembo 494438 655 $2,332,650 4.72 Isiqalo 392316 499 $1,786,250 4.55 Harare 416282 533 $1,834,050 4.41 Amara Total $8.91M (22.7%) Count of improvement 370258 440 $1,607,850 4.34 - 6700 $39,249,225 5.96 $10.38M (26.45%) Rural $28.33M Aggregated_improvements Improvements Aggregated_improvements Install RO fil… Install UV a… Repair infra… Install publi… Install RO filter Drill well 1879 Install UV and RO filter Count of improvement Drill well Budget 791 $8,908,000 Install public tap(s)* 1007 $11,775,000 Install RO filter 1879 $10,380,300 Install UV and RO filter 1852 $7,680,000 Repair infrastructure 1171 $505,925 Total 6700 $39,249,225 1852 Repair infrastructure 1171 Install public tap(s)* Total Budget 1007 Drill well $39,249,225 791 0 500 1,000 1,500 2,000 Power BI Desktop Budget Allocation Aggregate… Install RO filter Rural/Urban Spending Install public tap(s)* $0.41M $2.49M (11.06%) (1.8%) town_name Count of improvement Zanzibar 137956 235 $773,700 5.61 Yaounde 123312 217 $750,350 6.08 Serowe Urban $4.64M $7.4M (32.8%) Population  Budget Cost/Citizen 235050 129 $329,350 1.40 - 2928 $17,909,325 6.26 Djenne 145316 256 $863,200 5.94 Deka 163128 277 $827,350 5.07 Amina 179894 342 $1,100,050 6.11 - 4384 $22,553,325 5.87 Rural Total $6.04M (26.77%) Rural $17.91M $6.22M (27.57%) Aggregated_improvements Improvements Aggregated_improvements Install UV a… Install RO fil… Repair infra… Install UV and RO filter Install publi… Drill well Count of improvement Drill well Install public tap(s)* $2,494,750 515 $6,218,000 1334 $7,398,300 Install UV and RO filter 1440 $6,036,800 Total Install RO filter 210 Install RO filter Repair infrastructure 1440 Budget 885 $405,475 4384 $22,553,325 1334 Repair infrastructure 885 Install public tap(s)* Total Budget 515 Drill well $22,553,325 210 0 500 1,000 1,500 2,000 Power BI Desktop Budget Allocation Aggregate… Install publi… Install RO fil… $0.89M (6.61%) $1.1M (8.21%) Drill well town_name Rural/Urban Spending $5.9M (43.94%) Population Count of improvement Rural - 1702 $6,610,425 3.10 Pwani 497522 296 $905,500 1.82 Dahabu 747662 200 $1,251,750 1.67 Bello 385324 246 $960,300 2.49 Asmara 834026 503 $1,722,900 2.07 Amina 458596 589 $1,286,100 2.80 Abidjan 373650 212 $691,300 1.85 - 3748 $13,428,275 2.47  Rural $6.61M $2.59M (19.31%) Total Budget Cost/Citizen Urban $6.82M $2.95M (21.94%) Aggregated_improvements Improvements Aggregated_improvements Repair infras… Install publi… Install RO filter Install UV … Drill well Count of improvement Drill well 258 $2,592,500 Install public tap(s)* 622 $5,900,000 Install RO filter 523 $2,946,300 297 $1,102,400 Install UV and RO filter Repair infrastructure 2.0K Install public tap(s)* Budget Repair infrastructure 2048 $887,075 Total 3748 $13,428,275 0.6K Install RO filter 0.5K Install UV and RO filter Total Budget 0.3K Drill well $13,428,275 0.3K 0K 1K 2K Power BI Desktop Power BI Desktop Build visuals with your data Select or drag fields from the Data pane onto the report canvas.