• Combining Excel files using Power Query for Excel

    For the information in this post I am heavily indebted to Michiel Rozema who originally figured this out. This post is an extension to my previous post on combining text (CSV) files using Power Query for Excel.…

  • Power BI and why you should care

    Yesterday Microsoft announced Power BI for Office 365: a self-service Business Intelligence solution delivered through Excel and Office 365. Power BI ties together the various bits and pieces we already had (Power View, PowerPivot, GeoFlow, Data Explorer) and…

  • Meet Paul

    Those of you who have attended one of my talks on BI probably know this story. I get asked about it a lot so wanted to share this more permanently. For me this story sums up the…