This dataset provides a comprehensive overview of various UK Amazon grocery products. It captures vital statistics such as sales figures, revenue, ratings, and other essential metrics.
Product Details: A description of the grocery product. ASIN: Amazon Standard Identification Number. Brand: Brand of the product. Price: Price of the product. Sales: Number of units sold. Revenue: Total revenue generated from the product. BSR: Best Seller Rank on Amazon. FBA Fees: Fulfillment By Amazon fees. Active Sellers : Number of active sellers for the product. Ratings: Average customer rating. Review Count: Number of customer reviews. Review velocity: The number of reviews added in a specified time frame. Buy Box: The seller who currently has the "Buy Box" for the product. Category: The category of the product on Amazon (e.g., Food Cupboard, Drinks). Size Tier: Size classification for the product. Delivery: Delivery method. Weight: Weight of the product. Creation Date: The date when the product was added to Amazon.
- Analysing and clearing data with Pandas
- Evaluation by years
- Creating various views and assigning them to the staging layer
- Sending the created tables to DWH and performing their data analysis using data visualization
- Python
- Pandas
- SQL
- MsSQL
- Visual Studio 2022
- Microsoft PowerBI
