Project Breakdown
SPARK Brings Modern Workflow to Metro Detroit Industrial Service Leader
The Challenge
Customer and order data lived in GLR’s industry-specific ERP, but tedious steps had to be taken to track and report on the most important parts of their process.
The frontline office team was sick of digging through a hefty Excel spreadsheet of data exported from the ERP system in order to take action.Â
Project Breakdown
- Medium
- Custom Workflow
Timeline
6 Months
Size of Team
- 1 PM, 1 UX Designer
- 2 Developers
KPIs
100s of Data Entry Hour
- Automated Each Month
The Solution
SPARK collaborated with key GLR stakeholders during an Assessment to understand exactly what data and functionality GLR needed (and what they didn’t).
The new custom dashboard is now leveraged “all day, every day”! Customers receive automated email and text notifications for order updates.Â
Management can quickly see KPI visualizations by customer and commodity. They export data in 1-click.Â
Simple filters and search functionality save hours each week and empower the team to see trends in realtime.
Services provided
- Assessment
- Wireframing
- Technical Feasibility
Technology used
- ERP Import
- Laravel
- jQuery
- OneSignal
- Twilio
- MySQL
- AWS
