<?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 Precious_Okonkwo on Medium]]></title>
        <description><![CDATA[Stories by Precious_Okonkwo on Medium]]></description>
        <link>https://medium.com/@precious_NK?source=rss-b68c775d6df2------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*m8DgJKmyWA-zDTB1ApWung.jpeg</url>
            <title>Stories by Precious_Okonkwo on Medium</title>
            <link>https://medium.com/@precious_NK?source=rss-b68c775d6df2------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sat, 21 Nov 2026 13:59:12 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@precious_NK/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[U.S PRESIDENTS AND VICE PRESIDENTS OVERVIEW]]></title>
            <link>https://medium.com/@precious_NK/u-s-presidents-and-vice-presidents-overview-0787fb231c05?source=rss-b68c775d6df2------2</link>
            <guid isPermaLink="false">https://medium.com/p/0787fb231c05</guid>
            <dc:creator><![CDATA[Precious_Okonkwo]]></dc:creator>
            <pubDate>Thu, 29 May 2025 14:32:43 GMT</pubDate>
            <atom:updated>2025-05-29T14:32:43.943Z</atom:updated>
            <content:encoded><![CDATA[<p>This Project is basically to understand the United States Presidents and Vice Presidents dataset answering questions that might come up when looking at the data like the annual salaries of these various presidents, Presidents with Vice presidential experience, U.S Presidents and their Vice who had salaries above a certain amount etc.</p><p>The dataset was cleaned and visualized using Excel. Columns in the Dataset include: President, Prior (the position held before becoming President), Party, Vice President, Salary, Date Updated, Date Created, Year Created and ‘Was Vice President’-this column was added by me using this formula: =IF(ISNUMBER(SEARCH(“Vice President”, [@Prior])), “Yes”, “No”) to find the count of Presidents who were once vice presidents before assuming the role of President in the United States.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Y1iazX3hMOOYjx0k-hUu7w.png" /></figure><ol><li>Top 10 U.S Presidents Salary — Highlights the salaries of the U.S presidents( Top 10).</li><li>Total and Average Salary by Party — Compares the finance of each party in terms of salaries of their Presidents.</li><li>U.S Presidents Salaries above $350,000 — Highlights the salaries of U.S Presidents that are above $350,000, the names of the Presidents and their Vice.</li><li>Count of Presidents by Vice President — This checks who was the Vice President for more than one President and also the number of times the Vice President seat was left vacant which is 9 times according to the data.</li><li>Presidents who were once V.Ps — Simply shows how many U.S. presidents were previously Vice Presidents.</li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/859/1*M1hWh8VfQPMXDOp_hU6h3w.png" /></figure><p>The last chart (doughnut chart) shows that 30 of these presidents were not vice presidents prior to when they became Presidents while 14 of them had Vice Presidential experience.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=0787fb231c05" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How I Created My First Ms-Excel Sales Dashboard as a Data Analyst in Training.]]></title>
            <link>https://medium.com/@precious_NK/how-i-created-my-first-ms-excel-sales-dashboard-as-a-data-analyst-in-training-2a631c4f3f06?source=rss-b68c775d6df2------2</link>
            <guid isPermaLink="false">https://medium.com/p/2a631c4f3f06</guid>
            <dc:creator><![CDATA[Precious_Okonkwo]]></dc:creator>
            <pubDate>Mon, 26 May 2025 19:10:13 GMT</pubDate>
            <atom:updated>2025-05-26T19:10:13.406Z</atom:updated>
            <content:encoded><![CDATA[<p>In my journey to becoming a Data Analyst, one of our tasks in class was to create a Sales Dashboard using Microsoft Excel. Using Excel on the surface isn’t new to me but using it to create a Dashboard and learn other features felt a little intimidating at first but it is actually fun pulling everything together. The goal was to summarize and visualize the data shared with us.</p><p>Here’s the dashboard I created:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*rw4jeglBiTGkoj101_PmOQ.png" /></figure><ul><li><strong>Top 5 Agents:</strong> A bar chart highlighting the highest-performing sales agents by Sum of Revenue.</li><li><strong>Quantity of Sales:</strong> A horizontal bar chart showing which product categories drive the most units sold.</li><li><strong>Revenue by Region:</strong> A vertical chart showing which sales regions generates the most revenue.</li><li><strong>Top 5 Customers:</strong> A pie chart showing the customers with the highest spend.</li><li><strong>Monthly Trend in Revenue:</strong> A line graph that displays the monthly trend in revenue over time.</li><li><strong>Average per Item Sold:</strong> Compares average values per item in a horizontal bar format.</li><li><strong>Count of Unique Customers:</strong> Displays how many unique clients were served.</li><li><strong>Sales Performance :</strong> A combo chart showing agent performance in sales across the 4 regions.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*sZSN9uwsmY7gqnDOVVCkhQ.png" /></figure><p>I used Microsoft Excel to clean the data, create pivot tables to summarize the dataset into clear and useful insights; answering some questions that may arise as a result of looking at a cumbersome data, and for the dashboard layout. I also added slicers for interactivity, to allow users to filter the dashboard by region, agent and years.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=2a631c4f3f06" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>