ACL™ Analytics
The data analytics pioneer. The ACL™ Analytics desktop software has been helping users analyse large data volumes for over 20 years.
ACL Analytics is now a part of the new software ACL Robotics!
ACL™ Analytics – Overview
The top performer among data analytics tools combines table calculation and database features. You can input different data formats (PDF, Excel™ SAP® data) and perform analyses using predefined special functions. Large data volumes are not an issue; a logging functionality ensures your steps always remain traceable. An integrated macro language for programming apps, interfaces to R, Python and Tableau™ and visualisations complete the solution.
Analytics functionalities for experts
More than 100 specific data analytics features. Filtering, compression or matching of data records, duplicate searches or Benford analyses – ACL™ offers you all this and more at the touch of a button.
The best of two worlds
ACL™ Analytics uniquely combines the strengths of table calculation applications such as Microsoft Excel™ and database applications such as Microsoft SQL™ Server and enriches them with analytics components.
Extensive function library
ACL™ Analytics uniquely combines the strengths of table calculation applications such as Microsoft Excel™ and database applications such as Microsoft SQL™ Server and enriches them with analytics components.
Go Predictive, go Fuzzy
Exact would be just too simple. Do you need fuzzy duplicate searches or phonetic comparisons? Or do you need to include R or Python in order to incorporate predictive analytics aspects? Consider it done.
Fuzzy Duplicates
Many duplicates are the result of typos. You can identify Meyer and Meier as a potential duplicate by using unequal character comparisons. Here, ACL™ offers easy-to-use functions for phonetic similarities, Levenshtein distance or other algorithms.
Inclusion of R or Python
Nothing now stands in the way of predictive analytics. In ACL™ Analytics, you can call up R or Python program code and use the return values in your analyses.
Data import made easy
Without data, even the best analytics tool is useless. Effortlessly import countless data formats in ACL™ Analytics. An easy-to-use import assistant supports you during data import.
Other import formats. In addition to the general ODBC interface, ACL™ Analytics also offers predefined connectors for many data sources:
Microsoft Excel™
Microsoft Access™
CSV
ODBC Quelle
MongoDB
MS SQL Server™
Oracle™
Paradox
dBASE™
FoxPro
PostgreSQL
Vordefinierte Konnektoren. Nicht nur auf Dateibasis bietet ACL™ AN vielfältige Zugriffsmöglichkeiten. Auch für viele wichtige Dienste sind Verbindungen verfügbar:
Drill
Cassandra
DynamoDB
Amazon Redshift
Hive
HBase
Impala
Google BigQuery
TeraData
Spark
Oracle
SalesForce
What else?
ACL™ offers everything you need for data analytics. Ein starkes Entwicklerteam bei ACL™ kümmert sich um die kontinuierliche Verbesserung des Produkts. Das zeigt sich an vielen weiteren durchdachten Funktionalitäten.
Security:
Read only
ACL™ only performs read accesses on your data. So even with complex analyses, it is protected against overwriting or unintentional changes.
Transparency:
Logfile
If you want, ACL™ can record all your steps in a personal log file. Allowing you to track and document results at any time.
Efficiency:
Macro language
With increasingly less time available for manual work, use the built-in macro language to effortlessly create your own automated apps.
Performance:
Top
Keine Angst vor großen Daten! Auch bei großen Datenmengen ist ACL™ unglaublich performant – auch bei handelsüblicher Hardware.
Apps:
Part of the plan
Are you the specialist who designs the analyses? Make them available to your colleagues as simple, user-friendly apps.
Future:
Proof
Rely on longevity: At ACL™, over 80 developers work on constantly developing the software to ensure it always keeps pace with the times.
ACL™ Analytics versus Office tools
Don't get us wrong: table calculations such as Microsoft Excel™ are great tools for everyday use. However, if you want to establish structured data analytics within your company, we highly recommend the use of specialist software such as ACL™ Analytics. Not just because of the data volumes to be analysed, but also in the interests of standardisation and ensuring sustainability for your analytics work.
Interested?
We will be happy to show you in detail just how powerful ACL™ Analytics can be in the hands of experienced users. Please contact us for further information, a web demo or a personal meeting. We will get back to you immediately.