L o a d i n g

Amazon Sales Dashboard

Unlock Hidden Insights: Transforming Amazon Data into Actionable Intelligence

Category :
E-commerce
Powered by :
YBAISolution
Tool Used :
Power BI
Designer :
Bhrami Zadafiya

The dataset used for this Amazon Dashboard is a combination of real-time scraped data from Amazon and synthetic data generated for enhanced analysis. It encompasses a wide range of information to provide comprehensive insights. The Product Information section includes details such as product name, category, brand, price, and customer ratings, offering a clear view of product performance. The Sales Data covers daily, weekly, and monthly sales volumes, revenue figures, and order counts, enabling in-depth sales trend analysis. Additionally, the Profit & Loss Data provides critical financial insights, including cost price, selling price, and profit margin analysis to help identify revenue drivers and areas of potential loss. Lastly, the Customer Insights section captures valuable information from customer reviews, ratings, and feedback trends, which aids in understanding customer preferences and improving product offerings. This diverse dataset forms the backbone of the dashboard, enabling data-driven decision-making and strategic business growth.


Column Names Description Data Type
Product name Title of the product listed on Amazon String
New_Price Current selling price of the product Float
Old_price Original price before discount Float
Discount Percentage or value of discount applied Float
Ratings Average product rating (e.g., out of 5) Float
Helpful Number of helpful votes for the reviews Integer
Total_ratings Total number of customer ratings received Integer
discount_cost Total cost attributed to discounts given Float
product_cost Cost to produce or acquire the product Float
marketing_and_other Cost spent on marketing and other associated expenses Float
profit Net profit from product sales Float
Product Review Textual customer review content String
Old_Price_Revenue Revenue calculated using old (original) price before discount Float