Browse by Tags

All Tags » Pivot Tables (RSS)
Does Excel Do MDX?
Published Wed, Sep 29 2010 9:37 | Bob Phillips
One of my primary interests at present is Business Intelligence (BI), using available tools to present meaningful information to the business that actually adds value. I won’t go into what BI is, the quality of BI products available at present,...
Filed under: , , , , ,
Keeping It Clear
Published Tue, Aug 11 2009 8:17 | Bob Phillips
It is not my intention for EDDD to be another 'Excel Tips & Tricks' blog, there are plenty of good examples of these already, but I saw someone struggling in a demonstration recently so I am thinking that this technique is not as well know...
Filed under: , ,
The Glory of Pivots
Published Wed, Aug 5 2009 14:33 | Bob Phillips
Surely we all know how useful Pivot Tables are in Excel by now? They are great for knocking up a filterable, drillable list of the data, but they can be much more. For instance, it is realtively simple to create a Top 10 (or top n) list from your data...
Filed under: , , ,