<?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 Maryjane Obodoeze on Medium]]></title>
        <description><![CDATA[Stories by Maryjane Obodoeze on Medium]]></description>
        <link>https://medium.com/@maryjaneobodoeze?source=rss-70ba14483ae3------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*xkMGKhN3HBHeNdxKP-4KLQ.jpeg</url>
            <title>Stories by Maryjane Obodoeze on Medium</title>
            <link>https://medium.com/@maryjaneobodoeze?source=rss-70ba14483ae3------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Thu, 19 Nov 2026 03:31:57 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@maryjaneobodoeze/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[My Analysis of the Maven Marketing Campaign Data]]></title>
            <link>https://medium.com/@maryjaneobodoeze/my-analysis-of-the-maven-marketing-campaign-data-a2e91a10602d?source=rss-70ba14483ae3------2</link>
            <guid isPermaLink="false">https://medium.com/p/a2e91a10602d</guid>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[excel-dashboard]]></category>
            <category><![CDATA[data-analysis]]></category>
            <dc:creator><![CDATA[Maryjane Obodoeze]]></dc:creator>
            <pubDate>Sun, 31 Dec 2023 14:57:41 GMT</pubDate>
            <atom:updated>2023-12-31T15:28:52.673Z</atom:updated>
            <content:encoded><![CDATA[<h3><strong>My Analysis of the Maven Marketing Campaign</strong></h3><p>This has been long overdue but it is better late than never. I took several refresher courses on Excel and I have been up to a number of things, this Excel project is one of them. I came across it as I followed <a href="https://x.com/Rita_tyna/status/1612349072169439232?s=20">Tina’s roadmap</a> on the journey to becoming a Data Analyst. Get access to the dataset <a href="https://x.com/Rita_tyna/status/1622531347460902913?s=20">here</a> and <a href="https://github.com/OMaryjane/Maven-Marketing-Campaign-Analysis">GitHub</a>.</p><p><strong>The Data</strong></p><p>The dataset contained a total of 28 columns and 2240 rows representing an entry for each customer. The entire dataset was a classification of the customers present at Maven and a broad classification of them as well as their responses to the campaigns carried out. You can also find details of the columns <a href="https://drive.google.com/file/d/1gClTGYWYBJZuBpmmID4ZqnOyCvtoLUs0/view?usp=drive_link">here</a>.</p><p>ID Year_Birth, Education, Marital_Status, Income, Kidhome, Teenhome, Dt_Customer, Recency, MntWines, MntFruits, MntMeatProducts, MntFishProducts, MntSweetProducts, MntGoldProds, NumDealsPurchases, NumWebPurchases, NumCatalogPurchases, NumStorePurchases, NumWebVisitsMonth, AcceptedCmp3, AcceptedCmp4, AcceptedCmp5, AcceptedCmp1, AcceptedCmp2, Response, Complain, Country.</p><p><strong>Data Cleaning</strong></p><p>Cleaning of the Data didn’t require a lot as just minor changes and modifications were needed. The data contained a total of 24 blank cells in the income column which were probably not captured. These were filled with 0 as it was less than 5% of entire data available. No duplicate entries were observed in this dataset. The data was then put in a table and each column formatted accordingly.</p><p>I made some modifications by adding a few columns to help with my analysis; I created an Age range column in order to properly categorize each age and they consist of Teenager, Young Adult, Adult, Elder and Senior. This helped me properly visualize each customer into an age bracket and also to get the age of the ideal customer.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/208/1*IdsC2WJSGMjE9Vw1Kts3Hg.jpeg" /><figcaption>Age groups created</figcaption></figure><p>I also did something similar with the kids and teen column to get a total of children each customer had by using a simple excel formula, from this I was able to create a more simplified column that gave a “Yes” or “No” answer for the presence of kids.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/420/1*mOPGVlnzg3CVE8QGiQwz6A.jpeg" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/286/1*nvT6M1ci0rPHIByLJNqZzA.jpeg" /></figure><p>I also performed minor statistical calculations on the income column.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/377/1*A4PciqA45pA9L2js5z1LUQ.jpeg" /></figure><p>I started creating my pivot tables needed for the visualizations and made changes along the way. The cleaning, Analysis and Visualizations were done using Excel.</p><p><strong>Visualization</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/779/1*pL9Quwex3-cYok9-OHQIHw.png" /><figcaption>Broad overview</figcaption></figure><p>The above image gives a brief summary of this Maven company Dataset</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1015/1*jO4Zaiq-ZuBO99caQKz1ZA.png" /><figcaption>Campaign performance</figcaption></figure><p>The last campaign was the most successful of all 6 across all classes in terms of education and customers with kids or not.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/644/1*LA-VWcKju9om77rIbTo2-g.png" /><figcaption>Breakdown of web purchase by Age</figcaption></figure><p>Age is directly related to the number of web purchases made; the number of web purchases increases and is at its peak at the prime age but slowly decreases as one gets older, also the more educated a person is, the more likely the increase in web purchase, this is seen using the education filter.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/702/1*8DDiQgGSslKMN06y-JpK4g.png" /></figure><p>Based on the amount spent on each product, I was able to create a ‘Total amount’ column spent by each customer and this helped also view the income each country generated. Out of the 8 countries present, Spain made more than 3 times Saudi Arabia which was the second highest income generating country.</p><p><strong>Conclusions</strong></p><p>· Age is directly related to the number of web purchases made; the number of web purchases increases and is at its peak at the prime age but slowly decreases as one gets older, also the more educated a person is, the more likely the increase in web purchase.</p><p>· The last campaign yielded more success than any other, twice the outcome of the previous ones, while campaign 2 was the least performing at 8% of the last campaign.</p><p>· Wines generated the most income compared to the remaining products, fruits and sweet generate the lowest income and perhaps more deals and discount should be offered in these lines to scale up.</p><p>· In store purchases contributed to almost 50% of the income generated by the company, as well as Spain compared to other channels and countries respectively.</p><p>· The ideal customer is around age 41, graduated, married and has at least one child with an average income of $51,000.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*3s1O3dYa9n916vR-eqYIUA.jpeg" /><figcaption>Dashboard</figcaption></figure><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=a2e91a10602d" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[8 week SQL Challenge, Week 1; Danny’s Diner]]></title>
            <link>https://medium.com/@maryjaneobodoeze/8-week-sql-challenge-week-1-dannys-diner-1d9c86143def?source=rss-70ba14483ae3------2</link>
            <guid isPermaLink="false">https://medium.com/p/1d9c86143def</guid>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[sql]]></category>
            <dc:creator><![CDATA[Maryjane Obodoeze]]></dc:creator>
            <pubDate>Wed, 03 May 2023 11:12:31 GMT</pubDate>
            <atom:updated>2023-05-03T17:01:45.228Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*IjQ8XODW__ifjJqoBCvNVw.png" /></figure><p><strong>Introduction</strong></p><p>This is the Danny Ma 8Week SQL challenge. On this my SQL journey, I am challenging myself to start and finish this 8 week challenge. You can also get started <a href="https://8weeksqlchallenge.com/getting-started/">here</a>.</p><p>Just as every business person should, business owners should always perform an overview of their customer base and incorporate customer loyalty programs, which is what Danny is trying to achieve here. Also in doing this, Danny is trying to find out what customers are the most frequent and what products are more popular from the menu.</p><p><strong>N.B; In this case study, I used Postgre SQL for my solutions.</strong></p><p>Link to solution on <a href="https://github.com/OMaryjane/8week-SQL-Challenge-Case-study-1-Danny-s-Diner">GitHub</a>.</p><p><strong>Problem Statement</strong></p><p>From the information provided, Dany wants to know 3 main things about his customers amongst others; visiting patterns, how much money they’ve spent and also which menu items are their favourite. Danny wants to be able to deliver a better and more personalized experience for his loyal customers.</p><p>He plans on using these insights to help him decide whether he should expand the existing customer loyalty program — additionally he needs help to generate some basic datasets so his team can easily inspect the data without needing to use SQL.</p><p>Danny has provided you with a sample of his overall customer data due to privacy issues — but he hopes that these examples are enough for you to write fully functioning SQL queries to help him answer his questions!</p><p>Danny has shared with you 3 key datasets for this case study:</p><ul><li>sales</li><li>menu</li><li>members</li></ul><p><strong>ERD (Entity Relationship Diagram)</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/880/1*Ws1lbQirpRIgfqIwvLZiYA.png" /></figure><p><strong>Case Study Questions</strong></p><ol><li>What is the total amount each customer spent at the restaurant?</li><li>How many days has each customer visited the restaurant?</li><li>What was the first item from the menu purchased by each customer?</li><li>What is the most purchased item on the menu and how many times was it purchased by all customers?</li><li>Which item was the most popular for each customer?</li><li>Which item was purchased first by the customer after they became a member?</li><li>Which item was purchased just before the customer became a member?</li><li>What is the total items and amount spent for each member before they became a member?</li><li>If each $1 spent equates to 10 points and sushi has a 2x points multiplier — how many points would each customer have?</li><li>In the first week after a customer joins the program (including their join date) they earn 2x points on all items, not just sushi — how many points do customer A and B have at the end of January?</li></ol><p>Let’s dive in!</p><ol><li><strong>Total amount each customer spent at the restaurant?</strong></li></ol><p>To answer this, we need the customer_id from the sales table and the prices of the products from the product table using the key ‘product_id’. This was then grouped by customer_id in order to have the total for each customer.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/320/1*2R6WkrDZiLaGsCQwxwBh3g.png" /><figcaption>syntax for question 1</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/320/1*HCe1sLa_QqFZoGJRxusFuQ.png" /><figcaption>output for question 1</figcaption></figure><p>Results have been placed in descending order leaving Customer A as the customer who has spent the highest.</p><p><strong>2. How many days each customer visited the restaurant?</strong></p><p>For this, we need the customer_id, count of days the customers made order (this will give the number of visits) and we group by customer_id;</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/510/1*l87V4lkdabH3G7LlHOVrJg.png" /><figcaption>Question 2 syntax</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/463/1*SpgBvKL8dX7NKECY88ez9Q.png" /><figcaption>Output</figcaption></figure><p>The output indicates that customers A &amp; B had the most number of visits.</p><p><strong>3. What was the first item from the menu purchased by each customer?</strong></p><p>The first item from the menu will be gotten by ranking all orders of the customers then selecting the first by date. To do this, we need a CTE first then we use DENSE_RANK.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/864/1*Z1RIWUnarpHArYb_A7Zd-A.png" /><figcaption>Question 3 syntax</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/662/1*EivoYm1SxqkPAmr7ZX47-g.png" /><figcaption>Output</figcaption></figure><p>This shows that customer probably ordered 2 different products (curry and sushi) first, while customers B and C had curry and ramen as their first orders respectively.</p><p><strong>4. The most purchased item on the menu and how many times was it purchased by all customers?</strong></p><p>Here, the most purchased products from the 3 would be the product with the highest number of counts from the sales table joining the menu table.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*y1eTJ3WlVhDY0a7esM3I6w.png" /><figcaption>Question 4 syntax</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/470/1*XAouwqjFy5FEXWn30nla6Q.png" /><figcaption>Output</figcaption></figure><p>Ramen ranking first as the most bought item.</p><p><strong>5. Which item was the most popular for each customer?</strong></p><p>Most popular item for each customer will involve a COUNT of product orders and the highest by default becomes the most popular item.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/706/1*Z_yv6oQeob4LPVotqMAJgA.png" /><figcaption>Question 5 syntax</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/543/1*Sx-RiBuenE2huO0HbQaZxQ.png" /><figcaption>Output</figcaption></figure><p>From this result, we can see that customer A has ramen as the most popular item ordered, closely followed by curry.</p><p>Customer ordered all 3 items the most while customer C has ramen as the most popular. It’s looking like ramen is the most popular product at Da nny’s.</p><p><strong>6. Which item was purchased first by the customer after they became a member?</strong></p><p>For this problem, a CTE is definitely required. First we define our CTE by selecting customer’s order made when their order date was after their join date, we rank, then select from it.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/974/1*Zb4ThBCwULB0hKtm6bnx2g.png" /><figcaption>question 6 syntax</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/407/1*P3gcLAcr5LY1Xvd3ywyINw.png" /><figcaption>output</figcaption></figure><p>Customer A ordered curry immediately after becoming a member while B ordered sushi first.</p><p><strong>7. Which item was purchased just before the customer became a member?</strong></p><p>We run a query similar to the solution of question 6 but chain the condition to suit orders before the customer became a member.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/889/1*3T-AaKRA1f1z0HwXHYh5vw.png" /><figcaption>question 7 syntax</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/463/1*TFJdju9VdlWAFCwmCdrhQw.png" /><figcaption>Output</figcaption></figure><p>Customer A ordered sushi and curry first before officially becoming a member while B ordered curry first.</p><p><strong>8. What is the total items and amount spent for each member before they became a member?</strong></p><p>Putting the same condition (before the customer became a member), we count the number of items ordered by each customer and how much they each spent.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*EoniCu3k87ZMZoAKhEci5Q.png" /><figcaption>Question 8 syntax</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/501/1*qL_8a1STNnY0AR69dzOecw.png" /><figcaption>output</figcaption></figure><p>Customer A made a total of 2 orders amounting to $25 while B made 3 orders amounting to $40 before they became members.</p><p><strong>9. If each $1 spent equates to 10 points and sushi has a 2x points multiplier — how many points would each customer have?</strong></p><p>As initially stated, Danny hopes to start a customer loyalty program and one of the ways he wishes to determine this is by using a points system. We sum the prices for all products each customer ordered and allocate points to them. We also use a CASE statement here because not all products carry the same points.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ZJhlScbpPArrCOp25mWOeA.png" /><figcaption>question 9 syntax</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/465/1*sigiJusqNFCaNQNwBNZT2g.png" /><figcaption>Output</figcaption></figure><p><strong>10. In the first week after a customer joins the program (including their join date) they earn 2x points on all items, not just sushi — how many points do customer A and B have at the end of January?</strong></p><p>Adding another condition to allocate points to the customers, we use a CTE along with a CASE statement. Customers who ordered sushi get 2x the points as well as customers who made orders in the first week after joining.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*eKFf-7mG8iD5dUGldXqRxg.png" /><figcaption>question 10 syntax</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/467/1*qrqiat9B3P4_R0ChWx7WGg.png" /><figcaption>output</figcaption></figure><p>Customer A has 1,370 points</p><p>Customer B has 820 points.</p><p><strong>Bonus Questions</strong></p><p>Also, Danny needs a view of 2 tables to help him get insights from the data they have.</p><ol><li>To recreate the table below;</li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/639/1*Cmya0mNiW8E3Rp_IWSgJIw.png" /><figcaption>Bonus question 1</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/744/1*eT02TyMBRgMdLMbFOzGbwg.png" /><figcaption>solution</figcaption></figure><p>2. Recreate the table below showing ranked customers who are members;</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/745/1*jfrl8jDZWmqiMcfJx22wRw.png" /><figcaption>bonus question 2</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/845/1*oJFqJhXsBixQTrIZxm6ovQ.png" /><figcaption>solution</figcaption></figure><p><strong>INSIGHTS</strong></p><p>From this brief analysis, we can deduce a couple of things;</p><ul><li>Danny’s most popular product is Ramen across all customers, and should have more points.</li><li>Customer A visited the restaurant the most and also spent the highest money, this is closely followed by Customer B</li><li>Customer C is yet to become a member and has few orders too, follow ups should be done to understand where the customer is at.</li></ul><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=1d9c86143def" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Google Playstore Apps; my first ever project.]]></title>
            <link>https://medium.com/@maryjaneobodoeze/google-playstore-apps-my-first-ever-project-67d990d986e6?source=rss-70ba14483ae3------2</link>
            <guid isPermaLink="false">https://medium.com/p/67d990d986e6</guid>
            <dc:creator><![CDATA[Maryjane Obodoeze]]></dc:creator>
            <pubDate>Fri, 20 Jan 2023 02:02:35 GMT</pubDate>
            <atom:updated>2023-01-20T02:02:35.608Z</atom:updated>
            <content:encoded><![CDATA[<p><strong>Introduction</strong></p><p>I recently became a member of the She Code Africa (SCA) community . Late last year, I was opportune to have attended the first ever SCA conference and to say the least, it was mind blowing and challenging at the same time. I’m in the process of transitioning into the tech space; Data Analysis. I’ve known this for a while now but I needed to join a community for guidance and that’s how I got added to the SCA community on Slack.</p><p>Luckily for me, I came in time as they (data science-ML-AI) group were about starting their project for the year. I’ve had no experience at all analyzing any project or even completing a course but I wanted to do this to see how far I can go, to learn too in order to properly start this transitioning journey and that’s why I’m here.</p><p>Google play store also known as google play (formerly known as the Android Market) is a digital distribution service operated and developed by Google. It serves as the official app store for certified devices running on the Android operating system and its derivatives, allowing users to browse and download applications developed with the Android software development kit (SDK) and published through Google.</p><p>Google play was initially launched in October 2008 and then re-launched in March 2012 after combining the Android market and Google together. Google Play is the official app store for every device that runs on an android operating system.</p><p>It also acts as a digital media store that offers music, e-books, movies and TV programs. The apps can be downloaded directly from Google play, while the platform allows its app developers to make apps that are free and charge a fee. The platform had over 82 billion app downloads just in 2016 and had over 3.5 million Android applications available in 2017.</p><p><strong>Analysis</strong></p><p>Source of the dataset is kaggle. The dataset contains over 10,000 apps scrapped from google playstore and grouped into 33 different categories with reviews, number of downloads, latest versions of the apps created with date and type based on free or paid for.</p><p>I decided to go from the angle of the developers and to give observations from my analysis.</p><p>After accessing the <a href="https://www.kaggle.com/datasets/lava18/google-play-store-apps">dataset</a> on kaggle, I proceeded to upload on excel to start Data cleaning. I started by attempting data cleaning of which I checked for duplicates, inapplicable or inconsistent values etc by introducing slicers on all the columns to better get a view of the data.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*-qq7SKCylNMBXtRBXg9LQg.png" /><figcaption>Overview</figcaption></figure><p>After doing this, I got a bit of clarity and I used pivot charts to give an insight to which apps were the most popular by downloads and number of reviews as well as category of apps; apps that generated the most income going by the paid apps as well as category of apps and the highest income generated from the paid apps.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*4shlbjay3s2AbMPoStC6Pw.png" /><figcaption>Dashboard</figcaption></figure><p><strong>Observations</strong></p><p>1.The most popular apps going by number of installs of about 26B downloads are all free, more in-app purchases should be done alongside ads to generate more income.</p><p>2.Apps with the highest number of reviews should be looked into as to whether positive or negative reviews and improve on them.</p><p>3.Of all 33 categories of the apps, the game category ranks the highest by number of downloads; a number of them can be created with subscriptions in order to generate income.</p><p>4.A proper breakdown of the type of reviews for the finance category (which is the category with the highest number of downloads for paid apps) should be done for adequate improvement where necessary.</p><p><em>Thank you for coming this far.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=67d990d986e6" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>