The Accounting Analytics Capstone course is a compulsory capstone course for undergraduate students pursuing a 2nd Major in Accounting Data & Analytics. We showcase their completed projects below.
Expanding Lee Wee & Brother’s Market Footprint
The team employed several sophisticated techniques such as the Association Rules model, RFM model, and Geographical Map analysis to achieve a nuanced understanding of customer purchasing patterns and potential markets for expansion. This drove targeted strategies to help LWB further grow & gain a competitive advantage in the market.
Leveraging Data for the Identification and Analysis of LWB’s Key Target Audience and its Characteristics to Refine Business Strategies
The team was tasked to support Lee Wee & Brothers (LWB) in leveraging on relevant data for the identification and analysis of LWB’s key target audience and its characteristics to refine business strategies and better cater to customer preferences and needs.
Expense Claim Anomalies Detection
The team employed rigorous analysis and advanced methodologies to detect anomalies within Grab's employees' expense claims data, identifying irregularities that may pose risks to the company's financial integrity.
Optimising Pricing Strategy and Improving Market Competitiveness
The team was tasked to find out how Fong Lee Metal could better price their quotations to increase the likelihood of closing a deal while improving lead time, thereby optimising their pricing strategy and improving their market competitiveness.
Enhancing Operational Efficiency of FairPrice Online
The team utilised process mining tools to create a graphical representation of FPOnline's order-to-cash process. The output map allows them to compare the actual process to FPOnline's SOP for risk compliance, identifying bottlenecks and inefficiencies.
Identifying Potential Deviations and Opportunities for FairPrice Trading
The team was tasked to identify potential deviations, hidden bottlenecks and opportunities for FairPrice Trading’s order-to-cash (O2C) process through process mining algorithms.
Analysing Sales & Purchases to Better Understand Customers and Suppliers using Data Analyticsnable insights.
The team aimed to analyse past warehouse and transport sales and purchases to help GKE develop a model to forecast the following month’s total Sales and Purchases.
Increasing Sales in Transport and Warehousing Segments through Data Analytics
The team aimed to 1) use data analysis on historical sales to analyse trends for both warehouse, transport and individual customers; 2) develop a predictive model to forecast future overall sales for transport and warehouse, as well as for the top 10 customers each; 3) identify down periods and offer solutions to GKE to increase sales and 4) create dashboards to provide a visual analysis of data.
Developing a Price Visualisation Data Exploration Model to Empower Medical Bill Auditors
The team found that Benjamin & Joseph has abundant data but lacks a defined strategy for deriving valuable insights. They aimed to develop a price visualisation Data Exploration
model to empower medical bill auditors in the auditing process and facilitate informed decision-making.