Exploratory Data Analysis and Visualization of Amazon Sale Report Dataset using Tableau

Mohammed Maaz AliUG Scholar, Department of AI&DS, Methodist College of Engineering and Technology, Hyderabad, IndiaP.Ricky AaronUG Scholar, Department of AI&DS, Methodist College of Engineering and Technology, Hyderabad, IndiaSulaiman AhmedUG Scholar, Department of AI&DS, Methodist College of Engineering and Technology, Hyderabad, IndiaDiana MosesProfessor, Department of CSE, Methodist College of Engineering and Technology, Hyderabad, India

Vol 10 No 6 (2026): Volume 10, Issue 6, June 2026 | Pages: 46-54

International Research Journal of Innovations in Engineering and Technology

OPEN ACCESS | Research Article | Published Date: 06-06-2026

doi Logo doi.org/10.47001/IRJIET/2026.106004

Abstract

This analysis examines an Amazon India e-commerce dataset covering transactions recorded across April, May, and June 2022, spanning major shipping destinations across various Indian states and cities. The dataset captures key attributes including Order ID, Date, Status, Fulfilment, Product Category, Size, Quantity, Amount, and Shipping Locations, forming a structured foundation for evaluating multi-dimensional retail and logistics performance.

The "Set" category emerges as the highest revenue-generating product segment, followed closely by Kurtas, while individual items like Western Dresses and Tops contribute the least to overall revenue. Geographically, Maharashtra leads in both total revenue and order quantity, with major urban shipping hubs like Bengaluru, Hyderabad, and Mumbai pulling in the heaviest distribution volumes.

Logistical behavior analysis reveals that Merchant Fulfilled Network (MFN) and Fulfillment by Amazon (FBA) channels dictate the flow of order delivery, while status monitoring shows a strong majority of successfully shipped orders alongside a trackable segment of cancellations and returns. Time-based tracking reveals notable fluctuations in transaction velocity, highlighted by a gradual decline in sales amounts over daily cycles.

These findings highlight key regional performance disparities, category demand shifts, and operational volume trends, offering a data-driven foundation for improving inventory planning, catalog management, and supply chain strategies in the e-commerce sector.

Keywords

E-Commerce Analytics, Amazon India Dataset, Retail Data Analysis, Sales Performance Analysis, Consumer Purchasing Behavior, Product Category Analysis, Order Management, Supply Chain Analytics, Logistics Performance, Fulfillment by Amazon (FBA), Merchant Fulfilled Network (MFN), Inventory Management.


Citation of this Article

Mohammed Maaz Ali, P.Ricky Aaron, Sulaiman Ahmed, & Diana Moses. (2026). Exploratory Data Analysis and Visualization of Amazon Sale Report Dataset using Tableau. International Research Journal of Innovations in Engineering and Technology - IRJIET, 10(6), 46-54. Article DOI https://doi.org/10.47001/IRJIET/2026.106004

References
HAO, ONGQI. Incorporate Machine Learning in Analyse Amazon Sales Datasets to Improve Operational Strategy. Diss. Universiti Tunku Abdul Rahman, 2025.

Mishra, Monika, et al. "Big data predictive analysis of Amazon product review." KSII The 14th Asia Pacific International Conference on Information Science and Technology, APIC-IST, KSII, Beijing, China. 2019.

Woo, Jongwook, and Monika Mishra. "Predicting the ratings of Amazon products using Big Data." Wiley Interdisciplinary Reviews: Data Mining and Knowledge Discovery 11.3 (2021): e1400.

Alrumiah, Sarah S., and Mohammed Hadwan. "Implementing big data analytics in e-commerce: Vendor and customer view." IEEE Access 9 (2021): 37281-37286.

Haque, Tanjim Ul, Nudrat Nawal Saber, and Faisal Muhammad Shah. "Sentiment analysis on large scale Amazon product reviews." 2018 IEEE international conference on innovative research and development (ICIRD). IEEE, 2018.

Shubina, Ekaterina, and Violeta Cvetkoska. "Understanding the Drivers of Frequent Purchases on Amazon: Factors Influencing Online Shopping Behaviour." International Journal of Business Research Management (IJBRM) 16.2 (2025): 21-30.

Chen, Ben, et al. "Influential Factors in Increasing an Amazon products Sales Rank." arXiv preprint arXiv:2411.04305 (2024).

Zhang, Rongrong. "Research on the application of machine learning in business analytics: Cases of Amazon and eBay." Applied and Computational Engineering 51 (2024): 59-65.

Ghosal, Indrajit, and K. Balaji. "The Process of Providing Security Protection in the Amazon E-Commerce System." Journal of E-Commerce Security 4 (2022): 1-7.

Houda, Bessachi, Bouazza Sabrine, and Habbiche Wahiba. "Strategic Analysis of Artificial Intelligence Application in Marketing: Amazon as a Model." (2025).