cleaning Data using MySQL

Role: Data Analyst

Description: Processed unstructured customer transaction data to uncover behavioral insights. Used MySQL for cleaning, then applied statistical techniques to group customers into segments.

Challenges and Solutions: Faced challenges with inconsistent employees’ IDs ,salaries , overtime, and mangers’ IDs, names ,salaries

I standardized identifiers, merged

data sources

, and applied clustering

analysis.

Results: Discovered three key

employees salaries