Tutorial ACL Chapter 2 – Analisis Data Karyawan

Summary (Technology/ACL Tutorial Concepts)

This video is a tutorial (Chapter 2) on using ACL Desktop to analyze employee/HR data. It follows an ACL usage tutorial guidebook with step-by-step procedures.

1) Setup: Download/Open ACL Desktop & Load Data

• Download and use ACL Desktop (the application is already installed by the presenter).
• Open an employee data project via:
  • File → Open Project
  • Select the dataset (e.g., Metapor employee data).
• Data structure:
  • Two tables appear in the project navigator:
    • agent_metapor: sales agents
    • employ_list: head office employees

2) Basic Data Overview / Counts and Statistics

• Use the Analyze command to compute record counts:
  • Count results: 41 agents and 200 employees
• Use Statistics to summarize key fields (examples mentioned):
  • recruitment date, salary, bonus
• Use Profile to show distributions in a more concise view.

3) Data Quality Check: Duplicate Detection

• Perform duplicate checks using Analyze → Duplicates:
  • First check duplicates by last name
  • Then repeat for employee number
• Result:
  • No duplicate employee numbers were found.

4) Salary & Bonus Analysis

• Total bonus in the year 2002:
  • Use Analyze → Total (total field)
  • Select the 2002 bonus column
  • Result: Total bonus = R1,16,483.76
• Sorting salaries:
  • Use Quick Sort by right-clicking the salary column
  • Choose sorting options:
    • highest to lowest (descending)
    • lowest to highest (ascending)

5) Recruitment Counts by Year (Filtering)

• Determine how many employees were recruited in 2002:
  • Apply a filter on the recruitment date field (hairiet) using:
    • between Jan 1, 2002 and Dec 31, 2002
  • Then use Count Records
• Result:
  • 17 new employees in 2002

6) Derived Metric: Bonus as Percentage of Salary

• Create a computed field:
  • Name: bonus_%_saly
• Formula concept:
  • bonus_2002 * 100 / salary
• Bracket/format note mentioned:
  • values between opening and closing brackets (as part of the expression entry)
• Outcome:
  • Enables comparison of bonuses vs salaries per employee.

Main Speakers/Sources

• Speaker: Febriliana Pradin Swara Nindia Distianti (Roll number 11, AM4A, Semarang State Polytechnic)
• Source material referenced: ACL usage tutorial guidebook (specifically Chapter 2 on employee data analysis)