Nic | Data
  • About
  • Projects
  • Research
  • Life
  • CV
  • Blog
  • Resources
  • Get in Touch

Portfolio

Projects & Case Studies

Real work across six SDG domains. Public health, agriculture, finance, education, environment, and governance. Each project reflects field experience or original analysis.

Public Health & M&E
Professor Nyongo launching the Kisumu health dashboard 📈

MSc Research · Kisumu County · Georgetown gui2de

Financial Determinants of NCD Management in Primary Health Facilities

Mixed methods study across 7 public primary care facilities in Seme Sub County examining how facility financing architecture shapes continuity of hypertension and diabetes care.

Manuscript data snapshot from 7 facilities

Frequent medicine stockouts 85.7%
Facilities without direct spending autonomy 100%
Facilities receiving direct county funding 28.6%
Facilities with dedicated NCD budget line 0%
Manuscript dataMixed methodsHealth financingPrimary care Read case study →
📉

Maternal Health · SDG 3

Maternal Mortality Trends in Sub-Saharan Africa

Multi-country analysis of maternal mortality ratios using WHO data, with difference-in-differences modelling and publication-quality visualisations.

Rggplot2DiD View →
🧬

Oncology · KEMRI

Cancer Surveillance Dashboard in Kisumu

Epidemiological analysis of cancer incidence data from the KEMRI Oncology Registry, with interactive Power BI dashboard and trend analysis.

Power BIREpidemiology View →
📊

MEL Systems · USAID reporting context

MEL Framework for Multi Site Health Programmes

Designed indicator trees, data quality checks, and reporting schedules for complex health programmes. Supported alignment between field operations, donor metrics, and learning agendas.

MELIndicator designQA Case brief
💊

Health Economics · Georgetown gui2de

Health Financing Impact Evaluation

Built panel data workflows and quasi experimental analyses for health financing and household expenditure studies. Integrated dashboards and quarterly evidence products for program decisions.

DiDPanel dataPolicy reporting Case brief
Agriculture & Food Security
Goats at the farm — small-ruminant production in Homa Bay 🌾

Agricultural Economics · Homa Bay County · SDG 2

Goat Farming Economics: Small-Ruminant Production Systems

Field-collected profitability analysis of small-ruminant production in Homa Bay. Combines cost data from smallholder farmers with market price modelling to produce practical decision tools for extension services.

REconomic modellingField data View case study →
🌽

Food Security · SDG 2

Food Security Analysis in East Africa

Regional food security trends using FAO and household survey data. Vulnerability mapping and seasonal analysis.

RFAO dataMapping View →
🚜

Agri logistics · Input systems

Agricultural Supply Chain Analytics

Mapped fertilizer and seed distribution workflows, modeled delivery delays, and designed monitoring views for stock movement and last mile access in rural counties.

Supply chainForecastingLogistics Case brief
Finance & Economics
💳

Financial Inclusion · SDG 10

Mobile Money, Banking Access and Health Outcomes

Correlation analysis linking mobile money penetration, formal banking access, and health expenditure patterns across Sub-Saharan Africa using World Bank and GSMA datasets.

PythonPlotlyRegression View →
🏢

Real estate strategy · portfolio planning

Mixed Use Development Feasibility Studio

Case brief and decision studio built from public market indicators, listing level comparables, and developer cost assumptions. Covers SQL and R data pipeline, cleaning and harmonization, discounted cash flow analysis, scenario testing, and dashboard outputs for investment and ROI decisions.

Data pipelineDCF modelROI strategy Case brief and dashboard →
🏦

Household finance · Longitudinal data

Financial Diaries Analytics

Built analysis pipelines for high frequency household diaries, with volatility indicators, coping strategy tracking, and policy focused summaries for social protection design.

Panel dataRPolicy briefs Case brief
Supply Chain & Analytics Engineering
🔗

Business analytics · development operations

Development Operations Case Brief

Shows end to end analytics delivery from data intake and cleaning to scenario modeling and executive dashboarding. Structured for finance, planning, engineering, and construction stakeholders aligning on cost control, phasing, and return outcomes.

