Het PatelBusiness & Data Analyst

Selected work

Case studies are published here when the work behind them can be explained honestly — including where the evidence stops.

In preparation

  • Recruiting KPI and reporting system

    Professional work · February 2025 — present

    Requirements gathered across HR, Sales, and Operations, turned into KPI dashboards and an automated weekly reporting cycle used in leadership meetings.

    • Employer position on publication (docs/conflicts-and-gaps.md G-4)
    • Recreated diagrams using synthetic data
    • Statement of Het's contribution versus the team's
  • Healthcare provider performance dashboard

    Practice challenge — brief supplied by a third party, synthetic dataset

    An underspecified dashboard brief read, scoped, and turned into a KPI set and a multi-page Power BI report over a synthetic healthcare dataset.

    • Dashboard screenshot or export — the repository contains no image of its own output (docs/conflicts-and-gaps.md G-6)
    • Source or name of the challenge, if known
  • Mortgage finance analytics

    Practice build following a structured guide — generated synthetic data, fictional business

    A SQL analytical layer and scenario model over a generated mortgage origination dataset — monthly profitability, cost per loan, and revenue per loan.

    • Het's account of which parts he wrote versus followed from the supplied guide
  • AI-assisted requirements and KPI triage

    Proposed — not yet built

    A planned prototype that turns synthetic stakeholder notes into candidate requirements and KPI mappings, with ambiguity flags and a human approval step before anything is finalised.

    • Not built. Requires a build decision (docs/project-selection.md, decision 2)
    • Published evaluation results, including poor results

The work behind them is described on Experience, and framed by role on Role fit.