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.
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.
Using data to Generate Insights Helpful to all Relevant Stakeholders - Benjamin & Joseph
The team aimed to use accounting analytics to enable Benjamin & Joseph (B&J) to gain valuable insights into its clientele’s medical bills data. These insights will empower informed provision of consultancy services to its healthcare stakeholders.
Developing a Better Process to Detect Anomalies in Trading Transactions and Identify Trends in Client Activity
Due to large voluminous transactions faced by UOBKH and the lack of efficient process in place to flag out irregularities, the team aimed to develop a better process for UOBKH to detect anomalies in trading transactions and identify trends in client’s account activity.
Strengthening Anti-Money Laundering Measures through Identifying Suspicious Transactions
The group developed a set of key variables to determine suspicious activity and additional variables in the model which may be meaningful in identifying patterns.
Extracting Data Needed to Explain Variances and Spot Meaningful Trends in Asset Reports
Creating a dashboard to support Pontiac Land in finding the data needed to explain their variances and spot meaningful trends in their asset reports. Pontiac faced the challenge of voluminous data due to its large number and variety in properties and lacked data visualisation.
