Pete Moore writes about data
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.
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.
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.
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.)
This is what a Trello board looks like as JSON
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.
You don’t have access to this dashboard
This invitation contains dashboards, reports or data outside of your organisation that cannot be viewed
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.
Not an Expert, as I read it, means someone attaining a rarefied level of knowledge by servicing a wide diaspora of other’s needs. A person who acts as intermediary between the natural and supernatural [technical] worlds to attain a wide knowledge.
As I built the data model I realised that I was modelling nothing less than humanity itself.
Databackwriter Blog