I work with data but I look for truth. Let me explain: Below is an example of a datum: 42
Category Archives: Excel
Power BI and gaps in the Trello data (how to avoid)
Dealing with gaps in the Trello data (SQL vs NoSQL)
Power BI and gaps in the Trello data (SQL vs NoSQL)
Dealing with 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.
Building a Trello Data Model in Power BI
Lists and labels and cards and checklists need to know about what cards they belong to, the labels need to know to which cards they relate.
Getting Actual Trello Cards into Power BI
This is cool because it means that we have drilled into the data. Next we need to turn this into a table that we can work with.
Linking Trello to Power BI – Overview
This is what a Trello board looks like as JSON
How to: Measure Trello with Power BI
A fundamental tenet of the lean methodology is that you measure. As enterprises large and small move to a lean start-up principles they are using Trello to facilitate this. Here we use Power BI to measure Trello.
“The dog did nothing in the night-time. That was the curious incident” Sherlock Holmes
That is, the discussion has become about the box the data comes in, not the toy itself. Data, however could not be more strategic. We apply context to data and we get information. We apply context to information and we get knowledge. We all know what comes next.
The best way for a business to think of its data, then, is as a strategic resource.
The glory years of Excel (and how to recreate them)
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.
