<?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 Divyanshu baranwal on Medium]]></title>
        <description><![CDATA[Stories by Divyanshu baranwal on Medium]]></description>
        <link>https://medium.com/@divyanshubaranwal861?source=rss-f4baf7ef88de------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*mF7_U5iacs3DGf-B5jkd7A.png</url>
            <title>Stories by Divyanshu baranwal on Medium</title>
            <link>https://medium.com/@divyanshubaranwal861?source=rss-f4baf7ef88de------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sat, 21 Nov 2026 19:07:33 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@divyanshubaranwal861/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[From Raw Data to Business Decisions: Building a Sales Dashboard in Excel]]></title>
            <link>https://medium.com/@divyanshubaranwal861/from-raw-data-to-business-decisions-building-a-sales-dashboard-in-excel-afb426a0e229?source=rss-f4baf7ef88de------2</link>
            <guid isPermaLink="false">https://medium.com/p/afb426a0e229</guid>
            <category><![CDATA[decision-making]]></category>
            <category><![CDATA[business]]></category>
            <category><![CDATA[business-analyst]]></category>
            <category><![CDATA[excel]]></category>
            <dc:creator><![CDATA[Divyanshu baranwal]]></dc:creator>
            <pubDate>Wed, 11 Mar 2026 06:43:57 GMT</pubDate>
            <atom:updated>2026-03-11T06:43:57.048Z</atom:updated>
            <content:encoded><![CDATA[<p>Data is everywhere But raw data alone doesn’t help businesses make decisions. What organizations truly need are <strong>insights</strong> — clear, visual, and actionable.</p><p>As someone who is learning and aspiring to become a <strong>Business Analyst</strong>, I wanted to experience this process myself, So I picked a simple sales dataset and asked one question:</p><blockquote>How can raw sales data be transformed into insights that business leaders can actually use?</blockquote><p>This project was my attempt to answer that question by building a <strong>Sales Performance Dashboard in Excel</strong>.</p><h3>The Moment I Realized Data Needs Visualization</h3><p>Early in my analytics journey, I often worked with spreadsheets full of numbers.</p><p>Rows. Columns. Thousands of values.</p><p>But something always felt missing.</p><p>Even though the data was there, it was <strong>hard to understand what was actually happening in the business</strong>.</p><p>Then I realized something important:</p><p><strong>Decision makers don’t read spreadsheets.<br> They read dashboards.</strong></p><p>Managers want quick answers like:</p><ul><li>Which region is performing best?</li><li>Which product generates the most revenue?</li><li>Which salesperson contributes the most to sales?</li><li>Are sales improving or declining?</li></ul><p>This realization motivated me to build a <strong>simple but meaningful sales dashboard</strong>.</p><h3>The Dataset</h3><p>The dataset used in this project contains sales records with the following columns:</p><ul><li><strong>Date</strong> — Sales transaction date</li><li><strong>Salesman</strong> — Name of the salesperson</li><li><strong>Region</strong> — Sales region (East, West, North, South)</li><li><strong>Item</strong> — Product sold</li><li><strong>Quantity</strong> — Units sold</li><li><strong>Price</strong> — Price per product</li><li><strong>Amount</strong> — Total sale value</li></ul><p>From a business perspective, this data answers important questions about:</p><ul><li>Sales performance</li><li>Product demand</li><li>Regional performance</li><li>Individual sales contributions</li></ul><p>Even though the dataset is simple, it contains <strong>valuable business signals</strong>.</p><h3>Total Sales by Region</h3><p>This helps businesses understand <strong>which geographic markets generate the most revenue</strong>.</p><p>Insight:<br> If the <strong>West region contributes the highest revenue</strong>, the company may focus more marketing resources there….</p><h3>Sales by Product</h3><p>This shows which products are <strong>top performers</strong>.</p><p>Insight:<br> If <strong>Printers and Monitors generate the highest sales</strong>, inventory planning should prioritize those items.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Zl_w7dvzl_n9ap97bA9QLA.png" /></figure><h3>Sales by Salesman</h3><p>This helps evaluate <strong>individual performance</strong>.</p><p>Insight:<br> High-performing salespeople can become benchmarks for training and strategy.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*YBtmDz6p1zVy-AO915Efyg.png" /></figure><h3>Sales Over Time</h3><p>Tracking sales across dates allows us to observe <strong>sales trends</strong>.</p><p>Businesses can identify:</p><ul><li>High-demand periods</li><li>Seasonal sales patterns</li><li>Growth or decline in revenue</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*D1rli-Me6bs50Gvj4b3WVA.png" /></figure><h3>KPI Metrics</h3><p>At the top of the dashboard, I placed key metrics such as</p><ul><li>Number of Products</li><li>Number of Salespersons</li></ul><p>These metrics give decision makers a <strong>quick snapshot of business performance</strong>.</p><h3>Sales by Region Chart</h3><p>A bar chart visualizes which regions contribute the most revenue.</p><p>This helps businesses identify <strong>strong and weak markets</strong>.</p><h3>Sales by Product Chart</h3><p>This chart highlights the <strong>most profitable products</strong>.</p><p>Managers can quickly identify where most of the revenue is coming from.</p><h3>Salesman Performance Chart</h3><p>A chart comparing sales by salesperson helps evaluate:</p><ul><li>Top performers</li><li>Underperforming sales staff</li><li>Opportunities for coaching or recognition</li></ul><h3>Interactive Filters (Slicers)</h3><p>To make the dashboard interactive, slicers were added for:</p><ul><li>Region</li><li>Salesman</li><li>Product</li></ul><p>With a single click, users can filter the entire dashboard.</p><p>For example:</p><blockquote><em>A manager can instantly see how </em><strong><em>Printers performed in the East region</em></strong><em>.</em></blockquote><p>This interactivity makes the dashboard <strong>far more powerful than static reports</strong>.</p><h3>Key Business Insights from the Dashboard</h3><p>Once the dashboard was complete, several insights became clear.</p><h3>1️. Some Regions Perform Better Than Others</h3><p>Certain regions generate significantly higher sales.</p><p>This could indicate:</p><ul><li>Higher demand</li><li>Stronger sales teams</li><li>Better market penetration</li></ul><p>Businesses can focus expansion efforts in these areas.</p><h3>2️. A Few Products Drive Most Revenue</h3><p>Often in sales data, <strong>a small number of products generate most revenue</strong>.</p><p>This aligns with the <strong>Pareto Principle (80/20 rule)</strong>.</p><p>Understanding this helps businesses:</p><ul><li>Focus marketing on high-performing products</li><li>Optimize inventory</li><li>Reduce low-performing product lines</li></ul><h3>3️. Sales Performance Varies Among Salespeople</h3><p>Not every salesperson performs equally.</p><p>The dashboard highlights:</p><ul><li>High achievers</li><li>Average performers</li><li>Those who may need support or training</li></ul><p>For managers, this insight is extremely valuable.</p><h3>What I Learned from This Project</h3><p>This project taught me several important lessons about <strong>business analytics</strong>.</p><blockquote>Data is valuable only when it becomes insight</blockquote><p>Raw data is not enough. Visualization and interpretation are essential.</p><h3>Dashboards simplify complex information</h3><p>Instead of analyzing hundreds of rows, decision makers can view a <strong>single screen</strong>.</p><p>This makes decision-making faster and more effective.</p><h3>Why This Project Matters for My Business Analyst Journey</h3><p>As an aspiring Business Analyst, my goal is not just to analyze data but to <strong>translate data into business value</strong>.</p><p>This project helped me practice:</p><ul><li>Data analysis</li><li>Business thinking</li><li>Dashboard design</li><li>Insight generation</li></ul><p>It reinforced a core idea:</p><h4><em>The role of a Business Analyst is to turn </em><strong><em>data into decisions</em></strong><em>.</em></h4><h3>Final Thoughts</h3><p>Businesses today generate enormous amounts of data.</p><p>But the real competitive advantage comes from <strong>understanding that data</strong>.</p><p>Even a simple dataset can reveal powerful insights when analyzed correctly.</p><p>This project was a small step in my journey toward becoming a <strong>Business Analyst</strong>, but it clearly showed how data can support smarter business decisions.</p><p>And that is the true power of analytics.</p><p>✍️ <em>If you’re also learning data analytics or business analysis, try building your own dashboard. Sometimes the best way to understand data… is to start exploring it yourself.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=afb426a0e229" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[A Business Analyst project that shows how data can help farmers make smarter fertilizer decisions]]></title>
            <link>https://medium.com/@divyanshubaranwal861/a-beginner-business-analyst-project-that-shows-how-data-can-help-farmers-make-smarter-fertilizer-8488e62596c9?source=rss-f4baf7ef88de------2</link>
            <guid isPermaLink="false">https://medium.com/p/8488e62596c9</guid>
            <category><![CDATA[chemical-industry]]></category>
            <category><![CDATA[fertilizer]]></category>
            <category><![CDATA[business-analyst]]></category>
            <category><![CDATA[agriculture]]></category>
            <category><![CDATA[excel]]></category>
            <dc:creator><![CDATA[Divyanshu baranwal]]></dc:creator>
            <pubDate>Wed, 11 Mar 2026 03:33:27 GMT</pubDate>
            <atom:updated>2026-03-11T03:34:03.521Z</atom:updated>
            <content:encoded><![CDATA[<h3>A Question That Started With Curiosity</h3><p>A few weeks ago, while searching for datasets to practice data analysis, I stumbled upon something unexpected — a dataset related to <strong>fertilizer recommendations for crops</strong>.</p><p>At first, it looked like a simple agricultural dataset with numbers and crop names. But the more I looked at it, the more interesting it became.</p><p>I started asking myself a simple question:</p><p><strong>Can data analysis help farmers make better fertilizer decisions?</strong></p><p>Farmers deal with many uncertainties every day — weather changes, soil conditions, crop diseases, and market prices. But one decision that significantly affects productivity is <strong>choosing the right fertilizer</strong>.</p><p>Using the wrong fertilizer can lead to:</p><ul><li>Poor crop yield</li><li>Increased farming costs</li><li>Soil degradation</li></ul><p>This made me realize something important.</p><p><strong>Agriculture produces a lot of data, but much of it is still under used.</strong></p><p>As an aspiring <strong>Business Analyst</strong>, I saw an opportunity to explore how <strong>data visualization and analysis could simplify agricultural insights</strong>.</p><p>So I decided to turn this dataset into a <strong>small analytics project using Excel</strong>.</p><h3>The Goal of This Project</h3><p>The main purpose of this project was not just to analyze data, but to <strong>translate raw agricultural data into meaningful insights</strong>.</p><p>Specifically, I wanted to answer questions like:</p><ul><li>Which fertilizers are recommended most often?</li><li>Which crops appear most frequently in the dataset?</li><li>Are certain fertilizers associated with specific crops?</li><li>How can we present this information through a simple dashboard?</li></ul><p>Ultimately, my goal was to demonstrate how <strong>even basic data analysis tools like Excel can uncover useful insights</strong>.</p><h3>Key Insights From the Analysis</h3><p>After completing the analysis and building the dashboard, several insights became clear.</p><h3>1. Nitrogen-Based Fertilizers Are Highly Common</h3><p>The frequent appearance of Urea highlights the <strong>importance of nitrogen in crop development</strong>.</p><h3>2. Crop Diversity Influences Fertilizer Choice</h3><p>Different crops require different nutrient compositions, which explains the presence of <strong>multiple fertilizer types</strong> in the dataset.</p><h3>3. Balanced Fertilizers Play an Important Role</h3><p>Fertilizers with balanced nutrient ratios appear regularly, indicating that <strong>soil nutrient balance is essential for crop health</strong>.</p><h3>Why This Project Matters for Business Analysts</h3><p>Although this dataset focuses on agriculture, the <strong>analytical process is exactly the same as in business analytics projects</strong>.</p><p>The steps involved in this project mirror the workflow used by analysts in many industries:</p><ol><li>Understanding the data</li><li>Cleaning and preparing the dataset</li><li>Exploring patterns through analysis</li><li>Visualizing insights through dashboards</li><li>Communicating findings clearly</li><li>This project reminded me that <strong>data analytics skills are transferable across industries</strong>.</li></ol><p>Whether analyzing <strong>sales data, customer behavior, or agricultural datasets</strong>, the core principles remain the same.</p><h3>What I Learned From This Project</h3><p>This project helped me strengthen several key analytical skills:</p><ul><li>Data exploration</li><li>Pivot table analysis</li><li>Dashboard design in Excel</li><li>Insight communication</li></ul><p>But more importantly, it reinforced a lesson that many analysts eventually discover:</p><p><strong>Data becomes powerful only when it is presented in a way that people can easily understand.</strong></p><p>A well-designed dashboard can transform a spreadsheet full of numbers into <strong>clear and actionable insights</strong>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*6SecFG2psQtjNXp4jk-z1g.png" /></figure><h3>Final Thoughts</h3><p>Agriculture is one of the most important sectors in the world, yet it still has enormous potential for <strong>data-driven innovation</strong>.</p><p>Even simple analytical tools like Excel can help transform agricultural data into insights that support better decision-making.</p><p>For me, this project was another step in my journey toward becoming a <strong>Business Analyst</strong> — learning how to take raw data and turn it into a meaningful story.</p><p>Because at the end of the day, <strong>analytics is not just about numbers.</strong></p><p>It’s about <strong>understanding problems, discovering patterns, and communicating insights that help people make better decisions</strong>.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=8488e62596c9" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Water Allocation & Sustainability Scenarios]]></title>
            <link>https://medium.com/@divyanshubaranwal861/water-allocation-sustainability-scenarios-785225fbd018?source=rss-f4baf7ef88de------2</link>
            <guid isPermaLink="false">https://medium.com/p/785225fbd018</guid>
            <category><![CDATA[business-analysis]]></category>
            <category><![CDATA[water]]></category>
            <category><![CDATA[sustainable-development]]></category>
            <dc:creator><![CDATA[Divyanshu baranwal]]></dc:creator>
            <pubDate>Sat, 07 Mar 2026 19:01:47 GMT</pubDate>
            <atom:updated>2026-03-07T19:01:47.599Z</atom:updated>
            <content:encoded><![CDATA[<p>One of the most insightful scenario models I built involved <strong>global water allocation data from 2000–2025</strong>.</p><h4>The dataset included:</h4><ul><li>Agricultural water use (%)</li><li>Industrial water use (%)</li><li>Household water use (%)</li><li>Groundwater depletion rates</li><li>Total water consumption</li></ul><blockquote>When I analyzed the data, one insight stood out immediately:<br> <strong>Agriculture consistently consumes over 60% of global water resources.</strong></blockquote><p>But the real value came from scenario modeling.</p><h4><strong>Scenario 1: Agricultural Water Use Increases by 10%</strong></h4><ul><li>Groundwater depletion accelerates</li><li>Sustainability risk intensifies</li><li>Countries with high water scarcity face severe stress</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Dw-t9kJNLYvTgsTssJlIsQ.png" /><figcaption>Agriculture Water allocation pattern from 2000–2025</figcaption></figure><h4><strong>Scenario 2: Industrial Efficiency Improves by 15%</strong></h4><ul><li>Total water consumption drops</li><li>Groundwater pressure reduces</li><li>Long‑term sustainability improves</li></ul><h4><strong>Scenario 3: Household Consumption Rises Due to Urbanization</strong></h4><ul><li>Industrial and agricultural sectors remain stable</li><li>Total consumption increases moderately</li><li>Policy interventions needed in urban regions</li></ul><blockquote>These scenarios helped reveal something critical:<br> <strong>Agriculture is the single biggest lever for global water sustainability.</strong></blockquote><p>Without scenario modeling, this insight would remain hidden behind averages and trend lines.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=785225fbd018" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How I Built a Swiggy-Style Sales Performance Dashboard Using Excel — A Beginner’s Journey Into…]]></title>
            <link>https://medium.com/@divyanshubaranwal861/how-i-built-a-swiggy-style-sales-performance-dashboard-using-excel-a-beginners-journey-into-a4b1fcc0732b?source=rss-f4baf7ef88de------2</link>
            <guid isPermaLink="false">https://medium.com/p/a4b1fcc0732b</guid>
            <category><![CDATA[business]]></category>
            <category><![CDATA[execution]]></category>
            <category><![CDATA[writing]]></category>
            <category><![CDATA[sales]]></category>
            <dc:creator><![CDATA[Divyanshu baranwal]]></dc:creator>
            <pubDate>Thu, 27 Nov 2025 05:59:02 GMT</pubDate>
            <atom:updated>2025-11-27T05:59:02.661Z</atom:updated>
            <content:encoded><![CDATA[<h3>How I Built a Swiggy-Style Sales Performance Dashboard Using Excel — A Beginner’s Journey Into Data Storytelling</h3><h3>From Confusion to Clarity: Turning Raw Food Delivery Data Into Business Insights That Actually Matter</h3><h3>I still remember the moment I opened the dataset for the first time — hundreds of rows, unfamiliar column names, and absolutely no idea where to start.<br> For a few minutes, I just stared at the screen wondering if I had taken on more than I could handle.</h3><blockquote>But something inside me said:<br> <strong>“Don’t just learn Excel. Learn to tell a story with data.”</strong></blockquote><p>That thought changed everything.</p><p>This dashboard is not just a technical project for me — it represents the confidence I gained and the belief that even beginners can build something meaningful that drives decisions. If you’ve ever felt overwhelmed starting your data journey, trust me — you’re not alone. This project is proof that progress is possible, step by step.</p><h3>🖼 Picture of My Dashboard</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/853/1*1DrqvMPuuyFltJkA3i4y8A.png" /></figure><blockquote><em>Final Swiggy Sales Insights Dashboard</em></blockquote><h3>With this dashboard, I enabled the ability to:</h3><ul><li>Identify top-performing states, cities, and food preferences.</li><li>Analyze monthly, weekly, and daily sales patterns.</li><li>Compare quarter-wise performance across sales, orders &amp; ratings.</li><li>Track business KPIs at a glance.</li></ul><p>In short — <strong>a complete executive decision-making view on one screen.</strong></p><p>The data represented food delivery performance across multiple locations and time periods.</p><p>Key columns included:</p><ul><li><strong>Sales, Orders, Average Order Value, Ratings</strong></li><li><strong>Cities, States, Restaurant Names</strong></li><li><strong>Food Types (Veg / Non-Veg)</strong></li><li><strong>Daily, Weekly &amp; Monthly Date Records</strong></li><li><strong>Quarter wise breakup</strong></li></ul><p>The primary business purpose was to answer:</p><ul><li>Where is the business performing strongest?</li><li>What trends shape customer order behavior?</li><li>What drives growth visually &amp; logically?</li></ul><h3>🛠 Steps of Analysis</h3><h3>Step 1: Understanding the business questions</h3><p>Defined primary KPIs: Total Sales, Total Orders, Avg Order Value, Avg Rating</p><h3>Step 2: Preparing the dataset</h3><p>Cleaned columns, formatted dates, and handled missing values</p><h3>Step 3: Built Pivot Tables for each analysis block</h3><ul><li>State and city revenue comparisons</li><li>Veg vs Non-Veg pie</li><li>Quarterly heatmap</li><li>Monthly, weekly &amp; daily trends</li></ul><h3>Step 4: Designed the visuals</h3><p>Used bar, line, donut, map &amp; heat tables to represent meaningful patterns</p><h3>Step 5: Added slicers</h3><p>Enabled dynamic filtering by Month, Restaurant &amp; State</p><h3>Step 6: Applied formatting</h3><p>Brand theme using Swiggy orange, navigation panels, icons &amp; typography</p><h3>🔍 How I Reached My Results</h3><p>Through pivot table segmentation &amp; trend analysis, I compared sales contribution by region and time patterns.<br> Then I combined numbers with visual storytelling to highlight insights like:</p><ul><li>Demand fluctuations by weekday &amp; month</li><li>Strong regional revenue dominance</li><li>Customer rating correlation with order volume</li></ul><p>Each chart answered a real business question, creating a story instead of random visuals.</p><h3>📊 Result in Depth</h3><p>Business InsightFindingWhy it Matters<strong>Top Revenue State</strong>MaharashtraKey market growth opportunity<strong>Top Selling Cities</strong>Bengaluru &amp; LucknowStrong urban food delivery demand<strong>Food Preference</strong>63% Veg, 37% Non-VegHelps expansion planning<strong>Sales Trend</strong>Peak in Q1 &amp; steady rise laterSeasonality &amp; marketing effectiveness<strong>Weekly Pattern</strong>Highest sales on weekendsStrategy for promos &amp; operations</p><p>Additionally:</p><ul><li>Higher ratings correlated strongly with higher orders</li><li>Weekend spikes confirm behavioral customer patterns</li><li>Geographic map reveals strong North &amp; South market dominance</li></ul><h3>🏁 Final Outcome / Agenda</h3><p>This dashboard gives decision-makers:</p><ul><li><strong>A holistic view of sales performance</strong></li><li><strong>Ability to filter and explore data interactively</strong></li><li><strong>Insights backed by real visual analytics</strong></li><li><strong>A foundation for operations, marketing &amp; resource allocation strategies</strong></li></ul><p>For me personally, it delivered something bigger:</p><blockquote>The confidence that with the right guidance, even a beginner can build something impactful.</blockquote><h3>✨ Closing Note</h3><p>If you’re starting your Excel journey — stay consistent, start small, and build something that tells a story.<br> Dashboards are not about charts. <strong>They are about decisions.</strong><br> And this project taught me exactly that.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=a4b1fcc0732b" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>