Pollution Engineering - October 2008 - (Page 36)

Advertorial Environmental Data Workflow Automation Manufacturing Environmental Data Warehouses and Decisions T otal Quality Management (TQM) has provided valuable principles for manufacturing everything from printers to satellites. EarthSoft, the company behind the most widely used environmental data management software, has applied TQM principles which enables clients to “manufacture” high quality environmental data warehouses and subsequently make informed decisions. EarthSoft achieves this by integrating the workflow of environmental samples with manufacturing very large Environmental Quality Information System (EQuIS) data warehouses that are supported in either Oracle or SQL Server. For example, one TQM principle is that the manufacturer of a widget must provide the QA/QC for said widget. The problems produced by a step in the assembly line cannot simply be passed along to the next step; QA/QC must be addressed at the point of manufacture. Passing the problems only compounds the errors and increases the costs. Yet for years, the environmental laboratories have delivered unchecked electronic data deliverables (EDDs) or worse, paper reports, as their final deliverables. This has meant the associated errors are passed along to others who use this flawed data to make decisions. EDP + Enterprise EDP = EDD Automated Workflow EarthSoft’s EQuIS Data Processor (EDP) and Enterprise EDP offer a paradigm shift with a closed loop automated workflow. This disruptive technology allows labs and consultants to check and transfer large batches of EDDs, changing the speed and quality of shared and consumed environmental data. When the EDP is used at the lab, it not only finds errors, it identifies and highlights the errors and so that they can be easily spotted and interactively corrected. Once the data are checked and fixed, the EDDs can be emailed to the consultant without errors, where they are checked again by the consultant using EDP or Enterprise EDP and loaded into the EQuIS data warehouse. If errors are found, an error log is generated and emailed back to the lab for repair and resubmission. A web dashboard can be used instead of emails. The EDDs are usually spreadsheets, since .pdf files cannot be checked for content and are mere “pictures” of the data values. Figure 1: An EDD is received and automatically processed with EQuIS workflow. The New Notices dashboard provides information about workflow processes. Workflow Automation EZView + EQuIS Environmental Information Agents (EIA) = “No-Keystroke Reporting” EQuIS Environmental Information Agents (EIAs) take workflow automation one step further. Agents are software modules that monitor data elements, such as the date or a particular data item, and then perform action(s) when the date or data trigger conditions are met. Reports are then available on the Internet/intranet/private network in the EQuIS Enterprise Dashboard, or emails can be created and automatically forwarded to a list of designated recipients (“no-keystroke reporting”). The graphics can be emailed out to Figure 2: EQuIS Information Agents select a report and wait for calendar events or watch incoming data for new data arrivals or exceedances. When the condition is met, the report automatically generates and is sent via email to the distribution list defined in the trigger. New reports are logged in the New Notices dashboard. staff, managers or clients with no additional effort or labor. Benefits of Workflow Automation and a Sample Data Warehouse Benefits of workflow automation include increase of correct data loaded, more incorrect data rejected, improved productivity of expensive engineers, increased accountability to labs, more reports and graphics on more desktops and more informed decisions. These benefits are easily measured for metric-based statistically-driven process quality improvement, another principal of a larger TQM program. (978) 369-2201 | info@earthsoft.com | www.earthsoft.com 36 Pollution Engineering OCTOBER2008 http://www.earthsoft.com http://www.earthsoft.com

Table of Contents Feed for the Digital Edition of Pollution Engineering - October 2008

Pollution Engineering - October 2008 Contents The Editor’s Desk EnviroNews PE Events Legal Lookout Green Connections Clearing the Air Water for People There’s a New Show in Town Catching Wind for Clean Water Taking the Pressure off Blower Selection Pulsed Plasma Positive Redundancy Product Focus: Municipal Water Treatment Product Focus: Monitoring Equipment PE Products Classified Marketplace Advertisers Index State Rules

Pollution Engineering - October 2008

For optimal viewing of this digital publication, please enable JavaScript and then refresh the page. If you would like to try to load the digital publication without using Flash Player detection, please click here.