Product Line Profitability and Margin Performance Analysis for Nassau Candy Distributor: A Data-Driven Approach Using Exploratory Data Analysis and Interactive Dashboard

Author(s)	Ms. Geetha S
Country	India
Abstract	This study analyses product line profitability and margin performance for Nassau Candy Distributor using Python-based exploratory data analysis (EDA) and an interactive Streamlit dashboard. The dataset comprises 10,194 transactional records across 15 products in three divisions — Chocolate, Sugar, and Other — spanning January 2024 to December 2025. Key findings reveal that the Chocolate division dominates revenue at 92.88% share, while the Sugar division remains underutilised despite healthy margins. Pareto analysis confirms 5 of 15 products generate 80% of revenue, indicating significant concentration risk. The study delivers actionable recommendations for product portfolio rationalization, supplier cost renegotiation, and strategic pricing decisions.
Keywords	Gross Margin Analysis, Product Line Profitability, Pareto Analysis, Cost Structure Diagnostics, Exploratory Data Analysis, Streamlit Dashboard, Nassau Candy Distributor, Confectionery Distribution, Data Analytics, Business Intelligence
Field	Computer > Data / Information
Published In	Volume 7, Issue 3, May-June 2026
Published On	2026-05-25
DOI	https://doi.org/10.63363/aijfr.2026.v07i03.5984

About AIJFR Fees & Payment Current Issue Publication Archive	Submit Research Paper Track Submission Status Publication Guidelines Publication Ethics Peer Review & Plagiarism	Join as a Reviewer Editors & Reviewers Reviewer Referral Program Get Reviewer Membership Certi.	Website/Journal Policies Usage Policy Content Policies Privacy Policy

Contact Us		+91-9898-79-39-59	editor@aijfr.com

Advanced International Journal for Research