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: […]
Comparing Data Governance Good vs. Bad Practices – Data Analysts, Data Engineer, Data Manager
Good Practices vs. Bad Practices in Data Governance In today’s data-driven world, effective data governance is essential for organizations to
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
Starting with Apache Spark on Databricks with FAQs
Handling massive datasets can seem overwhelming, but Apache Spark makes it manageable. This hands-on guide will show you how to
10 Timeless Principles Every Tech Professional Should Know
Nowadays, people often talk about these principles on LinkedIn. Inspired by these discussions, I created my first design using Figma.
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
Comparing Command Lines: Windows, Linux, and macOS
It’s been an exciting week since I got my new MacBook, and I’ve been eager to explore its capabilities. As
Designing Health and Safety Dashboard — Step-by-Step Process
As a data analyst, I’ve always been driven by the thrill of transforming raw data into actionable insights. But when
Optimizing Null Handling in Talend ETL Processes with Java Routine
Project Summary: In data integration projects, dealing with null values is a frequent task, especially for code fields. This blog