If you’re like me or anybody else who travels frequently (or perhaps just lives in a particularly large city), you’ve probably become familiar with yelp, foursquare, or any of a number of different sites and apps designed to help you find somewhere to eat or other goods and services in […]
SQL
3 posts
Dealing with dates in Cognos can sometimes be a daunting task. Dates should be straightforward, but sometimes they take extra work to get what you want. Your data is designed to list the date of the transaction, but maybe you only care about data on a per week, per month, […]
Overview This document shows how an Open Source Database like MySQL can be used with Microsoft’s popular Excel plugin PoweverPivot. Many clients enjoy the familiarity of Excel and ease of use that PowerPivot brings but the clients do not want to married with any one particular vendor in their Business […]