I work with data but I look for truth. Let me explain:
Below is an example of a datum:
Category Archives: Excel
Power BI and gaps in the Trello data (how to avoid)
Supporting blog for placing Trello on Power BI. Continue reading Power BI and gaps in the Trello data (how to avoid)
Power BI and gaps in the Trello data (SQL vs NoSQL)
Sometimes when you model Trello with Power BI there are gaps. Welcome to NoSQL. Continue reading Power BI and gaps in the Trello data (SQL vs NoSQL)
Gotcha: Importing from Excel to SQL Server
Extremely short post about importing Excel data into SQL.
There is a gotcha that I just lost half an hour to. I’m writing this to save you that half hour. Continue reading Gotcha: Importing from Excel to SQL Server
Building a Trello Data Model in Power BI
Once your Trello data is accessible within Power BI it is necessary to make it self-aware. That is, the lists, labels and checklists need to know to which cards they belong; the cards need to know which list they are in. That is, we need to build a data model. Continue reading Building a Trello Data Model in Power BI
Getting Actual Trello Cards into Power BI
Now that Trello and Power BI are talking to each other, we need to give them something to talk about. To do this follow these instructions. Continue reading Getting Actual Trello Cards into Power BI
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 dog did nothing in the night-time. That was the curious incident” Sherlock Holmes
Q: What is data?
A: Data is everything.
That was the conclusion myself and a room full of Data Scientists came up with. Here was one exchange: Continue reading “The dog did nothing in the night-time. That was the curious incident” Sherlock Holmes
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)
