<?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 Jeffrey Emoakpo Agbejule on Medium]]></title>
        <description><![CDATA[Stories by Jeffrey Emoakpo Agbejule on Medium]]></description>
        <link>https://medium.com/@jeffboy4all?source=rss-467b9d3958cc------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/0*adQY34QwFO876rym</url>
            <title>Stories by Jeffrey Emoakpo Agbejule on Medium</title>
            <link>https://medium.com/@jeffboy4all?source=rss-467b9d3958cc------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sat, 21 Nov 2026 19:22:18 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@jeffboy4all/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[Hello, I’m so excited
I just completed my 2nd project at MeriSKILL - HR Analytics
Objective:
Data…]]></title>
            <link>https://medium.com/@jeffboy4all/hello-im-so-excited-i-just-completed-my-2nd-project-at-meriskill-hr-analytics-objective-data-6d1187a1e5ca?source=rss-467b9d3958cc------2</link>
            <guid isPermaLink="false">https://medium.com/p/6d1187a1e5ca</guid>
            <dc:creator><![CDATA[Jeffrey Emoakpo Agbejule]]></dc:creator>
            <pubDate>Mon, 22 Apr 2024 21:06:32 GMT</pubDate>
            <atom:updated>2024-04-22T21:06:32.272Z</atom:updated>
            <content:encoded><![CDATA[<p>Hello, I’m so excited<br>I just completed my 2nd project at MeriSKILL - HR Analytics<br>Objective:<br>Data Cleaning:<br>Deleting redundant columns.<br>Renaming the columns.<br>Dropping duplicates.<br>Cleaning individual columns.<br>Remove the NaN values from the dataset<br>Check for some more Transformations<br>Data Visualization:<br>∙ Plot a correlation map for all numeric variables<br>∙ Overtime<br>∙ Marital Status<br>∙ Job Role<br>∙ Gender<br>∙ Education Field<br>∙ Department<br>∙ Business Travel<br>∙ Relation between Overtime and Age<br>∙ Total Working Years<br>∙ Education Level<br>∙ Number of Companies Worked<br>∙ Distance from Home</p><p>Tools Used:<br>Microsoft Excel<br>Microsoft Power BI<br>Microsoft Power Point</p><p>Key Insight Derived:<br>Total Employee is 1470 with an attrition rate of 16% (237 employee)<br>Attrition by Distance to work: Those who live close to work tend to leave with a percentage of 69.8%<br>Attrition by Working Years: The level of Attrition was High for those who has worked for 0-10years followed by 11-20 years<br>Attrition by Gender: The level of Male leaving the company tend to be higher than that of the female (63% and 37% respectively)<br>Attrition by Job Satisfaction: Those are dissatisfied with the Job were 73 and Very Dissatisfied were 52 employee out of 237<br>Attrition by Department: The Company has 3 department and the Research and Development has 133 to be the highest<br>Attrition by Job Role: Laboratory Technician has highest of 62, closely followed by Sales Executive at 57 and Research Scientists at 47<br>Attrition by Employee Qualification: From the Visualization, Employee with Bachelor Degree tend to leave with 99 Employee<br>Attrition by Gender and Age; The Age Group between 26 and 35 has the higher with the Male counterpart leading with 70 Employee and Female 46<br>Attrition by Performance: Those with High performance 84% (200 employee) are more compare to those with low performance at 16% (37 employee)</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*V6ACa4oq8ax_Koel-lePmA.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*1O8cR9FBXUI5RoDcyYC2pQ.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ULckMUOjg2NzcFwPrw3cdg.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*8KAqRAhvK9q7bAKxB2z8qA.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*aaapygjHcAZIggsx-ryg0Q.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*9eqTGoShaiaXkAKDW70tkA.png" /></figure><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=6d1187a1e5ca" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Hello, I’m very excited
I just completed my 1st  project at MeriSKILL – Sales Data Analysis…]]></title>
            <link>https://medium.com/@jeffboy4all/hello-im-very-excited-i-just-completed-my-1st-project-at-meriskill-sales-data-analysis-a6ee0fa5a5d1?source=rss-467b9d3958cc------2</link>
            <guid isPermaLink="false">https://medium.com/p/a6ee0fa5a5d1</guid>
            <category><![CDATA[excel]]></category>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[data-visualization]]></category>
            <dc:creator><![CDATA[Jeffrey Emoakpo Agbejule]]></dc:creator>
            <pubDate>Mon, 22 Apr 2024 20:42:46 GMT</pubDate>
            <atom:updated>2024-04-22T20:42:46.255Z</atom:updated>
            <content:encoded><![CDATA[<p>Hello, I’m very excited<br>I just completed my 1st project at MeriSKILL – Sales Data Analysis<br>Objective:<br>In this project, you will dive into a large sales dataset to extract valuable insights. You will explore sales trends over time, identify the best-selling products, calculate revenue metrics such as total sales and profit margins, and create visualizations to present your findings effectively.<br>Tools Used:<br>Microsoft Excel<br>Microsoft Power BI</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*tqxNjpt95vhXfKpRKBzUOA.png" /><figcaption>Raw Data for cleaning</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*txJrXByH2omNCXzbZPG_lg.png" /><figcaption>VISUALIZATION</figcaption></figure><p>Key Insight Derived:<br>Profit Margin of 59%<br>San Franscisco has the Highest Sales and Next was New-York<br>Sales peaked in December<br>Sales dropped drastically in January 1.8Million<br>Top 5 best Selling products are: AAA Bacteries (4 pack), AA Bacteries (4 pack), USB-C Charging Cable, Lightning Charging Cable, Wired Headphones<br>MacBook pro has the highest sale on Top 5 product by sales<br>Tuesday is the most busiest day of the week with highest sales distribution</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=a6ee0fa5a5d1" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>