Malintha Wijewardana's top articles

Databases & DBA

ETL Design Pattern to Implement SCD Type 2 Using SQL, SSIS, or dbt

Jul 30, 2025 1.3k 0

Power BI

Performance Tuning a Tableau Dashboard with SQL Optimization

Sep 19, 2025 1.3k 0

Databases & DBA

How to Build a Data Mart from Scratch: A Data Warehouse & SQL-Focused ...

Jul 31, 2025 1.2k 0

Databases & DBA

Star Schema vs. Snowflake Schema – Which One Should You Use?

Jul 24, 2025 1.1k 0

Databases & DBA

Denormalization vs. Normalization - Striking the Right Balance in Data Wa...

Jul 25, 2025 1.1k 0

Business Intelligence(BI)

Building Trust in Data: Data Governance Best Practices for BI Teams

Oct 02, 2025 1k 0

Databases & DBA

Slowly Changing Dimensions (SCD)

Jul 28, 2025 940 0

Databases & DBA

Designing a Sales Data Mart from Scratch Using SQL and Dimensional Modelin...

Aug 08, 2025 899 0

Career Advice

My Journey from Data Warehousing to Business Intelligence: A Foundation Ev...

Jul 22, 2025 881 0

Business Intelligence(BI)

PostgreSQL Tips for BI Professionals: From Window Functions to LOD Alterna...

Oct 23, 2025 668 0