<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Bolaji Olatunji on Medium]]></title>
        <description><![CDATA[Stories by Bolaji Olatunji on Medium]]></description>
        <link>https://medium.com/@bolajiolatunji41?source=rss-5e9b57733d2f------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/0*pmRlAGImJj3Xr-Qd</url>
            <title>Stories by Bolaji Olatunji on Medium</title>
            <link>https://medium.com/@bolajiolatunji41?source=rss-5e9b57733d2f------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sun, 22 Nov 2026 01:32:33 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@bolajiolatunji41/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Behind The Numbers: What Four Years of Sales Data Reveal About Olatunji and Sons Ltd.]]></title>
            <link>https://medium.com/@bolajiolatunji41/behind-the-numbers-what-four-years-of-sales-data-reveal-about-olatunji-and-sons-ltd-dea000992277?source=rss-5e9b57733d2f------2</link>
            <guid isPermaLink="false">https://medium.com/p/dea000992277</guid>
            <category><![CDATA[business-communication]]></category>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[business-intelligence]]></category>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[data-analysis]]></category>
            <dc:creator><![CDATA[Bolaji Olatunji]]></dc:creator>
            <pubDate>Sat, 21 Nov 2026 20:48:12 GMT</pubDate>
            <atom:updated>2026-11-21T20:48:12.239Z</atom:updated>
            <content:encoded><![CDATA[<p><em>Revenue is up 48% since 2010, but a few product lines and one region are quietly eating the gains.</em></p><h3>1. Introduction</h3><p>Every business owner knows their sales number. Far fewer know where their profit actually comes from, or where it quietly leaks away.</p><p>Olatunji and Sons Ltd. runs a superstore which sells products spanning three categories: <strong>Technology</strong>, <strong>Office Supplies</strong> and <strong>Furniture</strong>. Between 2010 and 2014, it recorded <strong>₦8.95M in sales</strong>, <strong>₦1.31M in profit</strong>, and <strong>130,000 units sold</strong> to <strong>2,703 customers</strong> across four regions.</p><p>This is a four-page Power BI report on top of the company’s transactional data. The model is a classic star schema: a fact table of order lines connected to dimensions for customers, products, locations, managers, returns and dates. It includes measures for total sales, profit, quantity, return rate, average days to ship and year-on-year growth.</p><p>The four pages are an <strong>Executive Summary</strong>, a <strong>Summary/Product Report, a Profit Analysis</strong> and a <strong>Time Intelligence Report</strong>. This article walks through what they show, what is going wrong, and what management should do about it.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*aYbOSTwQK-U_2ePjqfxWQA.png" /></figure><p><em>Figure 1: Executive Summary dashboard. Profit, sales and quantity by product category, with monthly profit over time.</em></p><h3>2. Problem Statement</h3><p>The management had a reasonable question: <strong>“Sales are growing. Is the business actually profitable and healthy?”</strong></p><p>Headline revenue can hide a lot. A company can grow sales every year while margins thin out, while one category subsidises another, or while returns and shipping costs erode what is left. Without a structured view, three questions were going unanswered:</p><p>• <strong>Where does profit really come from?</strong> Which categories, products and regions earn their keep, and which do not?</p><p>• <strong>Is growth sustainable?</strong> How does performance move across years, quarters and months, and how dependent is the business on a single season?</p><p>• <strong>What is leaking value?</strong> How do returns, discounting, delivery and fulfilment affect the bottom line?</p><p>The goal of this analysis is to turn raw transactions into a decision-ready picture and to end with specific, measurable actions and decisions.</p><h3>3. Insights</h3><h3>3.1 The big picture: growing and getting more efficient</h3><p>The company has grown every year. Sales rose from ₦1.92M in 2010 to ₦2.85M in 2013, and the pace is accelerating: <strong>+1.05%</strong> in 2011, <strong>+14.72%</strong> in 2012 and <strong>+27.87%</strong> in 2013.</p><p>Profit grew faster than sales. It more than doubled from ₦213K to ₦447K, lifting the overall profit margin from <strong>11.1% to 15.7%</strong>. That is a healthy sign. It means growth has not been bought entirely with discounts.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*I2XBssPqahyPy2EMCfs5QA.png" /></figure><p><em>Figure 2: Time Intelligence report. Year-on-year sales comparison and monthly sales trend.</em></p><p>Operations look tight too. Orders ship in an average of <strong>2 days</strong>.</p><h3>3.2 Sales do not equal profit: the Furniture problem</h3><p>This is the report&#39;s single most important finding.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/952/1*Q_5v6zqrfzbwlCzwiJpMQA.png" /></figure><p><em>Figure 3: Product Category Performance</em></p><p><em>Furniture generates 36% of company sales but only 14% of its profit.</em></p><p>Furniture is the company’s second-largest category by revenue, yet it earns a margin of just 5.6%, against roughly 20% for the other two. The Product Report’s side-by-side bars make the gap obvious: the profit bar for Furniture is barely visible next to its sales bar.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*9NwvJj4dsE6dF3eYL5Y8pA.png" /></figure><p><em>Figure 4: Summary/Product report. Headline KPIs, sales vs. profit by category, and the top 10 products by quantity.</em></p><h3>3.3 Geography: the South underperforms</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*i71_C8tuRIwAgcZQzfHygA.png" /></figure><p><em>Figure 5: Profit Analysis report. Profit margins, average discounts and regional performance.</em></p><p>Central is the engine of the business. The South produces 18% of sales but only 8% of profit, which is a margin about one-third of Central’s.</p><h3>3.4 Discounts bite</h3><p>Order lines discounted by up to 5% earn a margin of about 17.7%. Lines discounted between 5% and 10% earn only <strong>10.6%</strong>. A few extra points of discount cost roughly seven points of margin, and it is applied to a large share of the business (₦3.81M of sales).</p><h3>3.5 Seasonality: the business peaks at the end of the year.</h3><p>Both time-series charts show the same shape every year: a long, flat first half, then a sharp climb from August. <strong>October to December generate about 40% of annual sales</strong>, and November alone contributes 16% (₦1.43M across the four years).</p><p>The two biggest profit peaks in the Executive Summary are November 2012 (<strong>₦109K</strong>) and November 2013 (<strong>₦102K</strong>). The weakest stretch is early 2010, including a <strong>₦30K loss in March 2010</strong>. February to April typically bring in only about a third of November’s sales. This shows that sales activities peak at the end of the year; the company needs to increase production planning and inventory preparation ahead of the anticipated year-end demand. There is also a need to investigate the reasons for the loss in March 2010.</p><h3>3.6 Customers and returns</h3><p>• <strong>Returns are high.</strong> The Return Rate stands at <strong>17.34%</strong> (1,634 returned order lines out of 9,426). Roughly one in six lines comes back, which means extra handling, restocking and lost goodwill.</p><p>• <strong>Volume leaders are low-ticket items.</strong> Office Supplies sells 71.54K units (55% of all units) at a ~20% margin. Items such as Avery 510 (428 units), wall clocks, fax modems and DVD-RAMs top the quantity chart.</p><h3>4. Recommendation</h3><p>The data points to profitability problems, not demand problems. Five actions, in rough order of impact:</p><p>1. <strong>Fix Furniture economics first.</strong> Review supplier cost and list price for Tables and Bookcases, then reprice, renegotiate or delist the worst performers. Lifting Furniture’s margin from 5.6% to even 10% would add about <strong>₦140K</strong> of profit at current volumes.</p><p>2. <strong>Run a South region turnaround.</strong> Investigate its product mix, discounting and delivery costs. Set a margin target and review it quarterly, using Central’s 20.5% as the benchmark.</p><p><strong>3. Put guardrails on discounting.</strong> Require approval for discounts above 5%, and track margin after discount as a standard KPI, not just revenue</p><p>4. <strong>Plan for Q4, and smooth the rest of the year.</strong> Pre-position inventory and staffing for October to December, and use targeted promotions, corporate contracts or bundles to lift the February to April trough.</p><p>5. <strong>Attack returns and protect key accounts.</strong> There is a need to break the 17.34% return rate down by product, supplier and ship mode to find root causes, and set a target. The company should also launch a retention programme for the top customers.</p><h3>5. Conclusion</h3><p>Olatunji and Sons Ltd. is a growing, efficient business. Sales are up 48% in four years, margins have improved from 11% to nearly 16%, and orders ship on average in two days.</p><p>But the headline hides a leaky bucket. Furniture, the South, heavy discounts and loss-making products together hand back close to half of what profitable lines earn, and the business leans on a single season for 40% of its revenue.</p><p>The good news is that these problems are specific, measurable and fixable. Revenue is not the constraint; margin discipline is. A company that can sell ₦8.95M of goods has the demand it needs. The next chapter is about keeping more of every naira it sells.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=dea000992277" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[International Breweries Sales Performance Analysis (2017–2019)]]></title>
            <link>https://medium.com/@bolajiolatunji41/international-breweries-sales-performance-analysis-2017-2019-458c1e207317?source=rss-5e9b57733d2f------2</link>
            <guid isPermaLink="false">https://medium.com/p/458c1e207317</guid>
            <category><![CDATA[business-intelligence]]></category>
            <category><![CDATA[business-communication]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[data-visualization]]></category>
            <dc:creator><![CDATA[Bolaji Olatunji]]></dc:creator>
            <pubDate>Mon, 16 Nov 2026 00:22:17 GMT</pubDate>
            <atom:updated>2026-11-16T00:22:17.145Z</atom:updated>
            <content:encoded><![CDATA[<h3><strong>Using Data to Understand Profitability, Product Performance and Market Opportunities</strong></h3><h3><strong>1. Introduction</strong></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/940/1*VdoTHct5N8aZAXPR8rK62A.png" /></figure><p>What drives profitability in a business operating across multiple countries and selling different product categories? Are some brands contributing more to profit than others? Which markets generate the highest returns, and is the business experiencing growth or a decline in performance?</p><p>These are important questions for management because revenue alone does not determine business success. Understanding profitability, product performance, market contributions and sales trends helps management allocate resources effectively, improve business operations and make informed investment decisions.</p><p>In this project, the analysis of International Breweries’ sales data from 2017 to 2019 was conducted to understand the company’s financial performance across five countries: Nigeria, Ghana, Togo, Benin and Senegal; the analysis and visualisation were done with Microsoft Excel.</p><p>The objective was to identify the most profitable products, evaluate performance across countries and sales territories, examine changes in revenue and profit over time, and identify opportunities for improving business performance.</p><h3><strong>2. The Business Problem: What Does Management Need to Know?</strong></h3><p>International Breweries operates across different markets, with multiple brands and sales representatives contributing to its overall performance.</p><p>However, without a clear understanding of how these different parts of the business perform, management may struggle to identify where profits are being generated, which products deserve greater attention and which markets require improvement.</p><p>This analysis addresses five important business questions:</p><ul><li>Which brands and product categories contribute the most to overall profitability?</li><li>Which countries and sales territories generate the highest profits?</li><li>How have the company’s revenue and profitability changed between 2017 and 2019?</li><li>Are there particular months or quarters with stronger financial performance?</li><li>Which sales representatives contribute the most to overall sales and profit?</li></ul><p>Answering these questions gives management evidence to support decisions about product investment, market expansion, sales strategies, and resource allocation.</p><h3><strong>3. The Data and Approach</strong></h3><p>The analysis used the International Breweries dataset, which contains 1,047 sales records covering January 2017 to December 2019. The dataset included sales representatives, brands, product categories, plant costs, selling costs, unit prices, quantities sold, revenue, profit, countries, territories and dates.</p><p>Microsoft Excel was used for data preparation, analysis and visualisation. Before the analysis, the dataset was checked for missing values and duplicate records. The working dataset contained no missing values or duplicate records. Countries were classified into Francophone and Anglophone based on their official languages. Nigeria and Ghana fall into the Anglophone category, while Togo, Benin and Senegal fall into the Francophone category.</p><p>I also reviewed the categorical fields and used the prepared worksheet, which contained the revenue, profit, date and quarterly fields required for the analysis.</p><p>Pivot Tables were used to summarise performance by brand, country, territory, sales representative, month and year. These summaries provided the foundation for the interactive dashboard visuals and the business insights presented below.</p><h3><strong>4. Key Findings and Dashboard Insights</strong></h3><p><strong>The Business Generated Significant Profit, but Performance Declined Over the Three Years</strong></p><p>Across the three years, International Breweries generated:</p><ul><li><strong>Total revenue</strong>: $241,892,650</li><li><strong>Total profit</strong>: $105,587,420</li><li><strong>Total quantity sold</strong>: 890,722 units</li><li><strong>Overall profit margin</strong>: approximately 44%</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/940/1*0OjvSKMWACxDtOaRNdDjnw.png" /></figure><p>Although these figures indicate substantial business activity, the yearly performance reveals a concerning downward trend.</p><p>Revenue declined by approximately 3% in 2018 and a further 16.8% in 2019. Profit also declined by approximately 3.7% in 2018 and 19% in 2019.</p><p>Comparing 2017 with 2019, revenue fell by approximately 19.2%, while profit declined by approximately 22%.</p><p><strong>Why this matters:</strong> The decline in both sales volume and profitability suggests that the company needs to investigate the factors affecting its commercial performance. If this trend continues, it could weaken the company’s ability to sustain profitability.</p><p><strong>Castle Lite and Budweiser Are the Company’s Biggest Profit Contributors</strong></p><p>Product performance analysis revealed that Castle Lite generated the highest profit, followed by Budweiser.</p><p>Together, Castle Lite and Budweiser contributed approximately 62.7% of the company’s total profit.</p><p>This is a significant finding because these two brands generate almost two-thirds of the company’s profit. Their performance therefore has a substantial influence on overall business results.</p><p>The analysis also showed that beer products generated <strong>$89,255,670</strong> in profit, representing approximately 84.5% of total profit. Malt products contributed <strong>$16,331,750</strong>, or approximately 15.5%.</p><p><strong>Why this matters:</strong> Management should recognise the importance of its leading brands while also evaluating opportunities to improve the profitability of products contributing less to the business.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/672/1*7gIa7H-ZMpfe9MYKcESMFw.png" /></figure><p><strong>Senegal Leads in Profit, but Performance Across Countries Is Relatively Balanced</strong></p><p>The country analysis showed that Senegal generated the highest profit, followed closely by Nigeria.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/698/1*iknSRPK51yl8qRyOHNbqDA.png" /></figure><p>Senegal contributed approximately 20.4% of total profit, while Nigeria contributed approximately 20.3%.</p><p>Although Senegal ranked first, the difference between the highest- and lowest-performing countries was relatively small. This suggests that profitability is distributed fairly evenly across the five markets.</p><p>The territory analysis also revealed that Francophone territories generated $63,198,160 in profit, compared with $42,389,260 from Anglophone territories.</p><p>Francophone territories therefore contributed approximately 59.9% of total profit.</p><p><strong>Why this matters:</strong> The company has a relatively balanced geographical profit base, but Francophone markets currently account for a larger share of profitability. Management should understand what is driving this difference before deciding where to concentrate additional resources.</p><p><strong>Monthly Profitability Is Relatively Consistent, with March Recording the Highest Profit</strong></p><p>The monthly analysis showed that March generated the highest cumulative profit across the three years, with $9,066,130. February followed with $9,028,450.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/735/1*1POfl1gEHx1x1DxWDAFd6A.png" /></figure><p>April recorded the lowest cumulative profit at $8,573,830.</p><p>Although there were differences between months, overall profitability was relatively consistent throughout the year.</p><p>Quarterly analysis also showed that the company did not experience a particularly dominant quarter.</p><p>The first quarter recorded the highest profit, while the second quarter recorded the lowest.</p><p><strong>Why this matters:</strong> Management should not assume that profitability depends on a single peak selling season. Instead, the business should maintain effective sales and distribution activities throughout the year while investigating the reasons for the relatively weaker performance in April and the second quarter.</p><p><strong>Jones Is the Highest-Contributing Sales Representative</strong></p><p>The sales representative analysis revealed differences in the financial contributions of individual representatives.</p><p>Jones recorded the highest total profit of $18,770,830, followed by Jardine with $13,531,650 and Gill with $12,290,130.</p><p>Jones also recorded the highest sales quantity, with 157,880 units.</p><p>This suggests that Jones was the strongest contributor by both sales volume and total profit during the period analysed.</p><p>However, differences in sales territories, customer assignments and individual targets may influence these results. Therefore, total profit alone should not be used as the only measure of individual performance.</p><p><strong>Why this matters:</strong> Management can use these results to identify high-performing representatives, understand successful sales practices and determine where additional support or training may be required.</p><h3><strong>5. Recommendations: From Insights to Action</strong></h3><p>Based on the findings, the following actions are recommended for management.</p><p><strong>1. Investigate the decline in annual revenue and profit.</strong></p><p>Management should prioritise a review of the factors responsible for the decline between 2017 and 2019. This should include an examination of sales volumes, pricing, distribution performance, customer demand and market competition. The objective should be to identify the main causes and establish measurable recovery targets.</p><p><strong>2. Protect and strengthen the leading brands.</strong></p><p>Castle Lite and Budweiser contribute approximately 62.7% of total profit. Management should prioritise the availability, distribution and marketing of these brands. Maintaining their market position is essential to protecting overall profitability.</p><p><strong>3. Review the profitability of lower-contributing brands.</strong></p><p>Hero and Trophy recorded the lowest profits among the seven brands. Management should investigate their production costs, pricing, customer demand and distribution performance. Where appropriate, targeted promotions or adjustments to the product strategy could improve their contribution.</p><p><strong>4. Strengthen sales strategies in Francophone markets.</strong></p><p>Since Francophone territories contribute approximately 59.9% of total profit, management should examine the successful practices in these markets. These practices could inform sales strategies in Anglophone territories, while maintaining appropriate consideration for differences in customer preferences and market conditions.</p><p><strong>5. Maintain consistent sales and distribution throughout the year.</strong></p><p>Although monthly profitability is relatively stable, April and the second quarter recorded comparatively lower results. Management should investigate whether these periods experience weaker demand, distribution challenges or other operational issues. Sales campaigns and inventory planning should be adjusted based on the findings.</p><p><strong>6. Use performance data to improve sales representative management.</strong></p><p>Management should study the practices of high-performing representatives, particularly Jones, and identify opportunities for knowledge sharing and staff development. Performance assessments should also consider individual targets, sales territories and customer portfolios to ensure fair comparisons.</p><h3><strong>6. Limitations</strong></h3><p>This analysis is based on historical sales records covering 2017–2019. It describes past business performance and does not establish the causes of the observed trends.</p><p>The dataset does not provide sufficient information about marketing expenditure, customer demographics, competitor activities, distribution costs beyond the recorded selling costs, or changes in market demand. These factors could influence the company’s financial performance but cannot be evaluated fully using the available information.</p><p>Additional information would be required to determine why performance declined and to assess the financial impact of the recommended interventions.</p><h3><strong>7. Conclusion</strong></h3><p>The analysis of International Breweries’ sales performance between 2017 and 2019 highlights both business strengths and areas requiring management attention.</p><p>The company generated a total profit of $105,587,420 during the period, with Castle Lite and Budweiser emerging as its leading profit contributors. Senegal recorded the highest country-level profit, while Francophone territories accounted for the larger share of overall profitability.</p><p>However, the decline in revenue, sales volume and profit between 2017 and 2019 is an important concern that management should investigate.</p><p>Ultimately, the findings demonstrate the importance of using sales data to understand business performance rather than relying on revenue figures alone. By protecting profitable brands, reviewing weaker product lines, strengthening market strategies and addressing the decline in annual performance, International Breweries can make more informed decisions to improve its commercial results.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=458c1e207317" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[EDUBRIDGE Limited: Turning Business Data into Insights]]></title>
            <link>https://medium.com/@bolajiolatunji41/edubridge-limited-turning-business-data-into-insights-97e7a0009717?source=rss-5e9b57733d2f------2</link>
            <guid isPermaLink="false">https://medium.com/p/97e7a0009717</guid>
            <category><![CDATA[business-analysis]]></category>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[data-analytics]]></category>
            <category><![CDATA[power-bi-training]]></category>
            <dc:creator><![CDATA[Bolaji Olatunji]]></dc:creator>
            <pubDate>Fri, 16 Oct 2026 09:51:37 GMT</pubDate>
            <atom:updated>2026-10-16T10:00:49.145Z</atom:updated>
            <content:encoded><![CDATA[<p><strong>Introduction</strong></p><p>Businesses generate large volumes of data, but the value of this information depends on how effectively it is analysed and applied to decision-making. Understanding sales performance, profitability, customer purchasing patterns and product performance is essential for identifying opportunities and addressing potential business challenges.</p><p><strong>1. Problem Statement</strong></p><p>This data analysis and visualisation seek to evaluate the performance of Edubridge Limited over the years 2013 and 2014.</p><p>This project uses Microsoft Power BI to analyse Edubridge Limited’s dataset to develop an interactive dashboard that examines sales and profit performance across countries, customer segments, months and products.</p><p>The analysis aims to answer five key questions:</p><ul><li>Which countries contribute the most to total sales?</li><li>Which countries contribute the most to the total profit?</li><li>Which customer segments contribute most to total profit and units sold?</li><li>How does sales performance fluctuate across the months?</li><li>Which products generate the highest sales values?</li></ul><p>By answering these questions, the project identifies performance patterns and provides practical recommendations to support informed business decisions.</p><p><strong>2. Dashboard Insights and Analysis</strong></p><p><strong>Overall Business Performance</strong></p><p>The EDUBRIDGE dashboard reports total sales of $127.93 million, total profit of $16.89 million, approximately 1.13 million units sold and 700 orders. These key performance indicators provide an overview of the business’s performance.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/807/1*ZVZMA9AryY-J50ipNnqojg.png" /></figure><p>The implied overall profit margin is approximately 13.2%, providing a useful baseline for monitoring profitability. However, aggregate figures alone cannot explain which markets, products or customer segments contribute most effectively to business performance; hence, we dive deep to answer the questions in the problem statement.</p><p><strong>Sales Performance by Country</strong></p><p>The country-level visualisation shows that the United States and Canada recorded the highest sales, at approximately $27 million each. France followed with $26 million, while Germany and Mexico recorded $25 million and $23 million, respectively.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/673/1*0zF149jQi6Sh6mr9SKwFjg.png" /></figure><p>These results indicate relatively close sales performance across the five countries displayed, although Mexico recorded the lowest value. The findings highlight the importance of comparing market performance beyond revenue alone. Analysing profit, operating costs and sales volumes by country would provide a more comprehensive assessment of each market’s contribution.</p><p><strong>Profit Performance by Country</strong></p><p>The country-level visualisation shows that France recorded the highest profit at $2.91 million. Germany followed with $3.68 million, while Canada and the United States recorded $3.53 million and $3 million, respectively. Mexico recorded the lowest profit with a figure of $2.91 million.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/712/1*uLPvzQ_-EgXCGA7vCUrhtw.png" /></figure><p>This result shows that a high sales performance doesn’t always mean a high profit level. France has the highest profit compared to Canada and the United States, with the two countries sharing the joint highest sales performance.</p><p><strong>Profit Contribution by Customer Segment</strong></p><p>The profit distribution chart reveals that Government accounts for 65.04% of total profit, while Small Business contributes 23.66%. The remaining customer segments contribute substantially smaller proportions.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/631/1*eqX4vaVlbJdUngsynlYiIA.png" /></figure><p>This indicates that profitability is concentrated in the Government segment. Although this represents a significant contribution to overall profit, it also raises questions about the business’s dependence on this customer group. Examining contract renewals, customer retention, and segment-level profitability would help assess the stability of this contribution.</p><p><strong>Units Sold by Customer Segment</strong></p><p>The units-sold chart shows that Government accounts for 41.81% of total units sold, followed by Midmarket at 15.29%, Enterprise at 14.97%, Channel Partners at 14.32%, and Small Business at 13.6%.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/664/1*7lgOgc-myzOJKDgTlm5S_Q.png" /></figure><p>Government’s share of profit is considerably larger than its share of units sold. This difference suggests that further investigation into pricing, product mix and costs across customer segments may be valuable.</p><p><strong>Monthly Sales Trends</strong></p><p>The monthly sales chart reveals fluctuations throughout the months displayed. October recorded the highest visible sales value, at approximately $23.1 million, followed by December at $18.3 million. August recorded approximately $6.3 million.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/756/1*4EFlJ2cxIEetYtmkUFlCZQ.png" /></figure><p>These variations suggest that sales performance changes considerably over time. Understanding whether these fluctuations reflect seasonal demand, promotional activities or product availability could help the business improve inventory planning and resource allocation.</p><p><strong>Sales Performance by Product</strong></p><p>The product chart identifies Paseo as the leading product among the six displayed, with approximately $36 million in sales. VTT followed with $22 million, while Velo and Amarilla generated approximately $20 million and $19 million, respectively. Montana and Carretera recorded approximately $17 million and $15 million.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/732/1*fblenhXtctmPiSphUnc0Zg.png" /></figure><p>Paseo’s leading position suggests that it is an important contributor to sales revenue. However, the highest-selling product is not necessarily the most profitable. Comparing product-level profit margins and associated costs would provide a stronger basis for evaluating product performance.</p><p><strong>3. Recommendations and Solutions</strong></p><p>Based on the dashboard findings, the following recommendations are proposed.</p><p>A. <strong>Strengthen profitability monitoring:</strong> The business should monitor profit margins alongside revenue to determine whether sales growth translates into sustainable profitability. Comparing profitability across products, countries and customer segments would support more informed decisions.</p><p>B. <strong>Aim for profitability in regions with high sales performance:</strong> Management should assess differences in market demand, operating costs and distribution coverage across the countries analysed. Management should also aim to increase profitability in regions such as Canada and the United States of America with high sales performance rather than relying solely on sales rankings.</p><p>C. <strong>Manage customer-segment concentration:</strong> Given the government’s substantial contribution to total profit, the business should assess its over-reliance on government patronage, as a change of government can pose serious risks to the business&#39;s profitability. The business should seek to expand its customer base and profit among the other segments.</p><p>D. <strong>Investigate monthly sales fluctuations.</strong> The business should review monthly sales alongside promotional activities, customer behaviour and product availability, as this could help identify recurring patterns. Where seasonality and a pattern are established, the business can use these insights to improve planning, sales campaigns and profitability.</p><p>E. <strong>Evaluate product profitability.</strong> The business should investigate Paseo’s strong sales performance and compare its profitability with that of other products. Product decisions should consider profit margins, costs and demand, rather than revenue alone, as revenue alone doesn’t tell the full story.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=97e7a0009717" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>