PowerPivot Component Architecture

(excerpt from a pending “Microsoft SQL Server PowerPivot Planning and Deployment” technical white paper that will be published in April/May, 2010, reviewed by Daniel Yu, Dave Wickert, Denny Lee, Donald Farmer, James Howey, John Hancock, ) Executive Summary Microsoft® SQL Server® PowerPivot is an innovative data analysis technology that redefines how organizations of all kinds… Read more

PowerPivot Data Refresh

In this posting we will take a look at the data refresh facility in PowerPivot for SharePoint and show you how to use it for maximum benefit. To start off, let’s begin with a simple question: So . . . what is data refresh? And why should I care? Data refresh is all about keeping… Read more