To be clear, this article won’t be an indictment on the popular McDonald’s sandwich. Indeed, that was in itself a brilliant idea to combat flagging Friday sales in the predominantly Catholic neighborhood of a franchise owner. Due to most of his customers choosing to abstain from meat on Fridays, franchise owner Lou Groen famously made…
Tag: featured
The Set Theory of Data Warehouse Design
I love volleyball as much as I love data. However, as this is a blog about data, I’ll leave the theories I have related to setting the ball at the door and move forward on the topic of data. Believe it or not, you learned the basics of how a data warehouse works way back…
The Game Theory of Warehouse Design – AKA – “What Would JJ Walker Do?”
In high school, I had the opportunity to play against a chess grandmaster. I can say without boasting that I soundly beat him … to the door. While playing, he told me in no uncertain terms around 40 moves into our game that he would have checkmate in twenty-something moves. As he went around to…
Those Who Don’t Know History Are Doomed to Repeat It…
In our daily work, we’re constantly bombarded with requests for short time periods – rolling 30 days, last month, last quarter, year to date, rolling 13 months, etc. All of these are fine for their defined purposes – reporting. It’s often called Business Intelligence, or Analytics, and there are some pieces of both within these…
Shoot for the Star Schema!
The phrase “Shoot for the stars!” has long been associated with trying to achieve something thought impossible, with the idea that while you may not get all of the way there, by aiming for something grandiose, you will at least achieve more than if you set your goals at something easily accomplished. In more recent…
The Importance of Perfect Data Transfer
Do your ETL right the first time – every time.
Rock the Data! 