🚨Quick Solution! When Acquired Data 'Rotten' 🚨

Dream Break! When I got the Excel file, I found it...The data is very messy! 😭

.

Before you start analyzing, you must always "clean up":

🔹 Delete null: Remove the incomplete part

🔹 Adjust Format: Date, Number. Must be the same format for the whole file.

🔹 Duplicate: Be careful of fake sales caused by repeated keying.

.

If the base is not tight, how beautiful the graph is can not be trusted! 🛑

# Data Cleaning # ExcelTips # BusinessAnalyst # Data analysis # Work like a pro