Dimensional Modelling – Key points you need to know
Star Schema: Dimensional data model, that has a fact table in the centre, surrounded by denormalized dimension tables. Snowflake Schema: […]
Building and Deploying an AI-Powered Cover Letter Generator
App Live : https://ai-coverletter.netlify.app/GitHub: https://github.com/kwagle7/AI-Personalized-Cover-Letter AI-Powered Cover Letter Generator Author: Kshitij Wagle (@kwagle) 📌 Introduction This project is a complete
Designing a Data Warehouse for a Grocery Retailer Quick Guide
Designing a Data Warehouse for Grocery Store In any modern retail business, data plays a crucial role in improving operations,
How to detect and handle duplicates in SQL and ETL pipelines
Duplicate records are one of the most common data quality issues in a data warehouse. They can lead to misleading
Medallion (Pull) vs Data Product (Push) architectures
This article summarizes the core arguments from Modern Data 101‘s piece: Data Products: A Case Against Medallion Architecture. The original
Exploring Idempotency in Data Modelling: Why Pipelines Fail
What is an Idempotent Pipeline? An idempotent pipeline produces the same results : This means that both production runs and
Slowly Changing Dimensions (SCDs) in Data Warehousing
SCD Definition: Change of dimension over a course of time rather changing on regular scheduled time. Why do dimensions change?
Data Governance (Good vs. Bad Practices) – Data Analysts, Data Engineer, Data Manager
Good Practices vs. Bad Practices in Data Governance What’s the secret to making data work for you, not against you?
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.
The impact of escaping Referential Integrity on building Wide Facts in Data Warehouse – Data Orphanage
What is Wide-Facts, why we need it? “Wide-Fact” is a fact table that contains a high number of columns and
DevFest Sydney 2024: A Day of AI, Innovation, and Networking
Yesterday, early in the morning, it was beautiful as I traveled to DevFest Sydney 2024, hosted by Google Developer Groups.
Top Parameters Frequently Used in Power BI: Practical Examples and Use Cases
Parameters are the secret ingredient that make Power BI reports dynamic and interactive. Let’s explore some of the most commonly
Fixing Many-to-Many Relationships in Power BI with Link or Join Tables
The Simple.. Imagine trying to organize a party where every guest is talking to every other guest at the same