Category Archives: analytics

Linking Trello to Power BI – Overview

A big help when measuring Trello is that Power BI knows something about Trello that you may not: Behind every board on Trello is a JSON file. Don’t worry if that makes no sense, let Power BI do that for you. Continue reading Linking Trello to Power BI – Overview

How to: Measure Trello with Power BI

If you use Trello and want to measure your activity, there is no better visualisaton tool than Power BI. However, putting Trello behind Power BI is, well, tricky. This is the first in a series of blogs in which we show you how to do this. Continue reading How to: Measure Trello with Power BI

The glory years of Excel (and how to recreate them)

This is a blog post for those who want to “wow” people with computers.

London was a good place to be in the summer of 1995.  The weather was hot, for ages, a specific kind of heat faceted by not only temperature but music, too.  The heatwave actually sounded like Blur, Oasis and, erm, The Boo Radley’s.  Cool Britannia was not only where we lived but how we lived it. Continue reading The glory years of Excel (and how to recreate them)

(What’s the story) macro glory

This is a blog for Excel-loving, technical historians who secretly wish it was 1995 – and almost no-one else. Continue reading (What’s the story) macro glory

Excel: where agile goes to die

To the casual onlooker all I have done is help with a formula in Excel.  In-house things are different.  We know: this is life changing.  Spreadsheets are faster.  Reports are smarter.  Truth is nearer.

This is part of who I am: the Excel Guru. Every office has one because every office needs one. This is inevitable.  Continue reading Excel: where agile goes to die