Sales Analysis Dashboard built using Power BI
While working on this task, the data cleaning phase was the most challenging and honestly, the most rewarding part!
I encountered different types of missing data, both numeric and text.
To handle them effectively, I applied statistical techniques I’ve been developing throughout my learning journey:
For numeric missing values → I used the average to maintain realistic patterns.
For text missing values → I used the mode or replaced them with ‘unknown’ depending on the context.