Where are my customers and are they unique to my brand or is there overlap with a competitor? To answer this question we need geospatial data about our stores, our competitors and where the customers ...
Use Case: I often get asked how I can add in Weekly, Monthly, Yearly averages, and I usually point them to this design pattern. The power in this that many people miss is that by ...
Use Case: Another useful design pattern to have at your fingertips is the ability to parse out a single row of a value(s) into multiple rows BUT—and this is the caveat that makes it all ...
Use Case: You have data that you want to summarize or get rid of duplicates and in developing a workflow realize that the data gets automatically sorted on the output, but you would like to ...
Use Case: You have a long list of items that you want to filter your SQL query down to for better performance. It can be difficult and painful to have to type many values. Fortunately ...
