The goal of this project is to analyze and understand customer purchasing behavior, identify popular product categories, and uncover sales trends in an online retail store. It covers several phases of data analysis.
-
The data preparation stage.
- This is the first stage of my data analysis project. At this stage, I downloaded my dataset from kaggle and imported it into Mysql for cleaning and analysis.
-
The data cleaning and manipulation stage.
- This is the second stage of my data analysis project. At this stage, I removed duplicates, identified and corrected inaccuracies, Null and empty cells, inconsistencies, and errors in my dataset to improve its quality and reliability.
-
Data Transformation and Feature Engineering
- At this stage, I transformed the raw data into a more usable format for analysis and created new columns that can provide insights into customer behavior.
-
Data Analysis and Visualization.
- This is the fourth stage of my project and at this stage, I Analyzed customer behavior: Identifying trends, patterns, and key metrics. And Visualized the data: Creating charts and graphs to understand the data more intuitively.