Robert HarmonI’m done with dashboards, and likely you should be too.Ok, maybe not completely done, but their common use is both expensive and a waste of time. This comes from a number of factors.Jan 4Jan 4
Robert HarmonIf you cannot constrain a thing, you cannot ingest that thingHigh data warehouse performance includes quality, rate, and volume of all activities. If we’re going to build a thing, we need a strong…Dec 7, 2023Dec 7, 2023
Robert HarmonThe key is in the key.One of the more common and costly mistakes I see in the many data implementations I get involved with all the time is confusion about keys…Dec 6, 2023Dec 6, 2023
Robert HarmonWho’s down with OBT? I can assure you, not me.Do we run to dimensional modeling because our data platforms don’t deliver?Dec 6, 2023Dec 6, 2023
Robert HarmonDo data architects exist anymore?That’s a loaded question. A bit of background is likely necessary to figure out where we were and how we got here.Dec 5, 20232Dec 5, 20232
Robert HarmonSimplifying time variance in a SQL data warehouseManaging time variance and non-volatility at scale and efficiency can be challenging. In the following blog, we use code examples to…Dec 5, 2023Dec 5, 2023
Robert HarmonAnalyzing event streams with SQL efficientlyAnalyzing event streams with SQL typically requires joining a billion rows to a billion rows that’ll never complete before a report times…Dec 4, 2023Dec 4, 2023
Robert HarmonTime, semantics, integration and lord help me, data contracts.If semantic knowledge is available and accessible, you don’t need a data contract.Oct 1, 2023Oct 1, 2023