Sharperlight Case Study
Retail – ATG
How Sharperlight and ATG transformed a single-store incentive spreadsheet into a commercial, web-enabled solution for setting targets, tracking gross profit, and reporting across multiple data sources.
Case study
The Challenge
ATG needed a solution that was easier to manage, more scalable, and capable of combining data entry and reporting across Excel and the web.
Provide an easy-to-use solution that enables store owners and managers to define and update targets, while sales staff can readily progress and track gross profit targets based on regularly managed incentives.
Update and simplify an Excel® spreadsheet-based staff incentive solution developed for a single store into a sophisticated commercial solution that could be sold to the wider Telstra® base.
Use Excel® and web-based content to deliver data-entry screens and provide data and reports from different applications.
Approach
The Solution
Sharperlight and ATG systems provide an easy-to-use interface that allows store owners and managers to allocate monthly, weekly, or fortnightly targets across products and employees while ensuring store targets are allocated evenly.
Delivery
Implementation
The entire ATG solution is written using the Sharperlight application framework, from extracting and populating data from the underlying sources into the ATG warehouse through to dashboard reporting and the presentation and administration of the user interfaces.
Outcome context
Scenario
The Sharperlight framework enabled privately owned stores to report on and drill into information from multiple data sources easily, quickly, and accurately. This improved business processes, data transparency for staff and management, operational efficiency and security, while reducing manual rework.
Before Sharperlight
Business Situation
Owners and managers of the T-Life shops struggled to gather the information needed to determine, allocate, and report budgets and sales promptly because internal processes were lengthy, manual, and complicated.
Delivered solution
Solution Summary
Sharperlight web-based data entry feeds the ATG Data Mart, with live dashboard reporting from three different systems providing managers and staff with up-to-date information.
Results
