Table of Contents
Tools & Training: Data Organization
Recommended Reading: Data Organization
Tools & Training: Data Analysis
Recommended Reading: Data Analysis
Tools & Training: Data Sharing and Archiving
Recommended Reading:Data Sharing and Archiving
Data Quality and Documentation
Tools & Training: Data Quality and Documentation
Recommended Reading: Data Quality and Documentation
Tools & Training: Data Management Planning
Recommended Reading: Data Management Planning
Data Management, Analysis, and Visualization Tools
There are a number of software programs (Excel, Matlab, SPSS, SAS, Stata, Minitab, JMP, etc) that are available through Cornell Software Licensing, CISER, the Cornell Statistical Consulting Unit, and the Cornell Store, amongst other areas, often including your department.
- Resources for Data AnalysisNorthwestern University has a great guide on resources and tutorials for using various statistical packages for data analysis, including Excel, Stata, SPSS, SAS, R, Matlab, ArcGIS, NVivo, and SSCC.
- Getting Started in Data AnalysisPrinceton University Library's Data & Statistical Services department has excellent tutorials on statistics in general as well as specific software like Excel, R, Stata, and others. Also see http://www.princeton.edu/~otorres/Excel/ for Excel (and Stata or R) online training.
- Exchange (copy, import, export) data between Excel and AccessMoving data from Excel to Access or vice versa? Microsoft Office's help page show you the various ways you can do this.
- SQLShareNot sure how well this works but intriguing. "SQLShare is a database service aimed at removing the obstacles to using relational databases: installation, configuration, schema design, tuning, data ingest, and even application design. You simply upload your data and immediately start querying it."
- The R Project for Statistical Computing"R is a free software environment for statistical computing and graphics. It compiles and runs on a wide variety of UNIX platforms, Windows and MacOS." Includes download links, FAQs, manuals, etc. CISER offers an introductory workshop.
- GIS @ Mann LIbraryTutorials, software, hardware, data sources, and help available at Mann for geographic information systems (GIS).
- Atlas.tiSoftware for qualitative data analysis. CISER has it on its research nodes and offers workshops (see http://www.ciser.cornell.edu/workshops/workshop_downloads.shtml for downloadable training modules)
Related Lynda.com Data Analysis tutorials
- Relational Database FundamentalsService Unit: Lynda.com
Location: Online Training
Time: On Demand - R Statistics Essential TrainingService Unit: Lynda.com
Location: Online Training
Time: On demand - SPSS Statistics Essential TrainingService Unit: Lynda.com
Location: Online Training
Time: On demand - Up and Running with RService Unit: Lynda.com
Location: Online Training
Time: On demand - SQL for Data Reporting and AnalysisGet the data you need for analysis and reporting by writing your own SQL code. Learn how to write basic SQL queries, sort and filter data, and join results from different tables and datasets.
Data Analysis Training
- Biotechnology Resource Center"The BRC provides advanced technologies, services, training and education." They offer workshops: https://cbsu.tc.cornell.edu/workshops.aspx and consulting: https://cbsu.tc.cornell.edu/lab/office1.aspx.
- Center for Advanced Computing: On-demand TrainingWorkshops in Python, R, Hadoop, C programming, Linux, MATLAB, Fortran, MapReduce, and more!
- CISER Support"Consultants are available to help with data access, data manipulation, program logic, program syntax and de-bugging, as well as database conversions, and file transfers across computing platforms. Our policy is to help you learn to do your own computing, rather than do it for you." They also have walk-in help hours at Mann, workshops and downloadable training modules.
- Cornell Statistical Consulting UnitThe Cornell Statistical Consulting Unit offers workshops emphasize application of statistical, rather than statistical theory. Workshop topics include statistical analysis with R, logistic regression, linear regression, and multilevel modeling. The workshops are offered free of charge to members of the Cornell community, but due to limited space, registration is requested.
- Mann Library WorkshopsWorkshops in Data Management, Data Publishing and Sharing, Scientific Metadata, ArcGIS, QGIS, CartoDB
- Olin Library WorkshopsExcel, ArcGIS, and Tableau workshops
- Cornell Data Services's List of Data Analysis Service ProvidersThe Cornell Data Services's exhaustive list of Cornell units that provide help with data collection and analysis software, hardware, labs, training, and consulting.