Supply Chain Intelligence & Sales Performance

By abhishek.verma75000 · April 8, 2026

The analysis uncovers critical patterns in supplier performance, product demand, and sales distribution. A high concentration of revenue among top…

The analysis reveals which suppliers offer the most diverse product portfolios based on unique item counts. A horizontal bar chart has been generated showing the top 20 suppliers ranked by the number of unique items they supply, making it easy to compare portfolio breadth at a glance.

The analysis compares total retail and warehouse sales across different item types. A grouped bar chart has been generated showing side-by-side comparisons, making it easy to see which item types dominate in retail versus warehouse channels. Data tables are also available with the detailed breakdown for each category.

A pie chart has been generated showing the percentage contribution of each item type to total retail sales. The chart gives a clear visual breakdown of how different product categories compare in terms of their share of overall retail revenue.

The analysis successfully identified the top 20 strongest revenue-driving items by retail sales. A horizontal bar chart has been generated showing each item's total retail sales, with the highest performers clearly visible at the top. The items are color-coded using a blue gradient scale, making it easy to spot the biggest contributors at a glance.

The analysis identifies which suppliers have the highest warehouse-to-retail sales ratio, a key indicator of distribution inefficiency. A bar chart has been generated showing the top 20 suppliers with the most imbalanced distribution — where warehouse sales significantly outpace retail sales. Suppliers at the top of the chart are moving proportionally more product through warehouses than retail channels, suggesting potential bottlenecks in getting goods to end consumers.

The top 5 suppliers account for 59.7% of total revenue, generating $4,754,405 out of a total $7,963,867. This represents a significant concentration risk — more than half of all revenue is tied to just 5 suppliers. A pie chart has been generated showing the revenue share breakdown between the top 5 suppliers and all others.

The analysis produced two interactive bar charts and supporting data tables that reveal which item types drive the most retail transfers — a key indicator of demand rebalancing across locations. The first chart shows total retail transfers broken down by item type, while the second compares retail transfers against warehouse sales and retail sales side by side for full context.

The analysis identified 3 items that have high warehouse sales but low retail sales, suggesting they move well through wholesale/warehouse channels but underperform at the retail level. Two visualizations were generated to help explore this pattern across all products.

The analysis identified 579 unique items with negative retail or warehouse sales values, which typically indicate product returns or accounting adjustments. In total, there are 100 records with negative retail sales and 620 records with negative warehouse sales. Two visualizations were generated to help explore these findings.

The analysis successfully identified the 10 suppliers with the lowest total retail sales and generated a horizontal bar chart visualizing their performance. The chart uses a red color scale to highlight the weakest-performing suppliers, making it easy to spot which partnerships may need attention.

The analysis identified the top 20 suppliers with the highest average retail sales per item, highlighting those with premium product performance. A horizontal bar chart has been generated showing all 20 suppliers ranked by their average retail sales, making it easy to compare performance across suppliers.

The analysis successfully identified items with high retail transfers relative to warehouse sales, which signals supply chain reallocation activity. A bar chart and supporting data tables have been generated showing the top 20 items ranked by their transfer-to-warehouse ratio. Items with a high ratio are moving more units between retail locations than they are selling directly from the warehouse — a strong indicator of inventory rebalancing across the supply chain.

The analysis identified the top 3 best-selling items within each item type based on total retail sales. A horizontal bar chart has been generated showing these top performers, grouped and color-coded by item type, making it easy to compare the leading products across categories. Data tables are also available with the detailed breakdown.

Here are the analysis results. Check the visualizations and data below.

The sentiment analysis of the 'ITEM DESCRIPTION' column reveals that the vast majority of descriptions are neutral in tone. A bar chart was generated showing the sentiment distribution across all entries.

A word cloud has been successfully generated from the 'ITEM DESCRIPTION' column in your dataset. The visualization displays the most frequently occurring words, with larger text indicating higher frequency terms.