Business Intelligence Solution – Retail

The client business consisted of retail outlets with full time and casual staff across 15 outlets.

They had an urgent need to simplify and automate the consolidation and reporting of financial and operational metrics. In addition to that employee attendance, rostering information and POS information was needed to be integrated with the accounting & payroll solution.

Developing the right solution helped

1) Reducing 0.5 FTE of manual effort of staff

2) Providing same day/real-time information on revenue, expenses as well on staff attendance and rostering

3) Avoiding compliance issues in managing pay rates, penalties, and superannuation.

4) Having transparency in decision making on service and product choices to drive revenue growth while keeping a tight leash on costs across heads.

Key Technologies: Xero, MySQL, Bootstrap/AngularJS, Deputy & AWS services.