Automating the “Site Visitors” XL Report
OK, the average Excel pro has not caught on yet. Heck, most of them haven’t even heard of PowerPivot yet – it did just release this week after all.
Let’s say you don’t have much need for handling large data volumes, your organization isn’t large enough to worry about spreadsheet robustness/business intelligence/one version of the truth, and you haven’t yet seen what DAX can do for you in pivots.
Tags: sharepoint, excel, refresh