PIVOT and Dynamic PIVOT in SQL - Advanced SQL for analytics
Jan 19, 2025 · 5 min
How to create Azure DevOps Pull Requests reporting with Power BI
Aug 18, 2024 · 6 min
How to start a successful Data Warehouse project
Aug 11, 2024 · 8 min
Understand Row-Oriented vs Column-Oriented Storage
Apr 5, 2024 · 5 min
OLTP & OLAP - Why we need Data Warehouse
Feb 28, 2024 · 4 min
Recursive CTEs and CONNECT BY in SQL to query Hierarchical data
Feb 20, 2024 · 10 min
What is a reliable Data System?
Feb 16, 2024 · 4 min
PySpark UDFs: A comprehensive guide to unlock PySpark potential
Feb 9, 2024 · 7 min
A Practical PySpark tutorial for beginners in Jupyter Notebook
Feb 8, 2024 · 11 min
Snowflake ID - Simplifying uniqueness in distributed systems
Feb 3, 2024 · 3 min