SQLCross functionalDecision support Open case brief →
🗄️

Data engineering · Multi country RCT

Research Data Engineering Pipeline

Architected a reproducible pipeline for cleaning, harmonization, and dashboard outputs using SQL, R, and automated validation layers across multiple countries.

PostgreSQLETLQA Case brief
📡

Health information systems · DHIS2

DHIS2 Integration and Reporting Automation

Designed a reporting workflow that joins DHIS2 extracts with field operations data for faster indicator reporting, exception monitoring, and partner dashboards.

DHIS2AutomationMonitoring Case brief
Source Code
---
title: ""
page-layout: full
toc: false
---

```{=html}
<div class="section-pad">
<div class="section-inner">
  <span class="section-eyebrow">Portfolio</span>
  <h1 class="section-h" style="font-size:clamp(2.4rem,4vw,3.4rem);margin-top:0.5rem;margin-bottom:0.8rem;">
    Projects &amp; Case Studies
  </h1>
  <p class="section-sub">
    Real work across six SDG domains. Public health, agriculture, finance, education, environment,
    and governance. Each project reflects field experience or original analysis.
  </p>

  <!-- Global filter -->
  <div class="proj-filters" role="tablist" aria-label="Filter projects by domain" style="margin-bottom:3rem;">
    <button class="proj-filter active" data-filter="all" role="tab" aria-selected="true">All</button>
    <button class="proj-filter" data-filter="health" role="tab" aria-selected="false">Public Health</button>
    <button class="proj-filter" data-filter="agriculture" role="tab" aria-selected="false">Agriculture</button>
    <button class="proj-filter" data-filter="finance" role="tab" aria-selected="false">Finance</button>
    <button class="proj-filter" data-filter="analytics" role="tab" aria-selected="false">Analytics</button>
  </div>

  <!-- ─── HEALTH & M&E ────────────────────── -->
  <div class="proj-section-header" style="margin-bottom:1.2rem;">
    <span class="section-eyebrow" style="margin-bottom:0;">Public Health &amp; M&amp;E</span>
  </div>
  <div class="project-grid allProjects" style="margin-bottom:5rem;">

    <a href="../research/thesis.html" class="proj-card proj-featured" data-category="health">
      <div class="proj-thumb" style="background:#1a2e1a;">
        <div class="proj-thumb-pattern" style="--dot:#ffffff10;"></div>
        <img src="../img/professor nyongo launching the dashboard.jpeg"
             alt="Professor Nyongo launching the Kisumu health dashboard"
             style="position:absolute;inset:0;width:100%;height:100%;object-fit:cover;opacity:0.5;"
             onerror="this.remove()">
        <span class="proj-icon proj-icon-hero">📈</span>
      </div>
      <div class="proj-body">
        <p class="proj-domain" style="color:#7fbf7f;">MSc Research · Kisumu County · Georgetown gui2de</p>
        <h3 class="proj-title">Financial Determinants of NCD Management in Primary Health Facilities</h3>
        <p class="proj-desc">Mixed methods study across 7 public primary care facilities in Seme Sub County examining how facility financing architecture shapes continuity of hypertension and diabetes care.</p>

        <div class="proj-thesis-plot" aria-label="Manuscript facility findings plot">
          <p class="proj-thesis-plot-title">Manuscript data snapshot from 7 facilities</p>
          <div class="proj-thesis-bars">
            <div class="proj-thesis-bar" data-value="85.7">
              <div class="proj-thesis-head">
                <span class="proj-thesis-label">Frequent medicine stockouts</span>
                <span class="proj-thesis-value">85.7%</span>
              </div>
              <div class="proj-thesis-track"><span class="proj-thesis-fill"></span></div>
            </div>
            <div class="proj-thesis-bar" data-value="100">
              <div class="proj-thesis-head">
                <span class="proj-thesis-label">Facilities without direct spending autonomy</span>
                <span class="proj-thesis-value">100%</span>
              </div>
              <div class="proj-thesis-track"><span class="proj-thesis-fill"></span></div>
            </div>
            <div class="proj-thesis-bar" data-value="28.6">
              <div class="proj-thesis-head">
                <span class="proj-thesis-label">Facilities receiving direct county funding</span>
                <span class="proj-thesis-value">28.6%</span>
              </div>
              <div class="proj-thesis-track"><span class="proj-thesis-fill"></span></div>
            </div>
            <div class="proj-thesis-bar" data-value="0">
              <div class="proj-thesis-head">
                <span class="proj-thesis-label">Facilities with dedicated NCD budget line</span>
                <span class="proj-thesis-value">0%</span>
              </div>
              <div class="proj-thesis-track"><span class="proj-thesis-fill"></span></div>
            </div>
          </div>
        </div>
        <div class="proj-footer">
          <span class="proj-tags"><span>Manuscript data</span><span>Mixed methods</span><span>Health financing</span><span>Primary care</span></span>
          <span class="proj-arrow">Read case study →</span>
        </div>
      </div>
    </a>

    <a href="../tidy-tuesday/2024-maternal-mortality.html" class="proj-card proj-half" data-category="health">
      <div class="proj-thumb" style="background:#1e2a1e;height:180px;">
        <div class="proj-thumb-pattern" style="--dot:#ffffff0d;"></div>
        <span class="proj-icon">📉</span>
      </div>
      <div class="proj-body">
        <p class="proj-domain" style="color:#7fbf7f;">Maternal Health · SDG 3</p>
        <h3 class="proj-title">Maternal Mortality Trends in Sub-Saharan Africa</h3>
        <p class="proj-desc">Multi-country analysis of maternal mortality ratios using WHO data, with difference-in-differences modelling and publication-quality visualisations.</p>
        <div class="proj-footer">
          <span class="proj-tags"><span>R</span><span>ggplot2</span><span>DiD</span></span>
          <span class="proj-arrow">View →</span>
        </div>
      </div>
    </a>

    <a href="../posts/kisumu-cancer-dashboard/index.html" class="proj-card proj-half" data-category="health">
      <div class="proj-thumb" style="background:#2a1a1a;height:180px;">
        <div class="proj-thumb-pattern" style="--dot:#ffffff0d;"></div>
        <span class="proj-icon">🧬</span>
      </div>
      <div class="proj-body">
        <p class="proj-domain" style="color:#e07f7f;">Oncology · KEMRI</p>
        <h3 class="proj-title">Cancer Surveillance Dashboard in Kisumu</h3>
        <p class="proj-desc">Epidemiological analysis of cancer incidence data from the KEMRI Oncology Registry, with interactive Power BI dashboard and trend analysis.</p>
        <div class="proj-footer">
          <span class="proj-tags"><span>Power BI</span><span>R</span><span>Epidemiology</span></span>
          <span class="proj-arrow">View →</span>
        </div>
      </div>
    </a>

    <div class="proj-card proj-half" data-category="health">
      <div class="proj-thumb" style="background:#183222;height:180px;">
        <div class="proj-thumb-pattern" style="--dot:#ffffff0d;"></div>
        <span class="proj-icon">📊</span>
      </div>
      <div class="proj-body">
        <p class="proj-domain" style="color:#7fbf7f;">MEL Systems · USAID reporting context</p>
        <h3 class="proj-title">MEL Framework for Multi Site Health Programmes</h3>
        <p class="proj-desc">Designed indicator trees, data quality checks, and reporting schedules for complex health programmes. Supported alignment between field operations, donor metrics, and learning agendas.</p>
        <div class="proj-footer">
          <span class="proj-tags"><span>MEL</span><span>Indicator design</span><span>QA</span></span>
          <span class="proj-arrow">Case brief</span>
        </div>
      </div>
    </div>

    <div class="proj-card proj-half" data-category="health">
      <div class="proj-thumb" style="background:#2b1d1d;height:180px;">
        <div class="proj-thumb-pattern" style="--dot:#ffffff0d;"></div>
        <span class="proj-icon">💊</span>
      </div>
      <div class="proj-body">
        <p class="proj-domain" style="color:#e07f7f;">Health Economics · Georgetown gui2de</p>
        <h3 class="proj-title">Health Financing Impact Evaluation</h3>
        <p class="proj-desc">Built panel data workflows and quasi experimental analyses for health financing and household expenditure studies. Integrated dashboards and quarterly evidence products for program decisions.</p>
        <div class="proj-footer">
          <span class="proj-tags"><span>DiD</span><span>Panel data</span><span>Policy reporting</span></span>
          <span class="proj-arrow">Case brief</span>
        </div>
      </div>
    </div>

  </div>

  <!-- ─── AGRICULTURE ──────────────────────── -->
  <div class="proj-section-header" style="margin-bottom:1.2rem;">
    <span class="section-eyebrow" style="margin-bottom:0;">Agriculture &amp; Food Security</span>
  </div>
  <div class="project-grid allProjects" style="margin-bottom:5rem;">

    <a href="../posts/agriculture-data-analysis/index.html" class="proj-card proj-featured" data-category="agriculture">
      <div class="proj-thumb" style="background:#2a1e08;">
        <div class="proj-thumb-pattern" style="--dot:#ffffff10;"></div>
        <img src="../img/goats drinking near goat pen, digging water pan in the background.jpeg"
             alt="Goats at the farm — small-ruminant production in Homa Bay"
             style="position:absolute;inset:0;width:100%;height:100%;object-fit:cover;opacity:0.55;"
             onerror="this.remove()">
        <span class="proj-icon proj-icon-hero">🌾</span>
      </div>
      <div class="proj-body">
        <p class="proj-domain" style="color:#d4a84b;">Agricultural Economics · Homa Bay County · SDG 2</p>
        <h3 class="proj-title">Goat Farming Economics: Small-Ruminant Production Systems</h3>
        <p class="proj-desc">Field-collected profitability analysis of small-ruminant production in Homa Bay. Combines cost data from smallholder farmers with market price modelling to produce practical decision tools for extension services.</p>
        <div class="proj-footer">
          <span class="proj-tags"><span>R</span><span>Economic modelling</span><span>Field data</span></span>
          <span class="proj-arrow">View case study →</span>
        </div>
      </div>
    </a>

    <a href="../tidy-tuesday/food-security.html" class="proj-card proj-half" data-category="agriculture">
      <div class="proj-thumb" style="background:#1a2a10;height:180px;">
        <div class="proj-thumb-pattern" style="--dot:#ffffff0d;"></div>
        <span class="proj-icon">🌽</span>
      </div>
      <div class="proj-body">
        <p class="proj-domain" style="color:#a8c87f;">Food Security · SDG 2</p>
        <h3 class="proj-title">Food Security Analysis in East Africa</h3>
        <p class="proj-desc">Regional food security trends using FAO and household survey data. Vulnerability mapping and seasonal analysis.</p>
        <div class="proj-footer">
          <span class="proj-tags"><span>R</span><span>FAO data</span><span>Mapping</span></span>
          <span class="proj-arrow">View →</span>
        </div>
      </div>
    </a>

    <div class="proj-card proj-half" data-category="agriculture">
      <div class="proj-thumb" style="background:#2a2a12;height:180px;">
        <div class="proj-thumb-pattern" style="--dot:#ffffff0d;"></div>
        <span class="proj-icon">🚜</span>
      </div>
      <div class="proj-body">
        <p class="proj-domain" style="color:#a8c87f;">Agri logistics · Input systems</p>
        <h3 class="proj-title">Agricultural Supply Chain Analytics</h3>
        <p class="proj-desc">Mapped fertilizer and seed distribution workflows, modeled delivery delays, and designed monitoring views for stock movement and last mile access in rural counties.</p>
        <div class="proj-footer">
          <span class="proj-tags"><span>Supply chain</span><span>Forecasting</span><span>Logistics</span></span>
          <span class="proj-arrow">Case brief</span>
        </div>
      </div>
    </div>

  </div>

  <!-- ─── FINANCE & ECONOMICS ─────────────── -->
  <div class="proj-section-header" style="margin-bottom:1.2rem;">
    <span class="section-eyebrow" style="margin-bottom:0;">Finance &amp; Economics</span>
  </div>
  <div class="project-grid allProjects" style="margin-bottom:5rem;">

    <a href="../tidy-tuesday/financial-inclusion.html" class="proj-card proj-half" data-category="finance">
      <div class="proj-thumb" style="background:#0d1a2e;height:200px;">
        <div class="proj-thumb-pattern" style="--dot:#ffffff10;"></div>
        <span class="proj-icon">💳</span>
      </div>
      <div class="proj-body">
        <p class="proj-domain" style="color:#6fa8dc;">Financial Inclusion · SDG 10</p>
        <h3 class="proj-title">Mobile Money, Banking Access and Health Outcomes</h3>
        <p class="proj-desc">Correlation analysis linking mobile money penetration, formal banking access, and health expenditure patterns across Sub-Saharan Africa using World Bank and GSMA datasets.</p>
        <div class="proj-footer">
          <span class="proj-tags"><span>Python</span><span>Plotly</span><span>Regression</span></span>
          <span class="proj-arrow">View →</span>
        </div>
      </div>
    </a>

    <a href="real-estate-feasibility-studio/index.html" class="proj-card proj-half" data-category="finance">
      <div class="proj-thumb" style="background:#162037;height:200px;">
        <div class="proj-thumb-pattern" style="--dot:#ffffff10;"></div>
        <span class="proj-icon">🏢</span>
      </div>
      <div class="proj-body">
        <p class="proj-domain" style="color:#6fa8dc;">Real estate strategy · portfolio planning</p>
        <h3 class="proj-title">Mixed Use Development Feasibility Studio</h3>
        <p class="proj-desc">Case brief and decision studio built from public market indicators, listing level comparables, and developer cost assumptions. Covers SQL and R data pipeline, cleaning and harmonization, discounted cash flow analysis, scenario testing, and dashboard outputs for investment and ROI decisions.</p>
        <div class="proj-footer">
          <span class="proj-tags"><span>Data pipeline</span><span>DCF model</span><span>ROI strategy</span></span>
          <span class="proj-arrow">Case brief and dashboard →</span>
        </div>
      </div>
    </a>

    <div class="proj-card proj-half" data-category="finance">
      <div class="proj-thumb" style="background:#10243c;height:200px;">
        <div class="proj-thumb-pattern" style="--dot:#ffffff10;"></div>
        <span class="proj-icon">🏦</span>
      </div>
      <div class="proj-body">
        <p class="proj-domain" style="color:#6fa8dc;">Household finance · Longitudinal data</p>
        <h3 class="proj-title">Financial Diaries Analytics</h3>
        <p class="proj-desc">Built analysis pipelines for high frequency household diaries, with volatility indicators, coping strategy tracking, and policy focused summaries for social protection design.</p>
        <div class="proj-footer">
          <span class="proj-tags"><span>Panel data</span><span>R</span><span>Policy briefs</span></span>
          <span class="proj-arrow">Case brief</span>
        </div>
      </div>
    </div>

  </div>

  <!-- ─── SUPPLY CHAIN & ANALYTICS ENGINEERING -->
  <div class="proj-section-header" style="margin-bottom:1.2rem;">
    <span class="section-eyebrow" style="margin-bottom:0;">Supply Chain &amp; Analytics Engineering</span>
  </div>
  <div class="project-grid allProjects" style="margin-bottom:2rem;">

    <a href="real-estate-feasibility-studio/index.html" class="proj-card proj-half" data-category="analytics">
      <div class="proj-thumb" style="background:#162233;height:180px;">
        <div class="proj-thumb-pattern" style="--dot:#ffffff10;"></div>
        <span class="proj-icon">🔗</span>
      </div>
      <div class="proj-body">
        <p class="proj-domain" style="color:#8cb5d9;">Business analytics · development operations</p>
        <h3 class="proj-title">Development Operations Case Brief</h3>
        <p class="proj-desc">Shows end to end analytics delivery from data intake and cleaning to scenario modeling and executive dashboarding. Structured for finance, planning, engineering, and construction stakeholders aligning on cost control, phasing, and return outcomes.</p>
        <div class="proj-footer">
          <span class="proj-tags"><span>SQL</span><span>Cross functional</span><span>Decision support</span></span>
          <span class="proj-arrow">Open case brief →</span>
        </div>
      </div>
    </a>

    <div class="proj-card proj-half" data-category="analytics">
      <div class="proj-thumb" style="background:#1d1f2b;height:180px;">
        <div class="proj-thumb-pattern" style="--dot:#ffffff10;"></div>
        <span class="proj-icon">🗄️</span>
      </div>
      <div class="proj-body">
        <p class="proj-domain" style="color:#8cb5d9;">Data engineering · Multi country RCT</p>
        <h3 class="proj-title">Research Data Engineering Pipeline</h3>
        <p class="proj-desc">Architected a reproducible pipeline for cleaning, harmonization, and dashboard outputs using SQL, R, and automated validation layers across multiple countries.</p>
        <div class="proj-footer">
          <span class="proj-tags"><span>PostgreSQL</span><span>ETL</span><span>QA</span></span>
          <span class="proj-arrow">Case brief</span>
        </div>
      </div>
    </div>

    <div class="proj-card proj-half" data-category="analytics">
      <div class="proj-thumb" style="background:#1a2533;height:180px;">
        <div class="proj-thumb-pattern" style="--dot:#ffffff10;"></div>
        <span class="proj-icon">📡</span>
      </div>
      <div class="proj-body">
        <p class="proj-domain" style="color:#8cb5d9;">Health information systems · DHIS2</p>
        <h3 class="proj-title">DHIS2 Integration and Reporting Automation</h3>
        <p class="proj-desc">Designed a reporting workflow that joins DHIS2 extracts with field operations data for faster indicator reporting, exception monitoring, and partner dashboards.</p>
        <div class="proj-footer">
          <span class="proj-tags"><span>DHIS2</span><span>Automation</span><span>Monitoring</span></span>
          <span class="proj-arrow">Case brief</span>
        </div>
      </div>
    </div>

  </div>

</div>
</div>

<script>
(function() {
  var filters = document.querySelectorAll('.proj-filter');
  var allGrids = document.querySelectorAll('.allProjects');
  var chartFills = document.querySelectorAll('.proj-thesis-fill');

  function animateThesisPlot() {
    chartFills.forEach(function(fill) {
      var parent = fill.closest('.proj-thesis-bar');
      if (!parent) return;
      var value = Number(parent.dataset.value || 0);
      fill.style.width = Math.max(0, Math.min(100, value)) + '%';
    });
  }

  if (chartFills.length) {
    if ('IntersectionObserver' in window) {
      var chart = document.querySelector('.proj-thesis-plot');
      if (chart) {
        var seen = false;
        var observer = new IntersectionObserver(function(entries) {
          entries.forEach(function(entry) {
            if (entry.isIntersecting && !seen) {
              seen = true;
              animateThesisPlot();
            }
          });
        }, {threshold: 0.25});
        observer.observe(chart);
      } else {
        animateThesisPlot();
      }
    } else {
      animateThesisPlot();
    }
  }

  filters.forEach(function(btn) {
    btn.addEventListener('click', function() {
      filters.forEach(function(b) {
        b.classList.remove('active');
        b.setAttribute('aria-selected', 'false');
      });
      this.classList.add('active');
      this.setAttribute('aria-selected', 'true');

      var f = this.dataset.filter;

      allGrids.forEach(function(grid) {
        var cards = grid.querySelectorAll('[data-category]');
        var anyVisible = false;
        cards.forEach(function(card) {
          var show = f === 'all' || card.dataset.category === f;
          card.style.opacity = show ? '1' : '0.14';
          card.style.transform = show ? '' : 'scale(0.97)';
          card.style.pointerEvents = show ? '' : 'none';
          if (show) anyVisible = true;
        });
        grid.style.display = anyVisible ? '' : 'none';
        var header = grid.previousElementSibling;
        if (header && header.classList.contains('proj-section-header')) {
          header.style.display = anyVisible ? '' : 'none';
        }
      });
    });
  });
})();
</script>
```

© 2025 Nichodemus Amollo · Built with Quarto

Nairobi, Kenya