That enormous wide table? It’s hiding entities, metrics, and time semantics. Learn the dissection framework that reveals schema structure and turns risky rewrites into surgical precision.
Denormalized tables promise simplicity, but often hide complexity in plain sight. A single table may contain business entities, metrics, time semantics, and technical artifacts: all mixed together behind a deceptively flat schema.
This talk introduces a practical framework for dissecting denormalized tables in 1NF by classifying columns into functional roles: keys, dimensions, facts, temporal granularities, technical columns, aggregates, and indices. This perspective turns tables into understandable systems instead of mysterious collections of fields.
With this mental model, data engineers can spot leaky abstractions early and approach normalization as a deliberate, surgical process rather than a risky rewrite. If you work with Python-based data stacks and messy real-world schemas, this talk will change how you look at tables forever.
Hi there, I’m Nino! An Italian-Finnish theoretical physicist turned into a Software Engineer for a living.
My relentless curiosity drives me to continuously explore new languages and frameworks. Over the past five years, I’ve thrived in roles ranging from DevOps and Full-Stack to Platform and Big Data Engineering.
When I’m not diving into data, you can find me challenging gravity with bouldering, centering my mind through yoga, or strategizing my next chess move.