How To Manage Your Data Why data management is like

1
How To Manage Your DataWhy data management is
like
WAWGG Conference Feb 4, 2009

• Jordan Ferrier
• Hogue Cellars

2
Why Manage Data?

• To measure is to know.
• If you can not measure it, you can not improve
  it.

Lord Kelvin great physicist and mathematician of
19th Century ALSO Heavier-than-air flying
machines are impossible.
3
Data is managed for others

• Governmental agencies
• TTB / LCB for the winery (and source)
• State pesticide and Ag reporting
• FDA and DHS coming soon
• Winery and Vineyard relations
• Organic / Biodynamic / Sustainable

4
Data managed for internal use

• Financial management
• Operations management
• Efficiency and yield
• Inventory management
• Capacity and equipment
• Personnel
• Quality control

5
Neural Network Model
6
Wine Industry Isnt There YET

• Our issue is data management
• Data mining requires good data sets
• Garbage in Garbage out
• Consistent qualitative information

7
Good Data ManagementORGANIZES INFORMATION

• For easy sorting and filtering
• Easy aggregation of results
• means, min, max,
• Easy referencing and recombination
• Easy communication, export, sharing

8
Computers Make it Easy

• Modern computers are FAST and CHEAP
• Software widely available
• Spreadsheet (MS Excel)
• Database (Access, SQL, MySQL)
• Commercial Software

9
Our Session

• Eric Wylie Field data collection at SMWE
• Jenn Smithyman GIS at SMWE
• Wayne Worby 4Qtrs database
• Me again Winery Perspective