NGDS Public Analytics

Programmes & Projects Analytics Dashboard

A public-facing dashboard for portfolio visibility across projects and programmes, including progress, financing, delivery timelines, clusters, ministries, and geographic coverage.
Advanced Analytics 36 Chart Views Public Transparency Map & Table View CSV Export
Public transparency view Designed for citizens, MDAs, leadership teams, and oversight users.
Interactive analytics intelligence Interactive financial, delivery, geographic, and portfolio visuals.
Filter-first workflow Refine once and the dashboard recalculates charts, map, and exports.
Cleaner public register Progress, utilization, views, and timeline stay in charts but are hidden from the table.
Filters & Controls
Refine the public portfolio view. These filters affect charts, map, and table exports.
Select2 enabled for faster filtering. Charts, map, and exports respond to these controls.
Active filters: Sort: portfolio_cost desc Rows: 500
Redesigned Public Analytics Experience

Organized for fast executive reading and public interpretation

The content now follows a storytelling flow: understand the portfolio, inspect financials, review delivery quality, explore composition, open deep-dive analytics, then review geography and the public register.

Executive Cockpit

High-level portfolio position

Core totals and public summary indicators appear first so users understand the portfolio before reading the charts.

Total Items
51
0 completed · 0 ongoing
Portfolio Value
KSh 9.40T
Estimated value in current filtered view
Budget
KSh 1.46T
Allocated budget
Spent
KSh 869.82B
59.5% avg utilization
Avg Progress
0.0%
51 pipeline · 0 stalled
Overdue
0
Timeline risk count in current view
Completion Rate0%
Budget Coverage0%
Geo Coverage0%
Data Quality Avg0%
Financial Theatre

Priority financial and portfolio visuals

Budget, expenditure, status, and category views are promoted to the top because they explain scale, direction, and portfolio balance fastest.

1
Financial Trend Analytics
Portfolio value, budget, and expenditure by year
2
Status Distribution
Current portfolio status split
3
Category Mix
Projects vs Programmes
Delivery and Data Quality

Implementation health, risk, and confidence signals

This section groups gauges, radar, delivery funnel, timeline risk, data quality coverage, and progress distribution for quick interpretation.

28
Gauge: Avg Utilization
Average spending utilization score
29
Gauge: Completion Rate
Completed share of current portfolio
30
Gauge: Data Quality Average
Average of core data coverage indicators
22
Portfolio Health Radar
Composite public health snapshot
23
Delivery Funnel
Progress bands as a delivery funnel
24
Sunburst: Cluster → Status
Hierarchical composition of portfolio
25
Treemap: Cluster Portfolio
Cluster contribution to overall value
26
Sankey: Category → Status
Flow of category counts into current status
27
Gauge: Avg Progress
Overall average progress score
4
Timeline Risk
Overdue, due soon, on-track, completed, and missing dates
5
Cluster Size
Projects/programmes by cluster
6
Cluster Portfolio Value
Portfolio value contribution by cluster
7
Duration Bands
Planned duration distribution
8
Data Quality Coverage
Geo, date, cost, and budget completeness
9
Progress Distribution
Histogram of progress percentages
Portfolio Composition

Clusters, ministries, cost leaders, and status mix

Use this section to understand where projects sit institutionally and how cost, progress, ministry, and status are distributed.

10
Utilization Distribution
Budget utilization histogram
11
Status by Category
Stacked count by Project/Programme
12
Top Ministries by Count
Most represented ministries in current view
13
Top Ministries by Portfolio Value
Estimated value grouped by ministry
14
Top Projects by Cost
Highest portfolio cost in filtered dataset
15
Top Projects by Progress
Highest progress projects/programmes
Performance & Delivery Insights

Advanced portfolio insight views

Use these advanced insight views to compare delivery progress, cost, utilization, cluster concentration, and portfolio risk patterns.

16
Scatter: Progress vs Cost
Cost positioning against delivery progress
17
Scatter: Progress vs Utilization
Utilization and progress relationship
18
Scatter: Budget vs Spent
Budget utilization diagonal comparison
19
Bubble: Views vs Cost
Bubble size indicates progress
20
Heatmap: Cluster × Progress Band
Distribution across progress ranges
21
Heatmap: Cluster × Status
Current status concentration per cluster
Additional Chart Types

Additional portfolio intelligence views

This section adds missing advanced visual types so the dashboard is not limited to bars, lines, scatter plots, and gauges. It includes waterfall, calendar, boxplot, pictorial, rose, and polar-style views derived from the same analytics payload.

31
Waterfall: Budget to Balance
Budget, expenditure, and remaining balance view
32
Calendar: Project Start Density
Monthly project/programme activity density by year
33
Boxplot: Cost Distribution by Status
Portfolio cost spread across status groups
34
Pictorial: Status Symbols
Symbol-based portfolio status summary
35
Rose: Category and Status Mix
Radial comparison of major portfolio groups
36
Polar: Progress Bands
Radial progress distribution across implementation bands
Geography

Project distribution map

The map supports location-based interpretation where coordinates are available.

Geographic Distribution Map
Project/programme locations across Kenya (where coordinates are available)
Ongoing Completed Pipeline Stalled
Public Register

Clean public-friendly project table

The register focuses on identity, institution, status, category, portfolio cost, budget, and spending. Sensitive analytical fields remain in charts but are hidden from the table.

Progress, utilization, views, and timeline are hidden from the public table
Projects & Programmes Analytics Table
Public-friendly detailed records (searchable client-side)
Project / Programme Cluster Ministry Status Category Portfolio Cost Budget Spent
Tip: Use server filters above for exports and chart recalculation. Use table filters here for quick exploration.
0 visible rows