<?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 Alarape AbdulAzeez on Medium]]></title>
        <description><![CDATA[Stories by Alarape AbdulAzeez on Medium]]></description>
        <link>https://medium.com/@alarapeolayiwola?source=rss-33b17ba24b3e------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/0*2114uHncxO68DhED</url>
            <title>Stories by Alarape AbdulAzeez on Medium</title>
            <link>https://medium.com/@alarapeolayiwola?source=rss-33b17ba24b3e------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sat, 21 Nov 2026 10:27:31 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@alarapeolayiwola/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[The Profit Paradox: When More Sales Don’t Mean More Profit]]></title>
            <link>https://medium.com/@alarapeolayiwola/the-profit-paradox-when-more-sales-dont-mean-more-profit-91698519917d?source=rss-33b17ba24b3e------2</link>
            <guid isPermaLink="false">https://medium.com/p/91698519917d</guid>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[exploratory-data-analysis]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[tech]]></category>
            <category><![CDATA[power-bi]]></category>
            <dc:creator><![CDATA[Alarape AbdulAzeez]]></dc:creator>
            <pubDate>Sun, 15 Nov 2026 19:20:28 GMT</pubDate>
            <atom:updated>2026-11-18T18:37:00.719Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*4baCXN8hnV_ZIt61" /><figcaption>Photo by <a href="https://unsplash.com/@ideanaire?utm_source=medium&amp;utm_medium=referral">Natasha Hall</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p><strong>TL; DR</strong></p><p>This project presents a three-page Profitability Analytics dashboard built in Power BI for evaluating financial performance in a Global Skincare E-Store. The analysis focuses on sales and profit trends, product and market profitability, and discount impact, transforming e-commerce transaction data into actionable business insights to identify profitability challenges, optimize pricing and discount strategies, and support data-driven business decisions.</p><h3>Introduction</h3><p>Revenue growth is often considered a sign of business success. However, increasing sales do not always translate into increasing profits. A business can attract more customers, process more orders and generate higher revenue while experiencing declining profitability due to excessive discounts, rising operating costs, poor pricing strategies or unprofitable product categories. This project explores that challenge through an analysis of a global e-commerce skincare store using Microsoft Power BI.</p><p>The objective was to move beyond sales performance and investigate what was happening to the business’s profitability across different products, categories and geographical markets. Rather than focusing exclusively on how much the business was selling, I wanted to understand how effectively it was converting revenue into profit.</p><h3>Project Approach and Analytical Focus</h3><p>To investigate the business’s declining profitability, I structured the Power BI dashboard into three analytical pages, each addressing a specific aspect of the business problem.</p><ul><li><strong>Page 1: Executive Profitability Overview:</strong> Examines the relationship between sales growth and declining profitability, highlighting changes in key financial performance indicators.</li><li><strong>Page 2: Product and Market Profitability:</strong> Identifies underperforming product categories, geographical markets and individual products contributing to weak or negative profitability.</li><li><strong>Page 3: Discount Impact Analysis:</strong> Investigates how different discount levels relate to profitability, highlighting high-discount transactions associated with negative profit margins.</li></ul><h3>Business Problem Statement</h3><p>The Global Skincare and Beauty E-Store has experienced consistent sales growth, reaching its highest sales performance in 2023. However, despite this growth, profit declined and profit margin also dropped. This indicates that increased revenue is not translating into improved profitability.</p><p>Management lacks clear visibility into the products, categories, geographical markets and discount practices contributing to the decline. Without understanding where profitability is being lost, the business risks continuing to generate higher sales while retaining less profit.</p><h3>Project Objectives</h3><p>The primary objective was to develop an interactive Power BI dashboard that provides a comprehensive view of the business’s financial performance.</p><p>The specific objectives were to:</p><ol><li>Analyze gross sales, net sales, profit and profit margins.</li><li>Examine monthly and yearly financial performance.</li><li>Identify profitable and unprofitable product categories.</li><li>Compare profitability across geographical markets.</li><li>Identify the highest- and lowest-performing products.</li><li>Examine discount patterns and their potential impact on profitability.</li><li>Provide actionable recommendations to support better pricing, discounting and product-management decisions.</li></ol><h3>Dataset Overview</h3><p>The project used an e-commerce dataset containing transaction-level information relating to product sales and financial performance.</p><p>The relevant fields included:</p><ul><li>Quantity: Number of units purchased.</li><li>Sales: Selling price per product.</li><li>Discount: Discount applied to a transaction, as a proportion (0.2 = 20%)</li><li>Gross Revenue: Revenue before discounts.</li><li>Net Revenue: Revenue remaining after discounts.</li><li>Profit: Profit after discounts.</li><li>Discount Level: percentage reduction applied to a product’s original selling price during a transaction.</li></ul><p>The dataset also supported analysis across different product categories, individual products, geographical markets and transaction dates. These fields made it possible to examine business performance at different levels of detail rather than relying on overall revenue figures.</p><p><strong>Data Description</strong></p><p>The dataset consists of one fact table and three-dimension tables structured in a star schema.</p><p>The tables include:</p><ul><li>Customers — contains information about customers who purchase products from the business.</li><li>Products — contains details of products categories and products offered by the business.</li><li>Calendar — contains dates information used for trend analysis, time intelligence calculations, and period over period comparisons.</li><li>Orders— contains transactional sales records, including information about orders, products, customers, quantities, and sales-related attributes.</li></ul><p><strong>Tool Used</strong></p><p>Power BI</p><p><strong>Data Cleaning, Preparation &amp; Modeling</strong></p><p>Before developing the dashboard, the dataset was prepared and transformed in Power Query to ensure it was clean, consistent, and suitable for analysis. The dataset was first imported into Power BI and processed using Power Query. During the transformation stage, data types were reviewed and assigned appropriately to improve accuracy and consistency across the dataset. Data quality checks were also performed to identify and address duplicate records, inconsistent values, missing or invalid entries, and formatting issues.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*YifDOsvImGbZ_I9Ph7qYGw.png" /><figcaption>Figure 1: Data cleaning and transformation performed in Power Query, showing the transformed dataset and applied cleaning steps.</figcaption></figure><p>Following the initial cleaning process, the dataset was transformed to support the key business questions. Additional calculated columns and DAX measures were created, including Profit Margin, Gross Sales, Net Sales, Discount Amount, and Discount Level. These fields enabled deeper analysis of financial performance, product and market profitability, and discount impact.</p><p>Once the data preparation was completed, the tables were loaded into Power BI and structured using a star-schema data model, consisting of a central fact table connected to multiple dimension tables. This structure helped reduce data redundancy, improve model performance, and establish efficient relationships for filtering and analysis across different business dimensions.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/930/1*2iPwtdiLTGy04tiUPaO1xA.png" /><figcaption>Figure 2: Star-schema data model used for the analysis.</figcaption></figure><p>Finally, DAX measures were developed to calculate key performance indicators and support more advanced analysis. These measures were used throughout the dashboard to evaluate KPI trends, Discount impact, and performance across countries, product categories, and individual products. The completed data model provided a reliable foundation for developing the interactive dashboard and answering the key business questions identified for the analysis.</p><p><strong>Key Performance Indicators</strong></p><ul><li>Gross Sales</li><li>Net Sales</li><li>Profit</li><li>Profit margin</li><li>Quantity Sold</li><li>Product Count</li><li>Discount Amount</li><li>Average Discount Rate</li></ul><h3>Dashboard Development</h3><p>I developed a three-page interactive dashboard in Power BI. Each page was designed to answer a different business question while maintaining a consistent visual structure. The three pages tell a connected story.</p><h3>Page 1: Executive Profitability Overview</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*qh8ZztGe6ln8yrYUXdoAYg.png" /><figcaption>Figure 3: Executive Profitability Overview Dashboard</figcaption></figure><p>The first page provides a high-level overview of the business’s financial performance. It contains five key performance indicators:</p><ul><li>Gross Sales</li><li>Net Sales</li><li>Total Profit</li><li>Profit Margin</li><li>Quantity Sold</li></ul><p>The page also includes monthly KPI trends, yearly profit trends, monthly discount amounts and profit distribution across geographical markets. The purpose of this page is to help management quickly understand the business’s overall financial position. The monthly trends make it possible to examine changes in performance over time, while the yearly comparison provides a broader view of profitability. The discount trend is particularly relevant because it helps identify periods with relatively high discount amounts.</p><h3>Page 2: Product and Market Profitability</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/585/1*SO5N1xgERbNzi7Gxv1bITQ@2x.jpeg" /><figcaption>Figure 4: Product and Market Profitability Dashboard</figcaption></figure><p>The second page investigates where the business generates profit and where it experiences profitability challenges. It includes:</p><ul><li>Net Sales and Profit by Category.</li><li>Top Five Profitable Products.</li><li>Bottom Five Profitable Products.</li><li>Market Performance Table.</li></ul><p>This page makes it possible to identify categories generating substantial revenue but weak profits. It also highlights geographical markets where high sales do not necessarily translate into strong profitability. The product ranking helps management identify products that contribute positively to business performance and those requiring further investigation.</p><h3>Page 3: Discount Impact Analysis</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*VBjYCepKxjroctavFeu8GA.png" /><figcaption>Figure 5: Discount Impact Analysis Dashboard</figcaption></figure><p>The third page investigates the relationship between discounting and business profitability. It includes:</p><ul><li>Transaction Distribution by Discount Level.</li><li>Discount Profitability Matrix.</li><li>Average Discount Rate, Profit Margin and Net Sales by Category.</li></ul><p>The objective is to understand whether different discount levels support profitable sales or reduce the amount of revenue retained by the business. The Discount Profitability Matrix is particularly important because it compares gross revenue, net sales, profit and profit margin across discount categories. This makes it possible to identify discount levels associated with negative profitability.</p><h3><strong>Key Findings and Business Insights</strong></h3><p>The analysis revealed several important findings.</p><p><strong>Finding 1: Revenue increased while profitability declined</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*9Wo34URF1mjMun-FxtuVig.png" /><figcaption>Figure 6: 2023 financial performance compared with 2022.</figcaption></figure><p>One of the most significant findings emerged from the 2023 financial performance. Net sales increased from approximately $14.92 million in 2022 to $18.31 million in 2023, representing a 22.68% increase. However, profits declined from approximately $318.67K to $279.93K, representing a 12.16% decrease.<strong> </strong>Profit margin also declined from 2.14% to 1.53%.<strong> </strong>This suggests that the business was generating more revenue but retaining a smaller proportion as profit.</p><p>The finding highlights why sales growth should not be used as the only measure of business success.</p><p><strong>Finding 2: High-discount transactions recorded negative profitability</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Xf_B4fToa_Cpd9GrpjwRZA.png" /><figcaption>Figure 7: Discount Profitability Matrix.</figcaption></figure><p>The Discount Profitability Matrix revealed that high-discount transactions generated approximately $5.21 million in gross sales and $2.64 million in net sales. However, these transactions recorded a loss of approximately $111.25K, with a negative profit margin of 4.21%. This makes high-discount transactions a major area of concern.</p><p>The findings suggest that the business may be sacrificing too much revenue through aggressive discounting without generating sufficient profitability.</p><p><strong>Finding 3: Transactions without discounts generated the strongest profit</strong></p><p>Transactions without discounts generated approximately $11.66 million in net sales and $335.16K in profit. Their profit margin was 2.87%, the highest among all discount categories. This suggests that the business retains more profit from transactions that do not involve discounts.</p><p>It also highlights the importance of protecting profitable sales rather than offering discounts indiscriminately.</p><p><strong>Finding 4: Profitability declined as discount levels increased</strong></p><p>The analysis showed the following profit margins:</p><ul><li>No Discount: 2.87%.</li><li>Low Discount: 1.83%.</li><li>Medium Discount: 0.99%.</li><li>High Discount: -4.21%.</li></ul><p>This pattern suggests a negative relationship between discount levels and profit margins. The findings highlight the need for a more controlled discount strategy.</p><p><strong>Finding 5: Home Accessories and Hair Care demonstrated weak profitability</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*BbZ7Cs5_gPnRsU7O6TxjMQ.png" /><figcaption>Figure 8: Category Profitability</figcaption></figure><p>Home Accessories generated approximately $3.48 million in net sales but recorded a loss of approximately $20K.</p><p>Hair Care generated approximately $2.84 million in net sales, yet its profit was negligible at the displayed level of precision.</p><p>This was particularly concerning because both categories contributed a considerable amount of revenue without generating positive profit. Both categories require further investigation into pricing, product costs and discounting practices.</p><p><strong>Finding 6: Regional Sales and Profitability Analysis</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*BuOB4Er9U3C1RIB9c_z4_w.png" /><figcaption>Figure 9: Market performance table</figcaption></figure><p>Asia Pacific generated approximately $4.72 million in net sales but recorded the lowest profit margin (0.93%) and the highest average discount rate (18.71%), suggesting a potential link between aggressive discounting and reduced profitability.</p><p>In contrast, Europe achieved the highest profit margin (2.05%), generating $100.20K in profit while recording the lowest average discount rate (9.16%).</p><p>Africa recorded the lowest total profit ($21.40K), but its profit margin (1.67%) was higher than those of Asia Pacific and LATAM.</p><p>Key takeaway: Higher discount rates may be associated with weaker profitability, particularly in Asia Pacific. However, further investigation is needed to establish the underlying causes.</p><p><strong>Finding 7: Certain products were generating negative profit</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Q-jPNDS8GuAn83QAt9OHuw.png" /><figcaption>Figure 10: Bottom 5 Product</figcaption></figure><p>The product profitability analysis identified several products with negative profit:</p><p>Sterling Frost Ring recorded the largest loss among the five least profitable products at approximately $1,606.32.</p><p>Golden Orb Locket followed with a loss of approximately $1,241.22.</p><h3>Business Recommendations</h3><p>Based on the findings, I identified the following recommendations.</p><ol><li><strong>Review high-discount transactions</strong></li></ol><p>Management should investigate the products and categories associated with high-discount transactions, particularly those generating negative profit. Discounts should be evaluated based on their contribution to profitability rather than sales volume alone.</p><p><strong>2. Reassess pricing and costs in Home Accessories and Hair Care</strong></p><p>These categories generate substantial revenue but demonstrate weak or negative profitability. Management should review product acquisition costs, selling prices and discount structures.</p><p><strong>3. Investigate Asia Pacific’s low profit margin</strong></p><p>The market’s 0.93% margin indicates weak profit conversion. Management should investigate market-specific costs, product mix and discounting practices.</p><p><strong>4. Protect profitable transactions</strong></p><p>Transactions without discounts recorded the strongest profit margin. The business should avoid unnecessary discounting on products that already sell profitably at their existing prices.</p><p><strong>5. Introduce category-specific discount strategies</strong></p><p>Discount decisions should reflect the profitability of individual categories. For example, categories with already weak margins should not automatically receive the same promotional discounts as more profitable categories.</p><p><strong>6. Monitor profitability alongside revenue</strong></p><p>Management should track net sales, total profit and profit margin together to identify situations where sales growth is accompanied by declining profitability.</p><h3>Limitations of the Analysis</h3><p>Although the dashboard provides useful insights, some limitations should be considered.</p><p><strong>Limited cost information:</strong> The available fields support analysis of profit as defined in the dataset. However, without a detailed breakdown of operating expenses, taxes and other business costs, the analysis should not automatically be interpreted as a measure of net income.</p><p><strong>Discount causality:</strong> The analysis identifies a strong association between higher discount levels and weaker profit margins. However, it does not independently establish that discounting is the sole cause of declining profitability.</p><p><strong>Customer loyalty:</strong> Although the original business scenario also raised questions about customer loyalty, this project prioritized profitability. A separate customer-retention analysis would be required to identify repeat customers and their purchasing behavior.</p><p>These limitations are important because analytical insights should distinguish between what the data demonstrates and what requires further investigation.</p><h3>Conclusion</h3><p>This project demonstrates why revenue growth alone is not sufficient to evaluate business performance. Despite recording a 23.01% increase in gross sales in 2023, the global skincare e-store experienced a 12.16% decline in profit and a reduction in profit margin from 2.14% to 1.53%. The analysis identified high-discount transactions as a major profitability concern, recording a negative 4.21% profit margin. It also highlighted weak profitability in Home Accessories and Hair Care, alongside low market profitability in Asia Pacific. These findings demonstrate the importance of examining business performance beyond overall sales figures.</p><p>Ultimately, the objective of data analytics is not simply to present numbers. It is to uncover meaningful patterns, identify business challenges and provide evidence that supports better decisions. <strong>The central question is not just how much a business sells, but how much it actually keeps.</strong></p><p><strong>Project:</strong> Global Skincare E-Store Analysis</p><p><strong>Author:</strong> Alarape Abdulazeez O.</p><p>Connect with me on<a href="http://linkedin.com/in/alarape-abdulazeez"><strong> LINKEDIN</strong></a><strong>.</strong></p><p>View Project on <a href="https://github.com/Alapexboi/Global-Skincare-E-Store-Analysis"><strong>GITHUB</strong></a><strong>.</strong></p><p><strong>Thank you for reading!</strong></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=91698519917d" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[From Data to Decisions: Analyzing Sales, Revenue, Profitability & Growth.]]></title>
            <link>https://medium.com/@alarapeolayiwola/from-data-to-decisions-analyzing-sales-revenue-profitability-growth-d5d018f86aca?source=rss-33b17ba24b3e------2</link>
            <guid isPermaLink="false">https://medium.com/p/d5d018f86aca</guid>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[sales]]></category>
            <category><![CDATA[storytelling]]></category>
            <category><![CDATA[excel]]></category>
            <category><![CDATA[data-visualization]]></category>
            <dc:creator><![CDATA[Alarape AbdulAzeez]]></dc:creator>
            <pubDate>Sun, 16 Aug 2026 12:37:05 GMT</pubDate>
            <atom:updated>2026-09-08T10:32:41.652Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*H9qXN26Ydo7lN22e" /><figcaption>Photo by <a href="https://unsplash.com/@goumbik?utm_source=medium&amp;utm_medium=referral">Lukas Blazek</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p><strong>TL; DR</strong></p><p>This project presents a two-page Sales Analytics dashboard built in Excel for Identifying Key Revenue Drivers in a Global Electronics Retailer. The analysis focuses on sales performance, revenue trends, and product performance, turning retail sales data into Actionable Business Insights to support data-driven decision making and business growth.</p><p><strong>Introduction</strong></p><p>Businesses generate large amounts of sales data every day, but data becomes valuable only when it can answer important business questions.</p><p>For this sales Analytics project, I analyzed a global electronics retailer’s sales data using Microsoft Excel to understand product performance, identify key revenue drivers, uncover opportunities for business growth and make informed decisions.</p><p>Rather than focusing only on creating charts, the objective was to use the data to answer a more important question:</p><p>Which products and product categories are driving sales, and where should the business focus its attention?</p><p>The analysis resulted in an interactive Excel dashboard designed to present key findings to business stakeholders in a simple and actionable way.</p><p><strong>Business Problem Statement</strong></p><p>The retailer operates across multiple products, categories, customers, stores, and geographic markets, making it difficult to identify the key factors driving revenue, sales volume, and profitability. Management needs a clear understanding of which products and categories are performing well, which are underperforming, and whether high sales volumes translate into strong revenue and profit.</p><p>The business also faces challenges relating to product and market concentration, inventory allocation, and declining sales performance in certain periods and categories. Without clear data-driven insights, management may struggle to allocate inventory, marketing resources, and sales efforts effectively.</p><p>Therefore, this analysis aims to evaluate sales, revenue, profit, product, category, and geographic performance to identify the main drivers of business performance, highlight areas of concern, and provide actionable recommendations to support better decision-making, improve profitability, and promote sustainable growth.</p><p><strong>Project Objective</strong></p><p>The main objective of this analysis was to identify the company’s key product-level revenue and sales drivers.</p><p>The analysis focused on four major areas:</p><p>1. Top 5 products by units sold</p><p>2. Revenue by product category</p><p>3. Relationship between units sold and revenue</p><p>These analyses were selected because they provide both a volume perspective and a financial perspective on product performance.</p><p><strong>Data Description</strong></p><p>The dataset was sourced from Kaggle consists of one fact table and three-dimension tables structured in a star schema.</p><p>The tables include:</p><ul><li>Customers — contains information about customers who purchase products from the business.</li><li>Products — contains details of products categories and products offered by the business.</li><li>Stores — contains information about each stores location and its operational characteristics in the business.</li><li>Sales — contains the business sales records.</li></ul><p><strong>Tool Used</strong></p><p>Microsoft Excel (Power Query, Power Pivot, Pivot Charts)</p><p><strong>Data Preparation</strong></p><p>Before creating the dashboard, I prepared the dataset in Excel.</p><p>The dataset was imported into Microsoft Excel and transformed using Power Query to ensure it was suitable for analysis. During the cleaning process, columns were assigned to their appropriate data types to improve data accuracy and consistency. Additional columns were created such as Price, Cost, Profit, Age, and Age Band were created to support deeper business analysis and answer key business questions.</p><p>Data quality checks were also performed by removing duplicate records and standardizing text values where necessary. Once the data had been cleaned and transformed, it was loaded into Power pivot and modeled using a star schema consisting of one fact table and multiple dimension tables. This data model was designed to reduce redundancy, improve performance, and enable efficient filtering across related tables.</p><p>Measures were created to calculate key performance indicators and support advanced analysis throughout the dashboard, including revenue trends, profitability, and performance comparison across countries, categories and products.</p><p><strong>Key Performance Indicators</strong></p><ul><li>Total Revenue</li><li>Total Cost</li><li>Total Profit</li><li>Total Orders</li><li>Total Quantity</li><li>%Profit Margin</li></ul><p><strong>Key Insights</strong></p><ol><li><strong>Executive Summary</strong></li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*imJe9OKKL_s3zP7LjuzJ9A.png" /><figcaption>Executive Summary Dashboard</figcaption></figure><p>The first page provides an overview of the business’s overall performance. During the analysis period, <strong>Global Electronics generated $55.8 million in revenue, $23.1 million in profit, and sold approximately 198,000 products</strong>.</p><p><strong>Insights</strong></p><p><strong>a. </strong>Sales grew strongly from 2016 to 2019, increasing by 6.86%, 72.32%, and 42.81% respectively. However, sales declined by 49.11% in 2020, reversing the previous growth trend. This significant decline highlights the need to investigate the factors affecting performance and develop strategies to improve sales resilience.</p><p><strong>b. The United States</strong> generated the highest country-level revenue, while <strong>North America</strong> remained the leading continent. This indicates that revenue is highly concentrated in one major market, creating a potential risk if demand or sales performance in this region declines.</p><p><strong>c. </strong>A major concern is the sharp decline in revenue between <strong>February and April</strong>, falling from approximately <strong>$8 million in February to below $1 million in April</strong>. This substantial decrease requires further investigation to identify the underlying causes and assess its impact on overall business performance.</p><p><strong>2. Product Performance Analysis</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*lWe4Cf1cNC8qFbSBtoFPrg.png" /><figcaption>Product Performance</figcaption></figure><p>The report indicates that the business maintained an overall <strong>profit margin of approximately 42%</strong> during the analysis period. <strong>Computers were the strongest contributor to revenue and profit, accounting for approximately 35%</strong>, while desktop products also dominated the top-performing products by quantity sold and revenue.</p><p><strong>Insights:</strong><br> <strong>a.</strong> Adventure Works was the highest-performing company, this distribution shows that performance is moderately concentrated at the top. However, the presence of lower-performing companies indicates uneven performance across the portfolio, suggesting a need to strengthen weaker segments while maintaining the strong contribution from leading entities.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/787/1*6uJSZURoKt91dnx0QlBScg.png" /></figure><p><strong>b. </strong>Several products generated high revenue but were not among the most profitable, indicating that <strong>strong sales do not necessarily translate into higher profitability</strong>.</p><p><strong>c. </strong>Lamp products recorded relatively low sales volumes, which may indicate weaker customer demand or ineffective pricing, product positioning, inventory management, or marketing.</p><p><strong>Business Recommendations</strong></p><p>Based on the analysis, management should consider the following actions:</p><ol><li><strong>Prioritize High-Performing Products:</strong> Focus inventory planning and marketing efforts on products that generate strong sales volume, revenue, and profit, particularly the computers category.</li><li><strong>Review High-Volume, Low-Revenue Products:</strong> Evaluate products with strong sales volumes but relatively low revenue to determine whether pricing, margins, discounts, or promotional strategies need adjustment.</li><li><strong>Protect High-Value Products:</strong> Maintain adequate stock and target marketing for lower-volume products that generate significant revenue or profit, as these may serve valuable customer segments.</li><li><strong>Review Underperforming Products:</strong> Products with consistently low sales and revenue should be assessed for possible repricing, repositioning, increased promotion, or removal from the product portfolio.</li><li><strong>Improve Inventory Planning:</strong> Use sales volume, revenue, and profitability data together to improve demand forecasting and inventory decisions, reducing the risk of overstocking slow-moving products or understocking high-demand products.</li><li><strong>Diversify Market Exposure:</strong> Since revenue is concentrated in key markets, particularly the United States and North America, management should explore opportunities in lower-performing regions through targeted marketing and customer acquisition strategies. This would reduce market concentration risk and support more sustainable long-term growth.</li></ol><p><strong>Limitations</strong></p><p>The analysis was subject to several limitations. The dataset covered multiple years, with 2021 representing the final and only partial year of data. This limited direct comparison between 2021 and the preceding complete years, as the available 2021 data did not cover the full annual reporting period. Therefore, performance trends involving 2021 were interpreted with caution and should not be considered representative of full-year performance. In addition, the data set did not include information on <strong>discounts, promotions, marketing activities, or other pricing factors</strong>. Consequently, the analysis could not fully determine whether changes in sales, revenue, and profitability were influenced by pricing strategies, promotional campaigns, or changes in marketing activity.</p><p><strong>Conclusion</strong></p><p>Overall, the business maintained a <strong>strong profit margin and significant sales activity</strong>, with Computers and key markets such as North America making major contributions to performance. However, the analysis also revealed <strong>product and market concentration, underperforming categories, and a significant decline in sales during 2020</strong>. Addressing these areas through improved product management, market diversification, inventory planning, and targeted marketing can help reduce business risk, strengthen profitability, and support sustainable future growth.</p><p><strong>Author</strong>: Alarape Abdulazeez</p><p>Connect with me on<a href="http://linkedin.com/in/alarape-abdulazeez"><strong> LINKEDIN</strong></a><strong>.</strong></p><p>View Project on <a href="https://github.com/Alapexboi/SALES-PERFORMANCE-ANALYSIS">GITHUB</a><strong>.</strong></p><p><strong>Thank you for reading!</strong></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=d5d018f86aca" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>