Pratik KhedekarEfficient Data Ingestion Using Snowflake’s Snowpipe — Hands-onIntroduction: Snowpipe is a powerful continuous data ingestion service provided by Snowflake, a leading cloud-based data warehousing…Apr 4Apr 4
Pratik KhedekarSQL Case Study 1: Famous PaintingsIntroduction: This Article highlights on various aspects of data engineering, where Docker orchestrates infrastructure, SQL queries unveil…Jan 22Jan 22
Pratik KhedekarImplementing Data Vault 2.0 using Snowflake (Part 2)In the preceding article, we delved into the principles and components of Data Vault 2.0, gaining insights into its architecture and the…Jan 173Jan 173
Pratik KhedekarData Vault 2.0 — Modern Data Modelling Methodology (Part 1)In the realm of a data warehouse, where maintaining a consistent and reliable data model is paramount, Data Vault 2.0’s approach offers an…Dec 29, 20232Dec 29, 20232
Pratik KhedekarData Warehouse Fundamentals — Normalization, Data Modelling, Kimball Approach and Inmon ApproachData: Data refers to raw facts, observations, or measurements that describe the characteristics of objects, events, or phenomena.Dec 24, 2023Dec 24, 2023
Pratik KhedekarDiverseCart: Analytical Engineering ProjectIntroduction: In the realm of data analytics, the rapid generation of extensive datasets by businesses necessitates a seamless, robust, and…Dec 18, 2023Dec 18, 2023