Tools for Advanced Data Visualization

Report 2 Downloads 168 Views
Excel offers some basic data visualization tools, including heat mapping based on cell values. This heat map shows dissolved oxygen levels above and below 5.0 mg/l (blue and red, respectively) at the Ben Franklin Bridge, and includes an overlay showing the coincidence of high tides based on a nearby tide gauge (green dots)

Excel

Qlik Sense

Powerful Data Manipulation Capabilities

 

Supports Large Data Sets Faster Computation Open Source Advanced Statistics Capabilities Easier Automation Free/ Licensed Available to EPA Powerful Data Visualization Tool



  

Tools for Advanced Data Visualization Abstract: Many types of environmental data are collected within the Delaware River Watershed by State, Federal, and Interstate agencies and are available free to the public. Distilling and displaying meaningful trends from larger (10,000+ data points) data sets can be challenging and require specialized knowledge to support interpretation, representation, and data processing efforts. Data visualization and data mining techniques have always played an important role in understanding temporal changes in environmental conditions and relationships between environmental parameters. Advanced visualization techniques can be used to illustrate significant trends and simplify the display of multivariate data for the lay audience. Today, the Delaware River Watershed faces significant environmental challenges, and communicators may find advanced data visualization techniques helpful in describing these issues clearly. The primary goal of this study is to introduce methods for efficient analysis and visual representation, including using R coding for enhancing capabilities to analyze large data sets and automate information updates.

RStudio

       

R coding, which can be simplified using R Studio, allows rapid analysis of large data sets, and is most useful for repeated analyses and applications requiring refreshing data through web scraping / interactive app

Qlik Sense allows interactive visualization of data sets through an interface that allows the user to change displays by selecting parameters of interest and filters simply by clicking interface buttons

Acknowledgment: This research was supported by an appointment to the Research Participation Program for the U.S. Environmental Protection Agency (EPA), administered by the Oak Ridge Institute for Science and Education(ORISE) through an interagency agreement between the U.S. Department of Energy and EPA.

DELAWARE ESTUARY SCIENCE AND ENVIRONMENTAL SUMMIT CONFERENCE (CAPE MAY, NJ 2017)





Shirin Mardani, ORISE Research Participant with EPA Region 2 & 3 [email protected] [email protected] Angela McFadden, Environmental Engineer at EPA Region 3 [email protected]