Category: Quick Tips & Tricks

Moore’s Law and Inflation

SQL Rockstar, aka Tom LaRock (Blog | Twitter) sent me a fascinating data set the other day:  a table of different computing devices over the years, their “horsepower” in calculations per second

Written by on March 13, 2012

Auto-Modify Every Pivot in a Workbook

It’s been awhile since I’ve talked about Macros (also known as VBA).  I think it’s overdue. Macros are nothing short of amazing.  We couldn’t live without them at Pivotstream

Written by on March 6, 2012

Data of Different Grains Using DAX: A Followup

Quick Recap: We Created a Separate “Periods” Table In last week’s post, I explained how PowerPivot can very easily help you solve the “Budget vs. Actuals” problem or any other problem where you have data sets

Written by on January 19, 2012