At a glance
Solution: Wherescape RED data warehouse automation, SQL Reporting Services, consulting expertise, training, implementation and support from NOW Consulting
- Increased productivity – increased the speed of their server migration project
- Decreased manual intervention – saved 20 hours per week of manual effort in commission reporting
- Increased accuracy – fewer manual processes have led to more accurate reporting
- Documentation – valuable documentation is now properly maintained
- Up-skilled team – NOW Consultants mentored the Spark Retail BI team resulting in increased capability within the team
Problem solving since 2006
Spark Retail Stores have worked with NOW Consulting (then known as WhereScape Consulting) for over a decade, using WhereScape RED and NOW Consulting Professional Services to build and automate their data warehouse and business processes.
Spark Retail Stores engaged NOW Consulting to manage the transition to new infrastructure across several environments. During the delivery of this server migration, several complex challenges arose, which were resolved efficiently by NOW, resulting in the project being delivered on time.
NOW Consulting also showed initiative by up-skilling a key member of Spark Retail Stores’ team who is involved in the daily data warehouse operations. Over a six-month period, NOW provided RED training as well as mentoring in data warehouse best practice and technical skills. This has been particularly valuable to Spark Retail Stores because it increased their autonomy and has reduced costs.
Difficulty of vast, manual data input
Spark Retail Stores asked NOW to improve their commission reporting for their Door-to-Door business unit, who sell Spark products and services to consumers, businesses and wholesale markets.
Precise reporting is critical for Spark Retail Stores as it enables them to communicate targets to Spark Retail Management as well as make accurate and timely commission payments.
The existing reporting system was extremely manual, labour intensive and prone to errors, so Spark Retail Stores engaged NOW Consulting to find a solution.
Ease of automated Commission Reporting
From the ground up, NOW built an automated reporting solution for Door-to-Door commissions and target reporting, using a complex set of business rules and Excel spreadsheets.
By breaking down the problem into simple iterations, NOW were able to reverse engineer the data and rules to create an accurate, automated reporting repository.
Spark Retail Store’s new commission reporting is now processed and delivered to its users automatically via the Biztrack business reporting hub. This new solution provides management reporting as well as valuable drill-down functionality, which offers additional data visibility and easier access for business users.
Saving time, increasing productivity & improving data
Spark Retail Stores’ new Door-to-Door commission reporting solution is delivering considerable time savings, increased productivity and more accessible, accurate data.
NOW Consulting has helped Spark Retail Stores save at least 20 hours per week of manual effort in generating reports, which has reduced overheads. It has also increased staff productivity, giving them more time to focus on sales and delivery activities.
The accuracy of data has also improved – and all reports are delivered straight to the business owner without any additional manipulation of Excel spreadsheets, which results in a further time-saving.
A trusted partner
Our personal approach to expertise in data warehouse solutions and analytics makes us a trusted partner to work with. Spark Retail Stores continue to value our approach of breaking down problems into bite-sized chunks, because it means that as their business evolves, their BI solutions can evolve with it, ensuring the solution delivered aligns with the businesses needs.