Join 📚 Kevin's Highlights

A batch of the best highlights from what Kevin's read, .

[![](https://userimg-assets.customeriomail.com/images/client-env-99697/1690722320571_2%20magic_01H6KEEGC8GRYVF5WR85K25EFF.png)](https://userimg-assets.customeriomail.com/images/client-env-99697/1690722320571_2%20magic_01H6KEEGC8GRYVF5WR85K25EFF.png)

The Meditations Newsletter #040

Alex from Sunsama

![The solution journey for analytics on Azure starts with learning and assigning roles. Next, choose a storage solution and an Azure BI or AI technology for the workload.](https://learn.microsoft.com/en-us/azure/architecture/solution-ideas/media/analytics-get-started-diagram.svg)

Analytics architecture design - Azure Architecture Center

big data architecture

Here’s what the entity resolution query looks like: ![](https://substackcdn.com/image/fetch/w_1456,c_limit,f_auto,q_auto:good,fl_progressive:steep/https%3A%2F%2Fsubstack-post-media.s3.amazonaws.com%2Fpublic%2Fimages%2F97ec307e-6b10-46fd-8b6a-773f9f163875_1212x728.png) I’m joining the table with itself on state + zipcode to reduce the search space and using string similarity thresholds for filtering potential duplicates. In entity resolution methodology this is known as “blocking.”

Fundamental Data Engineering Concepts - Part 2

Ergest Xheblati

...catch up on these, and many more highlights