Blog – Page 2 – Data Engineer Journey

The Pareto Principle (80/20 Rule) – What Works and What Doesn’t

A lot of people on LinkedIn and other professional platforms frequently discuss the Pareto Principle, also known as the 80/20 […]

It’s been an exciting week since I got my new MacBook, and I’ve been eager to explore its capabilities. As

As a data analyst, I’ve always been driven by the thrill of transforming raw data into actionable insights. But when

Project Summary: In data integration projects, dealing with null values is a frequent task, especially for code fields. This blog

I still remember the frustration I felt as a young data analyst, stuck between my technical expertise and the mysterious

OpenAI launched ChatGPT online on November 30, 2022. Like other large language models, ChatGPT uses real data from the internet

Have you ever wondered how the data in a database is structured and organized? From the books you borrow at

Are spare tables and fields causing confusion and inefficiency in your organization’s database management? Are they causing problems during the

Are you facing challenges related to discrepancies and validation in your Analytics team? Explore these situations: If you are facing

In the complex world of database management, ensuring consistency between databases, schemas, and tables is crucial for seamless data operations.

Ever wondered how Postgres handles date and time? In this practical guide, we explore 12 examples using a table named

Kshitij Wagle / 17 February 2024

Rank(): Dense_Rank() Row_Number() Showing Difference between Rank, Dense Rank , and Row Number in a single view: Partition By Clause: