Chart Analysis-and BI+AI+GenAI+Viz+23.pdf

It s about BI

1. Chart 1
The provided Tableau visualization is a line chart depicting yearly sales trends over different
months across multiple years.
Analysis of the Line Chart:
• Business Question:
How have sales trended over time, and are there any seasonal patterns?
• Key Insights:
• Sales exhibit a seasonal pattern with noticeable peaks in October, November, and December
across all years.
• The highest spikes in sales tend to occur in Q4, likely due to holiday shopping, corporate
purchases, or end-of-year budget spending.
• Year-over-year (YoY) sales growth is visible, with 2024 showing higher peak values than
previous years.
• March and June also exhibit some intermediate spikes, suggesting potential marketing events
or sales promotions driving revenue.
• January and July tend to be lower sales months, which could indicate periods of reduced
customer spending or seasonal downturns.
Potential Business Actions:
1. Leverage Q4 sales peaks:
• Run targeted holiday promotions or end-of-year discounts to maximize revenue.
• Ensure inventory levels are high to meet peak demand.
2. Address off-season sales dips (January, July):
• Introduce mid-year campaigns or special offers to boost sales during traditionally low-
performing months.
• Consider expanding into complementary product lines that perform well in those months.
3. Forecast inventory and staffing needs:

2. • Use this historical sales trend to better forecast demand, ensuring stock availability for peak
months.
• Plan workforce scheduling accordingly to manage customer demand efficiently.

Chart 2
The provided Tableau visualization is a bar chart that represents profit by product category
and sub-category.
Analysis of the Profit by Product Category Chart
• Business Question:
Which product categories and sub-categories contribute most to overall profitability, and which
ones are unprofitable?
• Key Insights:
• Technology is the most profitable category, with Copiers ($56,094) and Machines ($45,051)
generating the highest profits.
• Office Supplies also perform well, especially Paper ($34,512) and Binders ($31,426).
• Furniture has mixed profitability:
• Chairs ($27,224) and Furnishings ($13,892) contribute positive profits.
• Tables show a significant loss of ($17,753), indicating a potential pricing, cost, or demand issue.
• Some sub-categories show negative profitability, including:
• Storage (-$1,127)
• Bookcases (-$3,632)
• Tables (-$17,753)
• Copiers, Paper, and Binders are high-margin products, making them priority items for sales
focus.
Potential Business Actions
1. Optimize Pricing & Cost for Low-Profit Products

3. • Investigate why Tables, Bookcases, and Storage are unprofitable—whether it’s due to high
costs, low margins, or excess discounting.
• Consider re-evaluating pricing or sourcing cheaper materials for these products.
2. Leverage High-Profit Products
• Increase promotions and sales efforts for high-margin products like Copiers, Machines,
Paper, and Binders.
• Bundle these items with complementary products to drive additional revenue.
3. Reassess Inventory Management
• If low-profit sub-categories are slow-moving, reduce inventory levels to avoid unnecessary
holding costs.
• For high-profit items, ensure stock availability to meet demand without shortages.
4. Category-Specific Strategies
• Technology and Office Supplies should be the main focus for growth.
• Furniture category needs a turnaround strategy, particularly for Tables and Storage solutions.
Chart 3
The provided Tableau visualization is a text table (crosstab) displaying average discount,
average profit, average sales, and quantity sold by product sub-category.
Analysis of the Text Table:
• Business Question:
How do discount rates impact profitability and sales across different sub-categories?
• Key Insights:
• High Discounted Items Often Have Lower Profits:
• Tables (25.81% discount) have a negative profit (-$54), indicating excessive discounting may
be eroding margins.
• Bookcases (21.53% discount) also have negative profitability (-$16).

