Archive

2025  2

February  1

Introducing Dat⋂nalytics - My new home to share insights

Feb 27, 2025 · 3 min · Dat Thai

January  1

PIVOT and Dynamic PIVOT in SQL - Advanced SQL for analytics

Jan 19, 2025 · 5 min · Dat Thai

2024  9

August  2

How to create Azure DevOps Pull Requests reporting with Power BI

Aug 18, 2024 · 6 min · Dat Thai

How to start a successful Data Warehouse project

Aug 11, 2024 · 8 min · Dat Thai

April  1

Understand Row-Oriented vs Column-Oriented Storage

Apr 5, 2024 · 5 min · Dat Thai

February  6

OLTP & OLAP - Why we need Data Warehouse

Feb 28, 2024 · 4 min · Dat Thai

Recursive CTEs and CONNECT BY in SQL to query Hierarchical data

Feb 20, 2024 · 10 min · Dat Thai

What is a reliable Data System?

Feb 16, 2024 · 4 min · Dat Thai

PySpark UDFs: A comprehensive guide to unlock PySpark potential

Feb 9, 2024 · 7 min · Dat Thai

A Practical PySpark tutorial for beginners in Jupyter Notebook

Feb 8, 2024 · 11 min · Dat Thai

Snowflake ID - Simplifying uniqueness in distributed systems

Feb 3, 2024 · 3 min · Dat Thai