Amazon Product Review Dashboard
Project Overview Data analysis project that contains Excel dashboard analysis of an E-commerce product dataset (Amazon).The data set involves; Product rating,discounts,Customer's reviews across various products categories, product pricing and discount behaviour. Amazon case study data.xlsx
Data Source Digital Skill Africa (DSA) Dataset provided for project File Analyzed: Amazon case study.xlsx
Author Agboola Samuel Godwin Email: samuelagboola019@gmail.com
Tools Used
- Microsoft Excel 2019
- Pivot tables & charts
- Conditional formatting
Data Cleaning Tools
- Proper case formatting
- Catergory simplification with Delimeters
- Converted currency text into numbers
- Discount Calculations
- Evaluated Price range Buckets
Questions Answered
- 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 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.
Dashboard Features
- Amazon data overview
- Average discount % by product category
- Top 5 products in terms of rating number of reviews
- Average actual price vs the discounted price by category
- Products with discount of 50% or more
- Total potential revenue (actual_price × rating_count) by category
- Number of unique products per price range bucket
Contact
Agboola Samuel Godwin
Data Analyst| Nigeria
Email: samuelagboola019@gmail.com
GitHub: @sammieplays19