4. • Machines (30.43% discount) show moderate profit ($30), despite high average sales
($1,623).
• Highly Profitable Sub-Categories with Lower Discounts:
• Copiers (15.71% discount) have the highest profit per unit ($801), suggesting high-margin
sales.
• Phones (15.26% discount) and Accessories (7.85% discount) also generate good profit
margins.
• High-Sales, Low-Profit Items:
• Binders (36.91% discount) have high sales volume (6,071) but low profitability ($20).
• Envelopes and Labels, with moderate discounts (~7-8%), generate minimal profits.
• Loss-Making or Underperforming Sub-Categories:
• Supplies (-$6 profit) and Tables (-$54 profit) need attention as they are not contributing
positively to the bottom line.
• Despite higher discounting, their sales figures do not justify the profitability loss.
Potential Business Actions:
1. Reduce Deep Discounts on Loss-Making Products
• Tables and Bookcases are receiving very high discounts but are not profitable. Re-evaluating
pricing strategies or supplier costs could improve margins.
2. Maintain Pricing Power on High-Profit Items
• Copiers, Phones, and Accessories should be kept at steady pricing with moderate discounting
to retain high profit margins.
3. Reassess Inventory for Poor Performers
• If sub-categories like Supplies and Tables have consistently negative profit margins, consider
reducing stock levels or repositioning these products with different pricing.
4. Analyze Sales Elasticity of High-Volume, Low-Profit Products
• Products like Binders and Envelopes may be selling well due to discounts, but profitability is
very low. Experimenting with a slightly lower discount might retain sales while improving
margins.

5. Chart 4
The provided image is a heatmap visualization in Tableau, displaying average quantity of items
sold across different states and sub-categories.

Analysis Based on the Heatmap
• Business Question:
How do product sub-categories perform across different states in terms of quantity sold?
• Answer (Insight):
• The darker shades indicate higher average quantities sold, while the lighter shades indicate
lower sales in that state.
• Certain states (e.g., California, Texas, Florida) may show higher average quantities across
multiple sub-categories, suggesting stronger market demand.
• Office Supplies (like Binders, Paper, and Art Supplies) appear to have consistently higher
average quantities sold across multiple states.
• Some states (e.g., District of Columbia, Idaho) may show lower average quantities, potentially
indicating a smaller market size or lower demand for those product categories.
• Furniture and Technology sub-categories generally show lower quantity sales compared to
Office Supplies, but exceptions may exist for high-demand products like Chairs or Copiers in
specific states.
Potential Business Actions
• Inventory Optimization: Allocate higher stock levels for top-selling sub-categories in high-
performing states.
• Sales and Marketing Strategy: Focus on promotional campaigns in states where specific sub-
categories underperform.
• State-Level Strategy: Identify low-demand states and investigate potential causes (pricing,
competition, logistics).
Chart 5

6. The provided Tableau visualization is a map chart that represents sales distribution by
geographic location (state/province) across the United States.
Analysis of the Sales Map:
• Business Question:
Which states contribute the most to total sales, and where should we focus our marketing and
expansion efforts?
• Key Insights:
• Larger circles indicate higher sales volume, with states like California, New York, and Texas
showing the largest sales figures.
• Smaller circles in Midwest and Southern states suggest lower sales activity, indicating either
lower demand or weaker market penetration.
• Sales appear to be concentrated in high-population urban areas, particularly along the East
Coast, West Coast, and some major metropolitan hubs in the Midwest.
• Sparse sales presence in regions like Montana, Wyoming, and the Dakotas may indicate
either a lack of market penetration or a naturally lower demand.
Potential Business Actions:
1. Focus Marketing and Expansion on High-Sales Regions
• Strengthen advertising and promotional efforts in states with already strong sales, such as
California, New York, and Texas, to maximize revenue potential.
2. Identify and Address Weak Performing Regions
• Conduct further analysis into why some states have low sales—is it due to lack of distribution,
marketing, or demand?
• Consider new regional partnerships, localized advertising, or better logistics to improve sales
in underperforming areas.
3. Optimize Supply Chain and Logistics
• Ensure that distribution centers are well-positioned to meet high-demand areas efficiently.
• Explore whether long shipping times or higher costs in certain regions are affecting customer
purchasing behavior.

7. 4. Personalized Regional Strategies
• If high-sales states prefer specific product categories, tailor the inventory accordingly.
• Consider offering location-based promotions or pricing adjustments to attract buyers in
lower-performing states.
Chart 6
The provided Tableau visualization is a filled map (choropleth map) displaying profit
distribution across different states in the U.S. and Canada.
Analysis of the Profit Map:
• Business Question:
Which states generate the highest and lowest profits, and where should we focus on improving
profitability?
• Key Insights:
• Most Profitable States:
• California ($457,688), Texas ($170,188), and Washington ($138,641) have the highest profits.
• These states likely have strong demand and efficient operations, making them key areas for
business growth.
• Moderately Profitable States:
• Wisconsin ($32,115), Indiana ($53,555), and Colorado ($32,108) also show positive profits
but with room for growth.
• Low-Profit or Negative-Profit States:
• Some states, like Mississippi ($-10,771) and New Mexico ($4,784), show relatively lower
profits.
• Negative profits (highlighted in orange) indicate that certain states may have higher costs,
lower sales, or excessive discounting.
• Geographical Trends:
• The West Coast (California, Oregon, Washington) and Southern states like Texas and
Florida are generally profitable.

