Cleaning, wrangling and summarizing. I don’t know about you but I enjoy this process of data analysis. Power Query is the main tool I use for this. I’ll be writing more about Power Query in the future.

I clean because the data is dirty. I clean because I want good data for analysis. I wrangle to get the right “shape” for joins to work. It’s dreadful if you have to clean data manually and it’s prone to cleaning errors. Imagine error on top of errors? What will you really be analyzing?

Don’t worry. Functions — much like those cute little robots on top can come to the rescue.

#data-visualization #data-science #programming #power-bi #data-analysis