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: 123rf.com
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?