$1.$Data Model Design with javascript:

$$Design a MongoDB schema to store customer profiles, transactions, and products. Your schema should be efficient and support quick queries for analysis.

$$Requirements:

$$A$$Customer$$collection with information like$$customer$\_$id$,$name$,$email$,$phone$,$loyalty$\_$status, and$$created$\_$at$.$

$$A$$Transaction$$collection to track each purchase. Each document should include fields like$$transaction$\_$id$,$customer$\_$id$,$products$($array of product items$),$total$\_$amount,$$date$,$and$$store$\_$location.

$$A$$Product$$collection that stores$$product$\_$id$,$name$,$category$,$price$,$and$$brand$.$

$$Design considerations for managing$$high cardinality fields$$like product categories and customer locations.

$2.$Data Ingestion:

$$Write a script $($Python$,$Node$.$js$,$or MongoDB shell$)$to insert sample data into MongoDB for $500$customers$,$ each with $100$transactions$.$

$$Each transaction should include $1-5$product items, selected randomly from a product catalog.

$3.$Query Development:

$$Create MongoDB queries to support the following business requirements:

$$Customer Insights: Query the total spending per customer, sorted by highest to lowest.

$$Top Products: Identify the top $10$most frequently purchased products.

$$Purchase Trends: Aggregate monthly spending trends across all customers for the last $12$months$.$

$$Customer Segmentation: Segment customers based on their spending behavior:

$$High Spenders: Customers who spend over $$5,000$annually$.$

$$Frequent Buyers: Customers who have made more than $50$purchases in the last $12$months$.$

$$Infrequent Buyers: Customers who have fewer than $5$transactions$.$

$$Indexing: Identify and create indexes that will optimize query performance.

$4.$Aggregation Pipeline for Reporting:

$$Design an aggregation pipeline to create a report that shows:

$$The average transaction amount per customer.

$$Most popular categories by total sales.

$$Percentage of revenue by loyalty status $($e$.$g$.,$Gold$,$Silver$,$Bronze$).$

$5.$Data Visualization Recommendations$($Bonus$)$:

$$Propose MongoDB$-$compatible BI tools or front$-$end frameworks that could be used to visualize the data on a customer insights dashboard.

$$Describe a few example visualizations $($e$.$g$.,$bar charts for top products, line graphs for monthly spending trends$).$