Sales Data Analysis Project (CSV import & data cleaning)
Imported and prepared large CSV sales datasets for analysis by cleaning invalid entries, duplicates, nulls, and inconsistent date formats. Structured the cleaned data into appropriate MySQL table schemas and ensured fields were analysis-ready for querying. This preparation enabled consistent sales trend, customer behavior, and revenue metric analysis. • Imported large CSV files into MySQL (LOAD DATA INFILE) • Cleaned invalid values, duplicates, nulls, and inconsistent dates • Designed structured tables with appropriate data types • Prepared cleaned datasets for dashboard visualization