kwiklybi
Business intelligence dashboard for Kwikly's dental staffing marketplace, providing real-time analytics on fill rates, cancellations, and marketplace health.
650 commits over 82 days
What it is
KwiklyBI is an internal analytics platform built to give Kwikly team members visibility into their dental staffing marketplace. It surfaces metrics like fill rate (currently 83.4%, targeting 85%), state-by-state performance, cancellation revenue impact, posting behavior, and DSO (Dental Service Organization) activation tracking. The app connects read-only to production databases (153K+ assignments, 166 tables) and presents interactive dashboards with drill-down capabilities—for example, the DSO Explorer automates what was previously a manual Excel process for tracking DSO activation rates and office health scores.
Why I built it
Built to replace manual Excel workflows and give the Kwikly team a centralized, real-time view of marketplace performance. The DSO Explorer feature explicitly automated "Regina's manual process" of tracking DSO activation and health distributions. The platform supports strategic decision-making around fill rates, demand pacing, contractor engagement, and market expansion.
Tech stack
Laravel 12 backend (PHP 8.4) with Blade templating, Tailwind CSS + Alpine.js for interactivity, Chart.js for visualizations, MySQL (read-only replica connections to production), Redis caching, Google OAuth for @joinkwikly.com domain-restricted authentication. Multi-database setup: kwiklybi (app state, read-write), kwikly (production data, read-only), hdflex (partner data, read-only). Vite for asset bundling, PHPUnit tests, GitHub Actions CI/CD.
Timeline & effort
Last active Jun 17, 2026 — 650 commits across 82 active days (spanning 244 days).
Built over 244 calendar days (late Oct 2025 to mid-Jun 2026) with 650 commits across 82 active days. Activity ramped significantly from March onward (103→111→224 commits/month), indicating sustained iterative development and feature expansion.
Did it turn out useful?
This is a production internal tool actively used by the Kwikly team. It connects to live production data (153K+ assignments), enforces Google OAuth with domain restrictions, and has detailed implementation/testing docs for features like DSO Explorer that explicitly replace manual workflows. The commit cadence, CI/CD setup, permission/user-level system, and comprehensive feature inventory all signal a shipped, maintained internal tool rather than a prototype or experiment.