Data – Data Engineer Journey

Creating stage, loading and parsing Parquet file in Snowflake (Data Lake Workshop)

I love keeping track of my learning journey. Earning my fourth certification, Badge 4: Data Lake Workshop, has been exciting. […]

What is Wide-Facts, why we need it? “Wide-Fact” is a fact table that contains a high number of columns and

Parameters are the secret ingredient that make Power BI reports dynamic and interactive. Let’s explore some of the most commonly

The Simple.. Imagine trying to organize a party where every guest is talking to every other guest at the same

Kshitij Wagle / 4 September 2024

Handling massive datasets can seem overwhelming, but Apache Spark makes it manageable. This hands-on guide will show you how to

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

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 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.

Kshitij Wagle / 16 February 2024

Star Schema: Dimensional data model, that has a fact table in the centre, surrounded by denormalized dimension tables. Snowflake Schema: