In this article, we will try to understand how we can handle regulations such as GDPR and CCPA using Delta Lake — In the world we live in, the power of data cannot be challenged. This power has helped several companies accelerate their revenue by monetizing and marketing personal data in ways that cross the boundaries of ethical use. In some cases, the power of data has been misused to the extent…

Handling the challenge of slowly changing dimensions using the Delta Framework — For a long time, the Kimball method has been a standard for dimensional data modeling techniques. As per Kimball “ The notion of time pervades every corner of the data warehouse”. What does this mean in the context of data analytics? At a high level, modern analytics can be seen…

This article is an attempt to share my thoughts and experience regarding stress and anxiety management for professionals in the modern era of turbulence. — Never have I ever written on topics outside the realm of science and technology, but there always is a first time for everything. A lot of my readers may already be familiar that I have been training students to achieve higher in areas of big data engineering, data analytics, and…

Comparing query performance in the different flavors of Amazon Redshift and Athena. — For a while now I have been thinking of performing some benchmark tests on Amazon Redshift. As laziness settles in you tend to ignore a few things and this was one of them. That changed when I started to read about the new offering from Amazon Redshift. …

A guide on how to make the RDS database highly available and load balance database requests using read and write request splitting. — For readers who have known me through my articles and book in this article, I am going to digress from my usual topics around data engineering, data science, or data analytics. Instead, I am going to talk about a subject that I used to specialize in over many years in…

Understanding some use cases of computer vision using Amazon Rekognition — What is computer vision? Can computers see like humans? As per Wikipedia computer vision can be defined as “Computer vision is an interdisciplinary scientific field that deals with how computers can gain high-level understanding from digital images or videos.” Why is computer vision important in today’s world? Technically, computer vision…

Understanding the usage of data engineering and machine learning in the electric mobility world — We are living in the world of electric mobility. Globally, the adoption of electric cars and two-wheeler is steeply on the rise. Electric mobility devices rely on expensive rechargeable lithium-ion batteries for power. These batteries are integral for the fight against the bad effects of fossil fuels such as pollution…

An article on the evolution of big data architectures and the power of modern Lakehouse architecture. — In this article, we will travel through time and understand the evolution of big data architectures. We will also explore the power of modern Lakehouse architecture in greater detail. I just realized that I completed 10 years working in the field of big data. Looking back in time it has…

A guide to deploying and administering Hadoop Clusters like a smart administrator — Several years ago while I was still a developer I got chosen to be part of the prestigious Data Administration group. It was a dream come true because not many got that chance. While I was preparing myself to be part of the elite the Principal DBA gave me very…