More than occasionally, I work in data warehouse environments where there have been very loose standards when it comes to creating physical data models. One example of this is delivering dimensions and facts without surrogate keys, and delivering...
Here is a framework and an approach centered on a different approach to defining requirements that works. Most importantly, a successful analytics project is a partnership. The business users should want to help IT create an effective and robust solution and IT...
I have worked as a hands-on consultant, data architect, data engineer and analytics solution architect for more than 25 years, and the problem I see more than any other is data modeling. This problem is significant because it creates difficulty throughout the solution...
Integers still rule. There is a little debate or controversy regarding the right approach for assigning surrogate keys, assuming, of course you’re not mired in the debate whether or not to create data models in the first place. I guess if you aren’t creating data...
Over the years I have seen a number of clients try to buy something to solve their analytics challenges. When I worked for Cognos, people bought Cognos thinking it would fix things, sometimes they threw Cognos out thinking it was the problem. Companies have purchased...
The following is an overview of the platform architecture used to facilitate the process of ingesting data into the Snowflake platform and transforming it into data models to facilitate a wide variety of reporting and analytics. I recently developed this with a...
