Supporting blog for placing Trello on Power BI. Continue reading Power BI and gaps in the Trello data (how to avoid)
Category Archives: Management
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)
Connecting Private Trello Board to Power BI (without the API)
In theory, any private Trello board will connect with Power BI by using the Trello API. In practice this can get quite technical and, frankly, off-putting. Continue reading Connecting Private Trello Board to Power BI (without the API)
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
Connecting Trello to Power BI for the first time
You have your Trello board. You have access to Power BI. You want to make the two of them talk.
Here we show how to do this utilising the Trello board as a JSON file. (Do not worry if you don’t know what a JSON file is.) Continue reading Connecting Trello to Power BI for the first time
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
A-Level business data: a contradiction in terms
I originally intended this post for data-practitioners, their bosses and those who are both. Based on the small but noisy response it got, I now know I was wrong: this applies to any erstwhile student who has ever managed or been managed. That’s quite a lot more people. Enjoy.
Continue reading A-Level business data: a contradiction in terms
