Amazon Product Review Analysis. AMAZON is company that provides e-commerce analytics solutions to sellers on their platforms . our team has been tasked with analyzing product and customer review data to generate insights that can guide product improvement, marketing strategies, and customer engagement. #Case Study 1: Amazon Product Review Analysis
Case Study 1: Amazon Product Review Analysis
- Company Overview As a Junior Data Analyst working at RetailTech Insights, a company that provides e-commerce analytics solutions to sellers on platforms like Amazon. Your team has been tasked with analysing product and customer review data to generate insights that can guide product improvement, marketing strategies, and customer engagement.
- Dataset Description The dataset contains information scraped from Amazon product pages, including: • Product details: name, category, price, discount, and ratings • Customer engagement: user reviews, titles, and content • Each row represents a unique product, with aggregated reviewer data stored as comma-separated values Total Records: 1,465 rows TotalFields: 16 columns
- Analysis Tasks Use pivot tables and calculated columns where necessary to answer the following:
- What is the average discount percentage by product category?
- How many products are listed under each category?
- What is the total number of reviews per category?
- Which products have the highest average ratings?
- What is the average actual price vs the discounted price by category?
- Which products have the highest number of reviews?
- How many products have a discount of 50% or more?
- What is the distribution of product ratings (e.g., how many products are rated 3.0, 4.0, etc.)?
- What is the total potential revenue (actual_price × rating_count) by category?
- What is the number of unique products per price range bucket (e.g., <₹200, ₹200–₹500, >₹500)?
- How does the rating relate to the level of discount?
- How many products have fewer than 1,000 reviews?
- Which categories have products with the highest discounts?
- Identify the top 5 products in terms of rating and number of reviews combined.
- Final Task: Dashboard Creation Using your cleaned dataset and pivot outputs, build an Excel dashboard. Unleash your Creatives NB; The objective of the project is to analysis the product performance and secondly the customer view about the product, that is feedback from the customer about the product.
###DATA ANALYSIS SOLUTION/OUTPUT;
-
What is the average discount percentage by product category? £3,125,31
-
How many products are listed under each category? The product listed under categories are: 54 products are listed under categories.
-
What is the total number of reviews per category? The total number of review per categories is : 1465
-
Which products have the highest average ratings? The products that have highest average rating is Campfire Spring Chef Prolix Instant Port , rating figure; 4.7
-
What is the average actual price vs the discounted price by category? The average actual price is 84788.53 vs discounted price per categories is 147720.6 Therefore sum total is ; 232509.1
-
Which products have the highest number of reviews? The product that have Highest Number of Review is ; 12 count review. (7SEVEN® Compatible Vu Smart Tv Remote)
-
How many products have a discount of 50% or more? The product that has the discount of 50% and above or more are; 1265 product have a discount of 50% and more
-
What is the distribution of product ratings (e.g., how many products are rated 3.0, 4.0, etc.)? The distribution of the product rating are;
-
What is the total potential revenue (actual_price × rating_count) by category? The potential revenue by category are, Actual price by category; 7976911.28 Rating count by category: 267663777 Total potential revenue is; (7976911.28*267663777) =275,640,688,28
-
How does the rating relate to the level of discount? The rating relate to the level of discount by increases the level of demand and supply, The discount reduced the price of product to crease a room for more selling, to sell more product. While rating place the product in the most sort after and the product that is on high demand, product customer are frequency demand on daily basic., For example. Computers&Accessories|Accessories&Periph was rating 1580.6 Because of the discount percentage of 213.3. the more discount on a product the more the rating increase,
-
How many products have fewer than 1,000 reviews? The total number of products that have fewer than 100 reviews area: 54 categories of product,
-
Which categories have products with the highest discounts? The category of product with the Highest discount is : ( Electronics|HomeTheater,TV&Video|Television )1608017 discount.
-
Identify the top 5 products in terms of rating and number of reviews combined. The Top 5 product in terms of rating are: Ambrane Unbreakable 60W / 3A Fast Chargi 7 28 Fire-Boltt Ninja Call Pro Plus 1.83" Sma 5 21 Ambrane 60W / 3A Fast Charging Output Ca 5 20 boAt Wave Call Smart Watch, Smart Talk w 5 19 SanDisk Ultra® microSDXC™ UHS-I Card, 4 17.6 AmazonBasics New Release Nylon USB-A to 4 17.4 Fire-Boltt Phoenix Smart Watch with Blue 4 17.2
RECEOMMENDATION/CONCLUSION; The total number of 1,465 unique customer data were extracted from amazon database, purposely to study the product performance level, improve production and make customer satisfaction in their indoor, There 53 categories if product out of the 1,465 unique customers, The categories of product that were in high demand top 5 area,
1, Electronics|HomeTheater,TV&Video £2,620,347.00 £1,608,017.00 2.Electronics|Mobiles&Accessories|Smartpho £1,419,754.00 £1,086,799.00 3.Home&Kitchen|Heating,Cooling&AirQuality| £685,442.00 £373,789.61 4.Electronics|WearableTechnology|SmartWatc £650,162.00 £177,817.00 5.Home&Kitchen|Kitchen&HomeAppliances|Smal £579,344.00 £337,756.14
The types of product under these categories are: 1 Electronics /Home Theater TV&Video,:61product(2,620,347,00) 2. Electronics Mobile Accessories smart: 70 product:1,418,754,00 3. Home &kitchen: 115 product( 685,442,00) 4, Electronics WearableTechnology: 39 product(650,162,00) 5, Home&kitchen : 177 product(579,344,00)
Therefore, the management should pay more attention to the Top 5 categories of product, to maximalise more revenue, There should be a more market strategy to locate more customer base, 0,5% discount can also be added to the top 5 product to attract more revenue. Bonanza also can be considered
