2023 Data Analyst Training

Field to Market

Welcome

The level of complexity of agricultural sustainability project data is steadily increasing. Field to Market’s 2023 Data Analyst Training will prepare our members to credibly uncover trends in sustainability outcomes measured in the Fieldprint® Platform as part of a Fieldprint Project. As a result of attending this two-day training, participants will be able to:

  • Understand the Fieldprint Platform sustainability metrics and their methodology

  • Export data from the Fieldprint Platform

  • Perform data quality analyses to increase confidence in the measured outcomes

  • Summarize the metric outcomes, create baselines, and measure progress toward project goals

Is this workshop for me?

This workshop is for you if you:

  • are interested in sustainability measurement

  • have experience with data analysis with tools like R or Excel

  • have had some exposure to basic statistical concepts such as linear models, etc.

First Day

📆 October 10, 2023

⏰ 14:00-16:00 Eastern

💻 Zoom meeting

Time Module Resources and Tasks
Before first day Preparation
14:00 Welcome Slides
14:10

Field to Market Overview

Demonstrating progress towards sustainability

Read about FTM history

Fieldprint Platform

Projects

14:30 Metrics Overview

Sustainability Metrics

Slides

14:50 —– Break —–
15:00 Walk through Fieldprint Calculator Slides
Putting data into the tool

Data Collection Checklist

Which metrics use which data?

Getting results out

Example Comprehensive Data Output File

Data Dictionary

15:20 Checking data quality Shiny app for quality assurance
3:50 PM Wrap Up

Homework (coming)

Book an office hour with Austin

Book an office half-hour with Austin

Second Day

📆 October 17, 2023

⏰ 14:00-16:00

💻 Zoom meeting

Date & Time Topic Resources and Tasks
14:00

Summarizing project data

Project Benchmarks

Slides
14:50 —– Break —–
15:00

Asking more questions

Comparing to NASS Quick Stats

National Agricultural Statistics Service - Quick Stats

rnassqs package

15:50 Wrap Up
16:00 Office Hours

Preparation

For those unfamiliar with the Fieldprint Platform, please visit and explore the Calculator.

For those interested in Fieldprint data analysis with R, please join the workshop with a computer that has the following installed (all available for free):

  • A recent version of R, available at https://cran.r-project.org/

  • A recent version of RStudio Desktop (RStudio Desktop Open Source License, at least v2023.03, available at https://posit.co/download/

  • The following R packages, which you can install from the R console:

# Install the packages for the workshop
# List as of Oct 17
pkgs <- c("pak", "tidyverse", "janitor", "readxl", "skimr",
          "rnassqs") 

install.packages(pkgs)

pak::pkg_install("Field-to-Market/fieldprintr")

If you’re a Windows user and encounter an error message during installation noting a missing Rtools installation, install Rtools using the installer linked here.