8. • The Midwest and some Southern states (Mississippi, Kansas, and South Carolina) show
lower or negative profit margins, possibly due to lower demand or higher operational costs.
Potential Business Actions:
1. Expand in Highly Profitable States
• Strengthen marketing and sales strategies in California, Texas, and Washington, where
profitability is high.
• Increase product offerings or premium pricing in these regions to maximize revenue.
2. Investigate Low-Profit States
• Identify why some states are less profitable—is it due to high operational costs, low sales, or
excessive discounts?
• Optimize pricing strategies, logistics, and targeted promotions to improve profitability.
3. Reduce Losses in Negative-Profit Areas
• Mississippi and other loss-making states need further analysis:
• Are discounts too high?
• Are shipping costs affecting profitability?
• Are competitors dominating these markets?
4. Compare Profitability with Sales
• Some states with high sales might not be the most profitable due to higher costs.
• Cross-check with the sales map to identify high-revenue but low-profit areas and adjust pricing
accordingly.
Chart 7
The provided Tableau visualization is a stacked bar chart, comparing sales and profit across
different segments (Consumer, Corporate, Home Office) over multiple years (2021-2024).
Analysis of the Stacked Bar Chart:
• Business Question:
How do sales and profit vary across customer segments and product categories over time?

9. • Key Insights:
• Consumer and Corporate Segments Drive Higher Profits:
• In 2024, the Consumer segment shows the highest profit ($25,902) and sales ($350,000+),
indicating it is a strong revenue driver.
• The Corporate segment also performs well but is slightly lower in sales and profit compared to
Consumer.
• Home Office Segment is Less Profitable:
• The Home Office segment consistently shows lower profit margins, with negative profit (-
$645) in 2023 and a very low figure in 2024.
• This could indicate higher discounts, lower-margin products, or higher costs associated with
this segment.
• Technology Category is the Most Profitable:
• The yellow bars (Technology) contribute the highest profit share, suggesting that Technology
products yield better margins compared to Furniture and Office Supplies.
• Furniture Faces Profitability Challenges:
• In some segments and years, Furniture (blue bars) has lower or negative profit values.
• 2023 and 2024 show cases where Furniture in Home Office results in losses, signaling a need
for price adjustments or cost control.
• Steady Growth Over Time:
• Overall, both sales and profit have increased year-over-year from 2021 to 2024.
• 2024 has the highest profit and sales figures, confirming that business performance is
improving.
Potential Business Actions:
1. Target Marketing & Sales Towards Consumer and Corporate Segments
• These two segments show the highest revenue and profit generation.
• Invest more in targeted promotions, loyalty programs, and premium product offerings for
these customer types.

10. 2. Investigate Home Office Segment Issues
• Profitability is weak, with some years showing negative profits.
• Assess if Home Office customers are getting excessive discounts or if operational costs are
too high.
3. Prioritize High-Margin Products (Technology)
• Technology is consistently the most profitable category.
• Increase focus on selling more high-margin technology products, bundling them with Office
Supplies and Furniture to improve overall profitability.
4. Improve Furniture Category Performance
• Since Furniture occasionally shows low or negative profit, investigate:
• Whether pricing adjustments are needed.
• If supplier costs can be reduced.
• If alternative product bundling strategies could help boost margins.
5. Plan for Seasonal and Long-Term Growth
• Since sales and profits are trending upward over the years, ensure proper inventory planning
and supply chain efficiency to meet rising demand.

Chart 8
The provided Tableau visualization is a stacked line chart, displaying sales (black line) and
profit (red line) trends over time for different customer segments (Consumer, Corporate,
Home Office).
Analysis of the Stacked Line Chart:
• Business Question:
How do sales and profit trends vary across different customer segments over time?
• Key Insights:

