<?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 Hazeezat Adebayo on Medium]]></title>
        <description><![CDATA[Stories by Hazeezat Adebayo on Medium]]></description>
        <link>https://medium.com/@ahazeezat?source=rss-1149cce04b48------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*qj3F3GkUM4N40YGpWV1hKw.jpeg</url>
            <title>Stories by Hazeezat Adebayo on Medium</title>
            <link>https://medium.com/@ahazeezat?source=rss-1149cce04b48------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Wed, 18 Nov 2026 04:11:44 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@ahazeezat/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[Unlocking Insights with Microsoft Excel: Data Cleaning and Visualization]]></title>
            <link>https://medium.com/@ahazeezat/unlocking-insights-with-microsoft-excel-data-cleaning-and-visualization-349cdaa48934?source=rss-1149cce04b48------2</link>
            <guid isPermaLink="false">https://medium.com/p/349cdaa48934</guid>
            <category><![CDATA[excel-tips]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[excel-training]]></category>
            <dc:creator><![CDATA[Hazeezat Adebayo]]></dc:creator>
            <pubDate>Mon, 17 Mar 2025 16:11:36 GMT</pubDate>
            <atom:updated>2025-03-17T16:11:36.111Z</atom:updated>
            <content:encoded><![CDATA[<p><strong>Thanks to its versatility and user-friendly interface, Microsoft Excel remains the most widely used data analysis tool</strong>. It allows users to organize data, create visualizations, and perform statistical analysis with ease. Beyond its essential functions, Excel also offers advanced features that enable complex data analysis, making it a powerful tool for both beginners and experienced analysts.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/368/0*wVX8Z8LqGDK0I6Tb" /></figure><p>For this project, I leveraged my expertise in Microsoft Excel to clean and analyze data from the <a href="https://app.mavenanalytics.io/guided-projects/72ec0a0d-bc7d-4ac4-a8da-da811f9061d6?_gl=1*1ajlm5r*_gcl_au*MjQ0MDA5NTQ0LjE3Mzk4OTM4MDA.*_ga*MTM1ODE4NjUxMS4xNzM5ODkzNjY2*_ga_RNVXNX7G3B*MTczOTg5MzY2NS4xLjEuMTczOTg5NDU2NS42MC4wLjA.*_ga_D6PKE9HLBV*MTczOTg5MzY2NS4xLjEuMTczOTg5NDU2NS4wLjAuMA..*_ga_9CBEFJW9QX*MTczOTg5MzY2NS4xLjEuMTczOTg5NDU2NS4wLjAuMA.."><strong>Maven Analytics Coffee Shop Dashboard</strong></a><strong> </strong>dataset. The goal was to build an interactive dashboard to explore and analyze coffee shop sales. This dataset contains transactional sales data from a coffee shop, providing valuable insights into sales trends, customer behavior, and product performance.</p><p>For this project, I worked with the <strong>Maven Analytics Coffee Shop Dashboard</strong> dataset, focusing on three core objectives:</p><ol><li><strong>Profile and prepare the raw data for analysis</strong> — Cleaning and structuring the dataset to ensure accuracy and consistency.</li><li><strong>Explore the data using Excel PivotTables</strong> — Identifying key insights and trends in sales performance.</li><li><strong>Build a dynamic dashboard</strong> — Creating an interactive visual representation to analyze patterns and trends effectively.</li></ol><h3>Data Cleaning Process</h3><p>Before diving into data cleaning, the first step was to <strong>create a copy of the raw dataset</strong> in a new sheet. The main reason for this is that modern versions of Excel come with <strong>AutoSave</strong>, meaning your changes are continuously saved. This can be helpful, but it also increases the risk of <strong>accidentally modifying or overwriting the original dataset</strong>. To prevent this, it’s essential to <strong>use “Save a Copy” before making any edits</strong>. This ensures that you’re working on a separate version of the dataset while keeping the original intact. By doing so, if any mistakes occur during data cleaning or transformation, you can always refer back to the untouched dataset.</p><h3>Dataset Summary</h3><p>The <strong>Coffee Shop Sales</strong> dataset contains transactional data from a coffee shop, detailing purchases made by customers. The dataset includes the following key information:</p><ul><li><strong>Transaction details</strong>: Unique transaction ID, date, and time of purchase.</li><li><strong>Sales information</strong>: Quantity of items purchased and unit price.</li><li><strong>Store details</strong>: Store ID and location.</li><li><strong>Product details</strong>: Product category (e.g., Coffee, Tea, etc.)</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*RvxQ5b_BTz2m-BM-xlOigQ.jpeg" /></figure><h3>Objective 1: Profiling and Preparing the Raw Data for Analysis</h3><p>Before diving into analysis, I took the time to familiarize myself with the dataset. Understanding the structure of the data is crucial to ensure accurate insights. I focused on answering key questions such as:</p><ul><li><strong>How many transactions were recorded over the given period?</strong></li><li><strong>What products and product categories were sold?</strong></li><li><strong>What patterns can be identified in sales trends over time?</strong></li></ul><p>To efficiently explore the dataset, I applied <strong>filters to each column</strong> in Excel. This allowed me to <strong>sort and filter</strong> through large quantities of data with ease, making it simpler to spot inconsistencies and trends.</p><p>Next, I performed several data transformations to enhance the dataset for analysis:</p><h3>A. <strong>Revenue</strong></h3><ul><li>I created a new column labeled <strong>“Revenue”</strong> (Column L).</li><li>To calculate revenue, I used the formula:<br><strong>Transaction Quantity (Column D) × Unit Price (Column H) → </strong><strong>=D2*H2</strong></li><li>I then used Excel’s <strong>AutoFill</strong> feature to apply this formula to the entire column.</li><li>Finally, I formatted the Revenue column as <strong>currency</strong> with two decimal places to improve readability.</li></ul><h3>B. <strong>Extracted Month and Day of the Week</strong></h3><ul><li>To analyze sales patterns over time, I added two new columns to extract <strong>the month and day of the week</strong> from the transaction date.</li><li>For the <strong>month</strong>, I used the MONTH function to extract the numerical month value (01 for January, 06 for June, etc.), then formatted it using the TEXT function: =TEXT(B2, &quot;mmm&quot;) // Converts numerical month to short format (e.g., &quot;Jan&quot;, &quot;Feb&quot;)</li><li>For the <strong>day of the week</strong>, I used the WEEKDAY function to extract the numerical weekday value, then formatted it using the TEXT function: =TEXT(B2, &quot;ddd&quot;) // Converts weekday number to short format (e.g., &quot;Mon&quot;, &quot;Tue&quot;)</li></ul><h3>C. <strong>Extracted Hour of Transaction</strong></h3><ul><li>To analyze sales patterns by time of day, I created a new column to extract the <strong>hour</strong> from the transaction time.</li><li>I used the HOUR function in Excel: =HOUR(C2) // Extracts the hour from the transaction time (e.g., 07:06:11 → 7)</li><li>This allowed me to identify peak sales hours and understand customer purchasing behavior throughout the day.</li></ul><p>By preparing the dataset in this structured way, I ensured that it was clean, organized, and ready for deeper analysis using <strong>PivotTables and dashboards</strong>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/876/1*0SkTPMQKe4-oVCbxae_rfg.jpeg" /></figure><h3>Objective 2: Explore the Data with Pivot Tables</h3><p>After preparing the dataset, the next step was to <strong>slice and dice the data using PivotTables</strong> to uncover key patterns and trends. PivotTables provide a powerful way to summarize large datasets, allowing for quick insights into revenue, transaction frequency, and product trends. I created <strong>five PivotTables</strong>, each focusing on a different aspect of the sales data.</p><h4>Task A: Revenue by Month:</h4><ul><li>I inserted a Pivot Table on a new sheet to summarize revenue by month; This provided a clear overview of how monthly revenue fluctuated over the recorded period, making it easy to identify high and low-performing months.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/464/1*AgBwYM6p_itypRxgW9zU5w.png" /></figure><h4>Task B: Transactions by Day, Week, and Hour:</h4><ul><li>I added <strong>two more PivotTables (on the same sheet)</strong> to analyze transaction trends over time: <strong>Number of transactions by day of the week &amp; Number of transactions by hour of the day.</strong></li><li>Instead of summing values, I changed the value set to <strong>COUNT</strong>, ensuring that the PivotTables displayed the <strong>number of transactions</strong> rather than the total revenue.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/464/1*AgBwYM6p_itypRxgW9zU5w.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/458/1*g8qwo6vXfT6M38tklIrMGg.png" /></figure><h4>Task C: Product-Specific Trends by Category:</h4><ul><li>I created another Pivot Table to <strong>analyze product trends by category</strong>, sorting the data in <strong>descending order of transactions</strong> using the <strong>Sort options</strong> in pivot table settings.<em> This allowed me to see which product categories were the most popular based on sales volume.</em></li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/460/1*O7_GD4DM2B03XF0G5CNG3g.png" /></figure><h4>Task D: Top 15 Product Types by Transactions and Revenue:</h4><ul><li>Finally, I created a PivotTable displaying <strong>the number of transactions and revenue by product type, </strong>I filtered the results to show <strong>only the top 15 product types</strong>, based on <strong>transaction count</strong>. This highlighted the best-selling products and their contribution to overall revenue.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/622/1*9G8ZqBqzQSHLW_etKGMqHA.png" /></figure><p>By leveraging PivotTables, I was able to <strong>quickly explore patterns</strong> in revenue, customer behavior, and product performance, setting the foundation for the final step: <strong>building a dynamic dashboard</strong> to visualize these insights.</p><h3>Objective 3: Build a Dynamic Dashboard</h3><p>In the final step, I created an <strong>interactive dashboard</strong> to visualize key sales insights using <strong>four PivotCharts</strong> (a line chart, two-column charts, and a bar chart). I structured the dashboard layout and included a <strong>slicer</strong> to compare revenue across <strong>Hell’s Kitchen, Astoria, and Lower Manhattan</strong>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*EJjxIvWrtkVHJy07oc9pVA.png" /></figure><h4>Key Insights:</h4><ul><li><strong>Peak Sales Periods:</strong> Manhattan experiences a <strong>morning sales spike</strong>, likely due to commuters, while sales drop around <strong>7–8 PM</strong>, suggesting potential benefits from <strong>closing earlier</strong>.</li><li><strong>Top-Selling Product:</strong> <strong>Coffee is the most purchased item</strong> across all locations, emphasizing the need for adequate stock.</li></ul><p>This dashboard provides <strong>data-driven insights</strong> that can help optimize store operations, staffing, and inventory management.</p><p>THIS PROJECT CAN BE VIEWED VIA THIS<strong> </strong><a href="https://excel.cloud.microsoft/open/onedrive/?docId=BAE5025303872DAE%21s41e5c558b3324c9d8b43979e88023607&amp;driveId=BAE5025303872DAE"><strong>LINK</strong></a></p><p><strong>THANK YOU FOR READING!!!</strong></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=349cdaa48934" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>