Borrow brains if you can

Updated: Feb 15

I enjoy starting my posts with a quote. Did you notice this?

We should not only use the brains we have but all that we can borrow.” - Woodrow Wilson

Well, what else can I say?

It was a very small dataset and the company wanted a dashboard that showed base compensation to employees.

picture credit:

Let's just say that I borrowed Power BI's brains and created this simple dashboard. This was not before I cleaned the data. #PowerBi

Some basic but useful tips when cleaning data

  • Check the data format for each column

  • Remove duplicate values

  • If a column contains numbers and the numbers are skewed to the left, chances are the data format is wrong.

  • Numbers are typically skewed to the right while text, to the left.

what would you do differently if you are given small dataset?

35 views0 comments

Recent Posts

See All