The Business Analytics Programming

Business Analytics Programming

Table of Contents
1. Introduction............................................................................................................................1
1.1 Background related to Business Issues.........................................................................1
1.2 Literature Review............................................................................................................1
1.3 Objectives of the VBA Algorithm..................................................................................2
2. VBA Impacts...........................................................................................................................2
3. Users Operational Manual....................................................................................................4
4. Technical Documentation....................................................................................................12
5. Conclusion.............................................................................................................................13
References.....................................................................................................................................14
Appendix.......................................................................................................................................15

1. Introduction
The main objective of this project is to create VBA application which is used to help
automate an organizational process. The purpose of this application is to automate and secure the
employees’ personal information in an organization.
A VBA application is developed with the help of the VBA algorithm and all the necessary
functionalities will be completed by creation and updating of an employee management database
for the ABC Company.
1.1 Background related to Business Issues
In this project, the business scenario revolves around the ABC Company, which needs an
effective VB application for employee management system, because at present this company
lacks an employee management application, due to which the manual way of managing the
employee like employee records and information is followed. Thus, the existing management on
keeping the employee information and records takes place manually by hand-written records on
paper/books. Employee information is not always trustworthy because it is handwritten and
might have the possibility of human error, for instance, the data duplication problems can take
place, and the managers cannot determine the required information. During manual filling, there
is also a possibility of data misplacement. Therefore, it is important to create an employment
management application for this company to ease its management operations.
1.2 Literature Review
As per (Bagade, Shende and Sambre, 2016), the research paper aims to manage the
database of the Municipal corporations. This researchers presents the usage of how the employee
Information Management System supports to maintain the information of employees. It can
facilitate by keeping the employee information up-to-date. It ensure accuracy of the information
to be stored. Additionally, the employee information system comprises of all types of details like,
personal information of employees, service associated records, leave records, salary statements,
maintenance of attendance records etc. The researches says that it benefits by helping to easily
track all the required employees’ details from the joining date till the end of their service.
1

1.3 Objectives of the VBA Algorithm
The objective of the VBA algorithm is used to automate the ABC company process. As,
instead of employee management applications, the company uses manual record
keeping methods to store employee records. Employment management represents the power of a
company, as employees are considered as the company’s strength, the manual record keeping can
impact the effectiveness of the company’s business processes. It can even impact business
growth. Thus, the employee management system is essential for ABC. The following aspects are
included for the VBA application:
 Graphical user interface on Microsoft Excel
 Demonstrate the programming skills which includes the Array, VBA objects like
User forms, variables, data types, conditional structure, loops, procedures,
function etc.
 Also demonstrate clear understanding of programming usability, readability and
correctness.
2. VBA Impacts
Basically, the employees are an organization’s strength and help to improve it. The
application/system of employee management consists of crucial work associated and significant
personal information of the employees. The purposed employment application is used to ensure
that the following are met (Bhargav, 2019):
 Improve the efficiency of workforce management - The purposed application is used
to monitor and manage the employee information, and it can quickly spiral into the
administrative quagmire. If managers track the employee data manually, it only raises the
likelihood of human errors and it makes the business vulnerable to regulatory and legal
risks. So, the application is used to spiral view the employee data, and it does not create
business vulnerability. It makes the employee information work for the business and not
against it.
 Employee engagement - This system increases employee engagement, and it is a
valuable asset for business. It can realize its full potential, then it creates a perfect
environment in which management continuously engages with the employee. It is a
2

powerful organizer of employee and employee conversation. To create a platform for
tracking and evaluating employee development, the manager partners with workers in the
development, motivation and goal setting of a viable career path. Therefore, it improves
worker maintenance.
 HR data metrics and Analytics - Basically, the system of employee management is
used to capture, store and organize the information of employment in a conventional
electronic form, but it is not fully exploited if the data collected cannot be analyzed for
the invaluable insights which can help resolve the deep and hidden business challenges.
The trends and metrics have created the root cause of company improvement. Therefore,
the application of employee management is useful for HR staff for time consuming
administrative tasks, and it can concentrate on business innovation to the next level.
 Mitigate the risk compliance - This application also ensures risk compliance. Generally,
the employers have regulatory and legal obligations to employee and employee
information. Compliance can be a problem with companies constantly trying to keep
tracking the new rules that apply to their company. Thus, the employee management
system created it easier for business to capture, repot, analyze, and document the
employee information.
 Reduce the paperwork–The purposed solution reduces paper work, as the existing
system of book keeping to record the employee information requires manual efforts. In
such case, the employee information recorded is not always trustworthy because it is
hand written and might have human error. Therefore, a new application is created which
does not require any paper work.
 Securing the employee Information–In existing system, the employee information and
records are stored manually and documented. Therefore, the information is not always
trusted due to possibility of human mistakes. The paper documents can be misplaced and
have data duplication, therefore, the purposed application secures the employee
information. The company contains sensitive information about their employee like their
personal details, and unauthorized person handles the remuneration of the employee
records, driving license numbers, phone numbers, social security numbers, dependent and
spouse details, and also handles the bank accounts, which is dangerous. Hence, the access
3

control is centralized, where the users are assigned privileges based on their
responsibilities.
The purposed employee management application is even used to ensure the greater
understanding of the ABC Company by designing and analyzing the database suitable for the
company. The purposed database is used to store the employee personal information.
Additionally, it improves the skills and managerial work for the managers to record employee
information.
3. Users Operational Manual
The user manual for employee management application is presented below (Larsen,
2017).
First, open Excel sheet, and create homepage, database page and print page for the proposed
application. The below screenshots demonstrates the creation of these pages.
The home page contains two buttons such as employee details, and close. The employee
details button is used to open the employee management application, and close button is used to
close the program.
4