1M Shirisha, 2 C Eswar Charan, 3 I Adithya, 4 S Siddu, 5 J Adesh 03 09 The Pharmacy Sales and Inventory Trend Dashboard is designed to provide an interactive and efficient platform for analyzing pharmacy sales inventory levels and product trends The system collects and organizes pharmacy transaction data such as medicine names sales quantities prices stock levels purchase dates and sales dates The dashboard transforms this data into meaningful visual reports that help users understand sales performance and inventory movement Key indicators such as total sales total quantity sold available stock fastmoving medicines and lowstock products can be displayed through charts tables and summary cards Sales trends can be analyzed over different time periods to identify changes in customer demand and business performance Inventory analysis helps identify products that require restocking and medicines with slow or excess movement Productwise and categorywise analysis can also be used to compare sales performance across different medicine groups Interactive filters allow users to view information based on date product category or other relevant parameters The dashboard supports datadriven decisionmaking by presenting complex pharmacy data in a simple and understandable format It can help pharmacy managers improve stock planning monitor sales performance reduce inventoryrelated issues and identify important business trends Overall the project demonstrates how data visualization and analytical dashboards can be used to improve pharmacy sales and inventory management Copyright (c) Journal of Science Engineering Technology and Management Science. All rights reserved 2026