<?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 Olowo Ayodele on Medium]]></title>
        <description><![CDATA[Stories by Olowo Ayodele on Medium]]></description>
        <link>https://medium.com/@olowoayodele08?source=rss-769131fd483b------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/0*aY_HDhzGSkO-1-84</url>
            <title>Stories by Olowo Ayodele on Medium</title>
            <link>https://medium.com/@olowoayodele08?source=rss-769131fd483b------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sat, 21 Nov 2026 21:55:45 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@olowoayodele08/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[HCAHPS Patient Survey]]></title>
            <link>https://medium.com/@olowoayodele08/hcahps-patient-survey-732ed9d9b073?source=rss-769131fd483b------2</link>
            <guid isPermaLink="false">https://medium.com/p/732ed9d9b073</guid>
            <category><![CDATA[hospital-management]]></category>
            <category><![CDATA[patient-care]]></category>
            <category><![CDATA[health]]></category>
            <category><![CDATA[caregiver-support]]></category>
            <dc:creator><![CDATA[Olowo Ayodele]]></dc:creator>
            <pubDate>Fri, 11 Aug 2023 08:32:49 GMT</pubDate>
            <atom:updated>2023-08-11T08:32:49.288Z</atom:updated>
            <content:encoded><![CDATA[<p>HCAHPS Patient Survey</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/764/1*KSPnabnC-BcAIxM_jVo_Qg.jpeg" /><figcaption>HCAHPS Patient Survey</figcaption></figure><p>Aim</p><p>To evaluate whether the HCAHPS survey has been successful in accomplishing some specific goals</p><p>About the Project</p><p>The dashboard features a clean and intuitive design that allows users to quickly gain insights from the data.</p><p>There are FIVE visuals strategically placed to provide key metrics and summaries. These visuals are designed as CHARTS, making them easily distinguishable from the rest of the dashboard elements. There are also card where each focuses on specific aspects of the survey data.</p><ul><li>Each HCAHPS report is identified by a unique identifier</li><li>The survey results included in each report pertain to patients who were discharged between the “Start Date” and “End Date” specified in that report on a slicer.</li><li>The dataset includes the state abbreviation and full state name for the 50 US States (plus DC — District of Columbia).</li><li>States are categorized into groups based on definitions by the United States Census Bureau.</li><li>Each HCAHPS measure is represented by a unique identifier and corresponds to specific questions on the HCAHPS survey.</li><li>The measures are categorized as “Composite measures” (comprising multiple survey questions), “Individual Items,” or “Global Items” (tied to a single question).</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/901/1*8u_XKGQ4h0AKhArJFDMZrw.jpeg" /><figcaption>Care Transition Measure</figcaption></figure><ul><li>The “Question Num” represents the question number as it appears on the HCAHPS patient survey.</li><li>Each question is linked to the measure it relates to and is presented in the survey.</li><li>The “Bottom-box Answer,” “Middle-box Answer,” and “Top-box Answer” represent the answers considered least positive, intermediate, and most positive, respectively.</li><li>The “National Results” table contains data related to HCAHPS reports at the national level.</li><li>The “State Results” table contains data related to HCAHPS reports at the state level.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/900/1*g2Tsw_M7KNzmaW-B6YGsuw.jpeg" /><figcaption>Composite Measure</figcaption></figure><ul><li>The “Responses” table includes unique identifiers for hospitals that participated in the HCAHPS patient survey, completed surveys from patients discharged during the specified report period, and the response rate as a percentage.</li><li>I recommend that hospitals should always seek opinions from patients in other to serve them better.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/746/1*vKpC0A80ILNiiQ99EQWOuw.jpeg" /></figure><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=732ed9d9b073" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[HR DASHBOARD]]></title>
            <link>https://medium.com/@olowoayodele08/hr-dashboard-ef10e67b4d1?source=rss-769131fd483b------2</link>
            <guid isPermaLink="false">https://medium.com/p/ef10e67b4d1</guid>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[hr]]></category>
            <category><![CDATA[dashboard-design]]></category>
            <category><![CDATA[data]]></category>
            <dc:creator><![CDATA[Olowo Ayodele]]></dc:creator>
            <pubDate>Fri, 17 Mar 2023 07:42:04 GMT</pubDate>
            <atom:updated>2023-03-17T07:42:04.371Z</atom:updated>
            <content:encoded><![CDATA[<p>One of the responsibility of an HR is to track Key Performance of the company staff. Understanding the workers in a particular organization is solely on the Human Resources Department in other to determine the ones to be rewarded or not. I worked on the HR dataset to provide adequate information relating to the workers livelihood in an organization.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*7QDHMzhjHGiFiWn2fO6pLQ.jpeg" /><figcaption>HR — Detail page</figcaption></figure><p>CONTENT</p><p>1. INTRODUCTION</p><p>2. METHODOLOGY</p><p>3. INSIGHTS</p><p>4. CONCLUSION</p><p><strong>1. INTRODUCTION;</strong></p><p>The HR dataset provides succinct knowledge on total workers in an organization which also help me to determine those due for promotion and those that do not.</p><h3>METHODOLOGY;</h3><p>I downloaded the dataset from kaggle</p><p>· I conducted Data Filtering and Cleaning</p><p>· I also transformed my data using PowerBI Query (Conditional formatting, New Column, New Measures)</p><p>· I also did some Data modelling and Bookmark linking to other page.</p><p>· Data Visualization.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*7qKjDB0fRNOXXlnVDns5CA.jpeg" /><figcaption>Data View</figcaption></figure><h3>INSIGHTS:</h3><p>On this dashboard, I provided insights on;</p><p>A. Home Page: It was observed that the company total employee is 1,470 which include 60% male and 40% female of the total workers respectively. Total percentage of workers due for promotion is 4.90% while those that are not due for promotion is 95.10%. There are higher number of workers on service as compare to the numbers of workers that need to be retrenched.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/932/1*rKrWIs0GUa8gdBBCgE2qFQ.jpeg" /><figcaption>Home dashboard</figcaption></figure><p>A. Action Page: It was shown on the visualization that, the male gender receives high pay that the female. This might be due to the level of man power exacted on the job.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/929/1*tyaVOieNyrSPLNNZZ3fjVQ.jpeg" /><figcaption>Action Dashboard</figcaption></figure><p>A. Detail Page: It was observed that the 459 workers are satisfy (good benchmark) with their job with male taking the highest number while 280 workers are not satisfy (bad benchmark). Based on individual department, the research and development has the highest number of workers that will be retrenched (269) with highest number of workers that are due for promotion (47) while the human resources has the lowest number of workers that will be retrenched (15) with lowest number of workers that are due for promotion (2).</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*7QDHMzhjHGiFiWn2fO6pLQ.jpeg" /></figure><h3>CONCLUSION:</h3><p>In conclusion, the HR Dashboard report shows a lot of loop holes in the organization as regard gender equity, job satisfaction etc. However, apt concern should be shown to the welfare of the workers.</p><p>As a data analyst,</p><p>- I recommend that there should be gender equity in the organization where necessary to bring balance.</p><p>- I also recommend that workers livelihood should be attended to with more care and also, the organization should provide means of transporting their workers most especially the very fay and close category to the office to aid optimum result in work output.</p><p>All the data can be visualized at a glance on this interactive dashboard. Comments and recommendations from experts would be appreciated.</p><p>Thanks.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=ef10e67b4d1" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[SALES PERFORMANCE ANALYSIS]]></title>
            <link>https://medium.com/@olowoayodele08/sales-performance-analysis-c1dbd9f43b1d?source=rss-769131fd483b------2</link>
            <guid isPermaLink="false">https://medium.com/p/c1dbd9f43b1d</guid>
            <category><![CDATA[kpi-dashboard]]></category>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[sales]]></category>
            <dc:creator><![CDATA[Olowo Ayodele]]></dc:creator>
            <pubDate>Fri, 10 Mar 2023 16:54:53 GMT</pubDate>
            <atom:updated>2023-03-10T17:13:51.018Z</atom:updated>
            <content:encoded><![CDATA[<p><strong>SALES PERFORMANCE ANALYSIS</strong></p><p>While Sales is one of the pillar of businesses ‘Every business owner want to make sales’, it is important to analyze the sales impact to build insights that will form better decision like; increasing revenue, tracking progress through KPIs, identifying strength and weaknesses, as well as growth and development.</p><p>CONTENT</p><p>1. INTRODUCTION</p><p>2. METHODOLOGY</p><p>3. INSIGHTS</p><p>4. CONCLUSION</p><h3>1. INTRODUCTION;</h3><p>Kevin Cookie Company is a manufacturing company that produces cookies and pastries with outlet in Mexico, Canada, France, Germany and the United States. This report aims to provide an overview of the Sales Performance of Kevin Cookie Company. I analyzed the data and conducted a Sales Performance Analysis.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/891/1*9T-CK-j4xFXn3gEEIqu3bA.jpeg" /></figure><h3>METHODOLOGY;</h3><p>I downloaded the dataset from <a href="https://onedrive.live.com/view.aspx?resid=B09F9559F6A16B6C!68800&amp;ithint=file%2cxlsx&amp;authkey=!AIoMdcxZbck4gto">https://onedrive.live.com/view.aspx?resid=B09F9559F6A16B6C!68800&amp;ithint=file%2cxlsx&amp;authkey=!AIoMdcxZbck4gto</a></p><p>· Data Filtering and Cleaning</p><p>· Transformation of data using PowerBI</p><p>· Importation of additional datasets (countries and population) from an external source.</p><p>· Create Data Modelling.</p><p>· Created New Measures</p><p>· Data Visualization.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Als-uniLyO0qsISluOw1Pg.jpeg" /></figure><h3>INSIGHTS:</h3><p>On this dashboard, I provided insights on;</p><p>A. Overall Sales Profit: With the increase in profit between January 2019 and December 2019, the Kevin Cookie Company achieved a total sales profit of $2,110,000. Its highest profit was recorded in October 2019 at $256,211 and the lowest in March 2019 at $129,483. The decline in Profit by month might be attributed to competitors or customers cutting cost as preparedness for Christmas.</p><p>B. The variation of product by Countries: The dataset indicates Chocolate Chips has the highest seller in terms of profits, units sold, and countries. Canada holds the highest number of profits $172,225.</p><p>While Germany has the lowest profit of $112,462. It also shows that country population does not have an impact on number of units sold.</p><p>C. Percentage of company’s products by units sold: Kevin Cookie Company’s Chocolate Chip product has the highest unit sold at 29.73%. At (13.41%) SnickersDoddle is the lowest product sold at Kevin Cookie Company.</p><h3>CONCLUSION:</h3><p>In conclusion, the sales performance report for Kevin Cookie Company indicates that the company has experienced a successful year. The Chocolate Cookie and Canada were the primary contributors to the company’s success. Going forward, the company should continue to focus on the production of Chocolate Cookie to ensure continued growth and success.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*R8iyzSPIsSgskE4VzKZ6UA.jpeg" /></figure><p>As a data analyst,</p><p>- I recommend that the company improve more on all other cookies product as it may also generate greater income in the coming year.</p><p>- I recommend that some cookies should be produced based on the interest of particular country.</p><p>- I also recommend that the company track these metrics closely to identify trends and make data-driven decisions to optimize sales performance.</p><p>All the data can be visualized at a glance on this interactive dashboard. Comments and recommendations from experts would be appreciated.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/904/1*NCb4n86UuR1xo3Y8D2H4cA.jpeg" /></figure><p>Thank You.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=c1dbd9f43b1d" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Data Professional Survey Dashboard]]></title>
            <link>https://medium.com/@olowoayodele08/data-professional-survey-dashboard-75356ff99606?source=rss-769131fd483b------2</link>
            <guid isPermaLink="false">https://medium.com/p/75356ff99606</guid>
            <category><![CDATA[visualization]]></category>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[data]]></category>
            <dc:creator><![CDATA[Olowo Ayodele]]></dc:creator>
            <pubDate>Mon, 06 Mar 2023 10:04:22 GMT</pubDate>
            <atom:updated>2023-03-06T10:04:22.061Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/925/1*RfVfHycMQtoYnSSlm0Uaig.jpeg" /></figure><p>Working on a Real dataset of Data Professionals with my tutor @AlextheAnalyst</p><p>Where I did a lot of Data Cleaning to make sure the data is suitable for reporting and visualization</p><p>Data Cleaning</p><p>After loading my dataset on PowerBI I later transformed the data to perform all cleaning process, I remove some column that are not useful to my visual.</p><p>I also made use of split column by delimiter to filter some job professions, favorite programming language etc. then remove duplicate column.</p><p>The range of salary was also worked upon by separating the lowest value and highest value into different column then determining the average to get a usable numeric value for our visualization.</p><p>After creating a duplicate of the column, split column (by digit to non-digit) was applied the replace value was done on the column. A new custom column was added to get the average salary after which I close and apply my power query.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*VzhSlsGksQyuba8o0Oa4-A.jpeg" /><figcaption>Power Query</figcaption></figure><p>Creating DashBoard</p><p>Different visual was use such as card, stack bar chart, tree map, gauge and doughnut chart etc. In the data view, the average salary was converted to a decimal number string to produce the visuals I wanted.</p><p>The gauge visualization was done with the average, minimum and maximum value of work and salary.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*_VZhp33IH3ly2L-S2bKVjA.jpeg" /><figcaption>Data View</figcaption></figure><p><strong>Visualization carried out</strong></p><p>- Favorite Programming Language</p><p>- Average Salary by Job Title</p><p>- Average Salary by Gender</p><p>- Average Age of Survey Taker</p><p>- Count of Survey Taker</p><p>- Which country do you live in?</p><p>- How happy they are with their Job?</p><p>- How happy they are with their Salary?</p><p>- Difficulty to break into Data</p><p>After achieving all these visuals, thereafter, I change my dashboard theme setting to suit my desire.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/927/1*cMOo0-16U1UCUG82dbAiNQ.jpeg" /></figure><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=75356ff99606" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[NETFLIX MOVIES AND TV SHOWS DASHBOARD]]></title>
            <link>https://medium.com/@olowoayodele08/netflix-movies-and-tv-shows-dashboard-646e27d9b863?source=rss-769131fd483b------2</link>
            <guid isPermaLink="false">https://medium.com/p/646e27d9b863</guid>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[movies]]></category>
            <category><![CDATA[best-slicers]]></category>
            <category><![CDATA[netflix]]></category>
            <dc:creator><![CDATA[Olowo Ayodele]]></dc:creator>
            <pubDate>Tue, 21 Feb 2023 15:57:31 GMT</pubDate>
            <atom:updated>2023-02-21T15:57:31.405Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/903/1*JqrjMUiPpIKTOEbWX9JHyw.jpeg" /><figcaption>Netflix Dashboard</figcaption></figure><p>Comment and contributions are welcome.</p><p>Here’s the link to the dataset:<br> <a href="https://www.kaggle.com/code/chirag9073/netflix-data-analysis">https://www.kaggle.com/code/chirag9073/netflix-data-analysis</a></p><p><strong>CONTENTS</strong></p><p>1. <strong>Introduction</strong></p><p>2. <strong>Data Processing/Cleaning With Power Query</strong></p><p>3. <strong>Data Visualization</strong></p><p>Data Analysis is a major area that helps the entertainment industry to identify rating categories and also increase the productivity in the industry, which equals more revenue to the industry and also helps to understand the acceptable genre and target audience.</p><p>Power BI is a visualization tool that enables users to connect to and analyze data from various sources with great in-built visuals.</p><p><strong>2. DATA PROCESSING/CLEANING</strong></p><p>For data cleaning i utilized Power BI tools such as; Data Filtering, Data Blending, New Column, and New Measures.</p><p>These tools were used to delete redundant columns, dropping duplicates, cleaning individual columns and removing the null values from the datasets.</p><p><strong>3. DATA VISUALIZATION</strong></p><p>I utilized Map, Clustered Bar Chart, Dough Nut Chart, Area Chart to find relations between the Movies and TV Shows by;</p><p>i. Countries: The color red bubble shows that majority of Movies and TV Shows production are from the United States of America. While few productions are made in countries showing yellow and green color based on the count per Continent. The picture below shows the prototype before the gradient colors used in the final dashboard (Kindly check the above image for the final dashboard)</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/909/1*BHmHNrqjdcZWG81Ze2TRxw.jpeg" /><figcaption>Tv shows &amp; Movies per country</figcaption></figure><p>ii. Rating: This indicates that TV-MA (Matured Audience Only) program have the highest rating at 1,188. While the lowest rating goes to NC-17 (Not for Children Under 17) at 1.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/947/1*XLquOwHKcovWEz8dG8ZEJQ.jpeg" /><figcaption>Rating</figcaption></figure><p>iii. Distribution: Indicates the distribution between Movies and TV Shows, which leave Movies as the highest 97.45% and TV Shows at 2.55%</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/939/1*qZx0hx-ZJ7fvzyKYzcMFlQ.jpeg" /><figcaption>Distribution</figcaption></figure><p>iv. Genre: With genre is shows that viewers prefer Drama, International Movies than others.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/958/1*KFyn-wlyG8he9-FmZGllVg.jpeg" /><figcaption>Genre</figcaption></figure><p>v. Years: It indicates that Movies have always dominated the industry with higher production than TV Shows each year.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/940/1*_NSGDkTnFsFTerLd4I8qmg.jpeg" /><figcaption>TV Shows &amp; Movies per Year</figcaption></figure><p>vi. I also categorized using cards and slicers, the TV show/ Movie series, The type, title, rating, duration, date added, and description, release year, genre and release year.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=646e27d9b863" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>