Water Data Training & Resources
Don’t forget to check out the Water Data Events webpage for more informal training opportunities, such as seminars, webinars and workshops!
Course Catalog
Coming soon!
Data Tool Kit
Regardless of how you interact with data, we know how important it is to have access to resources to enable self-directed learning so individuals can learn new data concepts and skills at their own pace. This Data Tool Kit (Tool Kit) is a collection of resources for all Water Boards staff and partners on all things data. Readers at any stage of their data journey will be able to utilize different aspects of this Tool Kit, depending on their needs. Each Handbook provided below will begin with a general explanation of the concepts that will be covered in the Handbook and, as appropriate, will be followed by more detailed guidance on how to apply the concepts to real situations.
This Tool Kit was developed to begin to address data literacy related needs identified in the Water Boards Strategic Data Action Plan, Data Literacy Strategy, and the results of the 2019 Water Boards Data Use and Skills Survey. This Tool Kit is a living resource that will be revised and adapted as the Water Boards data sets, available tools, and related programmatic needs evolve.
If you are interested in volunteering to provide support to Water Boards staff in one of the areas listed below, please let us know by filling out this Data Science Support Offers Survey! When support is requested by Water Boards staff or teams that matches your offer, we will connect you with the individual or team that could use your support.
If you have suggestions for improvement or regarding what should be included in future updates, please let us know by taking our Water Board Data Tool Kit Feedback Survey.
Stay Informed
Subscribe to the CoWI email list!
Check your email account for a confirmation email to complete your subscription.
Openscapes
College of Water Informatics (CoWI)
Water Data Training | Data Tool Kit
Water Data Digest
Water Data Events
Water Data Communities
Free Resources
Data Science
- 2019 Community Water Science - Data Science Skills Workshop Video
- The 9 Best Free Online Big Data and Data Science Courses
- Coursera Data Science Courses
- edX Data Science Courses
- European Data Portal’s eLearning Programme
- School of Data Handbook
- Principles and Techniques of Data Science (Free online textbook)
- Data Science & Machine Learning Tutorials
- Snowflake Cloud Data Principals eBooks
Programming Languages
R and R Shiny
- R for Water Resources Data Science - Introductory Course Materials
- R for Water Resources Data Science - Intermediate Course Materials
- A Succinct Intro to R
- R for Excel Users
- Introduction to Programming in R YouTube Video (2 hours), Kevin Kane for School of Data LA 2019
- Reproducible Research in R + Shiny YouTube Video (1 hour), Lauren Steely, MWD, Robert Mitchell, Skid Row Housing Trust for School of Data LA 2019
- R for Data Science book and tutorial by Garrett Grolemund and Hadley Wickham
- Programming with R tutorial
- Data Analysis with R course
- RStudio Education
- From the maintainers of R, three pathways for beginner, intermediate, and expert listing different tools (webinars, free books, tutorials) for each pathway.
- R Studio Webinars
- RStudio Cloud Primers
- Interactive tutorials on The Basics, Work with Data, Visualize Data, Tidy your Data, Iterate, Write Function, and more to come.
- RStudio Cheatsheets
- Data Flair R Tutorials
- Geospatial Data Curriculum from Data Carpentry
- Mapping in R Tutorials
- An Introduction to reshape2
- reshape2 is an R package written by Hadley Wickham that makes it easy to transform data between wide and long data structures. See the Data Management Handbook, Collect and Process Section for more information on wide and long data structures.
- R Shiny tutorial
- Are you ready for Shiny? Quiz
- Seven written tutorials covering the basics; 32 video tutorials covering more advanced material
Python
- Data Flair Python Tutorials
- Introduction to Git and Python (GitHub page)
- Introduction to Data Analysis in Python (GitHub page)
- Text Analysis (GitHub page)
- Automate the Boring Stuff with Python
- Free online book written for non/new programmers
- Data Analysis: Intro Python Tutorial
- Working with Geospatial Data: Basics in Python Tutorial, City of Los Angeles
- Chris Albion’s Python Tutorials (and more data science and machine learning resources!)
Jupyter Notebook
SQL (Structured Query Language)
General Programming Resources
Microsoft Excel
- Intro to Excel
- Intermediate Excel
- Excel Shortcuts
- Excel Best Practices
- Data Carpentry Data Organization in Spreadsheets for Ecologists
- edX Microsoft Excel for the Data Analyst
- Excel YouTube Tutorials (Technology for Teachers and Students Channel)
- Excel YouTube Tutorials (Excel Campus Channel)
- Excel Help & Learning from Microsoft
