The Black Cat Logo

A collection of work by Sydney Hill

Metrics Reporting @ Passive Investing Cover Image

Case Study

Transforming raw backend data into actionable insight for smarter business decisions

TLDR

Built a real-time dashboard that gave stakeholders instant visibility into business health. I created a fluent metrics service in Laravel to calculate KPIs with readable, composable queries.

In Depth

The Challenge

Stakeholders needed insight into performance for their new franchise venture. We needed a flexible way to display dozens of metrics tied to models like memberships, revenue, and usage trends.

The Task

Create a reusable service layer to calculate business KPIs and display them in real-time on a Laravel admin dashboard.

My Contribution

Built the Stat service + chainable query API. Implemented tests, ensured dev ergonomics, and deployed a clean admin UI backed by dynamic metrics.

Result

Shipped a maintainable metrics system that stakeholders rely on daily. The service layer is now reused across internal dashboards.

Tools and Tech Stack

Design
Figma
Frontend
Vue 3,Tailwind,Vite
Backend
Laravel (PHP 8),MySQL
Build Tools
Git,NPM,Node,Composer,Docker
Testing
PHPStan,PHPUnit,Laravel Dusk,Codesniffer,BrowserStack
Workflow
GitTower,PHPStorm,Tinkerwell,Ray,TablePlus,Fish

Process Images

Coming soon.

Browse Others