Real-Time vs. Batch Analytics: Why Your Package’s ETA is Lying to You
As I write this, I am eagerly refreshing the status of my FedEx delivery. It’s currently 1 PM where I am. The package is estimated to be delivered between 10 AM — 2 PM, but the last status update shows it’s still in a city 2 hours away. Something needs to be fixed here. Either the ETA or the […]
Experimenting with AI: A New Approach to Querying Your Data Warehouse
As data practitioners, we’re always looking for ways to make working with data more accessible and faster. Lately, AI has been opening up exciting new possibilities. What if you could use AI to query your data warehouse quickly, even if you’re not a SQL expert? You can do it with a bit of help from […]
Data Modeling 101: Entities
When we talk to each other there are a million things left unspoken because of our assumptions, shared understandings, and presuppositions. Indeed if you’ve learned a new language you know this for fact. Speaking a different language from your mother tongue isn’t just rote translation. It’s communicating ideas, feeling, and concepts. In the business world, […]
Creating a Table in SQL: Quick and Easy vs. Full Setup
Creating a table in SQL is one of those things every good data engineer needs to know how to do. Like most things, there’s an easy way and a good way to do it. So, without further ado. Here are the two ways you can create a table in SQL… Aside: I’ll be using the Cat Fact Breed API […]