Real World SQL Join Examples

I found a diagram recently that helped to explain the different types of JOIN syntax. Being the type person that enjoys the visualization of abstract concepts such as set theory this diagram spoke to me. Despite the diagram being well done something seemed slightly wrong about it. I thought about it for a while and then it … Read more

Love Your PowerPivot Mashups

This past Monday I listed out the five trends that data professionals need to be aware of and how it will impact their careers. I’m here to tell you something else: Dont just love your data, that isn’t enough. You need to make love to your data using tools like PowerPivot. Yesterday Rob Collie (blog | @powerpivotpro) provided a … Read more