Description
This two-day course is a practical application of ACL™ Analytics, designed to make you more effective in real life situations. The course commences with a presentation of functions for harmonizing, searching and converting data to assist with issues and questions that are frequently encountered when performing data analytics. You will gain hands-on experience and real-world explanations for using these functions as your ACL™ Certified Trainer leads you through this presentation. You will then be guided through three hands-on case studies (approximately half-day duration each) which will help you develop your critical thinking skills as you cleanse dirty data, prepare for analysis, perform multiple analysis objectives and report your results. You will learn how to document your approach by effectively separating objectives into manageable milestones that will make it easier to determine which ACL command, expression or function should be used. This documented approach will provide essential support to your working papers.
What you will learn
You will learn from hands-on exercises and case studies, and from the explanations for using certain functions, commands, and expressions. Also, ways to document your approach, which provides essential support to your working papers.
Objectives
Review:
- Data Analysis Cycle
- Commands
- Filters
- Computed Fields
Functions:
- Functions Rules
- Presentation of Approximately 20 Functions in the Categories:
- Conversion
- Datetime
- Logical
- String
- Misc
- Harmonizing Data
- Converting Data
- Datetime Data
- Other Functions
Case Studies:
- Overview
- Salesperson Commission Audit
- Procurement Card Audit
- Travel and Entertainment Audit