<?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 Ibekendu ifeoma on Medium]]></title>
        <description><![CDATA[Stories by Ibekendu ifeoma on Medium]]></description>
        <link>https://medium.com/@ibekenduifeoma2017?source=rss-9e5d6645cdfd------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*I4SK30doufdGgdasUlqOKg.jpeg</url>
            <title>Stories by Ibekendu ifeoma on Medium</title>
            <link>https://medium.com/@ibekenduifeoma2017?source=rss-9e5d6645cdfd------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sat, 21 Nov 2026 04:02:52 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@ibekenduifeoma2017/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[Sample Superstore Financial Performance: Data Insights for Business Growth.]]></title>
            <link>https://medium.com/@ibekenduifeoma2017/sample-superstore-financial-performance-data-insights-for-business-growth-0e3f8667d5db?source=rss-9e5d6645cdfd------2</link>
            <guid isPermaLink="false">https://medium.com/p/0e3f8667d5db</guid>
            <category><![CDATA[data-analysis]]></category>
            <dc:creator><![CDATA[Ibekendu ifeoma]]></dc:creator>
            <pubDate>Wed, 05 Feb 2025 20:25:57 GMT</pubDate>
            <atom:updated>2025-02-05T20:32:23.499Z</atom:updated>
            <content:encoded><![CDATA[<p><strong>Introduction</strong></p><p>Sales performance is vital for maximizing profits and minimizing losses. This report analyzes data from a sample superstore to identify key factors affecting sales and suggests improvements. This analysis aims to identify insights that enhance profitability and reduce losses. Given the decline in sales, this report explores possible causes and recommends solutions.</p><p><strong>Dataset Overview</strong></p><p>The dataset contains 9,995 sales records from a sample superstore, covering shipping methods, customer categories, and other attributes. It was sourced from Kaggle and other open platforms.</p><p><strong>Data Cleaning</strong></p><p>To ensure accuracy, the dataset was cleaned by:</p><p>· Handling missing values</p><p>· Verifying data types</p><p>· Creating a “Profit and Loss” column to track losses</p><p>· Key Performance Indicators (KPIs)</p><p><strong>Key Findings</strong></p><p>· Total sales amounted to $2,297,201, with a profit of $286,397, reflecting a 12.5% margin. This low profitability calls for further investigation.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/366/1*nH-Q-k_2ZmtXXUTLb6hfsQ.png" /></figure><p>· Shipping Mode: Standard Class was the most used, while Same Day Delivery was the least. Shipping mode had minimal impact on profitability.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/643/1*tyuhHRxe7CsM-qs0XzbnZQ.png" /></figure><p>· Top Performing Cities: New York City, Los Angeles, Philadelphia, San Francisco, and Seattle had the highest order volumes.</p><p>· Discount Impact: Higher discount rates were linked to greater losses, indicating that discount policies significantly contributed to financial losses.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/666/1*I1VLjol-DdJ5CvB7-err6g.png" /></figure><p><strong>Recommendations</strong></p><p>1. Reduce Discounts — Lower the discount rates to prevent unnecessary losses while still attracting customers.</p><p>2. Focus on Best-Selling Cities — Invest more in marketing and promotions in top cities to increase sales.</p><p>3. Make Shipping More Cost-Effective — Find ways to cut shipping costs and improve delivery efficiency to boost profits.</p><p>This is a HNG internship project , to learn more : <a href="https://hng.tech/internship">https://hng.tech/internship</a>, <a href="https://hng.tech/hire">https://hng.tech/hire</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=0e3f8667d5db" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Learning Business Statistics and Analysis Online on Coursera.]]></title>
            <link>https://medium.com/@ibekenduifeoma2017/learning-business-statistics-and-analysis-online-on-coursera-271cb8cc1967?source=rss-9e5d6645cdfd------2</link>
            <guid isPermaLink="false">https://medium.com/p/271cb8cc1967</guid>
            <category><![CDATA[data-storytelling]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[statistics]]></category>
            <dc:creator><![CDATA[Ibekendu ifeoma]]></dc:creator>
            <pubDate>Tue, 05 Dec 2023 00:14:10 GMT</pubDate>
            <atom:updated>2023-12-05T00:14:10.191Z</atom:updated>
            <content:encoded><![CDATA[<p><strong>Learning Business Statistics and Analysis Online on Coursera.</strong></p><p>I stumbled upon tweets where people were discussing linear regression, hypothesis testing, and more. It was amusing because I’ve been learning data analysis for a while, and I wasn’t familiar with any of those concepts. I love challenges so I took up the challenge and got the Business Statistics and Analysis Specialization course by Rice University on Coursera.</p><p><em>N.B : This article serves as more of a guide; you won’t gain substantial knowledge until you actually enroll in the course.</em></p><p>The course taught me a bunch of things. I learned a lot, and the tests were quite challenging. I also checked out some YouTube videos, and they really helped me understand parts of the course I was struggling with. The specialization course had five courses.</p><p><strong>1.Introduction to Data Analysis using Excel</strong>:</p><p>This course was easy for me since I already knew some stuff. I learned about data manipulation and arithmetic manipulations and functions in Excel. I also figured out how to plot scatter plots, histograms (using bins) and graphs.</p><h4>2.<strong>Basic Data Descriptors, Statistical Distributions and Applications to Business Decisions</strong>:</h4><p>I understand that the course title might seem lengthy and unclear. However, during this program, I gained knowledge in descriptive statistics such as mean, box plot, standard deviation and more. I also acquired insights into distributions, their corresponding Excel functions and their practical application in business decision-making. Additionally, I learned about probability density functions and the distinction between sample and population data, as well as when to appropriately apply each. I faced challenges in completing this course, particularly due to the statistics component. Statistics has never been a subject I easily understood, even back in high school. To grasp the basics, I had to watch YouTube videos.</p><blockquote>Probability density functions is a rule that assigns probabilities to various possible values that a random variables takes when it is being approximated by a statistical distribution.</blockquote><h4>3.Business Applications of Hypothesis Testing and Confidence Interval Estimation:</h4><p>I gained knowledge about confidence intervals, specifically how to determine the confidence interval for a population proportion. Additionally, I learned the process of calculating sample sizes, t-statistics and z-statistics, along with understanding when to use either t-statistics or z-statistics for hypothesis testing.</p><blockquote>Hypothesis testing is a statistical method used to make inferences or draw conclusions about a population based on a sample of data.</blockquote><p>The course covered hypothesis testing, providing guidelines and formulas for effective implementation. Furthermore, I acquired the skills to assume equal variance and unequal variance for conducting paired t-tests on means. The learning experience included various case scenarios illustrating the assumption of equal variance.</p><h4>4. Linear Regression for Business Statistics:</h4><p>In this course, I learnt about Linear Regression models, constructing regression models, estimating parameters and interpreting the model. Additionally, I learned the process of obtaining p-values from the models, and the course addressed numerous questions. The introduction of Dummy Variables in linear regression was a key topic covered, I learnt the concept of collinearity, emphasizing the use of the semi-log function or log-log function when variables are highly correlated.</p><blockquote>Dummy variables, also known as indicator variables, are used in regression models to represent categorical data. In a regression analysis, we often encounter independent variables that are categorical and don’t have a meaningful numerical representation.</blockquote><h4>5. Capstone Project:</h4><p>I worked on 2 different projects, in this project I was instructed to clean and merge different datasets for the project.<br>- Test difference in market value between OCCUPIED and VACANT housing units.<br>- Build a model for predicting market value for housing units.</p><p>This is the link that provides a breakdown of the project <a href="https://github.com/ifykendu/Coursera-Capstone-Project">https://github.com/ifykendu/Coursera-Capstone-Project</a></p><h4>6.Conclusion</h4><p>I highly suggest this course for individuals beginning their journey in Data Analysis or Data Science. It provides a solid foundation in statistics and aids in prediction analysis, among other valuable skills. About halfway through the course, I realized my interest in Data Science, resolving a long-standing confusion about which path to pursue in the field of data.I was unable to obtain the direct link to the entire course, but you can visit Coursera and search for Business Statistics and Analysis Specialization by Rice University.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=271cb8cc1967" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[MAVEN AIRLINE CUSTOMER SATISFACTION ANALYSIS]]></title>
            <link>https://medium.com/@ibekenduifeoma2017/maven-airline-customer-satisfaction-analysis-40351a6eda92?source=rss-9e5d6645cdfd------2</link>
            <guid isPermaLink="false">https://medium.com/p/40351a6eda92</guid>
            <dc:creator><![CDATA[Ibekendu ifeoma]]></dc:creator>
            <pubDate>Wed, 09 Aug 2023 14:20:30 GMT</pubDate>
            <atom:updated>2023-08-09T14:20:30.523Z</atom:updated>
            <content:encoded><![CDATA[<p><strong>Project Overview</strong><br> This project focuses on the airline passengers satisfaction rate including additional information about each passenger, their flight, and type of travel, as well as their evaluation of different factors like cleanliness, comfort, service, and overall experience.<br>The aim of the project is to answer these questions:</p><p>1.Which percentage of airline passengers are satisfied? Does it vary by customer type? What about type of travel?</p><p>2.What is the customer profile for a repeating airline passenger?</p><p>3.Does flight distance affect customer preferences or flight patterns?</p><p>4.Which factors contribute to customer satisfaction the most? What about dissatisfaction?</p><p><strong>Data Information</strong><br>This dataset was acquired from Kaggle, seemingly as part of a data challenge. This dataset comprises of 129,880 rows and 24 columns which are:</p><p><em>ID, Gender ,Age range, Age ,Customer Type ,Type of Travel, Class ,Flight Distance, Departure Delay, Arrival Delay, Departure and Arrival Time Convenience, Ease of Online Booking, Check-in Service, Online Boarding, Gate Location, On-board Service, Seat Comfort, Leg Room Service, Cleanliness, Food and Drink, In-flight Service, In-flight Wi-Fi Service, In-flight Entertainment, Baggage Handling, Satisfaction.</em></p><p><strong>DATA CLEANING</strong><br>Data cleaning was relatively straightforward as the data wasn’t messy. Loaded my data into the power query editor, I examined the presence of absent data in the ID_Column. Also no outliers as the rating columns were the only ones containing categorical data, I categorized the age data into ranges to facilitate analysis using conditional statement.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/990/1*UUV-r2zoVjL7sUgAoovG2A.jpeg" /><figcaption>new column using conditional statement</figcaption></figure><p><strong>My Thought Process</strong><br>As this pertains to an airline satisfaction issue, I recorded the factors that might contributing to customer dissatisfaction based on the provided data which are:</p><ul><li>Departure delay: This occurs due to the fact that when airlines cause delays for customers, their satisfaction decreases.</li><li>Type of Class: Business class passengers typically receive favourable treatment owing to the higher ticket costs associated with their travel.</li><li>Airline service Quality.</li></ul><p><strong>Analysis</strong><br>I chose to start the analysis by considering my assumptions. Using pivot tables, I examined the dissatisfaction within different class types.<br>Around 30.5% of Business class customers are not satisfied. On the other hand, a significant 81.2% of Economy class and 75.4% of Economy Plus class passengers are also unsatisfied, which is remarkably high. This suggests that Business class customers receive better service as expected, but the difference in satisfaction levels is too substantial.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/534/1*ZL0vyeYVARhiglwquXXwcg.jpeg" /></figure><p>Out of the customers traveling for business, 58.4% express satisfaction, whereas only 10.1% of those traveling for personal reasons are satisfied. Additionally, delving into the 58.4% satisfied customers, it was found that a majority of them choose to travel in the business class. This reinforces our initial analysis.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/568/1*1j_dyths9t9CjNR-l1_q0A.jpeg" /></figure><p><strong>Departure Delay</strong><br>I also examined the departure delay aspect and observed that 56.5% of customers experienced no delays, which seems reasonable. However, 14% of customers faced delays of over 30 minutes, and only 6% of them were satisfied. This highlights that a delayed departure significantly impacts customer satisfaction.</p><p>Explored certain aspects that require enhancement, including Gate Location, In-Flight Service, and Online Booking. These crucial elements have an impact on customer satisfaction, as their average ratings were low.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/457/1*x5v4LKVo1wopHSpPQlKGuQ.jpeg" /></figure><p><strong>Insights</strong><br>43% of customers are not satisfied most of them are first time travelers. Business class travelers are more satisfied than economy and economy plus.</p><p>Customers travelling for business trips are more satisfied because most of them buy business class tickets.</p><p>Travel distance doesn’t affect customer satisfaction rate but Departure delay does.</p><p><strong>Neglecting these areas could lead to the airline losing more customers. The analysis indicates that 18% of customers are returning clients, implying that the airline struggles with customer retention.</strong></p><p><strong>Dashboard</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*oVHLTOH7x4SCOmHWRA441g.jpeg" /><figcaption>This Dashboard was done on excel.</figcaption></figure><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=40351a6eda92" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Maven Marketing Campaign Analysis.]]></title>
            <link>https://medium.com/@ibekenduifeoma2017/maven-marketing-campaign-analysis-8d536387f8c1?source=rss-9e5d6645cdfd------2</link>
            <guid isPermaLink="false">https://medium.com/p/8d536387f8c1</guid>
            <dc:creator><![CDATA[Ibekendu ifeoma]]></dc:creator>
            <pubDate>Mon, 12 Jun 2023 13:15:40 GMT</pubDate>
            <atom:updated>2023-06-12T13:15:40.382Z</atom:updated>
            <content:encoded><![CDATA[<p><strong>Introduction</strong></p><p>This is an analysis of Maven Marketing Campaign. This dataset contains marketing campaign data of 2,240 customers of maven marketing. The datasets consists of 27 columns which consists of Clients information, Products, Platforms and Campaign success/failures.</p><p><strong>Data Cleaning</strong></p><p>I cleaned the data for easier analysis to be done using Power Query. First I had to check for blank cells, errors and duplicates. I only considered the ID column for duplicate entries since it’s not possible to have two clients with the same ID.I modified each column to its appropriate data type. I changed “Dt_Customer” column to “Date Joined” .</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/236/1*oKcOQR7MYtfnxySeLd_AAg.jpeg" /></figure><p>I also renamed other columns that were misspelt and not accurately represented. I added a new column “Age” by subtracting the “Year_Birth” from 2023 to represent the age of clients.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/653/1*IxJYpmOh1-EfL5lA2_3zOQ.jpeg" /></figure><p><strong>Analysis</strong></p><p>The chart below indicates that majority of the web purchases were made by married people and Spain had the highest web purchase.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/860/1*QLyWNumWHwG9tJjnaawytA.jpeg" /></figure><p>Among the different purchasing platforms, in-store purchases accounted for the largest share at 46.18%, followed by web purchases at 32.58% and catalog purchases at 21.23%.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/445/1*glHqxwlGW-anSgCBF1ta0Q.jpeg" /></figure><p>Wine product performed exceptionally well, generating a total sales revenue of $680k.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/428/1*ubmDa1GmBeekKYiSASpz5A.jpeg" /></figure><p>This final visualization combines all the elements to presents a view of the data.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*DidfQUl46Cxg7qGXV3G7cw.jpeg" /></figure><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=8d536387f8c1" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>