E-Commerce Sales Analytics and Interactive Business Intelligence Visualization System

Design a data visualization platform that analyzes e-commerce sales data to identify product trends, customer purchasing behavior, and revenue patterns. The system should provide interactive charts and dashboards to support small businesses in making data-driven inventory and marketing decisions.

Collect or simulate e-commerce sales dataset (products, orders, customers).

Design relational database schema.

Import and preprocess sales data.

Build backend APIs to retrieve sales metrics.

Implement dynamic filtering (date range, category, region).

Create visual KPIs (Total Revenue, Profit Margin, Orders Count).

Implement pie charts, bar graphs, and line charts.

Add search functionality for product/category.

Provide export feature for reports.

Conduct basic statistical analysis (mean, growth rate).

Test dashboard responsiveness.

Deploy using local server or cloud hosting.

Document system architecture and working.