ERT - Enterprise Risk Technologies

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 over 25 years, ERT has been leading the way in the practical application of data analytic techniques to solve the data extraction and reporting problems of some of the largest corporate and government entities in Australia and New Zealand.

Data Analytics Expertise

Are you having trouble getting at the data you need? Do you struggle to get critical databases to talk to each other? Does your IT department talk a different 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 techniques, we can assist your organisation or your clients to solve data extraction and reporting problems.

Applications

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

§ Internal Audit

§ External Audit

§ IT Audit

§ Fraud Investigations

§ Suspicious Transactions Investigations

§ Third Party Database Investigations

§ Forensic Investigations

§ Internal Controls Breaches

§ Corporate Security Breaches

Data Access and Loading

ERT can talk on a technical level with your organisation's or your client's DBA, Systems 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 file structure or a complex file structure, ERT can load the data to our analytical platform for analysis and reporting.

Data Cleansing and Translation

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

Specialised Technical Knowledge

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

Data Analytics in Action

ERT can provide:

§ On-site systems assessment

§ Review of technical documentation

§ Database and file structure analysis

§ Data access and loading options

§ Data extraction methods

§ Data cleansing and translation

§ Key creation and file relations

§ Data Matching across databases

Systems Expertise

ERT’s knowledge extends to almost all known database types and applications, including:

§ Oracle	§ Peoplesoft
§ SAP R/3	§ IBM – DB2
§ Sun	§ OS/400
§ Ingress	§ Informix
§ Sybase	§ SQL Server
§ JD Edwards	§ Finance One
§ Chris Payroll	§ Excel/Access
§ AccPac	§ Aurion

The ERT Approach

Based on your or your clients identified business requirements, ERT will work together with you or your clients and liaise with the IT Department to define an overall strategy for the effective application of our data analytic techniques.

ERT’s data analytical services provide a number of benefits to your organisation or your clients:

§ Expert multi-platform database knowledge

§ No-nonsense project management and delivery

§ Accounting, Business and IT expertise

§ Low cost, efficient implementation

With our extensive knowledge of database design, data storage and data analytical techniques, we can assist you or your clients to solve data extraction and reporting problems.