Tutorial ACL Chapter 3 – Set Up Your Project (Import Data & Verifikasi)

Chapter 3: Set Up Your Project in ACL (Import Data & Verify)

Purpose of this chapter

This chapter explains how to:

• Create a new ACL project
• Import data correctly

Because later analysis depends entirely on the imported dataset.

Create a new project

1. In ACL, go to File → New → Project
2. Enter a project name (example: ACL_tutorial_metapor)
3. ACL launches a Data Definition Wizard to guide data import.

Import data files into tables

• Each imported file becomes one table in the ACL project.

Example data files mentioned:

• Credit card metapore: employee credit card data
• April transactions: transaction records for April
• Unactable code: list of transaction codes not allowed
• Company department: list of internal departments
• Employees: employee-related data
• Acceptable code: list of permitted transaction codes

During each import, the wizard helps set:

• File format (e.g., tab-delimited)
• Data type
• Table name

Specific field type adjustments mentioned:

• For unacceptable code:
  • Use tab-delimited text
  • Use a file type like .asc
• For employees:
  • Change the date column to date
  • Change salary and bonus to numeric

Project maintenance

Remember to save periodically:

• File → Save Project

This helps avoid losing changes.

Verify and check data types

After import, validate the data to ensure fields match expected types.

Examples of correct typing rules:

• Credit card numbers should be ASCII (not numeric), since they’re not used in calculations
• Dates must be correctly formatted
• Transaction amounts should be decimal numbers

Use ACL commands:

• Data → Verify to detect formatting/type issues

If there are no errors, the dataset is ready for analysis.

Wrap-up

By the end of this chapter, you will have covered:

• Creating a new project
• Importing multiple files into tables
• Saving the project
• Verifying data integrity and type correctness

The chapter concludes that the project is ready for the analysis phase in Chapter 4.

Main speaker / source

• Tutorial presenter (instructor) delivering “Tutorial ACL Chapter 3 – Set Up Your Project (Import Data & Verifikasi)” in an ACL training video
• No specific name is given in the subtitles.