All Hands on Data #59
As we venture through the dog days of summer, we hope you enjoy these articles we fetched for you.
The Data Modeling Divide
Focusing a specific part of the data pipeline, the author dives into the differing perspectives, tools, and gaps between transformation and semantic modeling. Ultimately, it comes down to these two sides using different tools and obscuring context from one another which creates difficulties and the author's dream world is one in which some of these tools are consolidated. I, for one, would love to see fewer tools in this wild data landscape. - John Forstmeier
5 Signs That Your Data is Modeled Poorly
According to Gazzano, the increase in data accessibility, while awesome, has also led to Data Lakes becoming Swamps. In my opinion, the signs covered in the article give a really good indication about the health of your data pipeline. - Katt Baum
In-Database Analytics: Leveraging SQL's Analytic Functions
This article is a great reminder of how valuable window functions in SQL are. The syntax can be a little strange at first, but the nice thing is they all follow the same pattern and the benefit of window functions can allow you to do some "analytical processing" all within the database instead of using a tool like pandas or dplyr. Not to mention the fact that in any data engineering interview, you will be expected to have a firm grasp on window functions. - Wes Poulsen
Security data lakes and the future of organizational security
It seems we've been living in the age of "data silos" for too long. The use of the silos prevent fast and easy access to business intelligence which can be costly over time. The use of security data lakes could be the solution. Security threats can be more quickly identified and managed with fewer gaps in access to security data. - Reed Cowan
How Artificial Intelligence, Data, and Analytics Are Transforming Formula One in 2023
I love to see these "obtuse" use cases for how data is transforming other industries we may not think to depend heavily on data. - Angel Catalan
ChatGPT Code Interpreter Released: Here are 10 Mind-blowing Use Cases
In my opinion, the biggest news coming out of the AI world this week is ChatGPT releasing its code interpreter. With any new release, it can be tough to think about how you can apply it to your daily work life. Thankfully, this article gives you some ideas on how you can use the newest release from OpenAI to make your daily life easier. - Steven Johnson