Search for tag: "data management"

Multiple5-minFilesCleanedAppendedRemovedDupesSummarizedCharted

This demonstration shows how to use MS Excel Power Query (with a user interface) to go from two excel files of 5 minute data, append the files, remove duplicates, filter AQS-nulled values, and…

From  ITEP Team 0 plays 0  

QC Data Sheets Pt 2-Setting up the QC Form and Data into Excel

Demonstration of establishing a free outlook.com account and setting up a form for smartphone or computer, for gathering field data that must be hand entered, such as flow rate checks, and accessing…

From  ITEP Team 1 plays 0  

QC Data Sheets Pt 1-Field QC Data on Paper and into Excel Overview

This video provides an overview of one way (free to anyone) to set up a form that can be accessed on a smartphone in the field, enabling users to type in the results of field QC checks, and then…

From  ITEP Team 2 plays 0  

Excel 6 Pivot Chart to Present Data

From  ITEP Team 2 plays 0  

Excel 5 Pivot Table for Summary Statistics

From  ITEP Team 3 plays 0  

Excel 4 Fun: Excel Map from Lat Long

From  ITEP Team 5 plays 0  

Excel 3 Use Named Ranges as Brain Savers

From  ITEP Team 2 plays 0  

Excel 2 Import Anything Using Power Query

Demonstration of the import of the same sensor data into excel as was demonstrated in the legacy import video, but this import is done using the self-documenting excel power query feature.

From  ITEP Team 4 plays 0  

Excel 1 Import Data Using Legacy Wizard

Demonstration of importing sensor minute data (follow along using the raw comma separated values .csv data file attached to this video) into an excel file using the excel legacy wizard. Legacy…

From  ITEP Team 6 plays 0  

Tribal EN Projects Deep-dive: Region 8 & 9 Tribes

(To request closed captioning or transcripts, contact [email protected] with the title and URL of the video.) This presentation reviewed the Native American Environmental Protection Coalition's…

From  ITEP Team 1 plays 0  

Tribal EN Projects Deep-dive: Yakama Nation Fisheries

(To request closed captioning or transcripts, contact [email protected] with the title and URL of the video.) This presentation reviewed the migration of an End-to-End Digital Data Management System for…

From  ITEP Team 4 plays 0  

A Conversation with EPA OMS and Tribes on the Exchange Network

(To request closed captioning or transcripts, contact [email protected] with the title and URL of the video.) This listening session provided the opportunity to ask questions about the Exchange Network…

From  ITEP Team 6 plays 0  

Roundtable Discussion: EN Grants Best Practices and Tips for Success

(To request closed captioning or transcripts, contact [email protected] with the title and URL of the video.) Panelists shared their experiences working with EN grants, whether it is grant proposals,…

From  ITEP Team 4 plays 0  

Online Capacity Building & Networking Tools for Local Communities

(To request closed captioning or transcripts, contact [email protected] with the title and URL of the video.) With the use of EPA funding, several platforms have been developed to connect tribal…

From  ITEP Team 9 plays 0  

Smarter Data Management using Excel Tools: Day 2, Part 1 FINAL

Tribal Data and Academy Workshop - Smarter Data Management using Excel Tools: Low-stress methods for assessing and manipulating any data using Excel Power Query & Pivot Tables (October 6, 2022)…

From  ITEP Team 7 plays 0  

Smarter Data Management using Excel Tools: Day 2, Part 2 FINAL

Tribal Data and Academy Workshop - Smarter Data Management using Excel Tools: Low-stress methods for assessing and manipulating any data using Excel Power Query & Pivot Tables (October 6, 2022)…

From  ITEP Team 8 plays 0