<?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 Victoria Kolawole on Medium]]></title>
        <description><![CDATA[Stories by Victoria Kolawole on Medium]]></description>
        <link>https://medium.com/@vkeykola3?source=rss-655545d8a5f1------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/0*0jXxkIkIsXKOeWrD</url>
            <title>Stories by Victoria Kolawole on Medium</title>
            <link>https://medium.com/@vkeykola3?source=rss-655545d8a5f1------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sat, 21 Nov 2026 17:42:13 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@vkeykola3/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[30-day Writing Challenge: Finding My Inner Voice]]></title>
            <link>https://medium.com/@vkeykola3/30-day-writing-challenge-finding-my-inner-voice-02911fe6f548?source=rss-655545d8a5f1------2</link>
            <guid isPermaLink="false">https://medium.com/p/02911fe6f548</guid>
            <category><![CDATA[growth-mindset]]></category>
            <category><![CDATA[speaking]]></category>
            <category><![CDATA[self-improvement]]></category>
            <category><![CDATA[writing]]></category>
            <category><![CDATA[creativity]]></category>
            <dc:creator><![CDATA[Victoria Kolawole]]></dc:creator>
            <pubDate>Thu, 19 Sep 2024 16:46:51 GMT</pubDate>
            <atom:updated>2024-09-19T16:46:51.840Z</atom:updated>
            <content:encoded><![CDATA[<p>I suddenly found myself in a phase where I need to write, and not just write but write to impress.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/736/1*hRUZQKB78PLvyyV5ddFrDw.jpeg" /></figure><p>We all get to that age where we need to write cover letters to tell a company why we would like to work with them.</p><p>Or when you have to pitch yourself to businesses to show them why you are a better fit for a task by sending proposals.</p><p>There’s also the academic sector where you have to write a statement of purpose which is an important piece in securing admission into the school.</p><p>So that’s where I currently am.</p><p>I am aware that many tools can be of help such as ChatGPT and other AI but I think they are better used for assisting and editing.<br>AI-written pieces are good but they all lack a “feeling”, a sense of identity of the writer.</p><p>Hence the reason for my title “Finding My Inner Voice”, a style, a tone, and a persona that is connected to me.</p><p>Finding out I will be dabbling into public speaking in the near future has also influenced my desire to get better at writing, writing helps to organize one’s thoughts and articulate with clarity.</p><p>The idea of writing a book from the growing knowledge I have is also a tempting thought, so building the foundation now seems like such a great plan.</p><p>With all these, I figured that writing is a skill connected to the future of a successful individual.</p><p>I found out there are three (3) ways I can get better at writing.</p><p>Firstly, by writing a lot as often as possible.<br>Hence the reason behind the “30-Day Challenge”.</p><p>Practice they say makes perfect, even though there is no getting perfect with writing, great improvements can be achieved through practice.</p><p>I committed to this 30-day journey by subscribing to Medium to hold myself accountable.</p><p>I will be writing about anything and everything, I do not expect it to be perfect but it’s a journey I am excited about.</p><p>Secondly, by reading a lot as often as possible<br>As someone who only reads web novels and Manga, I know this would be a bit of a challenge.<br>I won’t be cutting them off completely as inspiration can be gotten from different places, so I will be adding better-written pieces to the mix.</p><p>I am open to book recommendations so you can leave any in the comment section.</p><p>Finally, by adding to the reps.<br>Just like building muscles, you have to be consistent while also completing your reps to have a defined muscle.<br>Therefore, not just showing up but also showing up and writing a lot will I be able to make significant growth.</p><p>I am aware that it won’t be an easy task but I plan to write about things that I enjoy also being disciplined.<br>I will be posting regularly on my social media page for accountability.<br>Every clap and comment will also be a good motivation to keep writing so you can be a part of this journey by doing so</p><p>This is just the beginning, and I am eager to see where this journey takes me. See you in the next read.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=02911fe6f548" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Operation Analysis: An In-Depth Look at ‘The Taste of the World Cafe’ Premier Dishes]]></title>
            <link>https://medium.com/@vkeykola3/operation-analysis-an-in-depth-look-at-the-taste-of-the-world-cafe-premier-dishes-5c8dfe80a6f2?source=rss-655545d8a5f1------2</link>
            <guid isPermaLink="false">https://medium.com/p/5c8dfe80a6f2</guid>
            <dc:creator><![CDATA[Victoria Kolawole]]></dc:creator>
            <pubDate>Thu, 27 Jun 2024 13:10:47 GMT</pubDate>
            <atom:updated>2024-08-08T12:28:59.797Z</atom:updated>
            <content:encoded><![CDATA[<p>In this guided project from Maven Analytics, I will be working with data from ‘The Taste of the World Cafe’ using MySQL. My goal is to delve into customer data to uncover insights about the performance of various dishes on their menu, evaluate how customers are responding to new items, and offer informed suggestions for improvement.</p><p>I have imported the data to MySQL and there are two tables; Menu items and Order details</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/491/1*yp67155YkWdG3j8J763BIw.png" /><figcaption>Menu items Preview</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/608/1*xJ6EFkPgu66guSirLk5suA.png" /><figcaption>order details preview</figcaption></figure><p>I will be performing an exploratory data analysis (EDA) to gain insights into the dataset. This process will involve the following steps:</p><ol><li>Determining the total number of unique dishes listed on the menu.</li></ol><pre>SELECT DISTINCT COUNT(item_name) -- used &quot;Distinct Count&quot; incase there was a repetition <br>FROM restaurant_database.menu_items;</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/244/1*TyUr6pJ5HZs2NGrfu9kyzA.png" /><figcaption>There are 32 dishes on the menu</figcaption></figure><p>2. Menu Categories</p><pre>SELECT category, COUNT(category) as no_of_dishes<br>FROM restaurant_database.menu_items<br>GROUP BY category;</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/208/1*uv-61RKBpZ142kag6Ehj_A.png" /><figcaption>they have more Mexican and Italian dishes</figcaption></figure><p>3. Top 10 most expensive dishes</p><pre>SELECT item_name, category, price<br>FROM restaurant_database.menu_items<br>ORDER BY price DESC<br>LIMIT 10;</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/275/1*cHCRy9P5cZp9ka6MF3qFXQ.png" /><figcaption>looks like Italian dishes are expensive</figcaption></figure><p>4. Least expensive dishes</p><pre>SELECT item_name, category, price<br>FROM restaurant_database.menu_items<br>ORDER BY price ASC<br>LIMIT 10; </pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/270/1*WeEgc1Y-onIWdt6uNt0oUA.png" /><figcaption>American dishes seem to be the least expensive, from this we can also conclude that the Italian dishes are expensive</figcaption></figure><p>To further confirm that Italian dishes are the most expensive category</p><pre>SELECT category, FORMAT(AVG(price), 2) as avg_price<br>FROM restaurant_database.menu_items<br>GROUP BY category<br>ORDER BY avg_price DESC;</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/190/1*_fkMBkRdnlSXGcW1BMmmJA.png" /><figcaption>Italian dishes are really expensive and American dishes are the cheapest on the menu</figcaption></figure><p>Next, I will conduct an exploratory data analysis (EDA) on the Order Details table to gain a comprehensive understanding. This will include:</p><ol><li>Calculating the total number of orders made.</li></ol><pre>SELECT MAX(order_id) AS orders<br>FROM restaurant_database.order_details;</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/99/1*Y4yvtfZXpg6fAkIg0xZy2g.png" /><figcaption>This is the total number of orders made which can contain 1 or more dishes</figcaption></figure><p>2. Date range of the data</p><pre>SELECT MIN(order_date) AS start_date, MAX(order_date) AS end_date<br>FROM restaurant_database.order_details;</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/189/1*zQ9SAcuYtty2VsDEKc6Dow.png" /><figcaption>The data shows 3 months of sales from January to March</figcaption></figure><p>3. Number of dishes ordered in 3 months</p><pre>SELECT COUNT(order_id), COUNT(item_id)<br>FROM restaurant_database.order_details;</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/256/1*6H3VAkw3MBhjCFSyDDc7Nw.png" /><figcaption>the number of the order is more than the dishes which shows that some orders were empty</figcaption></figure><p>To further explore the data I will have combine the tables</p><pre>CREATE TABLE rest_dish AS<br>    SELECT *<br>    FROM restaurant_database.order_details t1<br>    JOIN restaurant_database.menu_items t2<br>    ON t1.item_id = t2.ï»¿menu_item_id;</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/722/1*AsoNpsOos3Vf8C6tqPGWuw.png" /><figcaption>A merged table displaying the order details and menu items purchased</figcaption></figure><p>I will analyze this table to answer key questions, such as:</p><ol><li>Identifying the most frequently ordered dishes.</li></ol><pre>SELECT item_name AS dishes, category, COUNT(item_name) AS count<br>FROM restaurant_database.rest_dish<br>GROUP BY item_name<br>ORDER BY count DESC<br>LIMIT 10;</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/333/1*YfKAEmKci24Q9nKRKelq6Q.png" /><figcaption>American dishes are the most ordered items. Could this be due to their lower prices? Let’s investigate this by analyzing the pricing data to determine if there’s a correlation between the frequency of orders and the cost of these dishes.</figcaption></figure><p>2. What are the least ordered dishes?</p><pre>SELECT item_name AS dishes, category, COUNT(item_name) AS count<br>FROM restaurant_database.rest_dish<br>GROUP BY item_name<br>ORDER BY count DESC<br>LIMIT 10;</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/297/1*nCMnoRYfFlvfJbTcyVIm8g.png" /><figcaption>Mexican dishes are the least ordered items. Could this be due to their higher prices? Let’s analyze the pricing data to examine if there’s a correlation between the low frequency of orders and the higher cost of these dishes</figcaption></figure><p>3. Could price be the reason why some dishes are ordered more frequently than others? To investigate this, we will perform a detailed analysis of the relationship between dish prices and their order frequencies to determine if there is a significant correlation</p><pre><br>WITH percentiles AS (<br>    SELECT <br>        item_name AS dishes,<br>        COUNT(item_name) AS count,<br>        NTILE(3) OVER (ORDER BY price) AS tercile,<br>        category,<br>        price<br> FROM restaurant_database.rest_dish<br>    GROUP BY dishes<br>    ORDER BY count DESC<br>)<br>SELECT <br>    dishes,<br>    category,<br>    count,<br>    CASE<br>        WHEN tercile = 1 THEN &#39;Cheap&#39;<br>        WHEN tercile = 2 THEN &#39;Not Expensive&#39;<br>        WHEN tercile = 3 THEN &#39;Expensive&#39;<br> END AS cost<br>FROM percentiles<br>LIMIT 10; --cost of the most ordered dishes<br><br><br>WITH percentiles AS (  <br>    SELECT <br>        item_name AS dishes,<br>        COUNT(item_name) AS count,<br>        NTILE(3) OVER (ORDER BY price) AS tercile,<br>        category,<br>        price<br> FROM restaurant_database.rest_dish<br>    GROUP BY dishes<br>    ORDER BY count DESC<br>)<br>SELECT <br>    dishes,<br>    category,<br>    count,<br>    CASE<br>        WHEN tercile = 1 THEN &#39;Cheap&#39;<br>        WHEN tercile = 2 THEN &#39;Not Expensive&#39;<br>        WHEN tercile = 3 THEN &#39;Expensive&#39;<br> END AS cost<br>FROM percentiles<br>LIMIT 10; --cost of the least ordered dishes</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/339/1*ir7X67PdhRKTLOhgyFuL3Q.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/328/1*wEiZuulMRoN3slpmYhf-Jg.png" /><figcaption>From the two images, we can see that price does not significantly influence the frequency of dish orders. However, I observed that Italian dishes are ordered less frequently. This warrants further investigation to understand the underlying reasons.</figcaption></figure><p>To delve deeper into the potential impact of cost on demand, I converted the data into a table format. This allows me to group the orders by price range, facilitating an analysis to determine if the cost is a driving factor behind high demand.</p><pre>CREATE TABLE cost_count AS<br>  WITH percentiles AS (<br>    SELECT <br>        item_name AS dishes,<br>        NTILE(3) OVER (ORDER BY price) AS tercile,<br>        category,<br>        price<br> FROM restaurant_database.rest_dish<br>    ORDER BY category ASC<br>)<br><br>SELECT<br>    CASE<br>        WHEN tercile = 1 THEN &#39;Cheap&#39;<br>        WHEN tercile = 2 THEN &#39;Not Expensive&#39;<br>        WHEN tercile = 3 THEN &#39;Expensive&#39;<br> END AS cost<br>FROM percentiles;      -- created table with this<br><br>SELECT cost, COUNT(cost)<br>FROM restaurant_database.cost_count<br>GROUP BY cost;        -- then ran this query to check demand by cost</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/309/1*5K4HBafhfinz_JwriGc3kQ.png" /><figcaption>this shows that cost doesn’t affect the demand of the dishes</figcaption></figure><p>Earlier, we established that Italian dishes are among the most expensive. Now, let’s investigate whether the category of the dish plays a role in influencing its demand. We’ll analyze the correlation between dish categories and their order frequencies to determine if the category affects the demand.</p><pre>SELECT  category, COUNT(item_name) AS count<br>FROM restaurant_database.rest_dish<br>GROUP BY category<br>ORDER BY count DESC<br>LIMIT 10;</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/197/1*79XxIid5pPVHqJ2NJDGFlg.png" /><figcaption>From this analysis, it’s evident that the category of the dish is not the primary factor influencing demand. While Italian dishes are among the most expensive, they are not the least ordered. Instead, American dishes, despite being more affordable, are the most ordered, indicating that price alone does not fully explain the demand patterns.</figcaption></figure><p>I believe that a visual representation will provide more insights. Therefore, I will create a Power BI report with this data. You can view the report by clicking the link below.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/408/1*bdEa3hW75SZ6XliBeJf3jA.jpeg" /><figcaption><a href="https://github.com/Bellevkey22/Operation_Analysis/blob/main/Operational%20Analysis%20Viz.pdf">https://github.com/Bellevkey22/Operation_Analysis/blob/main/Operational%20Analysis%20Viz.pdf</a></figcaption></figure><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=5c8dfe80a6f2" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>