Data Science for Water Professionals (The Course)
Data Science for Water Professionals
Learn how to solve water problems with the R language
Course Info
This course includes 1 attempt.
The term 'digital water utility' has become a popular buzzword in the industry. A digital utility can only exist when the people that manage the water improve their skills. This workshop introduces participants to the principles of data science and analysing data using the R language for statistical computing.
Participants will learn about the principles of data science and the basics of using the R language. This course focuses on providing a broad introduction to creating value from data. The objective of this course is to inspire water professionals to apply data science principles in their analysis and use computer code to solve problems.
Principles of Water Utility Data Science
The first session introduces a framework for best practice in analysing data and sharing the results. This framework derives from the book Principles of Strategic Data Science. The case studies each implement aspects of this framework.
Introduction to the R Language
The second session introduces the basic principles of the R language and applies these principles to compute the flow in an open water supply channel. The remainder of the course follows two case studies.
Case Study 1: Water Quality Regulations
In this first case study, participants apply their skills to laboratory testing data from an imaginary drinking water network. The case study revolves around checking the data for compliance with water quality regulations. Participants will analyse and visualise the data and create an automated PowerPoint presentation based on the data.
Case Study 2: Understanding Customer Perception
The data for the second case study consists of the results of a survey of American consumers about their perception of tap water services. Participants use the Tidyverse to clean, transform and visualise this data. The case study ends with participants creating a MS Word report to communicate the results of analysis.
Share
Course Material
- 1. Data Science for Water Professionals
- Learning Objectives
- Prerequisites
- Case Study approach
- Participant Activities
- 2. Principles of Water Utility Data Science
- What is data science?
- The Elements of Data Science
- The Water-Data Value Chain: The Digital Water Utility
- Data Science Tools
- Good Data Science
- Best-Practice Data Science with R
- 3. Introduction to the R Language
- The R Language
- Basic principles of a programming language
- Using R and RStudio
- Basics of the R language
- RStudio scripts and projects
- Quiz 1: Calculating channel flows
- 4. Exploring Data with the Tidyverse Packages
- R Libraries
- Introducing the Tidyverse
- Case Study 1
- Exploring the Case Study Data
- Explore the data
- Quiz 2: Exploring Water Quality Data
- 5. Descriptive Statistics
- Problem Statement
- Analyse the Data
- Calculating Percentiles
- Analysing Grouped Data
- 6. Visualising Data with ggplot
- Principles of Visualisation
- Visualising data with ggplot
- Sharing visualisations
- Assignment
- 7. Creating Data Products
- Data Science Workflow
- Reproducible Research
- R-Markdown
- Mini Hackathon
- 8. Cleaning Data
- Case Study 2
- Cleaning data
- Joining data frames
- Code structure
- Quiz 4: Cleaning Data
- 9. Exploring the Customer Experience
- Consumer Involvement
- Preparing the Involvement Data
- Missing Data
- Tidy Data
- Quiz 5: Transforming data
- 10. Analysing the customer experience
- The Reliability of Surveys
- Correlations
- Hierarchical Clustering to assess validity
- Reviewing the Personal Involvement Index
- 11. Writing Reports
- Creating documents with RMarkdown
- Survey Items
- Service quality
- Mini Hackathon
- Data Cleaning
- Data Exploration
- Data Analysis
- Write a report
- 16. In Closing
- Searching for answers
- Forums
- Further Study
- Thanks
Instructor
Dr Peter Prevos is a civil engineer and social scientist who also dabbles in theatrical magic. Peter has almost three decades of experience as a water engineer and manager, working in Europe, Africa, Asia and Australia. He has worked on marine engineering, drinking water an sewage treatment projects. Throughout his career analysing data has been a central theme.
He also a PhD in business and is the author of Customer Experience Management for Water Utilities (IWA Publishing) and Principles of Strategic Data Science (Packt Publishing). In his work, Peter combines the social sciences with engineering to create value for customers.
He is currently managing the data science function for a water utility in regional Australia. The objective of this strategy is to create value from data through useful, sound and aesthetic data science. His mission is to breed unicorn data scientists by motivating other water professionals to ditch their spreadsheets and learn how to write code.
Community
This course has a private forum for learners who are taking this course.
Authors have earned$9,908,351writing, publishing and selling on Leanpub, earning 80% royalties while saving up to 25 million pounds of CO2 and up to 46,000 trees.
Learn more about writing on Leanpub
The Leanpub 45-day 100% Happiness Guarantee
Within 45 days of purchase you can get a 100% refund on any Leanpub purchase, in two clicks.
See full terms
Free Updates. DRM Free.
If you buy a Leanpub book, you get free updates for as long as the author updates the book! Many authors use Leanpub to publish their books in-progress, while they are writing them. All readers get free updates, regardless of when they bought the book or how much they paid (including free).
Most Leanpub books are available in PDF (for computers), EPUB (for phones and tablets) and MOBI (for Kindle). The formats that a book includes are shown at the top right corner of this page.
Finally, Leanpub books don't have any DRM copy-protection nonsense, so you can easily read them on any supported device.
Learn more about Leanpub's ebook formats and where to read them
Top Books
C++ Best Practices
Jason TurnerLevel up your C++, get the tools working for you, eliminate common problems, and move on to more exciting things!
Continuous Delivery Pipelines
Dave FarleyThis practical handbook provides a step-by-step guide for you to get the best continuous delivery pipeline for your software.
OpenIntro Statistics
David Diez, Christopher Barr, Mine Cetinkaya-Rundel, and OpenIntroA complete foundation for Statistics, also serving as a foundation for Data Science.
Leanpub revenue supports OpenIntro (US-based nonprofit) so we can provide free desk copies to teachers interested in using OpenIntro Statistics in the classroom and expand the project to support free textbooks in other subjects.
More resources: openintro.org.
C++20
Rainer GrimmC++20 is the next big C++ standard after C++11. As C++11 did it, C++20 changes the way we program modern C++. This change is, in particular, due to the big four of C++20: ranges, coroutines, concepts, and modules.
The book is almost daily updated. These incremental updates ease my interaction with the proofreaders.
Atomic Kotlin
Bruce Eckel and Svetlana IsakovaFor both beginning and experienced programmers! From the author of the multi-award-winning Thinking in C++ and Thinking in Java together with a member of the Kotlin language team comes a book that breaks the concepts into small, easy-to-digest "atoms," along with exercises supported by hints and solutions directly inside IntelliJ IDEA!
Introductory Statistics with Randomization and Simulation
Mine Cetinkaya-Rundel, Christopher Barr, OpenIntro, and David DiezA complete foundation for Statistics, also serving as a foundation for Data Science, that introduces inference using randomization and simulation while covering traditional methods.
Leanpub revenue supports OpenIntro, so we can provide free desk copies to teachers interested in using our books in the classroom.
More resources: openintro.org.
Ansible for DevOps
Jeff GeerlingAnsible is a simple, but powerful, server and configuration management tool. Learn to use Ansible effectively, whether you manage one server—or thousands.
Java OOP Done Right
Alan MellorObject Oriented Programming is still a great way to create clean, maintainable code. But only if you use it right.
This book gives you 25 years of OO best practice, ready to use.
You'll learn to design objects behaviour-first, use TDD to help, then confidently apply Design Patterns, SOLID principles and Refactoring to make clean, crafted code.
Introducing EventStorming
Alberto BrandoliniThe deepest tutorial and explanation about EventStorming, straight from the inventor.
Discrete Mathematics for Computer Science
Alexander Shen, Alexander S. Kulikov, Vladimir Podolskii, and Aleksandr GolovnevThis book supplements the DM for CS Specialization at Coursera and contains many interactive puzzles, autograded quizzes, and code snippets. They are intended to help you to discover important ideas in discrete mathematics on your own. By purchasing the book, you will get all updates of the book free of charge when they are released.
Top Bundles
- #1
Software Architecture for Developers: Volumes 1 & 2 - Technical leadership and communication
2 Books
"Software Architecture for Developers" is a practical and pragmatic guide to modern, lightweight software architecture, specifically aimed at developers. You'll learn:The essence of software architecture.Why the software architecture role should include coding, coaching and collaboration.The things that you really need to think about before... - #2
CCIE Service Provider Ultimate Study Bundle
2 Books
Piotr Jablonski, Lukasz Bromirski, and Nick Russo have joined forces to deliver the only CCIE Service Provider training resource you'll ever need. This bundle contains a detailed and challenging collection of workbook labs, plus an extensively detailed technical reference guide. All of us have earned the CCIE Service Provider certification... - #3
Cisco CCNA 200-301 Complet
4 Books
Ce lot comprend les quatre volumes du guide préparation à l'examen de certification Cisco CCNA 200-301. - #4
Modern C++ by Nicolai Josuttis
2 Books
- #5
CCDE Practical Studies (All labs)
3 Books
CCDE lab - #6
"The C++ Standard Library" and "Concurrency with Modern C++"
2 Books
Get my books "The C++ Standard Library" and "Concurrency with Modern C++" in a bundle. The first book gives you the details you should know about the C++ standard library; the second one dives deeper into concurrency with modern C++. In sum, you get more than 600 pages full of modern C++ and about 250 source files presenting the standard library... - #7
Mastering Containers
2 Books
Docker and Kubernetes are taking the world by storm! These books will get you up-to-speed fast! Docker Deep Dive is over 400 pages long, and covers all objectives on the Docker Certified Associate exam.The Kubernetes Book includes everything you need to get up and running with Kubernetes! - #8
Modern Management Made Easy
3 Books
Read all three Modern Management Made Easy books. Learn to manage yourself, lead and serve others, and lead the organization. - #9
The Future of Digital Health
6 Books
We put together the most popular books from The Medical Futurist to provide a clear picture about the major trends shaping the future of medicine and healthcare. Digital health technologies, artificial intelligence, the future of 20 medical specialties, big pharma, data privacy and how technology giants such as Amazon or Google want to conquer... - #10
Django for Beginners/APIs/Professionals
3 Books