Online Store Data Cleaning and Analysis

Performed data cleaning and analysis for an online store dataset using Microsoft Excel and Power Query.

Key tasks included:

• Removing duplicate records

• Handling missing and inconsistent data

• Standardizing data formats

• Organizing customer and sales information

• Preparing clean datasets for analysis

• Creating summary reports and insights

The project improved data quality and helped transform raw sales and customer data into a structured format suitable for reporting and decision-making.

Tools Used:

Microsoft Excel, Power Query, Data Cleaning, Data Validation, Data Analysis