<?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 Masoud Saedi on Medium]]></title>
        <description><![CDATA[Stories by Masoud Saedi on Medium]]></description>
        <link>https://medium.com/@masoud_saedi?source=rss-a73de117340d------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*4obCknpVE3El5Ha_R7mmJg.jpeg</url>
            <title>Stories by Masoud Saedi on Medium</title>
            <link>https://medium.com/@masoud_saedi?source=rss-a73de117340d------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Tue, 17 Nov 2026 08:48:25 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@masoud_saedi/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[How Much It Costs to Have a Dog in Portugal]]></title>
            <link>https://medium.com/@masoud_saedi/how-much-it-costs-to-have-a-dog-in-portugal-b7c3b83f2c98?source=rss-a73de117340d------2</link>
            <guid isPermaLink="false">https://medium.com/p/b7c3b83f2c98</guid>
            <category><![CDATA[personal-finance]]></category>
            <category><![CDATA[dogs]]></category>
            <category><![CDATA[portugal]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[responsible-pet-ownership]]></category>
            <dc:creator><![CDATA[Masoud Saedi]]></dc:creator>
            <pubDate>Fri, 16 Oct 2026 01:05:25 GMT</pubDate>
            <atom:updated>2026-10-16T01:05:25.894Z</atom:updated>
            <content:encoded><![CDATA[<p><strong>A year of expenses with Choco and why every penny was worth it</strong></p><p>In September 2025, we finally decided to adopt a dog. We wanted to grow our family, and we felt ready.</p><p>We ended up at <a href="https://apatorresvedras.pt/"><strong>APA</strong></a>, a shelter in Torres Vedras. Choco was the first dog who came out to meet us. Or, as I prefer to remember it, he came out and chose us. He bonded with me from moment zero. There was something very familiar about him, even though we had just met. It felt like he had been with us forever.</p><p>Since then, he has become the joy of our lives. And because I am also the person who tracks our family expenses, he has his own category in my spreadsheet. Of course he does.</p><h4>So, how much does having a dog actually cost?</h4><p>Our records add up to <strong>€2,531</strong>, from 12 September 2025 to the latest transaction on 7 October 2026. Looking at the <strong>12 complete calendar months from October 2025 to September 2026</strong>, we spent <strong>€177 per month</strong>. Excluding one unexpected <strong>€400 medical bill</strong>, that average becomes <strong>€144</strong>.</p><p>That is our experience with Choco, living in <strong>Portugal</strong>. If you are thinking about adopting a dog, I hope these numbers help you understand what you are committing to, beyond buying a bag of food.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*CWIbTSut2v5sw2QdWyAbYQ.jpeg" /><figcaption><em>The one who chose us. September 2025.</em></figcaption></figure><h3><strong>Where the numbers come from</strong></h3><p>In my other article, <a href="https://medium.com/@masoud_saedi/running-our-family-finances-like-a-cfo-not-just-a-spreadsheet-nerd-6a7d768bbe9f"><em>Running Our Family Finances Like a CFO</em></a>, I explained how I use our expense tracking to understand the real cost of our family life. This article takes one part of that system and looks at it properly: Choco.</p><p>I use a full calendar year for the monthly averages because our records begin partway through September 2025, and October 2026 is still in progress.</p><h3><strong>What the monthly spending actually looks like</strong></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*pzTo6dsWqt6LWzc9iHJM9Q.png" /><figcaption><em>Source: our household expense records. The dashed line is the €177 average for October 2025 to September 2026. The shaded edge months are excluded from that average.</em></figcaption></figure><p>November 2025 was the most expensive month at <strong>€544</strong>. September 2026 was the cheapest complete month at <strong>€34</strong>.</p><p>The <strong>median</strong> monthly payment total was <strong>€158</strong> over the 12 complete months. That means half the months were below that middle value and half above it. The mean was higher, at <strong>€177</strong>, because the more expensive months pulled it up.</p><p>There were cheaper months later in the period, but I would be careful about calling that a permanent reduction in the cost of having a dog. Purchases happen at different times. Training can come in a package. Vaccines and insurance payments do not all arrive neatly together. A quiet month is useful breathing room, but it is not a promise about next month.</p><h3><strong>Where the money went</strong></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*vhrbAz5ZvRP0ZaxqR3y2Pw.png" /></figure><p><em>Every subcategory uses the same 12-month denominator, including months with no payments in that subcategory.</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*QI4q5lb1yLbFhp4AIVIJ1w.png" /><figcaption>The cost of loving Choco. How our dog expenses are shared across categoris.</figcaption></figure><h4><strong>Food averaged about 65 euros per month</strong></h4><p>Food was our biggest subcategory, averaging <strong>€65 per month</strong>. But this label includes more than his main meals. It also includes vitamins and supplements, including a <strong>€110 purchase in December</strong>.</p><p>Choco is very picky with food. We tried so many different options, from premium grain-free kibble to cheaper kibble and even a raw BARF diet. Maybe trying so many things was part of my mistake, too. I just wanted to find something he would happily eat.</p><p>I mention this because food spending really depends on the dog. The first few months can cost more while you try different options and find a balance between what your dog likes, what suits him and what works for your budget.</p><p>So I would read €65 as our average spending under the food label. It is not the price of a standard monthly bag of kibble, and it is not a minimum that every dog owner needs to spend.</p><h4><strong>Medical averaged about 59 euros with the unexpected bill</strong></h4><p>Medical spending includes recorded items such as vaccines, deworming, a protective collar and other care. Across the full year, it averaged <strong>€59 per month</strong>.</p><p>Then there is the bill that deserves its own paragraph: <strong>€400 in November 2025</strong>. After that experience, I decided to get <a href="https://www.barkibu.com/pt/"><strong>Barkibu insurance</strong></a>. I wanted more predictability around the financial side of looking after him.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*0pevK7X6i1yEbY0bObHxeg.png" /><figcaption>Barkibu hasn’t paid me for this mention. If you’re considering insurance for your cat or dog, you can use my code MASOUDANDCHOCO for a €25 discount.</figcaption></figure><p>Excluding that one bill, the medical average drops to <strong>€25 per month</strong>. That is a big difference, but the €400 was still real money we had to pay. Removing it helps me understand the rest of the spending; it does not make unexpected care disappear from the responsibility of having a dog.</p><h4><strong>One vet bill added €33 per month</strong></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*PjO_FotpBxKSDEi-uBKizg.png" /></figure><p>That one payment represented <strong>19% of the full-year total</strong> and added <strong>€33 to the monthly average</strong>. This is why I want both figures visible. Saying “our dog costs €144 a month” without explaining the emergency would leave out something important.</p><h4><strong>Training and accessories averaged about 33 euros per month</strong></h4><p>This category includes items such as a leash, harness and car seat belt, but also a <strong>€200 five training sessions</strong>.</p><p>Some payments are concentrated near the beginning, and some are occasional services or replacements. September 2025 alone had <strong>€138 in training and accessories</strong>, outside the 12-month comparison. That is worth remembering if you are preparing to bring a dog home: the average later on does not tell you how much cash you need at the start.</p><h4><strong>Insurance averaged about 21 euros per month</strong></h4><p>The insurance category averaged <strong>€21 per month</strong> across the full calendar year. That is the average of the payments recorded, not a quotation for a policy. The file includes insurance entries from December onward, with varying amounts, plus a <strong>€36 annual civil liability payment</strong> in July.</p><h4><strong>What I would budget before adopting</strong></h4><p>Based on our experience, I would personally plan for <strong>around €180 to €200 per month</strong>, while keeping money available for an unexpected bill and the first purchases.</p><p>That is my planning allowance based on these records, not a national average or a guaranteed ceiling. Our observed full-year average was about €178, and even the €144 average without the big medical bill still includes training, accessories and insurance.</p><p>The difference between a monthly allowance and the actual payments can stay in a pot for Choco. If we spend €50 in one month, I would rather leave the rest there for the next vaccine, replacement harness or medical expense than decide that dogs cost €50.</p><p>Our first recorded month cost <strong>€354</strong>, and the highest complete month cost <strong>€544</strong>. Those numbers are more useful for thinking about cash availability than assuming every month will match the average.</p><p>Your situation can be very different. A dog who needs a special diet, frequent treatment, grooming or paid care while you work or travel can have a different budget.</p><h4><strong>What the spreadsheet cannot measure</strong></h4><p>Before adopting Choco, I wanted to understand whether we were ready for the responsibility. Looking at these expenses now, I am glad we took the financial side seriously. Loving him means being able to look after him, including on an inconvenient, expensive day.</p><p>He reminds us every day how wonderful life can be. Every sunrise, a new morning, is a gift for him. He does not need to achieve something special to feel good, being together is all he wants. I need that reminder more often than I would like to admit.</p><p>So yes, Choco has cost us money. <strong>€2,500 in the records so far.</strong> He also takes time and attention, and he deserves both. We adore him. He came out of that shelter and somehow felt like family from the beginning. Every penny has been worth it.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=b7c3b83f2c98" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Behind the Credit Decision: A Guide to Acceptance Monitoring]]></title>
            <link>https://medium.com/@masoud_saedi/behind-the-credit-decision-a-guide-to-acceptance-monitoring-ad91c5b253f8?source=rss-a73de117340d------2</link>
            <guid isPermaLink="false">https://medium.com/p/ad91c5b253f8</guid>
            <category><![CDATA[banking]]></category>
            <category><![CDATA[credit-risk]]></category>
            <category><![CDATA[finance]]></category>
            <category><![CDATA[risk-analysis]]></category>
            <dc:creator><![CDATA[Masoud Saedi]]></dc:creator>
            <pubDate>Sat, 10 Oct 2026 01:06:49 GMT</pubDate>
            <atom:updated>2026-10-10T01:16:15.787Z</atom:updated>
            <content:encoded><![CDATA[<p>Imagine you’ve just joined a credit risk team. You open the monthly report and notice that the acceptance rate has fallen. Last month, the lender accepted 60% of applications. This month, it accepted 52%.</p><p>Someone asks: <strong>“What happened?”</strong></p><p>You can describe the movement. You can calculate the difference. But explaining it takes more than reading the number on the screen.</p><p>Did the credit policy change? Did more applications come from a channel with a lower acceptance rate? Were applicants carrying more debt? Or did the mix of products change?</p><p>Those are different explanations for the same headline result.</p><p>This is where acceptance monitoring becomes interesting. It gives us a way to investigate how credit decisions are changing and what those changes might mean for the business.</p><p>In this article, I’ll walk through that investigation using examples from an acceptance monitoring dashboard I developed. We’ll start with the application journey, build an understanding of the main measures, and explore how breaking down the data can reveal what an overall percentage hides.</p><p>We’ll also look beyond the decision itself. Accepting an application is only the beginning. The customer’s later repayment behaviour helps us understand the risk associated with the business we accepted.</p><p>The screenshots use <strong>fictional data and branding</strong>, while preserving the structure and functionality of the report.</p><h3>One Percentage, Several Possible Stories</h3><p>An acceptance rate summarises a set of credit decisions. It doesn’t explain why those decisions happened.</p><p>Consider a simple example. A lender receives applications through two channels:</p><ul><li>One channel generally brings applicants who meet its credit criteria more often.</li><li>The other generally has a lower acceptance rate.</li></ul><p>If the second channel accounts for a larger share of applications this month, the overall acceptance rate could fall <strong>even if the acceptance rate within each channel stays exactly the same</strong>.</p><p>Nothing necessarily changed in the decision rules. The mix of applications changed. That distinction matters. Changing the credit policy in response to a shift in channel mix could mean addressing the wrong problem.</p><p>The same principle applies to products, customer groups, debt ratios, and score bands. Before explaining a movement, we need to find out where it came from.</p><p>This is why I designed my report to let users choose both a metric and a dimension. They can start with an overall change, compare different groups, and narrow the investigation through filters.</p><p>For a junior analyst, this is a useful habit to build early:</p><blockquote><strong><em>Describe the change first. Then investigate what could explain it.</em></strong></blockquote><p>A dashboard helps us locate patterns and test explanations. To reach a conclusion, we may also need information about policy changes, campaigns, operational issues, or the way the data was recorded.</p><h3>Before Measuring Acceptance, Follow the Application</h3><p>There’s another question we need to answer before calculating any rate: <strong>what exactly are we counting?</strong></p><p>A customer can start an application without completing it. An application can be assessed and rejected. It can also be accepted without becoming a financed contract.</p><p>These stages represent different events, so their counts won’t necessarily match. That means two reports labelled “acceptance rate” can show different results if they use different populations or counting rules.</p><p>Before we interpret the percentage, we need to understand the journey behind it.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*wQVlBtWVCCV-nakaYLjSRA.png" /><figcaption>The credit acceptance journey: from application and assessment to the decision, account activation, and ongoing monitoring of repayment performance and risk.</figcaption></figure><p>The journey starts when a customer applies for credit. The lender assesses the application using scoring, affordability checks, and business rules before accepting or rejecting it.</p><p>For accepted applications that proceed to activation, monitoring continues after the decision. We follow credit utilisation, repayment behaviour, and signs of arrears or default. This connects the customers we accept today with the portfolio performance we observe later.</p><h3>Demand and Acceptance: How Many Applications Become Approvals?</h3><p>The first page starts with two basic questions: <strong>how many credit applications are coming in, and how many are we accepting?</strong></p><p>Looking at these together helps us separate changes in customer demand from changes in credit decisions. A fall in accepted applications could happen because fewer people applied, because a smaller share was approved, or because both changed.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*L8OP2BOI668DL9fSNGg5pQ.png" /><figcaption><em>Demand and acceptance overview, with previous-period comparisons and rejection rates broken down by customer population. The report allows users to change the metric and the dimension used for comparison.</em></figcaption></figure><h4><strong>Total Demand</strong></h4><p>Total demand is the number of credit applications included in the report for the selected period and filters.</p><p>The calculation is a count of applications. But before counting, we need a clear definition of what qualifies: all submitted applications, completed applications, or only those that reached assessment.</p><p>We also need to know whether repeated applications from the same customer are counted separately. Counting applications and counting unique applicants can produce different results.</p><p>Demand helps us understand the flow of business coming into the credit process. We can compare it over time or break it down by product and channel to see where a change originated. For example, a rise in applications from one channel could explain an increase in overall demand. It could also change the characteristics of the population we assess.</p><h4>Total Accepted</h4><p>Total accepted is the number of applications receiving an acceptance decision within the report’s defined population. The calculation is a count of accepted applications for the selected period and filters.</p><p>This tells us the volume of applications passing the credit decision stage. It does not necessarily tell us how many customers went on to use the credit. An accepted application and a financed contract are different stages of the journey.</p><p>Comparing accepted volume with demand is particularly useful. If demand rises but accepted volume falls, we need to investigate the decisions and the types of applications being received.</p><h4>Acceptance Rate</h4><p>The acceptance rate tells us what proportion of the relevant applications were accepted.</p><p>A simple calculation is:</p><p><strong>Acceptance rate = Accepted applications ÷ Applications included in the calculation × 100</strong></p><p>Suppose 1,000 applications are included and 600 are accepted. The acceptance rate is <strong>60%</strong>.</p><p>The denominator matters. Some reports use assessed applications, while others use a broader application population. Pending, incomplete, or withdrawn applications may be treated differently. The definition needs to be clear before we compare results.</p><p>A higher acceptance rate means a larger share of applications was accepted. It does not, by itself, tell us whether the lender made better decisions. We still need to understand the applicant mix, any policy changes, and the later performance of accepted customers.</p><h4>Rejection Rate</h4><p>The rejection rate tells us what proportion of the relevant applications were rejected.</p><p><strong>Rejection rate = Rejected applications ÷ Applications included in the calculation × 100</strong></p><p>If 400 out of 1,000 applications are rejected, the rejection rate is <strong>40%</strong>.</p><p>Acceptance and rejection rates add up to 100% only when they use the same denominator and every application in that population belongs to one of those two outcomes.</p><p>The screenshot shows rejection rates by population type. The trend chart helps us see when the groups started to change, while the bar chart compares their latest positions.</p><p>The population labels also need a definition. “Risky” and “non-risky” describe classifications used by this report; readers should know how those groups are assigned before interpreting the difference.</p><h4>Forcing Rate</h4><p>Some applications initially receive a rejection decision but are subsequently accepted through an override. <strong>The forcing rate measures how often this happens.</strong></p><p><strong>Forcing rate = Initially rejected applications subsequently accepted ÷ Total initially rejected applications × 100</strong></p><p>For example, if 1,000 applications were initially rejected and 20 were later accepted through an override, the forcing rate would be <strong>2%</strong>.</p><p>This helps us monitor how frequently initial rejection decisions are overridden. We can break it down by product, channel, or customer group to understand where these exceptions occur.</p><p>An increase gives us something to investigate: why are more rejected applications being accepted, and how do those customers perform afterwards?</p><p><strong>An override does not automatically mean a poor decision.</strong> The rate shows how often exceptions happen; their reasons and subsequent repayment performance help us assess their quality.</p><h4>Turning the Page into an Investigation</h4><p>Suppose acceptance falls. I would start by checking whether the decline appears across the portfolio or is concentrated in particular groups.</p><p>Using the metric and dimension selectors, we can investigate questions such as:</p><ul><li>Did rejection increase in every channel?</li><li>Did one product account for most of the change?</li><li>Did the share of applications from higher-risk groups increase?</li><li>Did a change in credit criteria coincide with the movement?</li></ul><p>This page helps us locate the change. Explaining its cause may require further analysis and information about business or policy decisions.</p><p>That is the purpose of demand and acceptance monitoring: <strong>understand what entered the credit process, what decisions followed, and where to investigate next.</strong></p><h3>Scores: Comparing Who Applies with Who Gets Accepted</h3><p>Application volumes tell us how many people apply. Scores help us understand the risk profile of those applications.</p><p>A credit score summarises information used to assess creditworthiness. Its meaning depends on the model: the scale and whether higher or lower scores indicate lower risk must be understood before interpreting the results.</p><p>For the examples below, we’ll assume <strong>a higher score indicates lower estimated credit risk</strong>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*NJ69KFcr28oVH96h2Smz6g.png" /><figcaption><em>Comparing average scores across all applications and accepted applications, with demand-score trends broken down by application channel. All figures are fictional.</em></figcaption></figure><h4>Average Demand Score</h4><p>The average demand score is the average score of applications in the demand population.</p><p><strong>Average demand score = Sum of valid application scores ÷ Number of applications with a valid score</strong></p><p>For example, if three applications have scores of 60, 70, and 80, their average demand score is <strong>70</strong>.</p><p>This measure helps us follow the risk profile of incoming applications. A decrease could indicate that applicants have become riskier according to the scoring model. It could also reflect a change in the mix of products, channels, or customer groups.</p><p>That gives us a question to investigate: <strong>did scores fall within individual groups, or did a lower-scoring group account for more applications?</strong></p><p>Applications without a valid score need separate attention. Treating a missing score as zero would distort the average.</p><h4>Average Accepted Score</h4><p>The average accepted score is the average score of applications that received an acceptance decision.</p><p><strong>Average accepted score = Sum of valid scores for accepted applications ÷ Number of accepted applications with a valid score</strong></p><p>This tells us about the score profile of the applications passing through the credit decision process.</p><p>In the fictional dashboard, the average demand score is <strong>68</strong>, while the average accepted score is <strong>82</strong>. Accepted applications therefore have a higher average score than the overall demand population.</p><p>This is consistent with selecting lower-risk applications under our assumed score direction. However, credit decisions may also consider affordability, eligibility, and other business rules.</p><h4>Why Compare the Two?</h4><p>Looking at both averages helps us distinguish changes in incoming demand from changes in the accepted population.</p><p>For example:</p><ul><li><strong>Demand scores fall while accepted scores remain stable:</strong> the incoming population has changed, while the accepted population retains a similar average score.</li><li><strong>Both averages fall:</strong> lower scores are appearing among applicants and accepted applications. We should investigate the customer mix and decision criteria.</li><li><strong>Accepted scores rise while acceptance falls:</strong> the lender may be accepting a more selective group, although the averages alone cannot establish why.</li></ul><p>These comparisons are meaningful only when the scores use comparable models and scales. A model change can create a movement that does not represent a change in customer risk.</p><h4>What the Average Can Hide</h4><p>Two groups can have the same average but very different score distributions. Scores of <strong>50 and 90</strong> average <strong>70</strong>. Scores of <strong>69 and 71</strong> also average <strong>70</strong>, but the first group contains much greater variation.</p><p>That is why averages are a starting point. Breaking results down by score band, product, channel, or customer group helps us understand what sits behind them.</p><p>The dashboard supports this investigation by showing historical trends alongside the latest group comparison. Users can identify a movement, locate the groups driving it, and decide where to look more closely.</p><p>Finally, a score reflects estimated risk. <strong>Later repayment performance tells us how the accepted customers actually behaved.</strong> Connecting those two views is an essential part of monitoring credit decisions.</p><h4>Average Debt Ratio: How Much Income Is Already Committed?</h4><p>A credit score helps us understand estimated risk. The debt ratio adds an affordability perspective: <strong>how much of the applicant’s income is committed to debt repayments?</strong></p><p>At application level, the calculation is generally:</p><p><strong>Debt ratio = Monthly debt repayments ÷ Monthly income × 100</strong></p><p>For example, someone with €1,500 in monthly income and €450 in monthly debt repayments has a debt ratio of <strong>30%</strong>.</p><p>The exact definition matters. We need to specify which income is used and whether repayments include the credit being requested.</p><h4>Average Debt Ratio of Demand</h4><p><strong>This is the average debt ratio across applications in the demand population with a valid ratio.</strong></p><p><strong>Average debt ratio of demand = Sum of individual debt ratios ÷ Number of applications with a valid ratio</strong></p><p>It helps us monitor the repayment burden of incoming applicants. An increase could reflect higher debt commitments, lower incomes, or a change in the applicant mix.</p><h4>Average Debt Ratio of Accepted Applications</h4><p>This is the average debt ratio among accepted applications with a valid ratio.</p><p><strong>Average accepted debt ratio = Sum of individual debt ratios for accepted applications ÷ Number of accepted applications with a valid ratio</strong></p><p>Comparing the two averages helps us understand how affordability differs between those who apply and those who are accepted.</p><p>In the fictional screenshot, demand has an average debt ratio of <strong>29.4%</strong>, compared with <strong>18.6%</strong> for accepted applications. The accepted group therefore commits a smaller share of income to debt repayments on average.</p><p>However, a lower ratio does not guarantee affordability. Two people with the same ratio can have very different amounts left for housing, food, and other essential expenses.</p><p>These are also <strong>averages of individual ratios</strong>, rather than total repayments divided by total income. Those calculations can produce different results.</p><p>Together, scores and debt ratios give us complementary views: estimated credit risk and repayment burden. Breaking both down by customer group helps us investigate what the overall averages might hide.</p><h3>Granted Credit: How Much Do We Offer?</h3><p>An acceptance decision tells us whether an application was approved. The next question is: <strong>how much credit did we grant, and how can the customer use it?</strong></p><p>For a credit card, the granted credit limit is the maximum amount made available under the agreement. It does not mean the customer has already borrowed or spent that amount.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*8ENX8opfbgGk2JUBzyPkHg.png" /><figcaption><em>Granted credit limits, the difference between requested and approved amounts, and the share of customers eligible to use their full limit outside the partner network. All figures are fictional.</em></figcaption></figure><h4>Total Granted Credit Limit</h4><p>This is the sum of the credit limits granted within the selected reporting population and period.</p><p><strong>Total granted credit limit = Sum of individual granted credit limits</strong></p><p>For example, granting limits of €1,000, €1,500, and €2,000 produces a total of <strong>€4,500</strong>.</p><p>This helps us monitor the scale of credit made available. An increase could come from approving more applications, granting larger limits, or both.</p><p>Looking at the total alongside accepted volumes and the average limit helps us distinguish those explanations.</p><h4>Average Granted Credit Limit</h4><p>This tells us how much credit is granted per approved application, on average.</p><p><strong>Average granted credit limit = Total granted credit limit ÷ Number of approved applications with a granted limit</strong></p><p>If 100 approved applications receive a combined €150,000 in credit limits, the average is <strong>€1,500</strong>.</p><p>Breaking this down by product, channel, or customer group helps us understand where limits differ. Those differences may reflect customer needs, affordability, risk assessments, or product rules.</p><p>A higher average is not automatically better. The question is whether the limits are appropriate for the customers receiving them.</p><h4>Average Credit Limit Gap</h4><p>Customers do not always receive the amount they request. <strong>The credit limit gap measures the difference between the requested and granted amounts.</strong></p><p>For each application:</p><p><strong>Credit limit gap = Requested credit limit − Granted credit limit</strong></p><p>Then:</p><p><strong>Average credit limit gap = Sum of individual gaps ÷ Number of applications included</strong></p><p>If a customer requests €2,000 and receives €1,500, the gap is <strong>€500</strong>. If they receive the full requested amount, the gap is <strong>zero</strong>.</p><p>A smaller gap means the offer is closer to what the customer requested. From that perspective, a reduction is favourable, provided the granted amount remains appropriate for the customer’s affordability and risk.</p><h3>Risk Monitoring: What Happens After Acceptance?</h3><p>So far, we’ve looked at applications, scores, affordability, and granted credit. Now comes the question that connects those decisions with their outcomes:</p><p><strong>How are the customers we accepted performing afterwards?</strong></p><p>This page follows groups of customers accepted in the same month. These groups are called <strong>cohorts</strong>, or <strong>vintages</strong>.</p><p>We monitor them at different points after acceptance, using both our own repayment information and external information from CRC.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*p-WKKpXrjmoLV8yoB4PhlA.png" /><figcaption><em>Risk monitoring by acceptance cohort, with selectable measures, internal or external risk, and observation horizons. The example shows internal amount-based risk at M+6 using fictional data.</em></figcaption></figure><h4>Understanding the Horizons</h4><p><strong>M</strong> represents the acceptance month. <strong>M+6</strong> represents six months after that month.</p><p>For example, customers accepted in March 2026 reach M+6 in September 2026.</p><p>The dashboard includes M+1, M+3, M+6, and M+12. These help us examine early repayment difficulties and performance further into the customer journey.</p><p>The essential rule is to compare cohorts at the same age. A cohort observed for one month has had much less time to develop payment problems than one observed for twelve months.</p><p>A cohort that has not yet reached M+6 should therefore have no M+6 result. Showing zero would incorrectly suggest that it had completed six months without any problems.</p><h4>Internal Risk Rate in Number</h4><p>This measures the proportion of accepted cases meeting the report’s internal arrears definition at the selected horizon.</p><p><strong>Internal risk rate M+6 in number = Accepted cases in arrears at M+6 ÷ Total accepted cases in the same cohort × 100</strong></p><p>If 40 out of 1,000 accepted cases are in arrears six months later, the rate is <strong>4%</strong>.</p><p>This tells us how widespread repayment difficulties are within the cohort.</p><p>The counting unit must remain consistent. If we count contracts, both parts of the calculation must use contracts. If we count unique customers, both must use unique customers.</p><p>We also need to define what qualifies as arrears, including any days-past-due or amount threshold.</p><h4>Internal Risk Rate in Amount</h4><p>This measures the unpaid amount at the selected horizon relative to the total amount accepted for that cohort.</p><p>Using this report’s definition:</p><p><strong>Internal risk rate M+6 in amount = Unpaid amount at M+6 ÷ Total accepted amount for the same cohort × 100</strong></p><p>For example, if a cohort has a total accepted amount of €1 million and €42,000 is unpaid at M+6, the rate is <strong>4.2%</strong>.</p><p>The amount-based measure adds financial scale to the analysis. A relatively small number of customers can account for a substantial unpaid amount.</p><p>It is important to specify exactly what “unpaid amount” includes: overdue instalments and the full outstanding balance of contracts in arrears are different measures. The accepted amount in the denominator must also be clearly defined.</p><p>This rate is not automatically a loss rate. Some unpaid amounts may subsequently be recovered.</p><h4>Why Look at Both Number and Amount?</h4><p>The two measures answer different questions:</p><ul><li><strong>Number:</strong> how widespread are repayment difficulties?</li><li><strong>Amount:</strong> how large is the unpaid amount relative to the amount accepted?</li></ul><p>If the number-based rate remains stable while the amount-based rate rises, larger balances may be driving the deterioration.</p><p>If the number-based rate rises while the amount-based rate stays relatively stable, difficulties may be spreading among smaller accounts.</p><p>These patterns help us decide where to investigate. They do not establish the cause on their own.</p><h4>External Credit Deterioration Rate</h4><p>Customers may develop repayment difficulties with other lenders while continuing to pay us normally. This indicator adds an external perspective to our internal repayment monitoring.</p><p>We identify accepted customers who had no negative external credit information at acceptance and check whether they have negative information at a later horizon.</p><p>In this report, the external information comes from Portugal’s credit register, known as CRC. For this article, I’ll call the custom measure the <strong>External Credit Deterioration Rate</strong>.</p><p>At six months, the calculation is:</p><p><strong>External credit deterioration rate M+6 = Accepted customers with no negative external information at acceptance who have negative external information at M+6 ÷ Total accepted customers in the same cohort × 100</strong></p><p>For example, if 30 customers meet that condition out of 1,000 accepted customers, the rate is <strong>3%</strong>.</p><p>The denominator includes <strong>all accepted customers in the cohort</strong>. This measures newly observed external deterioration as a share of the whole accepted population, rather than only the customers initially without negative information.</p><p>Comparing the indicator across cohorts and customer groups helps us identify where external repayment difficulties are emerging, including among customers whose payments to us remain up to date.</p><p>To interpret it correctly, we need to define what counts as negative information, which external credit exposures are included, and how missing observations are handled. <strong>Missing information should not automatically be treated as an absence of repayment problems.</strong></p><h4>Reading the Risk Page</h4><p>The controls let users choose the risk type, number or amount, horizon, and comparison dimension.</p><p>The trend chart compares acceptance cohorts at the selected horizon. The latest-cohort bars help users identify differences between groups.</p><p>Together, these views support questions such as:</p><ul><li>Are recent cohorts performing worse at the same age?</li><li>Is deterioration concentrated in a particular product or channel?</li><li>Are problems becoming more widespread, or concentrated in larger balances?</li><li>Are customers developing external difficulties while still paying us normally?</li></ul><p><strong>This is where acceptance monitoring closes the loop:</strong> we connect the decisions made at application with the behaviour observed afterwards.</p><h3>Giving Users Room to Explore</h3><p>A reporting page can answer the questions we anticipated when building it. But users often have follow-up questions.</p><p>They might notice a rise in rejection and want to focus on a particular channel. Then they may want to compare score bands, requested amounts, or debt ratios within that channel.</p><p>I designed the report to support that kind of investigation.</p><p>Users can select metrics and comparison dimensions, then use a collapsible filter pane to narrow the population. The filters include characteristics such as age band, score band, income band, credit duration, and application channel.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*1ei77uwi188em55jg7TyXQ.png" /><figcaption><em>The expandable filter pane lets users investigate specific customer groups while keeping the main reporting pages clear.</em></figcaption></figure><p>The pane opens when users need more detail and closes when they want to focus on the results. A clear-all button makes it easy to return to the broader view.</p><p>This flexibility could be particularly valuable to users, who could explore their own questions without asking the analytics team to prepare every new breakdown.</p><p>However, more flexibility also means users need to understand what they are looking at. Clear metric definitions, visible filter status, and consistent calculations are essential. A percentage based on a small filtered population can look dramatic, so it should always be considered alongside its underlying volume.</p><p>For me, a useful report gives people both <strong>the freedom to investigate and the context to interpret what they find</strong>. That is what connects the dashboard’s design with the credit risk concepts we’ve covered throughout this article.</p><h3>Following the Decision Through</h3><p>An approval is the beginning of a credit relationship. Its outcome becomes clearer as the customer starts using the credit and making repayments.</p><p>That is why I find acceptance monitoring so interesting. It connects several parts of the same story: who applies, who gets accepted, how much credit they receive, and how they perform afterwards.</p><p>Each measure adds something. Demand gives us volume. Scores and debt ratios help us understand the applicants. Granted limits describe the offer. Risk indicators show what develops after the decision.</p><p>For anyone starting in credit risk analytics, my advice is to spend time understanding those connections. Before explaining a movement, check what the metric counts, which population it covers, and whether the comparison is fair. Then break it down and investigate.</p><p>Building this report helped me develop that habit. Making it dynamic gave business users more independence, but it also pushed me to make the calculations and definitions clearer. A useful report needs both.</p><p>There will always be another filter to try or another chart to build. The question I keep coming back to is simpler: <strong>what does this help us understand about our credit decisions?</strong></p><p>If you’d like to follow the journey further, my earlier article, <a href="https://medium.com/@masoud_saedi/credit-risk-analytics-for-beginners-understanding-the-customer-collections-journey-0bafe8a4276e"><em>Credit Risk Analytics for Beginners: Understanding the Customer Collections Journey</em></a>, explores what happens when customers miss payments and how analytics supports collections.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=ad91c5b253f8" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Credit Risk Analytics for Beginners: Understanding the Customer Collections Journey]]></title>
            <link>https://medium.com/@masoud_saedi/credit-risk-analytics-for-beginners-understanding-the-customer-collections-journey-0bafe8a4276e?source=rss-a73de117340d------2</link>
            <guid isPermaLink="false">https://medium.com/p/0bafe8a4276e</guid>
            <category><![CDATA[credit-risk]]></category>
            <category><![CDATA[banking]]></category>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[credit-risk-management]]></category>
            <category><![CDATA[business-intelligence]]></category>
            <dc:creator><![CDATA[Masoud Saedi]]></dc:creator>
            <pubDate>Fri, 07 Aug 2026 17:13:04 GMT</pubDate>
            <atom:updated>2026-08-07T17:13:04.169Z</atom:updated>
            <content:encoded><![CDATA[<h4>A practical guide for junior Credit Risk Analysts, Data Analysts, and anyone starting their journey in Finance Risk Analytics.</h4><p>If you’re new to Credit Risk or Collections Analytics, you’ve probably come across dashboards filled with unfamiliar terms. <strong>Payment Rate, Efficiency Rate, Recycle Rate, Vintage Analysis, Days Past Due (DPD).</strong></p><p>At first, they can look like just another collection of KPIs. I remember feeling the same way. I understood what each metric measured, but I didn’t fully understand <strong>why</strong> the business cared about them.</p><p>That changed when I started working more closely with collections reporting.</p><p>I realised something that seems obvious now:</p><blockquote><strong><em>Business users don’t wake up thinking about KPIs. They wake up thinking about business questions.</em></strong></blockquote><p>Questions like:</p><ul><li>Are customers paying more quickly than last month?</li><li>Which collection phase is performing best?</li><li>Are recent collection strategies improving our results?</li><li>Is the overall portfolio getting healthier or worse?</li></ul><p>The KPIs are simply different ways of answering those questions.</p><p>Once I started looking at collections reporting from that perspective, dashboards stopped being reports. They became decision-making tools.</p><p>This article is my attempt to explain collections analytics in the same way I wish someone had explained it to me when I first entered this field.</p><p>We’ll look at the collections process, the most important KPIs, why segmentation matters, how Vintage Analysis works, and finally, how I designed a dynamic dashboard that helps business users answer these questions without needing dozens of separate reports.</p><p>All screenshots shown in this article use <strong>illustrative and anonymized data</strong>. The layout reflects a real dashboard, but all values, trends, and company information have been changed to protect confidential business information.</p><h3>Why Collections Reporting Matters</h3><p>When people hear the word <strong>Collections</strong>, they often imagine a team calling customers who have missed a payment. That certainly happens. But collections is much more than making phone calls or sending payment reminders. <strong>The real objective is to help customers return to a healthy repayment status while reducing financial risk for the bank</strong>.</p><p>Every payment collected improves cash flow. Every customer who returns to a normal repayment schedule reduces future risk. Every successful collection strategy helps improve the overall quality of the portfolio.</p><p>Because of that, collections teams constantly need answers to questions like:</p><ul><li>Are our current strategies working?</li><li>Which customer groups respond better to different collection approaches?</li><li>Where should we focus our efforts?</li><li>Which portfolios require immediate attention?</li></ul><p>Without reporting, answering these questions would mean manually reviewing millions of customer records.</p><p>That’s simply not practical. This is where analytics becomes essential. A good dashboard doesn’t replace business knowledge. It supports it. It turns thousands of rows of data into information that people can understand in seconds.</p><h3>Understanding the Collections Journey</h3><p>Before talking about dashboards or KPIs, it’s worth understanding what actually happens after a customer misses a payment.</p><p>Every organisation has its own collections strategy, but the overall journey usually looks something like this.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*omnuYpeq3XVwZzsgBtrbgQ.png" /><figcaption><em>A simplified view of the collections journey. Each stage represents a different point in the customer lifecycle and forms the basis for the key performance indicators (KPIs) used throughout this article. Actual collections workflows vary between organisations.</em></figcaption></figure><p>Of course, reality is rarely this simple. Some customers pay immediately after receiving a reminder. Others require several contacts before making a payment. Some move through multiple collection phases. Others may eventually enter legal collections.</p><p>This is why collections teams monitor the process so closely. It’s not enough to know <strong>how much</strong> money was recovered. They also want to understand:</p><ul><li>How quickly customers are paying.</li><li>Which collection phases perform best.</li><li>Which customer segments are improving.</li><li>Where customers get “stuck” in the journey.</li><li>Whether new strategies are producing better results than older ones.</li></ul><p>Each stage tells a different part of the story. When combined, they provide a much clearer picture of portfolio performance.</p><h3>Turning Data Into Business Decisions</h3><p>Most companies already have plenty of data. Customer information, Payment history, Outstanding balances, Collection activities, Risk classifications.</p><p>The challenge isn’t collecting data. The challenge is making it useful. One mistake I’ve noticed in many reporting projects is the assumption that adding more charts automatically creates more insight.</p><p>In reality, the opposite often happens. Reports become crowded. Users spend more time looking for information than understanding it. The dashboard becomes a place to find numbers instead of a tool to support decisions.</p><p>While designing this dashboard, I tried to keep asking myself one simple question:</p><blockquote><strong><em>What decision should this visual help someone make?</em></strong></blockquote><p>If I couldn’t answer that question, the visual probably didn’t belong in the report. That mindset influenced every page of the dashboard.</p><h3>Designing Around Questions, Not Around Pages</h3><p>One of the design decisions I’m happiest with has nothing to do with colours or charts. It has to do with reducing complexity. I’ve seen many dashboards where every metric has its own page. Another page for Payment Rate. Another for Efficiency Rate. Another for Recycle Rate.</p><p>Then separate pages again for Days Past Due. Another for Product. Another for Customer Segment. Another for Age Group.</p><p>Before long, a report has twenty or thirty pages, many of which look almost identical. I wanted to avoid that. Instead, I designed the dashboard around a small number of <strong>dynamic pages</strong>. Rather than navigating through dozens of reports, users simply choose <strong>what they want to analyse</strong>.</p><p>For example, they can switch between key collections metrics such as:</p><p>Payment Rate<br>Efficiency Rate (Outstanding)<br>Efficiency Rate (Overdue)<br>Recycle Rate (#)<br>Recycle Rate (€)</p><p>without leaving the page.</p><p>The same idea applies to segmentation. Instead of creating separate reports for every business dimension, users can choose whether they want to analyse the portfolio by: Risk Segment, Days Past Due, Product, Age Group, Collection Phase, and many other dimensions.</p><p>The visual updates instantly.</p><p>The same philosophy is also used in the Vintage Analysis pages. Rather than creating separate reports for M0, M1, M3, M6, M9 and M12, users simply select the horizon they want to analyse. The dashboard does the rest. This approach keeps the report compact, easier to maintain, and much more flexible.</p><p>More importantly, it allows business users to explore new questions on their own instead of waiting for someone to build another report.</p><p>To me, that’s one of the biggest strengths of modern Business Intelligence. A dashboard shouldn’t just display information. It should help people discover answers.</p><h3>The KPIs Behind Every Collections Dashboard</h3><p>Now that we’ve looked at the collections journey, let’s talk about the numbers behind it.</p><p>When someone opens a collections dashboard for the first time, it’s easy to focus on the KPI cards at the top of the page. They’re usually the first thing people notice. But the numbers themselves aren’t the most important part.</p><p>What’s important is understanding <strong>what each KPI is trying to tell you. </strong>A good collections dashboard shouldn’t encourage users to memorise formulas. It should help them answer business questions. Every KPI exists because someone, somewhere in the business, needed an answer.</p><p>Let’s look at the five core metrics that appear throughout this dashboard.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*DuBa-UU_VttCfK_p-AqqPg.png" /><figcaption>The dashboard uses dynamic metric and dimension selection, allowing users to analyse different KPIs and business perspectives without navigating through dozens of separate report pages. All values and trends shown are illustrative.</figcaption></figure><h3>1. Payment Rate</h3><p>Imagine you contacted 10,000 customers this month. Some paid. Some didn’t. One of the first questions management will ask is:</p><blockquote><strong><em>How many customers actually made a payment?</em></strong></blockquote><p>That’s exactly what the <strong>Payment Rate</strong> measures.</p><p>In simple terms, it tells us the percentage of customers who made at least one payment during the selected period.</p><p>A simplified formula looks like this:</p><p><strong>Payment Rate = Customers Who Paid ÷ Customers in Collections</strong></p><p>Although different organisations may calculate it slightly differently, the objective is always the same. It answers one simple question:</p><blockquote><strong><em>Are customers responding?</em></strong></blockquote><p>A higher Payment Rate generally means more customers are engaging with the collections process. That’s encouraging. But here’s an important lesson. A high Payment Rate doesn’t automatically mean the collections strategy is successful. Imagine these two situations.</p><h3>Portfolio A</h3><p>1,000 customers pay €10 each.</p><h3>Portfolio B</h3><p>500 customers pay €500 each.</p><p>Portfolio A has the higher Payment Rate. Portfolio B recovered much more money.</p><p>Which portfolio performed better? There’s no single answer. That’s why Payment Rate should never be analysed in isolation. It’s one piece of the story. Not the entire story.</p><h3>2. Efficiency Rate (Overdue)</h3><p>This KPI is one of my favourites because it focuses on something the business genuinely wants to reduce:</p><p><strong>Overdue debt.</strong></p><p>The question here isn’t:</p><blockquote><em>Did customers make a payment?</em></blockquote><p>The question is:</p><blockquote><strong><em>How much overdue exposure did we actually recover?</em></strong></blockquote><p>A simplified formula looks like this:</p><p><strong>Efficiency Rate (Overdue) = Overdue Amount Collected ÷ Total Overdue Amount</strong></p><p>In other words, if customers owed €1 million in overdue balances and €300,000 was recovered,</p><p>the efficiency would be 30%.</p><p>This KPI tells us how effectively the collections team is reducing delinquency. That’s an important distinction. <strong>A customer could make a payment and still remain overdue.</strong> From a collections perspective, reducing overdue exposure is often more meaningful than simply counting payments. This is why many collections managers monitor Payment Rate and Overdue Efficiency together. One measures customer behaviour, the other measures financial impact.</p><h3>3. Efficiency Rate (Outstanding)</h3><p>At first glance, these two metrics look very similar, but they’re answering different questions.</p><p>Think of a customer who has a total outstanding balance of <strong>€10,000</strong>, of which <strong>€2,000</strong> is overdue.</p><p>If the customer pays <strong>€1,000</strong>:</p><ul><li><strong>Efficiency Rate (Overdue)</strong> measures that recovery against the <strong>€2,000</strong> overdue balance.</li><li><strong>Efficiency Rate (Outstanding)</strong> measures the same recovery against the <strong>€10,000</strong> total outstanding balance.</li></ul><p>The payment hasn’t changed.</p><p><strong>Only the reference amount has.</strong></p><p>That’s why the two metrics tell different stories. One focuses on reducing delinquency, while the other measures recovery against the customer’s total exposure. Both are useful. They’re simply measuring different things.</p><h3>4. Recycle Rate (#)</h3><p>One of the main goals of collections isn’t simply collecting money. It’s helping customers return to a normal repayment cycle. This is where the <strong>Recycle Rate</strong> becomes important. In its simplest form, Recycle Rate (#) measures the percentage of customers who leave collections and return to a healthy status.</p><p>A simplified formula looks like this:</p><p><strong>Recycle Rate (#) = Customers Recycled ÷ Customers in Collections</strong></p><p>This KPI tells us something very different from Payment Rate. A customer might make one payment today. That’s good. But they could still remain overdue next month. A recycled customer has successfully moved back into the normal portfolio. That’s a much stronger outcome.</p><p>For this reason, many organisations consider <strong>customer cure</strong> one of the most important indicators of <strong>long-term collections success</strong>.</p><h3>5. Recycle Rate (€)</h3><p>Recycle Rate (€) follows exactly the same idea. The only difference is that we’re measuring <strong>portfolio value instead of customer count. </strong>A simplified formula looks like this:</p><p><strong>Recycle Rate (€) = Outstanding Amount Recycled ÷ Total Outstanding Amount</strong></p><p>This helps answer another business question.</p><blockquote><strong><em>How much portfolio value has actually returned to a healthy status?</em></strong></blockquote><p>Sometimes a relatively small number of customers represent a very large share of the portfolio value. Looking only at customer counts could hide that. By measuring both the number of customers and the monetary value, the business gains a much more balanced understanding of portfolio performance.</p><h3>Why One KPI Is Never Enough</h3><p>One of the biggest lessons I’ve learned while working with business users is that there’s rarely a “perfect KPI.” Every metric highlights one part of the story.</p><p><strong>Payment Rate</strong> measures customer engagement.</p><p><strong>Efficiency</strong> measures financial recovery.</p><p><strong>Recycle Rate</strong> measures long-term portfolio health.</p><p>If you focus on only one of them, you’ll almost always miss something important. That’s why the dashboard lets users switch between these metrics instead of creating separate reports for each one.</p><p>The business question changes. The dashboard changes with it. The layout stays exactly the same, making comparisons much easier.</p><p>Personally, I think this is one of the biggest advantages of using dynamic metrics. Users don’t need to learn five different report pages. They learn one dashboard, then simply change the metric they’re interested in.</p><h3>Looking Beyond the Overall Portfolio</h3><p>Imagine your dashboard shows a Payment Rate of <strong>45%</strong>. Is that good?Maybe. Maybe not. Without additional context, that number doesn’t tell us very much.</p><p>What if customers aged 18–25 have a Payment Rate of only 18%? What if customers over 60 are above 70%? What if the Legal collection phase is outperforming Commercial this month? What if one product has twice the recycle rate of another?</p><p>Suddenly, the overall portfolio average becomes much less interesting. This is why segmentation is one of the most powerful tools in collections analytics.</p><p>It helps us move from</p><blockquote><strong><em>“What happened?”</em></strong></blockquote><p>to</p><blockquote><strong><em>“Where did it happen?”</em></strong></blockquote><p>And that’s exactly what we’ll explore in the next section.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*0FggGLezmEhS8M-8lypFdw.png" /><figcaption><em>The same dashboard layout can analyse multiple KPIs. Users simply select the metric they want to explore, while the visual structure remains consistent. This makes comparisons easier and significantly reduces report complexity.</em></figcaption></figure><h3>Looking Beyond the Numbers: Segmentation and Vintage Analysis</h3><p>Segmentation helps us understand <strong>where</strong> performance is coming from. Vintage Analysis answers a different question:</p><blockquote><strong><em>How has performance evolved over time?</em></strong></blockquote><p>Two portfolios might have exactly the same Payment Rate today. That doesn’t necessarily mean they’re performing equally well. One portfolio may have reached that result after three months in collections, while another needed twelve months to get there.</p><p>Looking only at today’s numbers hides that difference. That’s why collections teams rely on Vintage Analysis.</p><p>Rather than comparing portfolios based on the calendar date, Vintage Analysis compares them based on how long they’ve been in the collections process. It gives us a much fairer way to evaluate performance.</p><p>Now the transition becomes:</p><ul><li><strong>Segmentation = Where?</strong></li><li><strong>Vintage = When / How long?</strong></li></ul><p>Instead of asking <strong>“What happened?”</strong>, they help answer <strong>“Where did it happen?”</strong>, <strong>“Who did it happen to?”</strong>, and <strong>“Is this part of a longer trend?”</strong></p><h3>Why Segmentation Matters</h3><p>One of the biggest mistakes analysts make is relying too much on portfolio averages. Averages are useful. But they can also hide problems. Let’s imagine a simple example. Suppose the portfolio has a Payment Rate of <strong>45%</strong>. At first glance, that might seem acceptable. Now let’s break it down:</p><p><strong>Segment A</strong> Payment Rate: 67%<br><strong>Segment B</strong> Payment Rate: 59%<br><strong>Segment C</strong> Payment Rate: 41%<br><strong>Segment D</strong> Payment Rate: 18%</p><p>The portfolio average hasn’t changed. But the story has. One segment is performing extremely well. Another clearly needs attention. If we had looked only at the overall KPI, we would never have seen that difference. That’s why experienced analysts rarely stop at portfolio-level metrics.</p><p>Their next question is almost always:</p><blockquote><strong><em>“Can I break this down?”</em></strong></blockquote><h3>Every Segment Tells a Different Story</h3><p>One thing I wanted to achieve while designing this dashboard was giving users the freedom to explore the portfolio from different perspectives.</p><p>Rather than creating a separate report for every business dimension, I built a single page where users simply choose what they want to analyse.</p><p>For example, they can view the same KPI by: Risk Segment, Days Past Due (DPD), Collection Phase, Product, Age Group, Customer Type and many other dimensions.</p><p>The KPI stays the same. The perspective changes. That might sound like a small design decision, but it has a big impact. Instead of maintaining ten nearly identical report pages, the business has one dynamic page that answers dozens of different questions.</p><p>From a user’s point of view, it’s also much simpler. Once they understand how one page works, they already know how to use the rest of the dashboard.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*SC1xU6v1A0hgx3YOrFYhvA.png" /><figcaption><em>A single dynamic page allows users to analyse different KPIs across multiple business dimensions. Small multiples are used instead of crowded multi-line charts, making trends easier to compare across categories while keeping the dashboard compact and easy to navigate.</em></figcaption></figure><h3>Different Questions Need Different Dimensions</h3><p>One thing I enjoy about collections analytics is that every business question naturally leads to a different way of looking at the data.</p><p>If management asks:</p><blockquote><strong><em>Which customers are more likely to pay?</em></strong></blockquote><p>Age Group or Customer Segment might be useful.</p><p>If they ask:</p><blockquote><strong><em>Which part of the collections process needs attention?</em></strong></blockquote><p>Collection Phase becomes more relevant.</p><p>If they ask:</p><blockquote><strong><em>Where is most of our overdue exposure?</em></strong></blockquote><p>Days Past Due may provide the answer.</p><p>There’s no single “best” dimension. It depends on the question you’re trying to answer. That’s another reason I wanted the dashboard to be dynamic. Instead of deciding in advance what users should analyse, I wanted them to explore the data themselves.</p><h3>Self-Service Analytics</h3><p>This brings me to one of my favourite parts of the project. I didn’t want users to depend on the BI team every time they had a new question.</p><p>Imagine a manager asks:</p><blockquote><em>“Can I see Recycle Rate instead of Payment Rate?”</em></blockquote><p>Or:</p><blockquote><em>“Can you show this by Nationality instead of Product?”</em></blockquote><p>In many organisations, that request becomes another ticket for the BI team. A few days later, someone builds another report. Eventually, dozens of similar reports start appearing. I wanted to avoid that cycle.</p><p>Instead, the dashboard lets users choose: the KPI, the business dimension, the collection phase, and other filters, all from the same page.</p><p>The report updates immediately. No new development. No duplicated visuals. No extra maintenance.</p><h3>Understanding Vintage Analysis</h3><p>If I had to choose one term that confused me the most when I first started learning collections analytics, it would probably be <strong>Vintage Analysis</strong>.</p><p>At first, I kept wondering:</p><blockquote><strong><em>“Why is it called vintage? Are we talking about something old?”</em></strong></blockquote><p>The answer is… <strong>not exactly.</strong></p><p>The term comes from the <strong>wine industry</strong>.</p><p>A <strong><em>vintage</em></strong> originally referred to wines produced from the <strong>same year’s grape harvest</strong>.</p><p>For example, a bottle labelled <strong>2018 Vintage</strong> means the grapes were harvested in 2018. Even if you compare it with a 2020 vintage years later, each group is evaluated based on its own starting point.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*15iZGYYE94PUYphs0KP35w.png" /><figcaption><em>The origin of the term “vintage”. In collections analytics, a vintage groups together all customer accounts that entered collections during the same period, just as a wine vintage groups bottles produced from the same year’s grape harvest.</em></figcaption></figure><p>Credit Risk uses the same idea. Instead of grouping wines by harvest year, we group customer accounts by the month they entered collections.</p><p>For example:</p><ul><li>Everyone entering collections in <strong>January</strong> belongs to one vintage.</li><li>Everyone entering in <strong>February</strong> belongs to another.</li><li>Everyone entering in <strong>March</strong> forms a third vintage.</li></ul><p>From that point onwards, we follow each group independently. Rather than mixing all customers together, we compare how each “generation” of accounts performs over time.</p><h3>What Do M0, M1, M3, M6 and M12 Mean?</h3><p>These labels simply describe how much time has passed since the customer entered collections.</p><p>For example: <strong>M0</strong> — the entry month, <strong>M1</strong> — one month later, <strong>M3</strong> — three months later ….. <strong>M12</strong> — twelve months later</p><p>The important point is that every vintage starts its own timeline. We’re not comparing January with June. We’re comparing every vintage at the same stage of its journey. That’s what makes the comparison fair.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*NMdKBa0pnjqt_OZkfIMaJA.png" /><figcaption>Users can dynamically change the KPI and the vintage horizon, allowing them to analyse how different cohorts evolve over time.</figcaption></figure><h3>Why Vintage Analysis Is So Powerful</h3><p>Let’s imagine two collection strategies.</p><p><strong>Strategy A</strong> started in January. <strong>Strategy B</strong> started in July.</p><p>If we simply compare today’s recovery amounts, Strategy B will almost certainly look worse. It hasn’t had enough time to mature.</p><p>Vintage Analysis removes that problem. Instead of asking:</p><blockquote><strong><em>“How much have we recovered today?”</em></strong></blockquote><p>we ask:</p><blockquote><strong><em>“How much had each vintage recovered after three months?”</em></strong></blockquote><p>Or after six months. Or after twelve months. Now we’re making a fair comparison. This helps answer questions like:</p><ul><li>Are newer vintages improving?</li><li>Are recent strategy changes producing better outcomes?</li><li>Are customers curing faster than before?</li><li>Is portfolio quality improving over time?</li></ul><p>For me, this is one of the most valuable tools available in collections analytics because it adds something every KPI needs: <strong>Context.</strong></p><h3>Looking for Patterns Instead of Numbers</h3><p>One thing I try to remind myself whenever I analyse a dashboard is this:</p><p>The goal isn’t to find interesting numbers. The goal is to find interesting patterns.</p><p>Anyone can notice that Payment Rate is 46%. A good analyst asks: Why?Since when? Which customers? Compared to what? Is this expected? What should we do next?</p><p>That’s where analytics creates value. The dashboard provides the numbers. The analyst provides the thinking. And that’s a skill that no visual can replace.</p><h3>What I Learned While Designing This Dashboard</h3><p>When I started building this dashboard, I thought the biggest challenge would be the technical side. Choosing the right visuals, writing DAX, optimising performance, making everything look clean.</p><p>Those things certainly matter. But after working with business users and continuously improving the report, I realised something.</p><p>Building the dashboard wasn’t the hardest part. Designing it so people actually wanted to use it was. That changed the way I think about Business Intelligence projects.</p><p>Below are some of the biggest lessons I took away from this project.</p><h3>Lesson 1 — A Dashboard Should Answer Questions, Not Display Numbers</h3><p>This became my design philosophy from the very beginning. Whenever I wanted to add a visual, I asked myself one question:</p><blockquote><strong><em>What business question does this help answer?</em></strong></blockquote><p>If I couldn’t answer that, I usually removed it. It’s surprisingly easy to fill a dashboard with charts. It’s much harder to build one where every visual has a purpose. The dashboard should guide users through the story of the portfolio. It shouldn’t make them search for it.</p><h3>Lesson 2 — Business Definitions Matter More Than Beautiful Charts</h3><p>One thing that surprised me was how differently people interpreted the same KPI.</p><p>Ask five people what “Efficiency Rate” means, and you might get five slightly different answers. That’s a problem. If everyone interprets a KPI differently, decisions become inconsistent. That’s one of the reasons I decided to include a dedicated glossary page.</p><p>Every KPI includes: A business definition, the calculation logic, an explanation of why it matters, and guidance on how to interpret it. At first, I thought of the glossary as documentation. Now I think of it as part of the product.</p><p>If users don’t understand the numbers, the dashboard has failed, no matter how good it looks.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ksCGrkWuumvsWbxEi6rVWQ.png" /><figcaption>Every KPI used throughout the dashboard is documented with its definition, business purpose and calculation logic. This helps create a shared understanding across business and analytics teams.</figcaption></figure><h3>Lesson 3 — Simplicity Is Harder Than Complexity</h3><p>One of the easiest things to do in Power BI is add another visual. Another page. Another chart. Another slicer.</p><p>The difficult part is deciding what <strong>not</strong> to include. Throughout this project, I found myself removing more visuals than I added. Every time I simplified the report, it became easier to use. That’s probably one of the biggest lessons I’ve learned in dashboard design.</p><p>A simpler dashboard isn’t necessarily a less powerful dashboard. Often, it’s exactly the opposite.</p><h3>Lesson 4 — Dynamic Reports Are Easier to Use and Easier to Maintain</h3><p>This was probably my favourite design decision. Instead of creating separate pages for every KPI and every business dimension, I focused on building reusable pages.</p><p>Users decide:</p><ul><li>which KPI they want to analyse</li><li>which dimension they want to break it down by</li><li>which collection phase to explore</li><li>and, in the Vintage pages, which time horizon they want to compare.</li></ul><p>The report adapts automatically. From a business perspective, this creates a much better user experience. From a development perspective, it also makes the dashboard easier to maintain. When a visual changes, I update it once instead of repeating the same work across multiple pages.</p><p>As the dashboard grows, that becomes a huge advantage.</p><h3>Lesson 5 — Trends Are More Valuable Than Snapshots</h3><p>One month’s performance is interesting. Twelve months of performance are useful. Whenever possible, I prefer showing how a KPI changes over time rather than displaying only the latest value.</p><p>A single number answers:</p><blockquote><strong><em>Where are we today?</em></strong></blockquote><p>A trend answers:</p><blockquote><strong><em>Where are we going?</em></strong></blockquote><p>That’s usually a much more valuable question.</p><h3>Lesson 6 — Context Changes Everything</h3><p>Earlier in the article, we talked about segmentation and Vintage Analysis. I think they both teach the same lesson. Numbers without context can easily be misunderstood. A Payment Rate of 45% doesn’t mean much on its own.</p><p>But once we compare it across: customer segments, collection phases, days past due, products or vintages, the story becomes much clearer.</p><p>Good dashboards don’t just present numbers. They provide context.</p><h3>Lesson 7 — Technical Skills Alone Aren’t Enough</h3><p>As analysts, we spend a lot of time learning technical skills. SQL, Python, Power BI, Excel, DAX.</p><p>They’re all important. But this project reminded me that technical skills are only part of the job. Understanding the business is just as important. Sometimes more.</p><p>If you don’t understand how collections works, it’s difficult to know:</p><p>Which KPIs matter? How they relate to each other? What questions stakeholders are trying to answer? Or why one visual is more useful than another?</p><p>The technology helps us build dashboards. Business understanding helps us build the right dashboards.</p><h3>Final Thoughts</h3><p>When I started this project, I thought I was building a Power BI dashboard. Looking back, I think I was actually building something different. A communication tool. The data already existed. The KPIs already existed. The challenge wasn’t calculating them. The challenge was presenting them in a way that helped people make better decisions.</p><p>That’s why I believe dashboard design is about much more than choosing charts or writing DAX. It’s about understanding the people who will use the report. The questions they’re trying to answer. The decisions they need to make. And how we can make those decisions a little easier.</p><p>If you’re just starting your journey in Credit Risk or Collections Analytics, my advice is simple:</p><p>Don’t focus only on learning the tools, learn the business. Understand why each KPI exists, ask questions, challenge assumptions, talk to the people who use your reports.</p><p>Because the best analysts aren’t the ones who build the most impressive dashboards. They’re the ones who help the business make better decisions. And that’s a skill that will always be valuable.</p><h3>About This Dashboard</h3><p>The dashboard presented throughout this article was developed as a personal portfolio project inspired by real collections reporting practices. To protect confidentiality, all screenshots have been anonymized. Company names, logos, portfolio values, trends, dates and other identifying information have been replaced with illustrative data.</p><p>The objective of this project is not to replicate a specific business environment, but to demonstrate how collections analytics can be translated into an interactive and business-focused reporting solution.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=0bafe8a4276e" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Running Our Family Finances Like a CFO (Not Just a Spreadsheet Nerd)]]></title>
            <link>https://medium.com/@masoud_saedi/running-our-family-finances-like-a-cfo-not-just-a-spreadsheet-nerd-6a7d768bbe9f?source=rss-a73de117340d------2</link>
            <guid isPermaLink="false">https://medium.com/p/6a7d768bbe9f</guid>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[personal-finance]]></category>
            <category><![CDATA[household-finances]]></category>
            <category><![CDATA[google-sheets]]></category>
            <dc:creator><![CDATA[Masoud Saedi]]></dc:creator>
            <pubDate>Wed, 31 Dec 2025 11:46:05 GMT</pubDate>
            <atom:updated>2025-12-31T11:50:50.061Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*AMtHJQumS8k40GT3" /><figcaption>Photo by <a href="https://unsplash.com/@jakubzerdzicki?utm_source=medium&amp;utm_medium=referral">Jakub Żerdzicki</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p>A while ago I wrote <a href="https://medium.com/@masoud_saedi/a-data-analysts-approach-to-personal-finance-creating-an-automated-dashboard-in-google-sheets-71148c51575e">an article</a> about building a personal-finance dashboard in Google Sheets. I explained how I export transactions from <strong>Spendee</strong> and then analyse everything.</p><p>Since then, life changed fast.</p><p>We bought a house.<br>We adopted a dog.<br>We are getting ready for our baby to arrive.</p><p>More responsibilities, more unknowns… and also more money flowing in every direction. My old dashboard was still “nice”, but I realised it was mostly <strong>for looking</strong>, not <strong>for deciding</strong>.</p><p>So I rebuilt everything. This time not as <em>a data analyst building charts</em>, but as <strong>the CFO of our household</strong>.</p><h3>Why I rebuilt my whole finance system</h3><p>When life gets more complex, guessing is not enough anymore. We suddenly had questions like:</p><ul><li>How many months can we survive if income stops?</li><li>How much does this house really cost every month?</li><li>What is fixed and what can we cut if needed?</li><li>How much does a baby / dog actually cost?</li><li>Are we slowly spending more without feeling it?</li></ul><p>My old dashboard had:</p><ul><li>All-time statistics</li><li>Monthly trends for every category</li><li>Colors, labels, pivots, etc.</li></ul><p>It looked advanced, but honestly, it was <strong>too much noise</strong>.</p><p>Now I focused only on what a CFO would care about:</p><ul><li>Risk</li><li>Flexibility</li><li>Cashflow</li><li>Structure of costs</li><li>Real cost of living our life</li></ul><p>Everything else is decoration.</p><h3>CFO-style Dashboard</h3><p>Below are screenshots of the new dashboard (numbers are not real)</p><p>Each row answers one important question.</p><h3>Row 1 — “Are we safe?” (Financial Health)</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*3lLyps-2IL0atMOcYnKkOA.png" /><figcaption>Available balance, total net worth, burn-rate, income trend, savings rate and runway in months (numbers are not real).</figcaption></figure><p>This part is very simple on purpose:</p><ul><li><strong>Available Balance</strong></li><li><strong>Total Net Worth</strong></li><li><strong>Expense burn-rate (3m vs 12m): </strong>compares our average expenses in the last 3 months to the last 12 months, and shows if we are currently speeding up or slowing down our spending.</li><li><strong>Income trend (3m vs 12m): </strong>does the same for income, so we can see if our earnings are trending higher or lower compared to our longer-term average.</li><li><strong>Runway in months</strong></li><li><strong>Savings percentage</strong></li></ul><p>The most important one for me is <strong>runway</strong>.</p><blockquote><strong><em>Runway</em></strong><em> = how many months we can survive if income becomes zero, while still paying </em><strong><em>only essential expenses</em></strong><em>.</em></blockquote><p>Seeing this number change month by month is powerful.<br>It changed some of our decisions immediately.</p><p>Burn rate also keeps us honest:</p><ul><li>last 3 months vs last 12 months</li><li>if 3 months is higher → lifestyle creeping up</li><li>if lower → we are cooling down a bit</li></ul><p>Small comparisons, big awareness.</p><h3>Row 2 — “What is really happening with our money?” (Income vs Expense &amp; Waterfall)</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*w0GUGK9FCUSFJGo9tJafvg.png" /><figcaption>Income vs expense trend, rolling average expense trend, and cash-flow waterfall showing where money actually goes.</figcaption></figure><p>Here I track:</p><ul><li><strong>Income vs expense trend</strong></li><li><strong>Rolling average expense trend: </strong>simply smooths expenses over a few months, so you see the <em>direction</em> they are moving, not just noisy monthly ups and downs.</li><li><strong>Cash-flow waterfall</strong></li></ul><p>The waterfall is my favourite chart now. It shows, for the last 12 months:</p><ul><li>Income</li><li>Essential — fixed</li><li>Essential — variable</li><li>Optional</li><li>Investments</li><li>Net cash change</li></ul><p>Yes, investments are red here. They are good for net worth, but they still reduce cash. I don’t want to trick myself emotionally.</p><p>This view answers:</p><ul><li>where the money is really going</li><li>what portion is locked, what is flexible</li><li>if we are living below our means or not</li></ul><p>Before, I had ten different charts. Now I only need these three.</p><h3>Row 3 — “What kind of life are we structurally running?” (Spending Structure)</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*arAplyd3sWrp5ibTP_fLvQ.png" /><figcaption>Essential vs optional %, fixed vs variable %, and top 5 expense categories for the last 12 months.</figcaption></figure><p>This row is about <strong>structure</strong>, not totals. I split expenses into:</p><ul><li>Essential vs Optional</li><li>Fixed vs Variable</li></ul><h3>Essential vs Optional %</h3><ul><li><strong>&lt; 50% essential</strong> → very flexible life 🟢</li><li><strong>50–70% essential</strong> → healthy range 🟡</li><li><strong>&gt; 70% essential</strong> → fragile, low adaptability 🔴</li></ul><p>This tells me <strong>how trapped or free we are</strong>.</p><h3>Fixed vs Variable %</h3><p>Here I only look at <strong>essential costs</strong>.</p><p><strong>Question: </strong><em>How much of our essential life is “locked in” contracts and obligations?</em></p><ul><li>high fixed % = risky if income stops</li><li>higher variable % = easier to adjust</li></ul><h3>Top 5 expenses</h3><p>Simple bar chart.</p><p>There are no lies and no “but this month was special”. The truth is usually obvious when you look at this chart. It’s also useful to see if restaurants and bars have crept into the top three.</p><h3>Row 4 — “Real cost of our life system”</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*GhW-1ASLAmGki_DjFVvMUQ.png" /><figcaption>Average monthly cost for our baby, our dog, and baseline monthly cost of housing and car ownership.</figcaption></figure><p>This is the most “family” part of the dashboard.</p><p>I track:</p><ul><li><strong>Our baby’s average monthly cost</strong></li><li><strong>Dog’s average monthly cost</strong></li><li><strong>Housing baseline</strong></li><li><strong>Car baseline</strong></li></ul><h3>Housing baseline (very important concept)</h3><p><strong>Housing baseline</strong> = <em>the cost of </em><strong><em>simply owning and living in our house</em></strong><em>, even if we do nothing extra.</em></p><p>I include: mortgage, property insurance, life insurance (required by bank), security subscription</p><p>I do <strong>not</strong> include: renovations, decoration, improvements, furniture, projects</p><p>This separation helped a lot.<br><strong>We now know the <em>true fixed cost</em> of our home.</strong></p><h3>Car baseline</h3><p>Same idea: loan, tax, insurance, inspection</p><p>Not included: fuel, repairs, accessories</p><h3>Baby &amp; Dog monthly averages</h3><p>Nothing scientific. Just reality: food, medical, clothes / gear, services, toys &amp; extras</p><p>Good for planning ahead and removing financial stress. It’s also useful if you’re considering bringing a second dog or baby.</p><h3>What I learned from doing this</h3><h4>1) Essential ≠ Fixed</h4><p>Groceries are essential but not fixed.<br>Netflix is optional but fixed.</p><p>Two different dimensions:</p><ul><li>essential vs optional</li><li>fixed vs variable</li></ul><h4>2) Variable gives freedom</h4><p>Two families with same income can have totally different safety:</p><ul><li>80% fixed costs → very fragile</li><li>40% fixed costs → very flexible</li></ul><h4>3) Investments are not savings</h4><p>Investments increase net worth. Savings increase cash.</p><p>You need both, and you need to see the difference clearly.</p><h4>4) You don’t need 20 charts</h4><p>I deleted most of my visualisations. Now the dashboard is not “ just beautiful”. It is <strong>useful too</strong>.</p><p>And this is exactly how a CFO works.</p><h3>If you want to build something similar</h3><p>You don’t need to copy everything.</p><p>But I recommend tracking at least:</p><ul><li>runway in months</li><li>essential vs optional %</li><li>fixed vs variable %</li><li>baseline costs (house, car)</li><li>12-month income vs expense</li><li>waterfall of where money really goes</li></ul><p>Everything else is optional decoration.</p><h3>Final note</h3><p>I am not a financial advisor. I am just someone who enjoys data and wants to run family finances consciously.</p><p>If you’re interested in the technical side (Google Sheets, formulas, Spendee export), you can also check my <a href="https://medium.com/@masoud_saedi/a-data-analysts-approach-to-personal-finance-creating-an-automated-dashboard-in-google-sheets-71148c51575e">older article</a> where I explain that part step-by-step.</p><p>Thanks for reading — I hope this helps you look at your money a bit more like a CFO too.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=6a7d768bbe9f" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Visualising Your Habits: Data-Driven Habit Tracker Inspired by Atomic Habits]]></title>
            <link>https://medium.com/@masoud_saedi/visualising-your-habits-data-driven-habit-tracker-inspired-by-atomic-habits-ff41aea9981b?source=rss-a73de117340d------2</link>
            <guid isPermaLink="false">https://medium.com/p/ff41aea9981b</guid>
            <category><![CDATA[habit-building]]></category>
            <category><![CDATA[data-analytics]]></category>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[google-sheets]]></category>
            <category><![CDATA[habits]]></category>
            <dc:creator><![CDATA[Masoud Saedi]]></dc:creator>
            <pubDate>Sun, 02 Feb 2025 00:58:29 GMT</pubDate>
            <atom:updated>2025-02-02T00:58:29.935Z</atom:updated>
            <content:encoded><![CDATA[<p>Four years ago, I read <em>Atomic Habits</em> by James Clear, and it completely changed the way I approach habits. The book’s core idea — that small, consistent changes can lead to remarkable results — resonated deeply with me. But what truly stood out was the concept of habit tracking. Clear emphasises that “<strong>what gets measured gets managed</strong>,” and I took that to heart.</p><p>Fast forward to today, and I’ve had countless conversations with friends about habits. The same question always comes up: <em>“How do you build good habits and break bad ones so easily?”</em> My answer is simple: <em>“Read Atomic Habits.”</em> But I also realized that tracking habits is where the magic happens. While the book provides a PDF habit tracker, I wanted something more dynamic, accessible, and insightful. So, I created my own <strong>habit tracker dashboard</strong> using Google Sheets — and it’s been a game-changer.</p><h3>Why a Dashboard?</h3><p>As a data analyst, I’m obsessed with turning raw data into actionable insights. A static PDF tracker was helpful, but I wanted to see my progress visually. I wanted to know which days, months, or seasons I was most consistent, and where I struggled. So, I built a dashboard that not only tracks habits but also transforms the data into beautiful, informative charts.</p><h3>The Dashboard Structure</h3><p>The dashboard consists of three main sheets:</p><p><strong>Habits</strong>:<br>This is where you define the habits you want to build and the ones you want to break.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*FUIETSLhjn-lON3bedIdcQ.png" /><figcaption>To make it more fun, you can add emojis for each habit!</figcaption></figure><p><strong>Habit Tracker</strong>:<br>Here, you’ll see a list of your defined habits. Each day, you simply mark a 1 if you’ve done the habit or leave it blank if you haven’t. It’s that simple.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*9ZjzZgKlqu3pRTLODQxKXw.png" /><figcaption>These cure 1s will transform to a nice dashboard in the next sheet!</figcaption></figure><p><strong>Dashboard</strong>:<br>This is where the magic happens. The dashboard automatically transforms your 1s into insightful visualizations. You can select any habit to see detailed metrics and charts.</p><h3>What You’ll See on the Dashboard</h3><p>The dashboard is divided into two sections: <strong>Habits to Build</strong> and <strong>Habits to Break</strong>. Here’s what you’ll find in each:</p><h4>Habits to Build</h4><ul><li><strong>Total Days Tracked</strong>: How long you’ve been tracking the habit.</li><li><strong>Consistency Rate</strong>: The percentage of days you’ve successfully done the habit.</li><li><strong>Current Streak</strong>: How many consecutive days you’ve done the habit.</li><li><strong>Longest Streak</strong>: Your personal best streak.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*xGcuPecVMGPHPEHjdOhKkg.png" /><figcaption>I noticed through the <strong>Consistency Rate by Day of Week</strong> chart that I was meditating far less on weekends compared to weekdays.</figcaption></figure><p>Then, you’ll see three charts:</p><ol><li><strong>Consistency Rate by Month</strong>: A line chart showing which months you were most consistent.</li><li><strong>Consistency Rate by Day of Week</strong>: A bar chart revealing which days of the week are your strongest (or weakest).</li><li><strong>Consistency Rate by Season</strong>: A donut chart breaking down your consistency by season.</li></ol><h4>What can you learn from these charts?</h4><p>For example, if you notice your consistency drops every winter, you can plan ahead to stay motivated during colder months. Or if weekends are your weakest days, you can adjust your routine to make habits easier to maintain.</p><p>Let me share a real-life example of how these charts helped me improve. I was tracking my <strong>morning meditation</strong> habit and noticed through the <strong>Consistency Rate by Day of Week</strong> chart that I was meditating far less on weekends compared to weekdays. After some reflection, I realized it was because I had trained my brain to associate meditation with my office routine — I’d arrive at work, sit at my desk, and meditate before starting the day. On weekends, I wasn’t going to the office, so my brain didn’t trigger the habit. Once I saw this pattern, I adjusted my routine: I started waking up earlier, meditating at home, and then heading out. The result? My weekend consistency rate improved dramatically. This is the power of visualizing your habits — it doesn’t just show you <em>what’s</em> happening, it helps you understand <em>why</em> and take actionable steps to improve.</p><h4>Habits to Break</h4><ul><li><strong>Total Occurrences</strong>: How many times you’ve done the habit you’re trying to break.</li><li><strong>Avoidance Rate</strong>: The percentage of days you’ve successfully avoided the habit.</li><li><strong>Current Clean Streak</strong>: How many consecutive days you’ve avoided the habit.</li><li><strong>Longest Clean Streak</strong>: Your personal best streak of avoidance.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*aQ8dvfKYzewziFXiOIgB5Q.png" /></figure><p>The charts here are similar but focus on avoidance:</p><ol><li><strong>Avoidance Rate by Month</strong></li><li><strong>Avoidance Rate by Day of Week</strong></li><li><strong>Avoidance Rate by Season</strong></li></ol><h4><em>What can you learn?</em></h4><p>If you see that your avoidance rate drops during stressful months, you can implement strategies to cope better. Or if certain days of the week are harder, you can plan distractions or alternatives.</p><h3>How This Dashboard Transforms Your Habits</h3><p>The beauty of this dashboard is that it turns abstract goals into tangible, measurable progress. It’s not just about tracking habits — it’s about understanding your patterns and making informed decisions. When you see your consistency rate drop in a specific month or day, you can ask yourself: <em>What was different during that time?</em> And more importantly: <em>What can I do differently next time?</em></p><h3>Final Thoughts</h3><p><em>Atomic Habits</em> taught me that habits are the compound interest of self-improvement. But it’s the combination of tracking and analyzing those habits that truly unlocks their potential. This dashboard has been my secret weapon for staying consistent, and I hope it can help you too.</p><p>If you’re ready to take your habit tracking to the next level, I’m excited to share my dashboard with you! You can <a href="https://docs.google.com/spreadsheets/d/1lq3n6wOqnZCtD2G71aFo9pClJ_PqKUcklTxRhxQtDLQ/edit?usp=sharing"><strong>access it here</strong>.</a> Simply make a copy, customise it with your habits, and start tracking. Feel free to share it with others too — because progress is better when it’s shared. Remember, it’s not about perfection; it’s about progress. And with the right tools, you can make that progress visible, rewarding, and sustainable.</p><p>If you found this article helpful, don’t forget to give it a <strong>clap</strong> and share it with others who might benefit. You can also connect with me on <a href="https://www.linkedin.com/in/masoud-saedi/"><strong>LinkedIn</strong></a> to stay updated on more data-driven tips and tools. Let’s build better habits together!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=ff41aea9981b" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[From Community Management to Data Analysis: Optimizing Coworking Spaces]]></title>
            <link>https://medium.com/@masoud_saedi/from-community-management-to-data-analysis-optimizing-coworking-spaces-5ebbd6afa3c5?source=rss-a73de117340d------2</link>
            <guid isPermaLink="false">https://medium.com/p/5ebbd6afa3c5</guid>
            <category><![CDATA[workplace-strategy]]></category>
            <category><![CDATA[community-management]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[community-engagement]]></category>
            <category><![CDATA[coworking-space]]></category>
            <dc:creator><![CDATA[Masoud Saedi]]></dc:creator>
            <pubDate>Sat, 28 Dec 2024 01:43:39 GMT</pubDate>
            <atom:updated>2024-12-28T01:50:30.561Z</atom:updated>
            <content:encoded><![CDATA[<p>Coworking spaces are more than just shared offices; they are vibrant ecosystems where professionals connect, collaborate, and thrive. As a former community manager at <a href="https://medium.com/u/2bf2e7b85d49">Impact Hub</a> <strong>Lisbon</strong> for nearly two years, I witnessed firsthand how data can be a goldmine for enhancing member experience, optimizing operations, and driving growth.</p><p>Today, as a data analyst, I’ve combined my experience with my technical skills to create a Power BI dashboard for a fictional coworking space, showcasing how actionable insights can transform decision-making. As I created this dashboard, I couldn’t help but think, <em>this is exactly what I needed back when I was managing a coworking space.</em></p><p>Let’s explore how coworking spaces can leverage their data to unlock their full potential.</p><h3>The Dashboard: Insights at a Glance</h3><p>I designed a six-sheet Power BI dashboard to provide a comprehensive overview of a coworking space’s performance. Each sheet serves a specific purpose, offering tailored insights for community managers and operational teams.</p><h4><strong>1. Members Overview</strong></h4><p>This sheet serves as the heartbeat of the dashboard, providing a snapshot of the coworking community.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*aeRpg8sdA9sjCzReqqpLoQ.png" /></figure><p>Key features include:</p><ul><li><strong>World Map of Members’ Nationalities:</strong> A visual representation of the diversity within the space.</li><li><strong>Active Members Count &amp; Membership Breakdown:</strong> Monitor the total number of active members and the percentage distribution of membership types.</li><li><strong>Demographics &amp; Professions:</strong> Get insights into the average age of members and their top professions.</li><li><strong>Monthly Awards:</strong> Celebrate member engagement with awards like:</li><li><em>Early Bird of the Month</em>: The earliest check-in.</li><li><em>Social Butterfly of the Month</em>: The highest event participation.</li><li><em>Meeting Master of the Month</em>: The most meeting room bookings.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/517/1*_KO3Cv3btivw7TaVjeY1Qg.jpeg" /><figcaption>I know this one’s a bit exaggerated, but Imagine displaying this sheet on a big screen in the coworking space, updating dynamically to foster engagement and community spirit.</figcaption></figure><h4><strong>2. Check-ins</strong></h4><p>This sheet dives into check-in patterns, providing insights such as:</p><ul><li><strong>Monthly Total Check-ins:</strong> Track how often members are using the space.</li><li><strong>Hourly Distribution:</strong> Understand peak hours for member arrivals.</li><li><strong>Seasonal Trends:</strong> Identify high and low seasons for occupancy.</li><li><strong>Day of Week Trends:</strong> Pinpoint the busiest and quietest days.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*wjVzwPocMssGhVDXZxOWyw.png" /></figure><p><strong>Actionable Insight: </strong>Use this data to optimize staffing schedules, plan cleaning routines, and launch targeted promotions during slower hours.</p><h4><strong>3. Bookings</strong></h4><p>Similar to check-ins, this sheet focuses on meeting and conference room bookings:</p><ul><li><strong>Top Resources:</strong> Identify the most frequently booked spaces.</li><li><strong>Time Distribution:</strong> Learn when bookings peak.</li><li><strong>Monthly and Day of Week Trends:</strong> Uncover patterns to optimize room availability.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*u7f7cb7he_OOgAeZJomN3A.png" /></figure><p><strong>Actionable Insight: </strong>Analyze booking patterns to adjust pricing, offer discounts during off-peak times, or allocate resources more effectively.</p><h4><strong>4. Events</strong></h4><p>Events are a cornerstone of coworking spaces, and this sheet tracks event performance:</p><ul><li><strong>Monthly and Hourly Trends:</strong> Discover when events are most popular.</li><li><strong>Event Types:</strong> Identify which events drive the most participation.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*J1WcKajsTo4HvhV6pnkLNw.png" /></figure><p><strong>Actionable Insight: </strong>Use these insights to curate events that align with member interests and maximize attendance.</p><h4><strong>5. Event Engagement</strong></h4><p>This sheet focuses on the effectiveness of events:</p><ul><li><strong>Registration and Attendance Rates:</strong> Measure the success of event promotions.</li><li><strong>Average Ratings:</strong> Track member satisfaction.</li><li><strong>Optimal Times for Events:</strong> Identify the best days and times for organizing events based on engagement metrics.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ySBHmMI0N0fkMbML1WOGtw.png" /></figure><p><strong>Actionable Insight:</strong> Tailor your event calendar to boost registration and show rates, ensuring higher member satisfaction.</p><h4><strong>6. Financial Overview</strong></h4><p>A crucial sheet for understanding the coworking space’s financial health:</p><ul><li><strong>Income vs. Expense Trends:</strong> Monitor profitability over time.</li><li><strong>Revenue by Membership Type:</strong> Identify your top revenue streams.</li><li><strong>Capacity Utilization:</strong> Track monthly occupancy and revenue loss due to unused capacity.</li><li><strong>Expense Breakdown:</strong> Analyze cost drivers to control spending.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*oJKKGUN1rf5eSKtvwK4Cug.png" /></figure><p><strong>Actionable Insight:</strong> Use financial data to make informed decisions about pricing, budgeting, and resource allocation.</p><h3>Data-Driven Decision-Making for Coworking Spaces</h3><p>Each of these dashboard sheets offers actionable insights that can revolutionize the way coworking spaces operate:</p><ul><li><strong>Enhance Member Experience:</strong> Personalize offerings based on member demographics and preferences.</li><li><strong>Optimize Resource Allocation:</strong> Use check-in and booking trends to improve space utilization.</li><li><strong>Boost Event Engagement:</strong> Tailor events to member interests and optimize scheduling.</li><li><strong>Drive Financial Performance:</strong> Leverage financial data to identify growth opportunities and manage costs effectively.</li></ul><h3>Unlocking Endless Possibilities</h3><p>What I’ve showcased here is just scratching the surface of what coworking spaces can achieve with their data. The potential is vast — spanning member engagement, operational efficiency, event optimization, and financial growth. With the right tools and strategy, the possibilities are endless.</p><p>By leveraging data, coworking spaces can not only solve immediate challenges but also uncover new opportunities to elevate their community, improve their services, and maximize their revenue streams.</p><p>If you found these ideas useful and think I could help your coworking space, let’s connect on <a href="https://www.linkedin.com/in/masoud-saedi/"><strong>LinkedIn</strong></a>! I’d love to hear your thoughts and explore how we can unlock the full potential of your data.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=5ebbd6afa3c5" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How Much Does It Cost to Own a Car in Portugal? My Two-Year Expense Analysis]]></title>
            <link>https://medium.com/@masoud_saedi/how-much-does-it-cost-to-own-a-car-in-portugal-my-two-year-expense-analysis-f3dd1e8f84d5?source=rss-a73de117340d------2</link>
            <guid isPermaLink="false">https://medium.com/p/f3dd1e8f84d5</guid>
            <category><![CDATA[personal-finance]]></category>
            <category><![CDATA[budgeting]]></category>
            <category><![CDATA[car-ownership]]></category>
            <category><![CDATA[portugal]]></category>
            <category><![CDATA[data-analysis]]></category>
            <dc:creator><![CDATA[Masoud Saedi]]></dc:creator>
            <pubDate>Sun, 17 Nov 2024 15:08:46 GMT</pubDate>
            <atom:updated>2025-12-30T19:58:08.987Z</atom:updated>
            <content:encoded><![CDATA[<p>Owning a car offers freedom, but it comes with costs that are often underestimated. For years, I’ve been tracking all my expenses — including car-related ones — to understand where my money goes and make better financial decisions. This habit has given me valuable insights into my spending patterns, which I’ve detailed in a separate article about my approach to personal finance (<a href="https://medium.com/@masoud_saedi/a-data-analysts-approach-to-personal-finance-creating-an-automated-dashboard-in-google-sheets-71148c51575e"><em>link here</em></a>).</p><p>When I bought my <strong>Toyota Yaris (2013 model)</strong>, I began documenting every aspect of car ownership costs. In this article, I’ll share my two-year analysis, breaking down fuel, maintenance, insurance, tolls and parking, and more. For anyone considering owning a car in Portugal, this data-driven guide will help you prepare for the financial realities of car ownership.</p><p>Using Google Sheets, I created a dashboard to visualize expenses over time, making it easy to explore different cost categories. At the end of the article, I’ll share a link to my Google Sheets so you can dive into the details yourself.</p><p>Whether you’re planning to buy your first car or just curious about the costs, this breakdown will provide a practical roadmap of what to expect. Let’s dive in!</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ySIiJlXByEtIx9r5mqCZNw.png" /><figcaption>A comprehensive dashboard overview (Sep 2022 — Oct 2024): Insight at a glance!</figcaption></figure><h4>Initial Costs: Getting Started</h4><p>When I bought my car, the only additional upfront cost beyond the purchase price was the <strong>registration fee</strong>, which is a flat €65 in Portugal (€55 if paid online).</p><p>Another mandatory cost is <strong>third-party liability insurance</strong>, which covers damages to other vehicles, property, or pedestrians in case of an accident but doesn’t cover your own vehicle. For full coverage (which includes your car), the price increases significantly. I opted for basic third-party insurance, paying €240 for the first year. Insurance costs typically decrease over time if you maintain a clean driving record. However, prices also depend on the car’s make and model.</p><h4>Recurring Costs: Keeping the Car Running</h4><p>Once you’re past the initial expenses, the real challenge lies in managing the recurring costs of car ownership. Here’s a breakdown of the major categories:</p><p><strong>Fuel:</strong> My Yaris is fairly fuel-efficient, averaging <strong>5.7 liters per 100 km</strong>. Even so, rising fuel prices in Portugal can make this one of the most significant recurring expenses.</p><p><strong>Maintenance and Repairs:</strong> Regular maintenance is crucial to keep your car in good shape. I choose to service my car at Toyota, which costs more than going to a regular mechanic but ensures thorough check-ups tailored to the car’s age:</p><ul><li>Every other year, I pay for a full check-up and oil change for <strong>€300</strong>.</li><li>In alternating years, I only need a standard oil change and minor service, which costs <strong>€100</strong>.</li><li>Unexpected repairs can happen too, so setting aside a budget for those is wise.</li></ul><p><strong>Tolls and Parking:</strong> Toll roads in Portugal are among the most expensive in Europe. While you can avoid them, it’s often impractical if you’re in a hurry. Comparatively, countries like Switzerland charge a flat €50 per year, while Germany and the Netherlands have toll-free highways. Urban parking fees, especially in Lisbon or Porto, can also add up quickly. I often avoid city-center parking altogether by using public transport or Uber to save money and avoid stress.</p><p><strong>Tax (IUC):</strong> In Portugal, every car owner must pay the <strong>Imposto Único de Circulação (IUC)</strong>, an annual tax based on your car’s age, engine size, and emissions. Electric cars are exempt, but for my Yaris, I pay <strong>€111 per year</strong>.</p><p><strong>Fines:</strong> While fines aren’t a planned expense, they’re worth mentioning. Parking fines or getting your car towed can be extremely costly, so it’s essential to stay mindful of parking rules and traffic laws.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*RfEeHKmB_6bmU3u8p3Cq3w.png" /><figcaption>All-Time Average Monthly Breakdown of Car Expenses (Sep 2022 — Oct 2024): A clear look at how costs are distributed across fuel, maintenance, insurance, tolls, parking, and more.</figcaption></figure><h3>Unexpected Expenses and Budgeting for the Unknown</h3><p>No matter how carefully you plan, car ownership often comes with its share of unexpected expenses. These can range from sudden repairs to emergency towing or even fines. Over the past two years, I’ve dealt with a few unplanned costs, including engine splash shield and paying fines and towing fees (Never is going to happen again!). Altogether, these expenses added up to over €400 — costs I hadn’t anticipated but had to manage quickly to keep my car functional and roadworthy.</p><p>To prepare for such surprises, having an <strong>emergency fund</strong> is priceless. A good rule of thumb is to save at least three months’ worth of your average monthly expenses costs. This ensures you’re prepared for both unexpected expenses and larger financial challenges, like losing your primary income source.</p><h4>Tips for Budgeting for the Unexpected</h4><ul><li><strong>Track Patterns:</strong> Regularly monitor your car expenses to identify trends and better anticipate unplanned costs. By recording your costs consistently, you can identify patterns and establish realistic budgets for recurring and emergency expenses. I’ve written more about creating effective budgets and tracking expenses in detail in <a href="https://medium.com/@masoud_saedi/a-data-analysts-approach-to-personal-finance-creating-an-automated-dashboard-in-google-sheets-71148c51575e">this article</a>, which you can check out for additional insights.</li><li><strong>Save Monthly:</strong> Set aside at least 15–20% of your income in an emergency savings account to cover unforeseen expenses.</li><li><strong>Prioritize Maintenance:</strong> Regular servicing and maintenance reduce the likelihood of costly breakdowns, saving you money in the long run.</li></ul><p>Below is a chart comparing <strong>monthly expenses versus the monthly budget</strong> for recurring costs, as well as <strong>accumulated expenses versus the yearly budget</strong> for the current fiscal year.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*9Ck1CN-blKwVHobd9BsDoQ.png" /><figcaption>Comparing July 2024 expenses with monthly and yearly budgets: A detailed look at how this month’s spending aligns with the overall plan for the year.</figcaption></figure><p>Being prepared for the unknown ensures that unexpected expenses won’t disturb your financial stability. This way, you can continue enjoying the freedom and convenience of owning a car without the stress of unplanned costs.</p><h3><strong>Insights from Analysing My Car Expenses Data</strong></h3><p>Tracking and analysing over two years of car expenses has provided interesting insights into how costs evolve and where my money goes. By using my dashboard, I’ve been able to break down every aspect of car ownership — from regular expenses to occasional surprises. These insights not only help me stay on top of my budget but also reveal trends and patterns that make managing car costs easier.</p><h4><strong>Key Trends and Visualisations</strong></h4><p>One of the most interesting (and perhaps obvious) findings is the cost-per-kilometer trend, which decreases over time. As you drive more, the cost per kilometre naturally goes down, which makes sense — the more you drive, the more you spread out the fixed ownership costs. This is a great reminder that <strong>the more you use your car, the less it costs per trip, making long-term ownership more economical</strong>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Z2NVhfo5c4RHtPjy3gGQ1Q.png" /><figcaption>This scatter plot shows how driving more reduces the cost per kilometre.</figcaption></figure><p>Another chart I created shows the distance driven per month. For example, August 2024 saw the highest distance driven due to a road trip from Lisbon to Amsterdam (I’ll dive into the full cost analysis of that trip in <a href="https://medium.com/@masoud_saedi/from-lisbon-to-amsterdam-a-road-trip-with-data-costs-and-insights-7e9ce80d0e08">this article here</a>). Tracking this helps me understand the relationship between distance and expenses, and could be useful if you’re considering how to manage long trips.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*nUBZUq7vZWjOIgfJgy63-Q.png" /><figcaption>Monthly distance driven, with a notable spike in August 2024 due to our Lisbon-Amsterdam road trip.</figcaption></figure><p>Additionally, I analyzed recurring expenses by season, day of the week, and over the last 12 months. For example, as expected, fuel consumption is highest in the summer months, accounting for 42% of the total fuel costs. In contrast, winter fuel costs are significantly lower, at just 14%. Similarly, for tolls and parking, summer accounts for nearly 60% of the total toll and parking expenses, while winter sees the lowest costs, at just 10%.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*cH7PbkeMGj5ZWa6qLRB-Sg.png" /><figcaption>Breakdown of recurring expenses by season, day of the week, and the last 12 months, showing seasonal spikes in fuel and toll costs.</figcaption></figure><h4><strong>Suggestions for Managing Variability</strong></h4><p>Understanding these seasonal and periodic trends allows you to plan and budget more effectively. For example, knowing that fuel costs spike in the summer, you can prepare by allocating more funds during these high-use months. Similarly, for tolls and parking, it’s helpful to anticipate higher costs in peak months and adjust your budget accordingly.</p><p>By monitoring these fluctuations, you can better anticipate your expenses, allowing for smarter budgeting and financial planning. This proactive approach ensures that you can manage your car expenses without the stress of unexpected costs.</p><h3>Comparing Car Ownership to Alternatives</h3><p>Owning a car is convenient, but it’s not always the most cost-effective choice. Based on my data, total car ownership costs average <strong>€230 per month</strong>, while a Lisbon public transport pass costs just €40. Car-sharing or rentals can also be economical for occasional trips, avoiding the fixed costs of insurance and taxes.</p><p>When my car usage was low, I found public transportation or car-sharing more cost-efficient. However, for long trips or maximum flexibility, owning a car provides unmatched freedom — especially where public transit options are limited. Ultimately, the best choice depends on your driving habits and lifestyle.</p><h3>Conclusion: Is Car Ownership Worth It?</h3><p>Car ownership in Portugal is undeniably a significant financial commitment, but whether it’s worth it depends on your lifestyle and priorities. For us, owning a car has been invaluable. Almost every weekend, we venture out of Lisbon to explore nature, rural areas, and the charming small towns of Portugal — something that would be far more expensive or impractical without a car. So yes, for us, it’s definitely worth it.</p><p>Tracking my car expenses over the past two years has been an eye-opener. It’s helped me understand where my money goes and make smarter decisions, like planning for seasonal expenses and preparing for unexpected costs. A dashboard has been an essential tool in this process, offering clear insights that manual tracking simply can’t match.</p><p>If you’re curious about the financial aspects of car ownership, <a href="https://docs.google.com/spreadsheets/d/1wyA0NzcHG_kzT0tzOqyukjfT1noHabk4Zvu4iXGxhwM/edit?usp=sharing"><strong>you can explore my full dashboard here</strong></a>. It’s interactive, letting you adjust dates and dive into trends to see how they might align with your own situation. This tool can help you better understand the true costs of owning a car and make informed decisions.</p><p>Ultimately, the value of car ownership depends on what you prioritize — whether it’s the convenience and flexibility of having your own vehicle or the cost savings of alternatives. With the right tools and thoughtful planning, you can enjoy the freedom of owning a car without financial stress.</p><p>If you found this article helpful, please share it with anyone considering buying a car in Portugal. Don’t forget to give it a clap and follow me for more insights!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=f3dd1e8f84d5" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[From Lisbon to Amsterdam: A Road Trip with Data, Costs, and Insights]]></title>
            <link>https://medium.com/@masoud_saedi/from-lisbon-to-amsterdam-a-road-trip-with-data-costs-and-insights-7e9ce80d0e08?source=rss-a73de117340d------2</link>
            <guid isPermaLink="false">https://medium.com/p/7e9ce80d0e08</guid>
            <category><![CDATA[data-analytics]]></category>
            <category><![CDATA[roadtrip]]></category>
            <category><![CDATA[camping]]></category>
            <category><![CDATA[travel-europe]]></category>
            <category><![CDATA[google-sheets]]></category>
            <dc:creator><![CDATA[Masoud Saedi]]></dc:creator>
            <pubDate>Thu, 12 Sep 2024 08:01:36 GMT</pubDate>
            <atom:updated>2025-12-30T19:59:30.510Z</atom:updated>
            <content:encoded><![CDATA[<h3>From Lisbon to Amsterdam: A Road Trip with Camping, Data, and Insights</h3><h3>Introduction</h3><p>While planning our summer vacation, I had the idea of driving from Lisbon to Amsterdam to visit friends and camp along the way. Mina, my wife, was traveling for work at the time, and when I shared the plan with her, she was excited about the adventure. We envisioned exploring more cities, enjoying the freedom to travel on our own schedule, and potentially saving some money.</p><p>I used Google Sheets to estimate costs, plan routes, and find camping spots. A month later, we set off on our three-week road trip!</p><p>In this article, I’ll share our experience — detailing our road trip and camping adventures, along with the costs involved. I’ll also provide insights into the data we collected during the trip. If you’re considering a road trip and camping in Europe, this guide will help you make informed decisions with less stress.</p><h3>Planning and Preparation</h3><h4>Route Selection:</h4><p>I started by examining the direct route from Lisbon to Amsterdam and zoomed in to identify potential cities where we could stop and camp. Our journey would take us through <strong>Spain</strong>, <strong>France</strong>, and <strong>Belgium</strong> before reaching the <strong>Netherlands</strong>. I wanted us to visit several cities but also to experience them at a relaxed pace, so I aimed to limit our driving to no more than five hours a day. Although the shortest route would have taken us through Paris — a city we’ve already visited — I decided to extend our trip slightly to explore the Normandy region of France.</p><p>Our planned stops were:</p><ul><li><strong>Spain:</strong> Salamanca, San Sebastián (Basque Country)<br><strong>France:</strong> Bordeaux, Mont Saint-Michel<br><strong>Belgium:</strong> Ghent</li></ul><p>On the return trip to Lisbon, we planned to camp in:</p><ul><li><strong>Luxembourg:</strong> Luxembourg City<br><strong>France:</strong> Cheverny<br><strong>Spain:</strong> Bilbao (Basque Country), Valladolid</li></ul><h4>Finding Campsites</h4><p>To find potential campsites, I used the <a href="https://campy.app/"><strong>Campy app</strong></a> and occasionally checked <strong>Google Maps</strong> to ensure we didn’t miss any good options. I also consulted friends with camping experience. In the end, we decided not to book campsites in advance. Since we only needed a spot for our tent and car, we felt that finding a place on the go would be manageable. We preferred to remain flexible and adjust our plans based on how much we enjoyed each location. More on this later, especially regarding the first challenge we encountered.</p><h4><strong>Packing Checklist</strong></h4><p>We opted not to invest heavily in camping gear before knowing how much we’d enjoy it. Instead, we borrowed a large party tent from a friend and purchased a good sleeping bag to keep warm up north. You can view our full camping checklist <a href="https://docs.google.com/spreadsheets/d/16GFhkV22o9rZkgtp4ZBuKzZanVLtp5iEW3IJZoTXLsI/edit?gid=0#gid=0"><strong>here</strong></a>.</p><h4>Vehicle Preparation</h4><p>Preparing our car was crucial. We have a reliable <strong>2013 Toyota Yaris</strong>, which still had five months and over 7,000 km before its next oil change. For peace of mind, I arranged a complete check-up with Toyota, which was complimentary.</p><p>Since our car didn’t have a good navigation system, we decided to invest in an aftermarket car screen with Apple CarPlay, which proved to be incredibly useful during our trip. Thanks to <strong>AliExpress</strong>, we got it for less than 100 euros. Additionally, we relied on <strong>Waze</strong> as our main navigation app, which is excellent for real-time driving guidance.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Zm084H5Rpu_AjrMinymwiw.jpeg" /><figcaption>God bless AliExpress, and our friends Pedro and Joaquim who helped me to install the new screen.</figcaption></figure><h3>Road Trip Breakdown</h3><p>Our journey began at noon on <strong>August 14th, 2024</strong>, from <strong>Lisbon</strong>. The car trunk and back seats were packed with more gear than we anticipated, but it was manageable. With high spirits and an open mind, we set off on our adventure. We aimed to drive no more than two hours at a time, taking breaks every two hours to avoid fatigue and prevent back pain. Given the long distance ahead, this approach helped keep us comfortable throughout the trip.</p><p>As we traveled, one of us was always in charge of collecting and recording data for later analysis and visualization. Here’s an overview of our trip:</p><ul><li><strong>Total Distance Driven:</strong> 5391 km</li><li><strong>Total Driving Time:</strong> 64 hours</li><li><strong>Average Speed:</strong> 84 km/hr</li><li><strong>Daily Driving Routine: <br></strong>Average Driving Duration: 5 hrs/day<br>Average Distance Covered: 415 km/day</li><li><strong>Total Cost:</strong> € 2,188</li></ul><p>You can get a quick look at the data we gathered to summarise our trip and visualise the journey.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*IiGgo98nIAqq-cqrdImozA.png" /><figcaption>Highlighting our road trip stats: Mina averaged a speedy 95 km/hr, while I cruised at 81 km/hr.</figcaption></figure><h4><strong>Transportation Costs</strong></h4><p>Transportation accounted for 47% of our total expenses. We spent <strong>€594</strong> on fuel (with an average price of <strong>€1.66 per litre</strong>), <strong>€256</strong> on road tolls (averaging <strong>€0.05 per kilometre</strong>), and the rest on parking and public transportation, mostly in the Netherlands. While tolls in Belgium, the Netherlands, and Luxembourg were free, France’s tolls were significantly higher, at <strong>€0.08 per kilometre</strong>. However, the French roads were excellent, with plenty of rest areas offering essential services like gas stations, toilets, supermarkets, and restaurants. Still, the tolls felt steep!</p><h4><strong>On the Road Observations</strong></h4><p>France had the highest speed limit of 130 km/h, while the Netherlands had the lowest at 100 km/h during the day, with a unique environmental policy. After 7 pm, the speed limit was increased to 120 km/h to reduce pollution during peak hours.</p><h3><strong>Camping Experience</strong></h3><p>This was our first time camping, and we loved it from the moment we set up our tent in Salamanca. Our biggest concern was how clean the campsites would be, especially the toilets and showers, as we initially associated camping with being a bit untidy. However, it was quite the opposite. Almost every campsite we stayed at had spotless facilities, and many even had swimming pools. Beyond that, we fell in love with the camping lifestyle — the tranquility of being in nature while still being near other people is something you don’t get when renting an Airbnb or staying at a hotel.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*obXIxh0WR75w3cO8y9BkJA.jpeg" /><figcaption>Yelloh! Village Camping Bordeaux Lac in Bordeaux, France.</figcaption></figure><h4><strong>Booking Challenges</strong></h4><p>One of the biggest challenges we faced while camping was the booking process. For most campsites, the only way to reserve a spot was by making a phone call or sending an email, which felt a bit outdated. The only seamless booking experience we had was with <a href="https://www.google.com/maps/place/Urban+Gardens+Gent/@44.4767539,-11.9082818,5z/data=!4m9!3m8!1s0x47c3713397be7bff:0x57b7b7ff7825ed2f!5m2!4m1!1i2!8m2!3d51.0462041!4d3.6807441!16s%2Fg%2F11kydbft0x?entry=tts&amp;g_ep=EgoyMDI0MDkwOS4wKgBIAVAD"><strong>Urban Gardens Gent</strong></a> in Ghent, where everything was handled online — no human interaction was required. We received all the onboarding information digitally, including the entrance code for the campsite.</p><p>As I mentioned earlier, we didn’t book anything in advance, and this led to some issues. In San Sebastián, for example, we found all the campsites fully booked and had to drive further to the next city to find an available site. My recommendation in the summer would be to contact campsites ahead of time and make a reservation, even if they don’t require upfront payment. Most campsites are flexible, and if your plans change, you can easily inform them.</p><h4><strong>Camping Costs</strong></h4><p>We spent <strong>€290</strong> for 9 nights of camping, averaging <strong>€33 per night</strong>. The most expensive site was <a href="https://www.google.com/maps/place/Camping+Igara+de+San+Sebasti%C3%A1n/@43.2966238,-6.9149234,7z/data=!4m9!3m8!1s0xd51b09203d273ef:0x8df0f0dba68e96c4!5m2!4m1!1i2!8m2!3d43.2966238!4d-2.0369937!16s%2Fg%2F1yfh_kdvz?entry=tts&amp;g_ep=EgoyMDI0MDkwOS4wKgBIAVAD"><strong>Camping Igara de San Sebastián</strong></a> at €60, while <a href="https://www.google.com/maps/place/Camping+Don+Quijote/@40.97509,-10.5498657,7z/data=!4m9!3m8!1s0xd3f258521bc6eab:0x6b1cc8d4eaad59a6!5m2!4m1!1i2!8m2!3d40.97509!4d-5.6038421!16s%2Fg%2F11g7z08jpx?entry=tts&amp;g_ep=EgoyMDI0MDkwOS4wKgBIAVAD"><strong>Camping Don Quijote</strong></a> in Salamanca was the least expensive at €20. Ironically, the one in Salamanca was far nicer. But given how touristic and pricey San Sebastián is, it made sense.</p><h4><strong>Memorable Experience</strong></h4><p>Our most memorable camping experience was at <a href="https://www.google.com/maps/place/Ferme+exp%C3%A9rimentale+du+CAVIAR/@48.5032851,-6.145407,7z/data=!4m9!3m8!1s0x48094fe2bf9cfdd3:0x2604c9d8d4e28fe1!5m2!4m1!1i2!8m2!3d48.5032851!4d-1.2674773!16s%2Fg%2F11spkflspq?entry=tts&amp;g_ep=EgoyMDI0MDkwOS4wKgBIAVAD"><strong>Ferme expérimentale du CAVIAR</strong></a>, a farm in <strong>Normandy</strong>. It was incredibly peaceful, and we enjoyed a breakfast made with fresh farm products. The highlight was milking the goats — an unexpected yet delightful experience.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*I3VxN-nShYkf2nLRRyWViQ.png" /><figcaption>Milking Whitey at Ferme expérimentale du CAVIAR in Normandy — an unforgettable experience on our first camping trip.</figcaption></figure><p>Another unforgettable night was at a gorgeous <a href="https://www.google.com/maps/place/La+Ferme+du+Bois+Rouland/@48.5660933,-2.9530108,8z/data=!4m6!3m5!1s0x4809538b875b0d81:0xf8b87b67bfc4a337!8m2!3d48.5660834!4d-1.3438644!16s%2Fg%2F11k4x8gfn1?entry=tts&amp;g_ep=EgoyMDI0MDkwOS4wKgBIAVAD"><strong>farm</strong></a> run by an inspiring young French woman. She baked her own bread and hosted a pizza night with live music, where we dined with the village locals. That evening, we met Beatriz, who later invited us to her home. Experiences like this remind us why it’s important to step outside your comfort zone — you never know who you’ll meet or the lifelong connections you’ll make.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*qELiZ8khg6ocQOut7DQMNA.jpeg" /><figcaption>Sharing pizza, music, and great company at La Ferme du Bois Rouland in Saint James, Normandy— an unexpected highlight of our road trip.</figcaption></figure><h3>Key Takeaways</h3><p><strong>Camping is Cleaner than Expected:</strong> Contrary to our initial worries, most campsites had excellent, clean facilities, and the added benefit of being surrounded by nature made the experience even more enjoyable than staying in a hotel or Airbnb.</p><p><strong>Transportation Costs vs. Flying:</strong> While our transportation costs were higher than a direct flight from Lisbon to Amsterdam, the trip gave us the freedom to explore more cities and enjoy experiences that flying would never have allowed. If we had taken separate flights from Lisbon to each stop we made, the overall cost would have been much higher. Plus, we saved 22% in carbon footprint compared to flying directly to Amsterdam — and even more if we consider the environmental impact of multiple flights to the cities we visited.</p><p><strong>The Value of Slower Travel:</strong> We made a conscious decision to drive no more than five hours per day, allowing us to explore more deeply without feeling rushed. Slower travel let us appreciate each destination, making the trip more fulfilling.</p><p><strong>Memorable Encounters:</strong> By stepping out of our comfort zone and embracing new experiences — whether it was milking goats, enjoying pizza with locals, or making new friends — we enriched our journey in ways we hadn’t anticipated.</p><p><strong>The Power of Data:</strong> By tracking costs, distances, and driving times in detail, we were able to better understand the logistics of the trip, and it will serve as a valuable resource for future travels — and hopefully, inspire others planning a similar adventure.</p><h3>Conclusion</h3><p>Our road trip from Lisbon to Amsterdam was more than just a vacation; it was an opportunity to experience Europe in a way that flying from city to city would never have allowed. Camping gave us a chance to slow down, immerse ourselves in nature, and meet people we wouldn’t have otherwise. Though our transportation costs exceeded that of a direct flight, the freedom to explore at our own pace, the richness of the experiences we had along the way, and the variety of destinations made it all worth it.</p><p>One of the most remarkable parts of our journey was the ease of crossing borders without any checks, a privilege we truly appreciated. On our way back, we stopped in Luxembourg to visit the Schengen Museum in the town of Schengen, where we learned a lot about the history of the European Union and the significance of open borders — an experience that gave us even more perspective on the freedom we enjoyed throughout our trip.</p><p>By planning carefully and tracking our expenses, we were able to stay on budget and make informed decisions throughout the journey. The data we collected allowed us to break down the costs, benefits, and even environmental impact of the trip. Compared to flying directly, we saved on carbon emissions, and considering all the places we visited, it’s clear that driving was the more economical and sustainable choice.</p><p>For anyone considering a similar adventure, I hope our experiences and insights will inspire you to hit the road, embrace the unexpected, and make lasting memories.</p><p>If you found this article helpful, feel free to give it a clap (or more!) and follow for more stories like this. Your support is much appreciated!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=7e9ce80d0e08" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[The Power of Starting: How Starting Transforms Your Learning Journey]]></title>
            <link>https://medium.com/@masoud_saedi/the-power-of-starting-how-starting-transforms-your-learning-journey-039225daa84d?source=rss-a73de117340d------2</link>
            <guid isPermaLink="false">https://medium.com/p/039225daa84d</guid>
            <category><![CDATA[career-development]]></category>
            <category><![CDATA[growth-mindset]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[professional-growth]]></category>
            <category><![CDATA[personal-development]]></category>
            <dc:creator><![CDATA[Masoud Saedi]]></dc:creator>
            <pubDate>Mon, 05 Aug 2024 15:50:50 GMT</pubDate>
            <atom:updated>2024-08-05T15:50:50.128Z</atom:updated>
            <content:encoded><![CDATA[<h3>Introduction</h3><p>Starting something new can be terrifying, especially when unsure where to begin. However, the best way to learn is often by diving in headfirst. In this article, I’ll share my journey as a junior data analyst at a company, where I was tasked with creating a report from scratch under a tight deadline. Through persistence, continuous learning, and leveraging Excel’s powerful features, I transformed my skills and delivered increasingly refined reports. This experience taught me that the only way to truly learn is to start doing.</p><h3>The Initial Challenge</h3><p>On one of my first days at <strong>WindSun</strong> (the company name, numbers, and industry have been changed for confidentiality), I was given a task that seemed overwhelming: create a comprehensive report using Excel, with only a few days to deliver the first draft. With limited experience, I felt the pressure but decided to tackle the challenge head-on.</p><h3>The First Report</h3><p>I spent hours researching basic Excel functions and experimenting with different layouts. My initial report was simple and not fancy but functional. To my surprise, it was well-received by my colleagues. Here’s a screenshot of that first report:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*qTiNb1mwlcMrgsPzb7u71g.png" /><figcaption>First Draft: The initial report created with basic Excel skills and limited experience.</figcaption></figure><h3>Continuous Improvement</h3><p>Encouraged by the positive feedback, I didn’t stop there. I began exploring more advanced Excel features, such as pivot tables, conditional formatting, and data visualization tools. Within three days, I had a significantly improved version of the report.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*aJf7dDGsLHBBpO54k2PYyg.png" /><figcaption>Second Version: Improved report incorporating advanced Excel features and stakeholders feedback.</figcaption></figure><h3>Mastering Excel</h3><p>Over the next months, I continued to refine the report. I incorporated user feedback, streamlined processes, and added interactive elements. The final version was not just a report but a dynamic tool that provided valuable insights at a glance.<br>As time passed, I deepened my understanding of the industry, reviewed other company reports to identify key KPIs that would be helpful to stakeholders, and obsessively watched YouTube tutorials to learn new data visualization techniques for better clarity. I also regularly sought feedback from my manager and teammates to ensure the report met their needs and expectations.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*qkWu7XO7yu-GpjYIPMG-QQ.png" /><figcaption>Final Version: A comprehensive, data-rich report showcasing advanced Excel skills and significant improvements over previous versions.</figcaption></figure><p>As time went on and more data became available, it was essential to visualize this information effectively. I used charts to illustrate the product’s monthly evolution and highlight differences between each period.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*tLSHAk5-4Cy7y978V0v92A.png" /><figcaption>Final Version: Detailed view of enhanced data visualization and analytical features.</figcaption></figure><p>Selecting the right chart and incorporating the most relevant elements is crucial to avoid misleading stakeholders. I focused on highlighting the key KPIs in a clear and accessible manner, ensuring that they could quickly identify and interpret the most important information.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*H6UEH9avzuL8LRBymoy9iQ.png" /><figcaption>Demonstrating the culmination of iterative enhancements and user feedback integration.</figcaption></figure><p>In the final enhancement, I added a map to the report. This geographic data allowed different teams, including Sales and Marketing, to pinpoint areas for improvement and tailor their strategies accordingly.</p><h3>Key Takeaways</h3><ol><li><strong>Start with What You Know</strong>: Even if your first attempt is basic, starting with what you know is crucial. It gives you a foundation to build on.</li><li><strong>Embrace Continuous Learning</strong>: Each new feature or function you learn can significantly enhance your work. Use resources like online tutorials, forums, and Excel’s help guides.</li><li><strong>Iterate Quickly</strong>: Don’t wait for perfection. Deliver what you have, gather feedback, and improve iteratively. This approach not only meets deadlines but also shows your commitment to excellence.</li><li><strong>Leverage Feedback</strong>: Constructive feedback is invaluable. It helps you see your work from different perspectives and identify areas for improvement.</li><li><strong>Showcase Your Work</strong>: Document your progress and improvements. Not only does this demonstrate your skills, but it also provides a tangible way to measure your growth.</li></ol><h3>Conclusion</h3><p>The experience of creating that initial report and improving it over time was invaluable. It highlighted the importance of starting with what you know, continuously learning, and iterating quickly. By diving in and tackling challenges head-on, you can accelerate your learning and achieve expertise faster than you might expect. So, if you’re hesitating to start something new, remember: <strong>the only way to learn is to start doing</strong>.</p><p>If you found this article inspiring, please <strong>clap</strong> and <strong>follow me</strong> for more stories and tips on personal and professional growth. Your support motivates me to keep sharing valuable insights!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=039225daa84d" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[My Birthday Data Party: How I Celebrated Turning 37 (and Nerded Out) with Friends]]></title>
            <link>https://medium.com/@masoud_saedi/my-birthday-data-party-how-i-celebrated-turning-37-and-nerded-out-with-friends-3504d37dc5f4?source=rss-a73de117340d------2</link>
            <guid isPermaLink="false">https://medium.com/p/3504d37dc5f4</guid>
            <category><![CDATA[birthday-party]]></category>
            <category><![CDATA[data-driven]]></category>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[excel]]></category>
            <category><![CDATA[google-sheets]]></category>
            <dc:creator><![CDATA[Masoud Saedi]]></dc:creator>
            <pubDate>Tue, 23 Jul 2024 17:40:15 GMT</pubDate>
            <atom:updated>2024-07-23T17:40:15.275Z</atom:updated>
            <content:encoded><![CDATA[<p>I recently hosted a birthday party, which was a big deal for me as it was the first time I took charge of planning and organizing it. Historically, I was always uncomfortable on my birthdays, however, this year felt different — perhaps a result of over three years of therapy, helping me embrace and love myself.</p><p>For the first time, I felt excited about celebrating my birthday. I began by inviting friends and tracking RSVPs using a Google Sheet. Out of curiosity, I added a few more columns to gather information about my friends, who I consider my chosen family. Having immigrated to Portugal with my wife over four years ago, this journey has been incredibly rewarding. I decided to add details like nationality, age, and gender.</p><p>My inner data analyst couldn’t resist the urge to do something more interesting. So, I brainstormed additional data points to collect, envisioning a dashboard presentation for my guests. Here’s the final list of data points I tracked:</p><ul><li>Name</li><li>1st RSVP (including “Maybe”)</li><li>Final RSVP</li><li>Gender</li><li>Birth Date</li><li>Marital Status</li><li>Nationality</li><li>Travel Distance to The Party Location</li><li>Friendship Age</li><li>Response Time to The Invitation</li><li>Arrival Time and Delay</li></ul><p>Using this data, I created a dashboard and decided to add some fun by giving out awards for the minimum and maximum values in each category:</p><ul><li><strong>Arrival Time</strong>: Early Bird and Night Owl</li><li><strong>Travel Distance to the party location</strong>: Local Legend and Miles Master</li><li><strong>Age</strong>: Baby Face and Golden Oldie</li><li><strong>Friendship Age</strong>: Newbie Pal and Old Pal</li><li><strong>RSVP Time</strong>: Turbo Reply and Tardy Turtle</li></ul><p>Here are some interesting insights from the data:</p><ul><li><strong>Gender Distribution</strong>: Of the invitees, 21 were male, and 19 were female. 65% of men and 35% of women attended the party.</li><li><strong>Marital Status</strong>: 23 were married and 17 were single. 52% of the married invitees and 65% of single invitees attended.</li><li><strong>Age Range</strong>: 39% of guests were between 32 and 38 years old.</li><li><strong>Nationalities</strong>: Among the 23 guests, there were 13 different nationalities, with an average age of 41 years old.</li><li><strong>Travel Distance</strong>: On average, guests traveled 6 km to the party location.</li><li><strong>Friendship Age</strong>: The average length of friendship between me and each guest was 2 years and 7 months.</li><li><strong>Response Time</strong>: It took guests an average of 10 hours and 48 minutes to reply to my invitation.</li><li><strong>Arrival Delay</strong>: The average delay in arrival time was 1 hour and 40 minutes.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*3Q-DLro6snxfpQviewqOqQ.png" /><figcaption>To overcome the limitations of the geographic chart in Google Sheets, I did the final design in Excel, which allowed for a more polished and detailed presentation.</figcaption></figure><p>During the party, I gathered everyone in front of the TV to present the dashboard. The guests were both fascinated and amused by my data-driven approach. As I introduced the winners of each category, I handed out symbolic gifts. For example, the <strong>Golden Oldie</strong> received a golden colour crown, and the <strong>Tardy Turtle</strong> got a Merry Christmas coffee mug to humorously acknowledge his delayed response.</p><p>After the awards, I gave a heartfelt speech:</p><p>“I want to thank my beautiful wife, Mina, who has been my partner and best friend for the past 18 years. Thank you for your love and for creating a safe environment that lets me embrace my authentic self.</p><p>To my dear friends, I’ve always been fascinated by the diversity of friendships I’ve formed here in Portugal, thanks to Impact Hub Lisbon, Carris, and COVID-19.</p><p>Before we arrived in Portugal four years ago, the countries represented here today were just names, flags, and capital cities to me. Now, I’m surrounded by friends from all over the world. You have made my world so big that it feels small. Through your stories, food, and drinks, I’ve travelled to your homes and experienced your cultures.</p><p>I am incredibly happy to say that I have more Portuguese friends around me today than Iranian friends, from the country I come from. Your friendship and warmth have helped me build something very special here — something I can proudly call home.</p><p>Thank you all for being here and for being such an important part of my life. Let’s raise our glasses to friendship, peace, diversity, and the many more memories we’ll create together. Cheers!”</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*PMe5tD3bITddTXJcOdc1zw.jpeg" /></figure><p>Data is often seen as dry and impersonal, but that night, it became a tool for connection and celebration. It was a reminder that numbers can tell stories, and that even the most mundane data points can reveal something meaningful about ourselves and the relationships we cherish.</p><p><strong>Have you ever used data to create a unique experience? I’d love to hear your stories in the comments! If you enjoyed this article, please follow me and consider giving it a clap to show your support.</strong></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=3504d37dc5f4" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>