Tag Archives: Power Pivot

Quench your thirst for knowledge

Like many analysts I’ve always had it in my mind that if I only had some new data to fill in a ‘data jigsaw’ then I’d be able to add much more value to the business. Frequently this information isn’t … Continue reading

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

CIMA Business Intelligence Talk

As promised during my CIMA talk on the 16th November I have attached the slides, the supporting document and link to the demo video on YouTube (select the HD option and watch in full screen) If you’re not able to … Continue reading

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

Always use Date tables in Power Pivot

Power Pivot comes with some very good time intelligence functions, however, to get the most from these functions it’s a best practice to provide Power Pivot with a Date table. Date tables can be used to report on Calendar, Financial … Continue reading

Posted in Power Pivot | Tagged , | Leave a comment