Weekend Work 010: Importing Excel and the basics of KPI’s

When you’re developing solutions in the real world you have to start somewhere often times that will be a pre-existing spreadsheet, often this takes time each week, month, day (please no) or hour (ok I quit), this time can be greatly reduced by setting Power BI up to import the spreadsheet and make it available. In this video we will go through what it takes to import a sample of data from a Finance system, this is a basic version of a process I have used many times to pull spreadsheets in when we first start the process of migration to Power BI with people and companies.

YouTube player
Taking Account

In last weeks video we investigated the concept that not every table within a Power BI file relates to data. This week we look at another “non-table”, true KPI’s are definitely not tables, but it does help to consider them as tables. In this video, we use Calculated Columns to create three columns, DaysSince, Towers and State, these allow us to use the Building information to populate a map of New York with buildings with Water Towers coloured by the times since their last inspection.

YouTube player

1 thought on “Weekend Work 010: Importing Excel and the basics of KPI’s”

Leave a Reply