This repository contains a comprehensive data analysis and strategic recommendations report for Global Electronics, a leading retailer in the consumer electronics industry. The project involves data cleaning, preprocessing, exploratory data analysis (EDA), and actionable insights derived from customer, product, sales, and store data. The report includes detailed analyses, visualizations, and recommendations to enhance marketing strategies, optimize inventory management, improve sales forecasting, guide product development, and inform store expansion and operational decisions.
- Enhance customer satisfaction
- Optimize operations
- Drive overall business growth
- Identified key customer segments and their purchasing patterns.
- Recognized top-performing products and stores.
- Highlighted the impact of currency exchange rates on sales.
- Tailor marketing campaigns to specific customer segments.
- Optimize inventory based on sales trends.
- Improve international pricing strategies to maximize profits.
Data_Spark.ipynb: Jupyter Notebook containing the data cleaning, preprocessing, and analysis steps.Data_spark.docx: Comprehensive data analysis and strategic recommendations report.Datasets/: Folder containing the raw and cleaned datasets used in the analysis.Visualizations/Data_spark.pbix: Folder containing visualizations and dashboards created during the analysis.Data_spark_Sql_Query.docx: File containing SQL queries used in the analysis.README.md: Detailed project overview and instructions.
Ensure you have the following software installed:
- Python 3.x
- Jupyter Notebook / VS code
- Required Python libraries: pandas, numpy, matplotlib, seaborn
To get a local copy up and running, follow these simple steps: