<?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 Osas Abu on Medium]]></title>
        <description><![CDATA[Stories by Osas Abu on Medium]]></description>
        <link>https://medium.com/@osarenomaabu?source=rss-fd8dc08699cd------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*8fb708yHzzr-qeOTwFjDOA.jpeg</url>
            <title>Stories by Osas Abu on Medium</title>
            <link>https://medium.com/@osarenomaabu?source=rss-fd8dc08699cd------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Thu, 19 Nov 2026 10:47:06 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@osarenomaabu/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[SuperStore Sales Data Analysis]]></title>
            <link>https://medium.com/@osarenomaabu/superstore-sales-data-analysis-d2000a7f6dbd?source=rss-fd8dc08699cd------2</link>
            <guid isPermaLink="false">https://medium.com/p/d2000a7f6dbd</guid>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[data-analytics]]></category>
            <dc:creator><![CDATA[Osas Abu]]></dc:creator>
            <pubDate>Mon, 16 May 2022 00:44:30 GMT</pubDate>
            <atom:updated>2022-05-16T00:44:30.043Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*2MNSa-yvPoIOkjJ5g1u1kQ.jpeg" /><figcaption>©Getty images/ Carvan images</figcaption></figure><p>In this modern times, businesses are highly dependent on it’s data to make better and informed decisions, data analysis plays an essential role in helping companies reduce cost, increase sales and identify more efficient ways of doing business.</p><p>I utilized a dataset from <a href="https://www.kaggle.com/datasets/rohitsahoo/sales-forecasting/download">Kaggle</a> to perform exploratory data analysis to gain valuable insights on the sales of a global SuperStore.</p><p>Microsoft Excel was the only tool used for the data cleaning, analysis and visualization.</p><h4>Context</h4><p>The retail dataset of a global superstore for 4 years (2015–2018). The dataset is simple and is accessible. It is one csv file with 17 columns and 9801 rows. The data was cleaned and there were no duplicates. The data fields included Row ID, Order ID, Order Date, Ship Date, Ship Mode, Customer ID, Customer Name, Segment, Country, City, State, Region, Product ID, Category, Sub-Category, Product Name, Sales.</p><h4>Content</h4><p>This is a documentation of the analysis process and answers to some key questions related to sales:</p><ol><li>What was the best month and year for sales and why?</li><li>What State had the highest number of sales ?</li><li>What product segment and category was sold the most?</li></ol><p>The answers to these questions come with a visualization to enhance the result.</p><h4>Analysis and Insights</h4><p>As mentioned earlier, MS Excel was the only tool employed in this analysis.</p><p>Some summary statistics for the data set include:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/315/1*-SNFrbE3_HiL3JgMxru5lA.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/303/1*2EOfgRjqmkbwRvA_pYpsKQ.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/289/1*WYBgCwLI-XYJ9hSbUmoelg.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/300/1*ALwZ0ZTVA3Q5BXhOHzShyA.png" /></figure><h4>Question 1</h4><p>What was the best month for sales and why?</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/932/1*bUzhd6S-fDt7AfNvPudW5Q.png" /><figcaption>Illustration 1 by Osas</figcaption></figure><h4>Answer</h4><p>November had the highest sales while the lowest was in February. This can be attributed to seasonal demand just before Christmas (starting from November until the end of December). The store earned a total amount of $350,161.71 in November.</p><h4>Question 2</h4><p>What States had the highest number of sales ?</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/712/1*dH5gv5IeAau-dxGcUSQ--g.png" /><figcaption>Illustration 2 by Osas</figcaption></figure><h4>Answer</h4><p>The state with the highest sales was California with $446,306.46, New York came in second. Other states in the top 5 were Florida, Pennsylvania and Texas. The high number of sales in these states is as a result of the high population which translates to more demand and hence more sales. According to the US Census Bureau, these five states were the five most populated states in the USA in the time period this data was collected.</p><h4>Question 3</h4><p>What product segment and category was sold the most?</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*yc_60sRDi4mtjhc-j4f8oQ.png" /><figcaption>Illustration 3 by Osas</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/698/1*k803HMEMB_ldfViiD_8lug.png" /><figcaption>Illustration 4 by Osas</figcaption></figure><h4>Answer</h4><p>We can see that consumer goods segment generated the most revenue by a very large margin with $1,148,060.53. Consumer goods are fast selling and cheap products purchased by customers for everyday use. Corporate and Home office sales come in at second and third respectively.</p><p>For the sales by category, technology generated the most revenue with $827,455.87. This shows that customers are more likely purchase smart gadgets, appliances, electronics in the stores. Office supplies such as stationaries and Furniture come in at second and third respectively.</p><h4>Excel Dashboard for all the visualizations</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*PQSB62WAgbHJh4vGXFUVNQ.png" /></figure><h4>Conclusion</h4><p>There has been a steady rise in yearly revenue from sales which is attributed to the high number of sales recorded in the most populated states. November is the month with the highest number of sales due to demand during the Christmas season. The most bought items are consumer goods in the technology category.</p><h4>Recommendation</h4><p>The superstore should open more stores in the states and regions with higher revenue like California while geotargeted advertising should be done in the areas with lower revenues.</p><p>The company should also focus on encouraging customers to buy more corporate and home-office products to increase revenue. This can be achieved by partnering with brands in those sectors and offering promotions, coupons and loyalty rewards.</p><p>Another way of increasing sales of the corporate and home-office products is to group them close to the consumer goods so customers can see them when purchasing their tech products. There was also no data about purchases from a mobile app, I believe developing a mobile application for customers to shop from the comfort of their homes will also increase sales.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=d2000a7f6dbd" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>