|
Background
Suruhanjaya Perkhidmatan Awam Malaysia (SPA) is a
Commission responsible for a duty which is referred
by the Federal Constitution to appoint, confirm, confer
into permanent or pension status, promote, transfer
and to exercise disciplinary control over personnel
for services covered by its jurisdiction. To achieve
these objectives, one of the Commission's Division,
that is the Examination Division, was put in charge
to conduct interviews, put candidates through exams,
in order to shortlist and appoint candidates according
to the appointment's directive.
Problem Faced and Requirements
The problems faced by SPA - Examination Division is
that their data needed for analysis was done manually
by keying in to a spreadsheet using data generated
by their IT Department. The many candidates who apply
for jobs, at the initial stage, must go through a
few stages of examinations. After such examinations,
statistical reports need to be generated for analysis
purpose. To churn out such reports, the IT Department
must first generate data from the SQL Server and these
data are given to the Examination Division. The Examination
Division then, using these data, needs to manually
create analysis reports in Excel spreadsheet format.
Other than these tedious and time consuming data and
report generation, whereby the IT Department needs
to stay and run the data overnight, these procedures
were also found to be stringent. If some reports need
to be changed, the IT needs to modify the complicated
query and re-run the whole procedure again from scratch.
The Excel reports that are prepared manually also
have its limitations. Although the spreadsheet data
can be generated, it cannot drill into detail listing.
This makes the information provided by the spreadsheet
very limited, and one needs to have other references
to make a complete judgement.
These are the reasons why SPA had assigned Speedminer
to help them simplify and speed up the tedious and
time consuming work, and at the same time able to
generate accurate computerized data for analysis purposes.
SPA also wanted to reduce the manual work to manage
such huge data, with Speedminer's help.
Achievement
All the requirements and objectives had been met and
obtained through Speedminer BI solution. All the required
data can now be obtained directly from the dashboard
by just a selection from the user to filter by search
criteria. Statistical and analytical data of candidates'
appointments by date, candidates' special examination
marks, candidates' attendance by location, specialized
candidates for special examination, to name a few,
can be displayed directly from the dashboard.
The creation of dashboard with analysis, especially
top-level analysis, has served as a decision making
tool for their Management.
It took about two weeks to complete the whole project
that includes training of the SPA staff.
Sample
Type of Analysis
1) Statistics of Recruitment Management
2) Statistics of Appointment according to Date
3) Statistics of Candidates' Special Examination's
Marks
4) Statistics of Candidates' Attendance according
to Centre
5) Statistics of Candidates' Qualification for Special
Examination
|
