8,000 top customers, one dashboard.
A loyalty marketing company’s largest retail client wanted analytics on its top 8,000 customers, on an aggressive timeline. The company had no spare technical capacity and no dashboard expertise in-house. Digineer architected and built a secure drill-down dashboard and handed it to the company’s team, and the company went on to win data warehouse work from the same retailer.
At a glance
- Client
- A loyalty marketing company
- Program
- Customer analytics dashboard for a retail client
- Scale
- Top 8,000 customers of a worldwide home improvement retailer
- Engagement
- BI architecture, development and transition
- Capability
- AI Enablement & Delivery
The situation
A client request with no team to build it
The company connects loyalty vendors with large retailers, and its system held the retail point-of-sale data. One of its largest customers, a worldwide home improvement chain, wanted to increase per-customer purchases, prevent defections and improve service to its top 8,000 customers.
The company was well placed to answer with a customer analytics dashboard, and it knew it could reuse the technology for other clients. But like most high-growth organizations, it had no idle technical capacity and no dashboard development knowledge in-house. The timeline was aggressive.
Warning signs
- A time-sensitive request from a large client
- No spare technical capacity
- No dashboard skills in-house
- A solution that had to be secure and repeatable
- A team that would have to support it afterward
What we did
Scope it, build it, hand it over
Digineer analyzed the retail client’s objectives, architected a solution and helped stakeholders agree on priorities and a delivery schedule that could be met.
Agreement on scope and timeline
Digineer gained consensus on scope and timeline first, so an aggressive deadline rested on a feasible plan.
A secure drill-down dashboard
The dashboard gives the retail client up-to-date aggregate sales for any region, store or customer worldwide, with drill-down for trend analysis, plus supporting processes and critical reports.
Built to transition
Digineer integrated the dashboard with the existing infrastructure on Microsoft SQL Server Reporting Services and transitioned support to the company’s own technical team.
The outcome
Delivery that led to more business
Praise for timely delivery
The retail client praised the company for delivering a robust solution on time.
Follow-on data warehouse work
The company was then engaged to build a data warehouse for the same client, to analyze consumer purchase preferences and provide ad hoc data mining.
New service offerings
Because of the dashboard’s success, the company added service offerings for its customers, giving it an additional competitive advantage.
One extensible platform
A single, easy-to-use platform the company can extend, with a strategy for data warehouse and data mining capabilities.
Business intelligence
Have the data but not the team to use it?
Digineer designs and builds analytics your clients can use, then hands them to your team to run.
Client name withheld for confidentiality.