Periodically, members of the PivotStream team write as guest writers in various blogs and other areas of interest, including Microsoft’s Excel Blog and CIMA’s Insight E-Magazine. When articles of specific interest to PivotStream clients are posted, we will make them available here.
Chartered Institute of Management Accountants (CIMA) Insight E-Magazine, London, UK
“Introducing PowerPivot” by Rob Collie, CTO — August 2011
Part One of a series targeted at Accounting and Finance professionals. Explains how PowerPivot blends the strengths of spreadsheets and “real” BI.
“The Hidden Cost of Traditional BI Projects” by Rob Collie, CTO — September 2011
Illustrates how the costs of a traditional BI project, which are always understood to be high, are actually much higher than what is usually measured.
“Using PowerPivot for BI Projects” by Rob Collie, CTO — October 2011
Having implemented the exact same project using traditional BI methodology in 2006 and then PowerPivot in 2009-2010, Rob provides a detailed ROI comparison.
“Using PowerPivot” by Rob Collie, CTO — November 2011
Rob walks through the fundamental tasks in PowerPivot of loading data, using calculated columns, and creating pivots.
“Revolutionary Features” by Rob Collie, CTO — December 2011
Intro to the benefits of relationships and a first glimpse of formulas in pivots.
Official Microsoft Excel Blog, Redmond, WA
“Top 5 Ways PowerPivot Helps Excel Pros” by Rob Collie, CTO
Explaining to the “Excel pro” community how PowerPivot magnifies the strength and relevance of their skillset.
“Portable formulas: A PowerPivot benefit you’ll never believe you lived without by Rob Collie, CTO
One of the most valuable and yet often overlooked benefits of PowerPivot: you can write your formulas once and then use them in many different contexts, eliminating the single most tedious and time-consuming aspect of traditional Excel reporting. Detailed examples are provided.