All Hands on Data #20
How spooky is it that Katt and Jon recommended the same article this week? Check it out and the rest of the team's recommendations below!
How to Build a Data Product that Won’t Come Back to Haunt You
Nodine talks about what to consider when developing a data product. They focus on three pipeline phases (the starting data, the ending product, and everything in between) and four criteria for analyzing those phases: Is it self-explanatory? Does it inspire trust and confidence? Does it adapt easily to change? Is it reliable, accurate, and well-maintained? The criteria applied to each phase creates twelve touch points that will help you quickly assess the health of your product. - Katt Baum & Jon Davidson
Handling Missing Values in Time-series with SQL
This is a quick-and-dirty overview of how to use the "LAST_VALUE" function in SQL - something that's pretty important to help plug up holes in your data if there are missing values! - John Forstmeier
The Production Grade Data Pipeline
I really liked Chad's way of defining a production-grade pipeline as "a pipeline where data quality meaningfully contributes to the pipeline’s ROI". Chad also gives some great initial tips towards making sure your production pipelines are running effectively and sustainably. - Blake Burch
A Walk in the Tidyverse
I used to be a big R user back in the day, and the Tidyverse was a main reason why. There will always be a place in my heart for R, even though I don't use it anymore - Wes Poulsen
The Sound that Data Makes
Three words: Shipyard Theme Song. But really, it would be interesting to see what different types of data would sound like - especially pulling some form of weather data, maybe based on temperature or pressure values. It's also crazy to think that this could be pieced together from just a small bit of code! - Joseph McDermott
Introducing the New LoL Esports Data Portal
With the League of Legends World Championships currently happening, I was brought back to my college days where I tried to do a project in college on esports. It was near impossible to get good data on esports matches due to the community having to gather it all. I'm excited about what can be built with this official data. - Steven Johnson