Transcript How To Manage Your Data

WAWGG Conference
Feb 4, 2009
How To Manage Your Data
Why data management is like…
Jordan Ferrier
Hogue Cellars
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.”
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
Data managed for internal use
• Financial management
• Operations management
– Efficiency and yield
– Inventory management
– Capacity and equipment
– Personnel
– Quality control
Neural Network Model
Wine Industry Isn’t There YET
• Our issue is data management
• Data mining requires good data sets
– Garbage in = Garbage out
– Consistent qualitative information
Good Data Management
ORGANIZES INFORMATION
• For easy sorting and filtering
• Easy aggregation of results
– means, min, max,…
• Easy referencing and recombination
• Easy communication, export, sharing
Computers Make it Easy
• Modern computers are FAST and CHEAP
• Software widely available
– Spreadsheet (MS Excel)
– Database (Access, SQL, MySQL)
– Commercial Software
Our Session
•
•
•
•
Eric Wylie – Field data collection at SMWE
Jenn Smithyman – GIS at SMWE
Wayne Worby – 4Qtrs database
Me again – Winery Perspective