Dealing with gaps in the Trello data (SQL vs NoSQL)
Category Archives: Management
Power BI and gaps in the Trello data (SQL vs NoSQL)
Dealing with gaps in the Trello data (SQL vs NoSQL)
Connecting Private Trello Board to Power BI (without the API)
Within Power BI press Get Data but instead of choosing Web, choose JSON. Upload the file you just exported.
From this point on the file will behave exactly as the web connected version with the downside that it is not 100% live. To refresh the data, you would need to export back over the top of the original file.
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.
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.)
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.
A-Level business data: a contradiction in terms
Teachers want to see your method because they need to know you’re doing it right. Your boss needs to be able to assume this.