Posts
All the articles I've posted.
Denormalization: When and Why to Flatten Your Data
Published: at 04:00 PMNormalization is the first rule taught in database design. Eliminate redundancy. Store each fact once. Use foreign keys. It's the right rule for transactiona...
Headless BI: How a Universal Semantic Layer Replaces Tool-Specific Models
Published: at 04:00 PMYour organization uses Tableau for executive dashboards, Power BI for operational reports, and Python notebooks for data science. Revenue is defined in Table...
Partition and Organize Data for Performance
Published: at 03:00 PMA table with 500 million rows takes 45 seconds to query. After partitioning it by date, the same query — filtering on a single day — returns in 2 seconds. Th...