In data analysis, it is not always easy to identify the right tool for the type of analysis. In most cases, the decision would come down to the cost of the investment. Since that’s the case, then it would imply that any tool must have some standout features to justify the price. In simple words, the question always boils down to: “What is the added value for our customers?”
Since that is a valid question, we are going to explore the 3 main differentiating features of the audit command language, which distinguish it from its competition, such as SAS, MS EXCEL, etc.
1. ACL audit command language is GUI based
Yes, it is difficult to imagine how complex operations can be performed using a GUI, but the creators of this tool have given the ability that all actions that are performed using the GUI are also captured with support scripts in the logs. As a result, the tool has a very small learning curve for both GUI operations and scripting.
See how to set up an ACL project in the video below:
See how to leverage the GUI in the ACL tool to your advantage,
2. Data can be updated directly from the source file
The second unique feature is that the tool allows us to simply update the raw data file to reflect any changes to the tables that are imported into any audit scripting language. This saves time and effort, especially if the data set is very large. It can take considerable time to re-import a large data file instead of just making minor updates to the raw file and updating the file from source. See the video demo below:
3. Work spaces
The ACL audit command language provides these truly differentiating features called “workspaces.” These act as younger siblings to the tool’s scripting functions. Basically, workspaces provide scripts with a possibility of reusability. The user can simply define the types of fields they want from certain raw tables and simply activate these workspaces in the scripts to quickly enable them at any time. See below how to use the workspace:
Apart from MS SQL Server and MS Excel, which are available in most places. Audit Command Language offers additional value for money compared to most tools available on the market for most basic types of analytical needs. The audit scripting language can be said to be a baseline for tools in the data analysis industry.