 |
The Client |
 |
- Our client provides Market Research services to large blue chip retailers around Australia and New Zealand
- Their major clients in Australia include Coles, Myer, Bankwest and Westpac.
|
The Problem |
|
Labour intensive generation of over 10,000 reports
- Information Delivery department typically generate, print and post around 10,000 reports to their clients every month.
- Reporting process managed by a team of 30 people.
- Highly labour intensive process to update and format reports using Microsoft Excel.
- Data validation and data integrity issues that introduced significant re-work and delays
- Impact on confidence in the reporting process.
|
The Solution
|
|
Streamlined, automated data consolidation and self-serve reporting
- Data warehouse and individual Data Mart for major clients - integration of the Business Intelligence Portal for web delivery of reports
- New front end using a stable, robust and customisable survey collection Engine.
|
The Value |
|
Efficient, Automatic, Scalable solution
- Monthly report generation more efficient - two staff members, significantly reducing cost
- 7,000 end users have access to analytical reports with powerful drill through capabilities
- Full automation of the entire data gathering and consolidation phase with in-built data validations checks monitoring data quality
- Major reduction in the number of data issues that delay the delivery of reports
- Tech savvy end user can create ad hoc reports from the consolidated data warehouse
- Major reduction in carbon footprint as reports are now delivered by web or email