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.
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.
Automating the Visualisation & Presentation of Asset Review Data for Millenia Singapore Cluster
The team was tasked to automate the visualisation & presentation of asset review data for
Millenia Singapore Cluster (specifically Millenia Tower). This includes identifying variances between budgeted and actual figures, and trend analysis.
Addressing Challenges of Pontiac’s Reporting Process which Relies on Manual Integration of Excel Tables and Charts
The team identified the following challenges in the reporting process and proposed measures to address them
1) Manual Reporting Process:
It is time-consuming, prone to errors, lacks real-time updates, and is difficult to identify variances and anomalies.
2) Lack of Interactivity in Reporting Deck:
The absence of interactive features hinders in-depth analysis and comparison between data sets.
Improve the Timeliness and Readability of the Pontiac Team’s Monthly Reporting
The group aims to improve the timeliness and readability of the Pontiac team’s monthly reporting of its consolidated Singapore-based hotel figures, using data preparation and
visualisation software to automate the process.
Optimize Profits by Prioritizing Most Profitable Target Customers and Event Types
The team made use of accounting analytics to allow UP to gain valuable insights into the revenue and profitability for each customer and type of event. The insights will empower informed decision-making by the management.