Authors: Tosif Raza Mansoori
Abstract: In the modern business environment, organizations generate large volumes of transactional data that contain valuable information regarding profitability, operational efficiency, product performance, and market behavior. However, extracting meaningful insights from raw datasets remains a significant challenge. Business Intelligence (BI) and Data Analytics techniques provide effective solutions by transforming data into actionable information that supports strategic decision-making. This research presents a comprehensive Product Line Profitability and Margin Performance Analysis Dashboard developed for Nassau Candy Distributor. The primary objective of this project is to evaluate the profitability of product lines, analyze revenue distribution, identify high-performing products, assess regional performance, and provide business recommendations through data visualization. The dashboard was developed using Python and Streamlit, while Pandas, NumPy, Matplotlib, and Seaborn were utilized for data preprocessing, statistical analysis, and visualization. Several analytical techniques including Key Performance Indicator (KPI) evaluation, profitability analysis, division-wise performance assessment, revenue analysis, and Pareto Analysis were implemented to uncover business insights. The developed dashboard enables stakeholders to monitor revenue, profit, cost, margin percentage, and product performance through interactive visualizations. The findings demonstrate that a limited number of products contribute significantly to overall profitability, confirming the applicability of the Pareto Principle in business analytics. The proposed solution provides a scalable and user-friendly analytical framework that assists management in making informed business decisions related to pricing, inventory planning, product portfolio optimization, and strategic growth initiatives.
