ACL%20Training%20Materials

1
ACL Training Materials
Unit C Analysing data characteristics ????????
KPMG ACL?????? PriceWaterHouseCooper
ACL??????
2
Situations when we would use data analysis

• ACL commands that allow us to perform data
  analysis
• Data validity commands
• Analysis of numeric fields and values
• Analysis of non-numeric fields and values.

3
Analysing data characteristics

• Numeric fields

4
Analysing data characteristics (??)

• Count
• Total
• Statistics
• Profile
• Stratify

5
Count

• Count - counts the number of records that meet
  the specified condition

6
Total

• See if you can derive the total value of the
  invoices (ie voucher type IN) that were billed
  before 1997
• ?????????

7
Total
8
Total
PricewaterhouseCoopers
9
Statistics and Profile (????)

• Statistics - returns a statistical summary of one
  or more numeric fields
• Profile - returns similar but slightly less
  detailed information
• Run the statistics command on the value field.

10
Statistics and Profile (????)
Total value of receivables 468,880.69 Average
value 865.81 Positive values 609 records with
value of 527,277.55 Negative values (probably
credit notes) 161 records with value
of (58,396.86)
11
Stratify (????)
?????????????????
??????Min? ? ?Max? ,???????, ?Interval? ????10
,????Free? ??????? ?
12
Stratify (????)

13
Workshop C1

• ??ap_trans
• ??Analyze/Stratify
• ????Statistic?Min?Max?????
• ??InvoiceAmount ??10,000????????
• ??0,1000,3000,5000,7000???

14
Workshop C2

• ??
• ????????,??????????,?????????,????????????????????
  ??(Inventory.fil)
• 0.00 to 9.99 10.00 to 49.99 50.00 to
  99.99100.00 to 599.99
• ?????????????????

15
Analysing data characteristics

• Non-numeric fields

PwC
16
Analysing data characteristics (???)

• Classify
• Age
• Summarise

17
Analysing data characteristics

• Using these commands we could
• Group data into subsets and return relevant
  totals for these subsets
• --gt Group data in a payroll file into departments
  and return the total payroll value for each
  department
• Perform ageing of records with date fields
• --gt Age a receivables file by intervals of 30
  days to determine bad and doubtful debts.

18
Classify

• ????????????????,??????????????
• ???????????????(??????)

19
Classify

20
Age

• Performs ageing of records based upon a selected
  date field
• ?????Cut - Off ???,??????

21
Age

22
Summarize

• ?????????
• ??????,????String ????,????

23
Summarize

• Summarise
• The order that the Summarise On fields are
  selected is very important

24
Summarize

25
Workshop C3

• ?????????????????,??,??MIS??????????????(AR.fil)?
  ???????????????? Invoice IN
  Payment PM Credit Notes CN
  Transfer TR
• ??
• ?????????????????????????????,???????????????????
  ???????