11. • Sales and profit generally trend upward across all segments, with frequent peaks and
troughs, likely indicating seasonality in customer purchases.
• Consumer segment has the highest sales and profit, consistently outperforming Corporate and
Home Office.
• Corporate segment follows a similar pattern but at a lower magnitude, showing steady
growth but with slightly lower fluctuations.
• Home Office has the lowest sales and profit, and in some periods, profit drops close to zero,
indicating weaker margins or possible losses.
• Spikes in sales do not always correspond to proportional spikes in profit, suggesting that
some sales surges may be driven by discounts or low-margin products.
Potential Business Actions:
1. Leverage Consumer Segment Growth
• Since Consumer sales and profits are growing, invest in marketing, promotions, and
customer engagement programs to capitalize on this growth.
• Ensure inventory and fulfillment efficiency to support peak sales periods.
2. Improve Corporate Segment Margins
• While Corporate sales are strong, profit margins seem lower than expected.
• Consider optimizing pricing, reducing discounts, or offering bundled product solutions to
increase profitability.
3. Revitalize Home Office Performance
• The Home Office segment shows weaker profitability trends, suggesting a need for:
• Better pricing strategies
• More targeted marketing
• Operational cost reductions
4. Analyze Seasonal Peaks
• Since sales spikes are visible at certain points (likely Q4 holiday seasons, year-end
purchases, or promotional periods):

12. • Plan targeted discount strategies during peak seasons.
• Ensure sufficient stock availability for high-demand periods.
5. Investigate Profitability Drivers
• The gap between sales and profit trends suggests that some high sales periods are not
generating enough profit.
• Conduct a deeper margin analysis to identify low-profit items or customer segments causing
revenue leakage.
Chart 9
The provided Tableau visualization is a discrete line chart, showing quantity trends over time
for different customer segments (Consumer, Corporate, Home Office) from 2021 to 2024.
Analysis of the Discrete Line Chart:
• Business Question:
How does product quantity ordered fluctuate across customer segments over time?
• Key Insights:
• Overall Quantity Trends:
• The Consumer segment consistently orders the highest quantity, with a strong upward trend,
especially in 2024 where it reaches 1,055 units in December.
• The Corporate segment follows a similar pattern but at lower volumes, peaking at 530 units
in December 2024.
• The Home Office segment has the lowest order quantities, staying below 400 units throughout
the timeline.
• Seasonality Observed:
• Each year sees spikes in certain months (August-December), suggesting seasonal purchasing
behavior.
• The highest order quantities often occur in Q4 (October-December), likely due to holiday or
year-end business purchases.
• Sharp Growth in 2024:

13. • Significant spikes in orders across all segments in 2024, particularly in November and
December, suggest increased demand or successful sales campaigns.
• Fluctuations Across Years:
• Some months show sudden drops, particularly in early months (January-February), indicating
possible seasonal slowdowns.
Potential Business Actions:
1. Capitalize on Q4 Sales Spikes
• Since demand peaks in October-December, optimize inventory, logistics, and marketing
campaigns during these months.
• Ensure stock availability to meet high order volumes.
2. Expand Sales in Slower Months
• Address January-February slowdowns by launching promotional discounts or new product
offerings.
• Consider targeted outreach to Corporate and Home Office segments, which may have lower
seasonal fluctuations.
3. Leverage the Consumer Segment’s High Demand
• Since Consumers order the most, focus marketing efforts on personalized promotions,
bundling, and loyalty programs.
• Maintain adequate stock levels for fast-moving Consumer products.
4. Analyze Product-Specific Demand
• Further break down the quantity trends by product category to identify which items are
driving peak order periods.

Chart 10
The provided Tableau visualization is an area chart, displaying quarterly sales and profit
trends over time from 2021 to 2024.
Analysis of the Area Chart:

14. • Business Question:
How have sales and profit evolved over time on a quarterly basis?
• Key Insights:
• Consistent Growth Over Time:
• Sales and profit show a steady increase across quarters, indicating business expansion and
rising demand.
• Q4 each year experiences a peak, suggesting a seasonal trend in purchasing behavior (likely
due to year-end or holiday sales).
• Sales are Growing, but Profitability Varies:
• The highest sales recorded are in Q4 2024 ($287,104), with the highest profit ($29,018).
• However, some quarters have relatively high sales but lower profits, suggesting margin
fluctuations due to discounting, pricing, or cost factors.
• Quarterly Fluctuations:
• Every year, sales and profit tend to drop in Q1 and Q2, indicating a slow start to the year.
• Q3 and Q4 typically show higher sales and profits, reinforcing seasonal buying patterns.
• Most Profitable Quarters:
• Q4 2023 ($236,745 sales, $38,195 profit) was one of the strongest periods.
• Q4 2024 outperformed all previous quarters, making it the best-performing quarter overall.
• Lowest Performing Quarters:
• Q1 2022 ($70,392 sales, $9,555 profit) had one of the weakest sales and profit figures.
• Q1 and Q2 of each year consistently underperform compared to Q3 and Q4.
Potential Business Actions:
1. Leverage Q4 Peaks:
• Since Q4 consistently outperforms other quarters, increase marketing efforts and inventory
planning for that period.

