A couple of years ago I began my journey into the world of Microsoft PowerPivot suite. Being honest as someone who got on fine with Excel, PowerPivot seemed a little sledgehammer meet nut. I looked for a number of things to use with it often times having to discount them because my audience just wasn’t ready. Then that all changed. Over the course of 2015 I was heavily involved in a major ITSM system upgrade, the required me to review all our current reporting and make sure that it was migrated to the new tool. Like almost every company I have ever worked for we couldn’t leverage the tools reporting engine immediately because of our requirements (we like to fiddle and not follow our own rules – doesn’t everyone?).

The net result I got the opportunity to implement what I had been planning for two years but had been able to get enough traction behind. We implemented a Power Query and PowerPivot based reporting solution. Over the course of a year I will be implementing a number of major improvements to the core report pack as well as learning more and more about the tool.

I hope you’ll join me on this exciting journey (I promise I’ll try and put some humour in somewhere).