Select Page

The Great Function Project – Part 3

Lord of the Rings. Mad Max. Star Wars. Indiana Jones… The Great Function Project. Another great trilogy comes to an end… well at least until the next one comes out. If you haven’t “seen” part 1 & part 2, go… This post first appeared...

Power Query (M)agic: Super SubVars

The Challenge I love the idea behind Power Query (M)agic. These posts let Power Query users learn and share best practices (tips & tricks) that solve real problems. Query management comes up a lot. What if multiple PQ queries point… This post first appeared...

Journey to PowerPivotPro: Ryan Bergstrom

  The Rewarding Things Aren’t Easy Sometimes I forget that it has only been a year at PowerPivotPro.  Every new client that I have seems like I‘ve spent months getting to know a business, their projects, and the incredible people… This post first appeared...

The Great Function Project – Part 2

My name is Mathew Herring Jack, and I am a member of Traditional Excel Users Anonymous. As a Traditional Excel User, I could not stop copying and pasting downloaded reports. Even when my manager diagnosed me with inaccurate month-end reporting,… This post first...

Agile BI Moves from “If” to “How”

My 2010 Wake Up Call Eight years ago, I lucked into an epiphany: IT-driven BI was going to give way to biz-driven BI (aka “self-service” or “Agile” BI). The new wave of BI tools – led by Power Pivot at… This post first appeared...