Welcome to the Eniacs Discounts Analysis project! In this repository, we aim to analyze the effectiveness of offering discounts on products for Eniacs, a fictional company. The project involves assessing various aspects related to discounts, product categorization, and their impact on sales and revenue.
The company is facing a dilemma regarding the implementation of discounts. While the Marketing Team Lead advocates for discounts, emphasizing their potential benefits in customer acquisition and satisfaction, the main investors are concerned about the impact of aggressive discounts on overall revenue and market positioning. Our task is to provide clarity on these issues through data analysis.
To address the concerns and provide insights to the company board, we'll focus on answering the following questions:
- How should products be classified into different categories to simplify reports and analysis?
- What is the distribution of product prices across different categories?
- How many products are being discounted, and what is the magnitude of these discounts as a percentage of product prices?
- How do seasonality and special dates (Christmas, Black Friday) affect sales?
- How could data collection be improved?
Before diving into the business questions, it's crucial to ensure the quality of our dataset. The provided data seems to have inconsistencies, possibly due to issues in data pipelines or encoding. Hence, we'll invest time in data cleaning to make it usable and reliable for analysis.
This repository contains the following files:
- Presentation: - A PDF presentation summarizing the analysis and insights.
- Jupyter Notebook: - A Jupyter Notebook containing Python code for data cleaning, analysis, and visualization.
The Jupyter Notebook provided in this repository includes the following sections:
- Data Loading: Loading necessary datasets for analysis.
- Data Cleaning: Preparing the data for analysis by handling inconsistencies and missing values.
- Exploratory Data Analysis: Exploring various aspects such as product categories, pricing distribution, discounts, and sales trends over time.
- Insights and Visualization: Providing visualizations and insights to address the business questions effectively.
Through this analysis, we aim to provide valuable insights to help Eniacs make informed decisions regarding discount strategies and overall business direction. For any questions or further discussions, feel free to reach out.
Let's dive into the data and uncover meaningful insights together!