15. • Consider special promotions, bundling, and targeted discounts to further maximize Q4 sales.
2. Boost Performance in Q1 & Q2:
• Since Q1 and Q2 are slower periods, introduce new promotions or targeted outreach to
Corporate customers to maintain steady revenue.
• Analyze which product categories sell well in early months and develop targeted marketing
campaigns.
3. Optimize Profit Margins:
• While sales are growing, profitability does not always increase proportionally.
• Investigate whether discounts, high-cost logistics, or low-margin products are affecting
certain quarters.
• Adjust pricing or product focus to improve profit margins.
4. Inventory and Resource Allocation:
• Plan inventory levels and staffing based on seasonal demand trends.
• Ensure high-demand products are well-stocked in Q3 & Q4, while adjusting procurement
for Q1 & Q2 slowdowns.

Chart 11
The provided Tableau visualization is a stacked area chart, displaying quantity shipped over
time, segmented by Ship Mode.
Analysis of the Stacked Area Chart:
• Business Question:
How does the quantity of shipments vary by shipping mode over time?
• Key Insights:
• Steady Growth in Shipments Over Time:
• There is an overall increasing trend in shipment quantity, indicating business growth or higher
order volumes.

16. • Significant spikes appear in September and November, suggesting seasonal peaks in
demand (likely due to holiday or end-of-year purchases).
• Fluctuations in Monthly Shipment Quantities:
• There is a notable dip in February, possibly indicating a post-holiday slowdown or lower
consumer demand.
• The largest surge in shipments occurs in November and December, reinforcing a year-end
sales rush.
• Ship Mode Distribution:
• The largest portion of shipments is represented by the bottom (green) section, likely
indicating that Standard Class is the most used shipping method.
• Other shipping modes, such as Express and First Class (smaller yellow and blue portions),
account for fewer shipments.
• The proportion of faster shipping options increases slightly during peak months, suggesting
that customers may opt for quicker deliveries during high-demand periods.
Potential Business Actions:
1. Plan for Seasonal Peaks (September - December)
• Since shipments spike in these months, ensure logistics and warehouse teams are well-
prepared.
• Increase inventory levels ahead of peak demand to avoid stockouts and delivery delays.
2. Optimize Shipping Costs and Strategies
• Standard shipping is the most used mode, but explore ways to balance cost and delivery speed.
• Consider offering promotions for faster shipping modes (e.g., First Class or Express) during
peak months.
3. Address Off-Season Slumps (February)
• Since February has the lowest shipment volumes, consider running targeted promotions or
discounts to stimulate demand.
• Offer special shipping incentives to encourage off-season purchases.
4. Improve Shipping Efficiency

17. • Analyze whether the shipping network can handle peak demand smoothly, ensuring on-time
deliveries during spikes.
• Work with logistics partners to optimize rates and service levels, particularly for high-traffic
months.
Chart 12
The provided Tableau visualization is a Combo Chart (Bar and Line Chart), showing profit
(bars) and sales (line) trends over the years 2021 to 2024.
Analysis of the Combo Chart:
• Business Question:
How have sales and profit evolved over time, and what is their relationship?
• Key Insights:
• Sales show a steady upward trend from 2021 to 2024, indicating business growth.
• Profit has also increased overall, but the rate of increase is not proportional to sales, suggesting
fluctuations in margins, costs, or discounting strategies.
• 2022 shows a slight dip in sales, while profit remains stable, indicating a possible price
adjustment or cost control measures taken in that year.
• The biggest jump in both sales and profit occurs between 2023 and 2024, suggesting higher
demand, successful marketing efforts, or operational efficiencies.
Potential Business Actions:
1. Sustain Sales Growth While Improving Margins
• Since sales are growing steadily, but profit is not increasing at the same rate, analyze:
• Cost of goods sold (COGS) and operational expenses.
• Discounting strategies and their impact on profit margins.
2. Identify Key Drivers Behind Profit Growth
• Determine which product categories, regions, or customer segments are contributing the
most to profit.
• Increase focus on high-margin products and profitable customer segments.

