Operational Plan Report

Location

Perth, Western Australia, Australia
Adelaide, South Australia, Australia

Campuses

Kewdale | Thornlie | Dianella

About AIC

AIC was founded in 1986 and has grown to become one of Western and South Australia’s most significant Islamic educational institutes. AIC has experienced numerous beneficial improvements over the years. The teachers and staff of AIC exemplify the institution’s mission of educating students in a constructive manner that fosters an understanding of the world in which we live. Their mission to establish a modernized Islamic educational institution explains why they have progressed so far since their inception.

Problem Statement

All organizations have a payroll procedure in place that provides a comprehensive set of data for each employee and the amount of hours they have worked over a specific period. AIC, as spread out as it is, has a lot of full-time and part-time employees who have a specific amount of hours to meet in a specific timeframe. They had a manual system to do this which was tedious and time consuming. 

They requested Bela Corp to help automate the process and make it not only easier but more efficient.

Our Solution

With TASS already in place at AIC, we created a Power BI report which was fed data through TASS and with the help of SQL servers. The report provides the finance team a detailed report of each employee’s worked hours against the hours assigned per week or month.

Additionally, the report helps the line managers keep overtime hours in check and makes it easier to process salaries against number of hours at end of each pay cycle. 

Platforms used

28888191[1]

TASS

Power BI

Microsoft Power BI

Automate

Microsoft Automate

microsoft_sharepoint_logo_office_icon_145722[1]

Microsoft SharePoint

Team for this Project

Maria Shamim

Project Manager

Waqas

Waqas Ahmed

Developer

New Project (46)

Abdus Sami Patel

Developer

Yasir Hussain

Yasir Hussain

QA Engineer

Related Articles