Posts in Engineering
Insights & Technical Logs
Documenting my journey through data architecture, BI strategy, and automated analytics. Read the latest technical insights.
How to Improve Website Performance: The Engineering Guide to a 100/100 GTmetrix Score
Master website performance optimization with this 1200-word guide. Learn the "Elite Tier" techniques used to achieve a 100/100 GTmetrix score, 0.6s LCP, and zero blocking time on Next.js.
Beyond the SELECT: Mastering Advanced SQL for Surgical Business Intelligence
Deep-diving into CTEs, Window Functions, and Recursive queries to build the high-performance engines behind enterprise dashboards.
Scaling the Forge: Why Python is the Backbone of Modern Data Engineering
Analyzing the shift from manual ETL to automated Python-based data pipelines for 10M+ record datasets.
How I Engineered a 10M-Row Autonomous AI-BI Agent Using DuckDB
A technical deep-dive into the Surgical Forge SDR-9 engine, featuring in-process OLAP, conversational SQL generation, and sub-second persistence.
PostgreSQL vs Snowflake: When to Scale Your BI Database
A technical deep-dive into the performance benchmarks of PostgreSQL and Snowflake for BI workloads.
Building Robust Data Pipelines with Python and Prefect
Master the art of automated data engineering with resilient, self-healing pipelines.
The Ultimate Visual Guide to SQL Joins: Mastering Advanced Cases
Forget Venn diagrams. This guide uses real-world data scenarios to master Inner, Left, Right, Full, and Self Joins like a pro.
Mastering Tableau Level of Detail (LOD) Expressions for Complex KPIs
Level of Detail expressions are the "secret sauce" of advanced Tableau dashboards.
Performance Tuning: How to Make Your Power BI Reports 10x Faster
Slow reports cause low BI adoption. Learn the secrets of DAX optimization and query folding.