Tag Archives: Excel

Spatial analysis with Bing Maps & Excel

Posted on January 28, 2012 by Lee Hawthorn

After months of BI work in the office I finally got the opportunity to take a break and get out of the office to see the field sales end of the business. Additionally, in the last couple of months I’ve … Continue reading →

Posted in Spatial Analysis | Tagged , , | Leave a comment

Data modelling for Excel users

Posted on November 20, 2011 by Lee Hawthorn

In this post we’ll have a basic look at the transformation of data usually seen in Excel into a format that is better suited for Business Intelligence. In the screen below we have an extract of data from a Financial … Continue reading →

Posted in Power Pivot | Tagged , | Leave a comment

Pivot Table Sort

Posted on November 15, 2011 by Lee Hawthorn

In Excel 2010 we are able to apply our own custom sort to Pivot Tables. This is particularly useful when you want to report on financial periods such as Jan, Feb, Mar. If your financial year begins on Apr, you … Continue reading →

Posted in Power Pivot | Tagged , , | Leave a comment