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.
-
BI dashboard for Financial / operational analytics and reporting features such as across Profit & Loss & Balance sheet Variance (daily/monthly/quarterly/yearly) analysis by location outlet, product segments etc.
-
Top cost drivers by category & vendors, GST analysis etc
-
Charting and Time series of performance parameters.
-
Exporting Reports to PDF/Excel
-
REST API based Integration of timesheet and rostering data from Deputy and ledger data from Xero.
Key Technologies: Xero, MySQL, Bootstrap/AngularJS, Deputy & AWS services.