18. 3. Optimize 2024 Strategy for Maximum Profit
• Since 2024 has the highest sales and profit, identify what worked well (pricing, promotions,
demand increase).
• Expand those successful strategies in 2025.
4. Address Sales Drop in 2022
• Investigate why sales dipped slightly in 2022:
• Was there reduced market demand, inventory shortages, or competition impacts?
• Learn from this and implement corrective measures to avoid similar trends.
Chart 13
Analysis of the Tree Map (First Image)
• Business Question:
Which product sub-categories contribute the most to total quantity sold?
• Key Insights:
• Binders, Phones, and Paper account for the largest share of total quantity sold, indicating high
customer demand.
• Storage and Art supplies also have a significant presence, suggesting frequent purchases in
office-related categories.
• Smaller sections represent low-quantity-selling sub-categories such as Machines, Copiers,
and Supplies, which might indicate either lower demand or higher pricing limiting sales
volume.
• This visualization does not account for profitability, meaning some high-selling sub-
categories might have low margins.
• Potential Business Actions:
1. Maintain Inventory for High-Demand Items
• Ensure that Binders, Phones, and Paper remain well-stocked to meet demand.
2. Assess Profitability of High-Volume Items

19. • Investigate whether high-selling items contribute proportionally to profit.
3. Increase Marketing for Low-Selling Categories
• Items like Copiers and Machines may require better promotions or price adjustments.
Chart 14
Analysis of the Bubble Chart (Second Image)
• Business Question:
Which states contribute the most to total order volume?
• Key Insights:
• California (2,001 orders) and New York (1,128 orders) dominate order volume, suggesting
strong customer presence and market share in these states.
• Texas, Pennsylvania, and Illinois also contribute significantly to total orders.
• Smaller states like Oregon, Kentucky, and Delaware have relatively few orders, indicating
either lower market penetration or lesser demand in those regions.
• Potential Business Actions:
1. Focus More Marketing and Sales Efforts on High-Order States
• Since California and New York drive the most orders, invest in localized promotions and
regional supply chain improvements.
2. Expand Reach in Low-Order States
• Investigate why Oregon, Delaware, and Wisconsin have fewer orders—possibly due to
distribution challenges or limited awareness.
3. Optimize Supply Chain for High-Order Regions
• Ensure faster shipping and warehouse efficiency in high-order states like California, Texas,
and New York to reduce delivery costs and times.

Chart 15
Analysis of the Box Plot (First Image)

20. • Business Question:
How do sales distributions vary across different product categories?
• Key Insights:
• The median sales are relatively similar across Furniture, Office Supplies, and Technology,
indicating a consistent central tendency across all categories.
• Technology has the highest upper range, suggesting that some large transactions
significantly contribute to total sales.
• The spread (IQR) of sales is widest in Technology, meaning that sales amounts in this
category fluctuate more than in Office Supplies or Furniture.
• Outliers are present, indicating some exceptionally high sales values, particularly in the
Technology and Office Supplies categories.
• Office Supplies and Furniture have tighter distributions, meaning their sales values are more
consistent compared to Technology.
• Potential Business Actions:
1. Investigate High Variability in Technology Sales
• Understand whether high-value transactions come from a few large orders or if there are
recurring patterns in demand.
2. Leverage Consistency in Office Supplies and Furniture
• Since these categories have a stable sales distribution, optimize inventory management and
pricing strategies to improve profitability.
3. Analyze Outliers for Large Sales Transactions
• Identify which specific products in the Technology category contribute to large sales spikes
and target promotions accordingly.

Chart 16
Analysis of the Circle Chart (Second Image)
• Business Question:

