This project explores four years of sales data (2015-2018) for a global retail store, focusing on sales trends and profitability. Using Power BI, I built an interactive dashboard that uncovers key trends across different years, regions, product categories, and shipping methods:


First, I checked the Column Quality on the Power Bi query which shows the percentage of missing, errors, and valid values. The results seemed to be valid as all columns appeared fully green and were 100% accurate. However, as I proceeded to check each column using the dropdown filter. I found 11 nulls on the Postal Code.

Therefore, I create a conditional column to indicate these 11 missing values as “invalid” and the rest as “valid”.


Next, I discovered that the Order and Shipping Dates were stored in Text, resulting in a visualisation error. Thus, I transformed the data type from ‘Text’ to ‘Date’ by using Locale.