The team was tasked to drive sales growth of Everyday Natural Fruit & Drink Pte Ltd by improving customer retention through effective tracking of buying patterns and evaluation of salesperson performance. They used RFM Analysis to rate Customer Health Score, YoY Seasonality Analysis to rate the Product Health Score, and Power BI to Forecast Sales through the Holt-Winters Additive Model.
The team aimed to develop a Power BI dashboard to provide doctor-owners in Livingstone Health the financial clarity they need to drive business discussions and spot growth. The dashboard was designed to track expenses, profit breakdown, cashflow, revenue, and red flags.
The current FairPrice Group claims management system presents opportunity for improvement. The team aimed to improve oversight and control over employee expense claims and automatically generate exception reports to flag potential anomalies. The team deployed various data analytics and AI tools for data exploration and transformation; anomalies detection analysis and investigate dashboard and statistical analysis.
The team was tasked to create an effective monthly monitoring dashboard for the FairPrice division to identify and flag high-risk claims that are non-compliant with SOPs and perform employee expenditure analysis. They focused on detecting anomalies through different tests and quantifying their financial impact, as well as identifying employees with patterns of exceeding or maximising claim limits in amount and frequency.
The team aimed to develop an interactive dashboard to track the energy performance of various industry sectors, to support the progress towards achieving Green Mark Certification. Their approach:
- Showcase clear benchmarks for different industry sectors based on Green Mark Certifications
- Highlight any anomalies or patterns
- Develop a website prototype featuring an interactive dashboard