Tag: BI

Excel: Consolidating crosstab data

This is a continuation of the Data Cleanup series. One common form of bad data is called crosstab. Consolidating crosstab data requires lot of manual effort. Pivot – Multiple Consolidation

Read »
Use PowerPivot instead of VLOOKUP

This time I wanted to try a new style of writing. I created a presentation instead of the usual document like style. Download presentation and view Download the presentation (300kb)

Read »