Unifying 6 Departments into One Real-Time Operations Platform
A custom enterprise dashboard that replaced scattered spreadsheets with secure, role-based, real-time analytics for a US-based multi-store automotive dealership group.
One Source of Truth for the Entire Dealership Group
The client operates a multi-store automotive dealership group where every team — executive, accounting, payroll, sales, fixed-ops, and vehicle inventory — ran on its own disconnected mix of spreadsheets, vendor portals, and manual reports.
OpenMalo designed and built a single enterprise web application that centralizes business-critical metrics, tools, and reports into one secure, role-based dashboard. Authorized team members get exactly the data they need — and nothing they don't — in real time.
The result is a unified operations platform that cuts manual work, speeds up decision-making, and gives leadership live visibility across every store.
Deployed Across the United States
The platform powers day-to-day operations for the group's dealership stores across the United States, serving hundreds of staff members spanning six departments — all from a single, centralized application.
17
Dealership Stores
6
Departments
4
Auth Providers
10+
Modules
The Problems We Set Out to Solve
Data scattered across 6+ disconnected systems
Every department ran on its own mix of spreadsheets, vendor portals, and manual exports — with no single place to see the business.
A unified dashboard with single sign-on that brings executive, accounting, payroll, sales, fixed-ops, and inventory data together.
Slow, error-prone manual Excel reporting
Month-end reporting meant hours of copy-paste across workbooks, leaving room for costly mistakes and stale numbers.
Automated, real-time dashboards with one-click PDF and Excel export — accurate reports in seconds, not days.
No role-based access or data security
Sensitive financial and payroll data had no proper access boundaries between roles and stores.
Granular role-based access control (RBAC) backed by enterprise auth — Supabase, Clerk, Auth0, and AWS Cognito support.
No real-time visibility for leadership
Executives lacked a live, cross-store view of profit, approvals, and operations to make timely decisions.
Live KPIs, interactive charts, and drill-downs that give leadership instant visibility across all 17 stores.
Built on a Modern, Enterprise-Grade Stack
Frontend
Data & Auth
Visualization
Reporting & Utils
A Closer Look at the Interface
Live business data has been blurred to protect client confidentiality.
Company-wide financial and operational KPIs across every store in one executive view.
Have a complex internal tool to build?
Let's turn your spreadsheets and disconnected systems into one secure, real-time platform your whole team will rely on.
Book a Free ConsultationEverything the Dealership Needs, in One Place
Unified Dashboard
Single sign-on access with role-based navigation and fast module switching.
Real-Time Data Visualization
Interactive line, bar, pie and area charts with live updates and drill-downs.
Excel-like Data Grids
Handsontable-powered bulk entry — copy/paste from Excel, sort, and filter.
Automated PDF & Excel Reports
One-click, print-optimized financial statements and data exports.
Role-Based Access Control
Six+ roles with department-level permissions across four auth providers.
Multi-Language Support
i18next-based localization, ready to extend beyond English.
10+ Integrated Modules
A Phased, Agile Delivery Process
Discovery & Requirements
Mapped operational workflows across all six departments and 17 stores.
Architecture & Design
Designed the modular dashboard, RBAC model, and real-time data layer.
Core Module Build
Built 10+ modules in agile two-week sprints with weekly client demos.
Integrations
Connected Supabase, Mapbox, vehicle-data vendors, and CDN delivery.
QA & Testing
Jest + Testing Library coverage and cross-browser validation.
Launch & Iterate
Shipped to production on Vercel with CI/CD and ongoing enhancements.
Agile · two-week sprints•Weekly client demos•CI/CD on Vercel
