Thought Leadership
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.
Read the article on the Microsoft Excel Blog.
“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.