Business Intelligence: A Web-based Business Intelligence System For Real-time Retail Analytics, Demand Forecasting, And Risk Management

Abstract

Small And Medium Retail Businesses Frequently Face Operational Difficulties Related To Inventory Management, Stock Monitoring, Demand Estimation, And Financial Reporting. Most Shop Owners Rely On Manual Records Or Entry-level Billing Software That Can Generate Invoices But Offer No Analytical Insight Into Business Performance. BI-Mart Is Proposed As A Web-based Business Intelligence Platform Developed To Address These Challenges. The System Is Built Using React.js For The Frontend, PHP REST APIs For Backend Services, And MySQL For Data Storage. It Incorporates Over Twenty Functional Modules Including A Performance Dashboard, Demand Forecasting, Risk Alert Generation, Expiry Tracking, GST Report Automation, And Customer Segmentation. The Demand Forecasting Module Processes The Past Ninety Days Of Sales Records And Applies A Day-of-week Multiplier To Estimate Product Demand For The Coming Thirteen Weeks. A Risk Scoring Mechanism Evaluates Stock Levels, Expiry Timelines, And Profit Margins To Classify Products Into Risk Categories. Results Confirm That BI-Mart Provides Small Retailers With Clear And Actionable Business Insights To Support Efficient And Informed Decision-making.

Keywords