At first I thought this data set is quiet easy and will only require few measures for the analysis. But as soon as I stated looking at the data, I realized, it’s not that much easy.
Foe me the first challenge was to find latitude and longitude of states, which I did after lots of search and with help of Luca.
Secondly, I had to create quite a few measures to find out top defected vendor and vendor, material with top down time. At this stage I took some help of my brother @hafizsultan.
The last challenging part for this report was to show is there a relationship between top defected vendor and vendor with top down time?
after trying many visuals, matrix sorted out the issue.
I have put lot of hard work and time in this challenge and no doubt learnt a lot in my journey.