Intertek ASG Laboratory > Informatics and Computational Chemistry > Informatics > Data Automation

Informatics: Data Automation

The Intertek ASG Informatics Group has significant experience in many areas of Data Automation including macros, scripting, standalone application design and implementation, database stored procedures, workflow management and data pipelining. Each of these techniques can be applied to both scientific and non-scientific data to enhance data throughput, ensure greater data consistency, simplify repetitive tasks and increase user productivity.

Specific Data Automation offerings include:

• Excel Macros - simplification of repetitive tasks, data validation, complete Excel customisation
• Standalone Applications - file format conversion, data aggregation, database upload
• Database Applications - calculated fields, string processing, complex pivoting
• Workflow Management - data pipelining, reusable protocols

Intertek Data Automation Services

Data Automation processes are equally applicable to scientific and non-scientific data and the same procedures can be applied to analytical, financial, HR, textual or even weblog data. Within the group, we have specific additional expertise in dealing with specialised data types including molecular, spectroscopic, elemental and colour.

The Intertek Informatics Group offerings range from one-off single dataset processing to complete system design and implementation. We can also provide consultancy services enabling customers to benefit from our significant expertise and knowledge.

Case Studies:

• Data Validation in Microsoft Excel
• Formulation Data Collection in Microsoft Excel

asg.nwtc@intertek.com

+44 (0) 161 721 5247

Call Us using Skype

• Data Automation Case Study: Data Validation in Microsoft Excel

• Data Automation Case Study: Formulation Data Collection in Microsoft Excel

• Excel for Scientists Course