21. How do sales metrics (Max, Average, Min) vary across different segments and product categories?
• Key Insights:
• Technology consistently has the highest maximum sales across all customer segments,
indicating that it drives large purchases.
• Office Supplies have lower maximum sales but relatively stable average sales, showing
steady customer demand.
• Home Office segment has the lowest minimum sales values, suggesting that this segment
makes smaller purchases compared to Consumer and Corporate segments.
• Consumer and Corporate segments have more evenly distributed sales, while Home Office
sales appear more sporadic.
• Different marker shapes represent different sales metrics, allowing easy identification of
high-value and low-value transactions per category and segment.
• Potential Business Actions:
1. Boost Large Sales in Technology Category
• Since Technology has the highest max sales, offer bulk purchase incentives to encourage large
transactions.
2. Encourage Home Office Segment to Increase Order Size
• Since Home Office has low minimum and average sales, target it with bundled product
promotions or volume-based discounts.
3. Maximize Office Supplies Sales Stability
• As Office Supplies show consistent average sales, maintain steady inventory levels and ensure
supply chain efficiency to meet demand.


Chart 17
Analysis of the Circle Chart (First Image)
• Business Question:

22. How does product category performance vary in terms of sales volume?
• Key Insights:
• The larger circles indicate higher sales volumes, meaning high-demand products like
Binders, Furnishings, and Phones contribute the most to overall sales.
• Some sub-categories have smaller circles, indicating lower sales volumes, which could be
due to lower demand or higher price points.
• Office Supplies categories like Binders and Paper have significant sales volumes, likely due
to frequent purchases in bulk.
• Furniture categories, such as Chairs and Tables, show more variation, suggesting that some
large transactions drive their sales rather than consistent demand.
• Potential Business Actions:
1. Leverage High-Sales Items for Growth
• Products with high volume (Binders, Phones, Furnishings) should be the focus for promotions
and inventory optimization.
2. Investigate Low-Sales Items
• Identify whether lower-volume items have pricing or marketing issues that prevent higher
sales.
3. Analyze Sales Trends Over Time
• Determine if seasonality impacts certain sub-categories and adjust inventory planning
accordingly.




Chart 18
Analysis of the Gantt Chart (Second Image)
• Business Question:

23. How do shipping statuses vary over time, and are there trends in shipping delays or early
shipments?
• Key Insights:
• The three categories (Shipped Early, Shipped Late, and Shipped On Time) are displayed
across multiple years (2021-2024).
• Shipping on time is the most common status, suggesting that logistics performance is stable.
• Late shipments are minimal, which means customers are receiving their orders within
expected delivery timeframes.
• Early shipments appear in smaller numbers, which could mean that there is room for
optimizing inventory and logistics to improve faster deliveries.
• Potential Business Actions:
1. Improve Shipping Speed and Reliability
• Since most shipments are on time but rarely early, explore faster logistics solutions for
competitive advantage.
2. Minimize Late Shipments Further
• Although delays are minimal, analyze if specific products or regions experience higher delays.
3. Monitor Yearly Trends in Shipping Performance
• Track changes in shipping efficiency over time and adjust fulfillment strategies accordingly.




Chart 19
Analysis of the Profit by State/Province Chart
• Business Question:

24. Which states or provinces contribute the most to overall profitability, and where are the biggest
profit losses?
• Key Insights:
• California dominates in total profit, significantly outperforming all other states.
• British Columbia, Illinois, and Florida also contribute positively, but at much lower levels
compared to California.
• Several states show minimal or negative profitability, suggesting either low sales volume or
excessive discounting/cost issues.
• Some states (e.g., Mississippi, Idaho, and Montana) appear to be weak performers,
indicating underpenetrated markets or unprofitable business operations.
• There are significant variations in profit margins across states, which could be due to
regional pricing strategies, customer preferences, or cost variations.
Potential Business Actions:
1. Double Down on High-Profit States (e.g., California, Illinois)
• Increase marketing efforts and product availability in top-performing states to further
expand profitability.
• Analyze customer preferences in these states and align sales strategies accordingly.
2. Address Low or Negative Profit States
• Identify reasons for low profitability in underperforming states:
• High shipping or distribution costs?
• Excessive discounts?
• Low sales volume?
• Adjust pricing, marketing, or operational efficiencies in these regions to improve profit
margins.
3. Expand in Mid-Performing States
• Some states, like Massachusetts and Michigan, have moderate profit levels but could grow
further.

25. • Focus on localized marketing and regional partnerships to boost sales and optimize costs.
4. Optimize Pricing and Cost Structures
• Investigate cost drivers (transportation, supplier pricing, local competition) that may be
affecting profitability in different states.
• Experiment with regional pricing models to see if certain adjustments can maximize profit per
unit sold.