Data Analytics 

 Assisting you to get the data you need in a readable and useable format

Data analytics is the development of tactical solutions to access, load, analyse, cleanse and translate data into a form that facilitates reporting or investigative activities.

For a number of years, ERT has been specialising in the practical application of data analytical methods to solve business problems for some of the biggest corporate and government entities in Australia and New Zealand.

DATA ANALYTICS

Are you having trouble getting the data you need ? Do you struggle to get critical databases to talk to each other ? Does you IT department talk another language ? Do you have a complex reporting requirement that you just can’t resolve ? ERT may have the solution.

With our extensive knowledge of database design, data storage and data analytical methods, we can assist your organisation to solve its data mining and reporting problems.

Applications

In the past, ERT has applied its data analytical capabilities to meet a myriad of business objectives, such as:

• Internal/IT Audit
• Fraud Investigations
• Suspicious Transactions Analysis
• Corporate Credit Card Investigation
• Data matching across databases
• Third party database investigation
• Ledger Reconstruction
• Forensic Accounting
• Internal Control Breaches
• System Control Breaches

COMPONENTS

Data Access and Loading

ERT has experts who can talk on a technical level with your DBA, System Administrator, IT Manager or outsourced IT providers, to ensure you get access to the data you need in a readable and useable format.
Whether the data is accessible in a simple data format (eg: flat file, ODBC compliant), or a complex file structure (eg: multiple record variable length file), ERT has skilled technicians that can load the data to our analytical platform for analysis and reporting.

Data Cleansing and Translation

If you have a need to analyse report files, log files and other non-standard file structures, ERT can cleanse and translate these files types into flat files for further processing and analysis, quarantining invalid data for special treatment.

Data Analysis

ERT can apply advanced programming code and specialised technical knowledge to whatever task is required. We will work with you to specify the required analytical outcomes, and we’ll find the most efficient way to achieve them.

For more information on Data Analytics contact us at info@ert.net.au