POWERPIVOT 2010 BLOGS
BLOGS BY AUTHOR
BLOGS BY YEAR
Wise Owl Training - PowerPivot 2010 blogs
Showing blogs 1-7 (out of 7)
Posted by Andy Brown on 20 February 2015
The editor for calculated fields in Excel (aka measures) isn't the greatest; this blog shows you how to install and use DAX Studio as a substitute editor.
Posted by Andy Brown on 09 January 2014
Power View is an Excel or SharePoint add-in which allows you to create quick and interactive dashboard reports, with built-in drill-down. This blog considers whether you're missing a trick if you don't know how to use Power View.
Posted by Andy Brown on 04 November 2013
The RANKX function works out where a measure lies in order for any dimension, but it has a couple of gotchas to watch out for, as this blog explains.
Posted by Andy Brown on 31 January 2013
PowerPivot is a superb addition to Excel: it allows you to create pivot tables based on multiple tables taken from a variety of data sources, and its DAX language lets you report any statistic you want. This overview summarises how to get started with PowerPivot, and what it does.
Posted by Andy Brown on 16 January 2013
This blog shows you how to create a calendar of dates for use in PowerPivot. Instructions are included for Excel and Access.
Posted by Andy Brown on 04 January 2013
This blog includes the SQL script to generate a table of calendar dates for linking to from within PowerPivot or an Analysis Services tabular model.