Global Sales Insights Report - Tableau Project

---

Project maintained by Bo-Neau Hosted on GitHub Pages — Theme by mattgraham

Global Sales Insight Report for Anonymous Company (Wayne Trading Co.)

Executive Summary

Wayne Trading Co. has demonstrated resilience and profitability amidst challenging market conditions, including the tumultuous COVID-19 period. Through comprehensive analysis of key metrics and performance indicators, the company has not only weathered the storm but has also shown consistent growth and increasing profits year over year.

The Global Sales Overview provides a snapshot of the company’s robust performance, with total sales reaching an impressive $4,300,785 in 2022. Despite facing seasonal fluctuations, such as the significant sales drop observed in January compared to December, Wayne Trading Co. has maintained a strong foothold in the market.

Furthermore, the Order Efficiency Analysis underscores the company’s commitment to operational excellence, with efficient shipping operations and order processing dynamics. Despite challenges, the company has managed to optimize processes and maintain high customer satisfaction levels across diverse product categories and market segments.

Customer Segmentation Insights reveal Wayne Trading Co.’s strategic focus on catering to consumer preferences and demands, resulting in a sizable customer base and increasing sales figures. The company’s ability to identify and capitalize on market trends and regional variations has positioned it for continued growth and expansion opportunities.

Product Performance Insights shed light on the company’s product portfolio, highlighting the profitability of technology products and the popularity of top-selling items such as phones, copiers, and chairs. Through strategic pricing and marketing initiatives, Wayne Trading Co. has effectively maximized sales potential and capitalized on profitable product categories.

Lastly, the Post-Holiday Sales Analysis demonstrates the company’s agility in adapting to changing market dynamics and consumer behaviour. Despite seasonal challenges, Trading Co. has maintained a competitive edge through data-driven insights and proactive measures to mitigate sales fluctuations and optimize performance.

Global Sales Overview

The Global Sales Overview provides a comprehensive analysis of the company’s performance across various key metrics. At a glance, it showcases the company’s total sales, profit, and customer count for the year. The top left chart reveals that the total sales for 2022 amounted to a substantial $4,300,785, highlighting the company’s significant revenue generation over the year. Additionally, the top middle chart indicates a commendable profit of $504,411, reflecting the company’s ability to effectively manage costs and maximize profitability. Furthermore, the top right chart showcases the sizable customer base, with a total of 1,511 customers contributing to the company’s sales success.

Sales Trend

Delving deeper into the sales by quarter chart presenting a breakdown of sales by year, offering insights into seasonal trends and performance fluctuations throughout the years. December 2022 emerges as the month with the highest sales, reaching an impressive $1,500,000, while January registers the lowest sales at the start of every year, indicating potential areas for further analysis and strategic planning.

Performing and Non-Performing Products

Moving to sales by product illustration, it becomes evident that certain products have significantly outperformed others. Phones emerge as the top-selling product category, with sales reaching approximately over $1,500,000, underscoring their popularity and market demand. Conversely, labels exhibit the lowest sales figures, hovering around $50,000, suggesting potential areas for improvement or re-evaluation of product offerings.

Highest and Lowest Sales

Sales by country heat map provides insights into sales performance by country, shedding light on geographical variations in sales revenue. The United States emerges as the leading country, with sales exceeding $700,000, showcasing its significance as a key revenue generator for the company. Conversely, Canada records the lowest sales, totalling around $25,000, signalling potential opportunities for market expansion or targeted marketing strategies in this region.

Order Efficiency Analysis

The Order Efficiency Analysis provides valuable insights into the company’s shipping operations and order processing dynamics. Firstly, the scatterplot comparing shipping costs to sales by order priority reveals a weak positive relationship, suggesting that higher-priority orders incur slightly higher shipping costs. Conversely, the strong positive relationship observed between shipping costs and sales by product category indicates that certain product categories, such as furniture and technology, drive higher shipping costs due to their size or special handling requirements.

Do Consistency mean Efficiency?

Additionally, the consistent order processing times across different order priorities within main categories (furniture, office supplies, and technology) highlight the company’s operational efficiency in managing order fulfilment regardless of priority level.

However, the distribution of product sales paints a clear picture of customer preferences, with phones emerging as the top-selling category followed closely by copiers, chairs, and bookcases. Interestingly, office supplies emerge as the most ordered category despite phones driving the highest sales, indicating a potential area for further investigation.

Looking into the Future

Henceforth, the next step would involve a deeper dive into the underlying factors influencing shipping costs and sales within each product category. This could include analysing shipping methods and carriers, exploring pricing strategies, and assessing inventory management practices to identify opportunities for cost savings and revenue optimization. Additionally, optimizing order processing times for specific product categories, particularly furniture and technology, could further enhance operational efficiency and customer satisfaction.

Customer Segmentation Insights

