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
