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

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 listslabels 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