Upon examining the Customer Segmentation Insights, the distribution of profit margin by customer segmentation indicates a remarkably consistent profitability across all segments, with each segment yielding around 12 percent profit margin. This suggests that the company has effectively managed costs and pricing strategies across diverse customer segments, ensuring profitability across the board.

Furthermore, the analysis of sales by customer segment reveals that the consumer segment emerges as the top performer, generating total sales exceeding 6.5 million. This underscores the significance of targeting and catering to consumer preferences and demands to drive revenue growth.

What is happening in EMEA, Africa and Canada?

Delving into regional sales distribution adds another layer of insight, with the APAC region emerging as the top sales contributor, generating a total of 3.5 million in sales. Despite a comparable customer count, the EMEA and Africa regions lag significantly behind in sales, suggesting potential opportunities for market expansion or targeted marketing efforts in these regions. Conversely, Canada stands out as having both the lowest customer count and sales volume, signalling the need for focused strategies to increase market penetration and drive sales growth in this market.

Next Phase

Moving forward, the next step would involve a more detailed analysis of customer preferences, behaviours, and satisfaction levels within each segment and region by conducting customer surveys, analysing purchasing patterns, and identifying opportunities for product diversification or customization to better meet the needs of diverse customer groups. Additionally, targeted marketing campaigns and sales promotions tailored to specific regions or segments could help capitalize on untapped market potential and drive revenue growth enhancing its competitive position in the market.

Product Performance Insights

Looking into Product Performance Insights, technology emerges as the most profitable category, boasting a robust profit margin of 13.98%. Meanwhile, office supplies also contribute significantly to the total profit, albeit with slightly lower margin. This highlights the importance of leveraging technology products to drive profitability, while also ensuring adequate attention to furniture to maintain a balanced revenue stream.

Top-Selling Products

Moving on to the top-selling products, it becomes apparent that phones, copiers, chairs, bookcases, storage, and appliances are the clear favourites among customers. This information serves as a valuable guide for inventory management and marketing efforts, enabling the company to prioritize these high-demand items in stock allocation and promotional campaigns to maximize sales potential and customer satisfaction

High Discount Rate, Low Sales, and Product with loss

Furthermore, the comparison of profit and discount rates by sub-category sheds light on areas of opportunity and challenge. While some products, like copiers and phones, demonstrate strong profitability alongside moderate discount rates, others such as paper and labels exhibit high profit margins despite low sales figures suggesting the need for targeted marketing initiatives to boost the visibility and appeal of these products among customers. Additionally, the discovery of loss-making products, such as tables, underscores the importance of scrutinizing cost structures and pricing strategies to rectify profitability issues and ensure sustainable business operations.

In the Ensuing Steps

Considering these findings, the next step for the company would involve a comprehensive review of its product management and pricing strategies. This could entail refining product offerings, optimizing pricing strategies, and implementing targeted marketing campaigns to capitalize on profitable products and address challenges in less-performing categories. Additionally, efforts should be directed towards identifying and rectifying cost inefficiencies to improve overall profitability and maintain a competitive edge in the market

Post-Holiday Sales Analysis

The Post-Holiday Sales Analysis provides crucial insights into the company’s sales dynamics during the transition from December to January each year. Firstly, the consistent pattern of significant sales drops in January compared to December highlights a seasonal trend that warrants attention. Despite efforts to boost sales post-holidays, the data suggests that January remains a challenging month for sales performance.

Do more discounts mean more sales?

Analysing the scatter plot of discount versus sales reveals a weak negative relationship between the two variables, indicating that higher discounts do not necessarily correlate with increased sales. This underscores the importance of carefully evaluating discount strategies and their impact on overall sales performance.

Delving into the average discount comparison, December 2019 stands out with the highest average discount rate, while January 2021 records the lowest. Interestingly, despite the lower average discount in January 2021 compared to December 2020, total sales still increased, indicating that other factors may be influencing purchasing decisions during this period.

Does January perform better every year?

Furthermore, the comparison of sales between December and January by product category unveils interesting trends. While products like phones, chairs, copiers, bookcases, and storage consistently exhibit above-average sales in both December and January, there is a notable drop in sales specifically in January for these items. Despite this, the overall trend shows a steady increase in total sales year over year, suggesting a broader upward trajectory in sales performance.

The analysis of sales comparison by market also reveals a consistent sales drop in January across all markets every year. Despite efforts to incentivize purchases through increased average discounts in January 2022, sales continue to decline. This suggests that market-specific factors may be at play and require further investigation.

Analysing the cause for the future

Moving forward, the next step would involve a deeper dive into the underlying reasons behind the January sales drop and the impact of discount strategies on consumer behaviour conducting customer surveys, analysing market trends, and exploring alternative promotional tactics to mitigate the seasonal decline in sales. Additionally, leveraging advanced analytics and predictive modelling techniques could help forecast sales patterns more accurately and inform targeted strategies to optimize sales performance during the post-holiday period.