<?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 Marc Heymann on Medium]]></title>
        <description><![CDATA[Stories by Marc Heymann on Medium]]></description>
        <link>https://medium.com/@marcheyp?source=rss-695a35bebbfb------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/0*Rl04zgsOd6JWdpJB.jpg</url>
            <title>Stories by Marc Heymann on Medium</title>
            <link>https://medium.com/@marcheyp?source=rss-695a35bebbfb------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sat, 21 Nov 2026 11:11:23 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@marcheyp/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Unlocking Success: Understanding Customer Lifetime Value (CLV) in Subscription-Based Online…]]></title>
            <link>https://medium.com/@marcheyp/unlocking-success-understanding-customer-lifetime-value-clv-in-subscription-based-online-3aa3ae84a95d?source=rss-695a35bebbfb------2</link>
            <guid isPermaLink="false">https://medium.com/p/3aa3ae84a95d</guid>
            <category><![CDATA[analysis]]></category>
            <category><![CDATA[ltv]]></category>
            <category><![CDATA[lifetime-value]]></category>
            <category><![CDATA[data]]></category>
            <category><![CDATA[kpi]]></category>
            <dc:creator><![CDATA[Marc Heymann]]></dc:creator>
            <pubDate>Fri, 21 Jul 2023 07:11:37 GMT</pubDate>
            <atom:updated>2023-07-21T07:11:37.604Z</atom:updated>
            <content:encoded><![CDATA[<h3>Unlocking Success: Understanding Customer Lifetime Value (CLV) in Subscription-Based Online Businesses</h3><h4>They key to understanding a crucial part of your revenue projections</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*AA70D1nmzlNSUzwmtQMpkA.png" /><figcaption>DALL-E 2 generated image.</figcaption></figure><p>In today’s fast-paced digital world, subscription-based online businesses have gained immense popularity across various industries. From streaming services to meal-kit deliveries and software subscriptions, these models offer convenience and flexibility to customers, while generating stable and predictable revenue streams for businesses. One key metric that plays a crucial role in the sustainable growth of subscription-based online businesses is Customer Lifetime Value (CLV). In this blog post, we will explore the definition, importance, calculation methods, and practical use cases of CLV to help businesses harness its power to drive long-term success.</p><h3>Understanding Customer Lifetime Value (CLV)</h3><p>Customer Lifetime Value (CLV), also known as Lifetime Customer Value (LCV), is a fundamental metric that quantifies the total worth of a customer to a business over their entire relationship. In the context of a subscription-based online business, CLV refers to the total revenue a customer is expected to generate throughout their subscription tenure.</p><p>CLV is a critical metric for subscription-based businesses for several reasons:</p><ul><li>Revenue Forecasting and Planning: CLV helps businesses forecast future revenue and make data-driven decisions for resource allocation, marketing budgets, and customer acquisition efforts.</li><li>Customer Segmentation: By categorizing customers based on their CLV, businesses can identify their most valuable customers and tailor personalized retention strategies to enhance loyalty and increase CLV further.</li><li>Customer Acquisition Cost (CAC) Efficiency: CLV provides insights into the cost-effectiveness of customer acquisition efforts. If the CAC exceeds the CLV, the business may struggle to maintain profitability.</li><li>Churn Prediction and Prevention: High CLV customers are less likely to churn, making it easier for businesses to identify at-risk customers and implement targeted retention tactics.</li></ul><h3>Factors Affecting CLV</h3><p>Several factors influence a customer’s lifetime value in a subscription-based online business:</p><ul><li>Subscription Duration: Longer subscription durations generally lead to higher CLV as customers continue generating revenue for a more extended period.</li><li>Average Revenue per User (ARPU): Higher ARPU signifies that customers are spending more on average, increasing their overall lifetime value.</li><li>Customer Retention Rate: Higher customer retention rates positively impact CLV, as customers remain subscribed for longer periods.</li><li>Customer Referral and Advocacy: Customers who refer others or actively advocate for the business tend to have a higher CLV due to their contribution to customer acquisition.</li></ul><h3>Calculating CLV</h3><p>Calculating CLV can be approached through various methods, depending on the available data and business model. Here are three commonly used techniques:</p><p><strong>Historic CLV</strong> is calculated by summing up all the revenue generated by a customer over the entire subscription period, excluding acquisition and retention costs. The formula for Historic CLV is:</p><p>Historic CLV = Σ (Revenue per Period * Average Customer Lifespan)</p><p><strong>Predictive CLV</strong> is a more complex but valuable approach that takes into account future revenue projections based on customer behavior and subscription patterns. To calculate Predictive CLV, businesses use statistical models and machine learning algorithms to predict customer retention and spending. This method helps businesses optimize marketing strategies and allocate resources efficiently.</p><h3>Cohort Analysis</h3><p>Cohort analysis groups customers based on similar characteristics (e.g., acquisition date) and analyzes their behavior over time. By understanding how different cohorts evolve, businesses can project CLV more accurately for different segments.</p><h3>Personalized Marketing Campaigns</h3><p>By understanding the CLV of individual customers, businesses can create personalized marketing campaigns and offers that cater to their unique preferences and behaviors. For example, high CLV customers might receive exclusive rewards or discounts, while at-risk customers may receive targeted retention offers.</p><h3>Pricing Strategies</h3><p>CLV insights can inform pricing decisions, such as offering longer-term subscription options with discounted rates to increase customer commitment and lifetime value. Implementing dynamic pricing based on CLV can also optimize revenue generation.</p><h3>Churn Prediction and Mitigation</h3><p>CLV aids in identifying customers who are likely to churn, enabling proactive measures to prevent attrition. Through predictive modeling, businesses can implement personalized retention strategies for high CLV customers and re-engage low CLV customers to extend their subscription tenure.</p><h3>Customer Segmentation and Targeting</h3><p>Using CLV data, businesses can segment their customer base into categories like “high-value,” “medium-value,” and “low-value” customers. This segmentation helps in creating targeted marketing initiatives, improving customer engagement, and optimizing customer support efforts.</p><h3>Product Development and Upgrades</h3><p>Understanding CLV can influence product development decisions. By identifying features or services that attract high CLV customers, businesses can focus on enhancing those aspects to attract new high-value subscribers.</p><h3>Enhancing CLV through Customer Experience</h3><p>An effective onboarding process can set the tone for a positive customer experience, increasing the likelihood of customer satisfaction and retention. Personalized onboarding, tailored to individual needs and preferences, helps customers understand the value of the subscription from the start.</p><p>Consistent and engaging communication with customers can foster a sense of community and brand loyalty. Regularly updating customers about new features, product updates, and exclusive offers can lead to higher CLV as customers remain engaged and continue to find value in the subscription.</p><p>Prompt and effective customer support plays a pivotal role in customer satisfaction and retention. Resolving issues promptly and providing exceptional service can leave a positive impression, leading to longer customer lifespans and higher CLV.</p><h3>Measuring CLV Across Different Customer Segments</h3><p>Segmenting CLV data allows businesses to understand how customer value varies across different demographics, geographies, or subscription plans. This information can guide marketing strategies, product improvements, and expansion efforts to target the most lucrative segments.</p><h3>Leveraging CLV for Business Growth</h3><p>Customer loyalty programs that reward long-term subscribers can strengthen customer relationships and encourage retention. Tailoring loyalty rewards based on CLV ensures that the most valuable customers receive the most attractive incentives.</p><p>Understanding a customer’s CLV can reveal opportunities for upselling or cross-selling relevant products or premium subscription plans. Strategic upselling can increase ARPU and overall CLV.</p><p>High CLV customers are more likely to advocate for a business. Implementing a referral program that rewards customers for referring others can attract new customers with higher CLV potential.</p><p>Customer Lifetime Value (CLV) is an invaluable metric for subscription-based online businesses. By calculating and leveraging CLV, businesses can refine their marketing strategies, optimize pricing, and improve customer retention efforts. Understanding the long-term value of customers empowers businesses to build stronger relationships, enhance customer experiences, and drive sustainable growth in today’s fiercely competitive digital landscape. As the subscription economy continues to flourish, harnessing the power of CLV will be key to unlocking success and remaining ahead of the curve. With data-driven insights and customer-centric approaches, businesses can maximize CLV and achieve continued success in the dynamic world of subscription-based online ventures.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=3aa3ae84a95d" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Deciphering the Data Overload: The Frustrating World of Unactionable Dashboards]]></title>
            <link>https://medium.com/@marcheyp/deciphering-the-data-overload-the-frustrating-world-of-unactionable-dashboards-67b775802d1b?source=rss-695a35bebbfb------2</link>
            <guid isPermaLink="false">https://medium.com/p/67b775802d1b</guid>
            <category><![CDATA[analysis]]></category>
            <category><![CDATA[data]]></category>
            <category><![CDATA[metrics]]></category>
            <category><![CDATA[dashboard]]></category>
            <category><![CDATA[kpi]]></category>
            <dc:creator><![CDATA[Marc Heymann]]></dc:creator>
            <pubDate>Thu, 20 Jul 2023 07:16:58 GMT</pubDate>
            <atom:updated>2023-07-20T07:16:58.928Z</atom:updated>
            <content:encoded><![CDATA[<h4>Let’s add another indicator the dashboard. No harm , right?</h4><p>I found this cartoon and it made me think.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*rCOkqwhY8WQPDvkzvethGg.jpeg" /><figcaption>Cartoon from Marketoonist. The rights belong to them. Shown for educational purposes only.</figcaption></figure><p>In today’s data-driven world, dashboards are ubiquitous tools used to display critical information and metrics for businesses and organizations. Although this sentence can be, and at some point will be, challenged, these dashboards are designed to provide key insights, allowing decision-makers to understand the current state of affairs and make informed choices. However, in many cases, these dashboards become a tangled web of charts, indicators, and data points that lack actionable value, leading to confusion and frustration for users. In this blog post, we’ll explore the common pitfalls of such dashboards and highlight the importance of actionable data visualization for making better decisions.</p><h3>The Allure of Data Overload</h3><p>In an effort to demonstrate comprehensiveness, dashboard designers often overload the screen with a plethora of charts and indicators. On the surface, it may seem impressive to see so much information packed into one place. Unfortunately, more isn’t always better. When users are confronted with an overwhelming sea of data, they struggle to extract meaningful insights or identify actionable steps. The primary goal of a dashboard is to simplify complexity, not add to it.</p><p>While it’s essential to provide comprehensive data, designers should exercise caution to avoid cluttering the dashboard with irrelevant or redundant information. A cluttered interface can lead to cognitive overload and hinder users’ ability to focus on the data that matters most.</p><h3>Misalignment with Business Objectives</h3><p>One of the main reasons for the lack of actionable dashboards is the failure to align them with specific business objectives. Each dashboard should have a clear purpose and cater to a particular audience. However, when designers attempt to address every possible scenario or audience on a single dashboard, it loses its effectiveness. The key is to focus on the most important metrics that directly impact the business goals, making it easier for users to take decisive actions.</p><p>To achieve alignment with business objectives, designers must collaborate closely with stakeholders and end-users. Understanding the key performance indicators (KPIs) that matter most to decision-makers and presenting them in a visually intuitive manner can significantly enhance the dashboard’s actionability.</p><h3>Lack of Contextualization</h3><p>The absence of context is another culprit behind the ineffectiveness of many dashboards. Charts and indicators often provide snapshots of data without linking them to broader trends or historical performance. Without context, users cannot understand the reasons behind certain trends or fluctuations, leaving them unable to devise actionable strategies based on the available data.</p><p>To remedy this, dashboards should incorporate historical data and trend analysis, enabling users to track progress over time and identify patterns. Moreover, providing explanatory notes or tooltips for specific data points can further enhance users’ understanding and decision-making.</p><h3>Complex Visualization Techniques</h3><p>While data visualization is a powerful tool for conveying insights, the misuse of complex visualization techniques can hinder understanding and actionability. Dashboards featuring intricate 3D charts, obscure graphs, or overcomplicated visualizations often confuse users, making it difficult for them to grasp the significance of the data. Simplicity and clarity should be the guiding principles when creating actionable dashboards.</p><p>Choosing the right visualization type that best represents the data and aligns with users’ mental models is crucial. Simple bar charts, line graphs, and pie charts are often more effective in communicating data trends and facilitating decision-making.</p><h3>Overemphasis on Vanity Metrics</h3><p>Vanity metrics, such as social media likes or page views, may look impressive on a dashboard but provide little actionable value. These metrics often lack a direct correlation with key business goals and can distract users from focusing on the metrics that truly matter. Effective dashboards prioritize actionable metrics that directly impact decision-making and help organizations make data-driven choices.</p><p>When designing dashboards, it’s essential to distinguish between vanity metrics and meaningful KPIs. Concentrate on metrics that contribute directly to business growth, customer satisfaction, or operational efficiency.</p><h3>Real-Time vs. Historical Data</h3><p>Dashboards often offer real-time data feeds, which can be both beneficial and misleading. While real-time data can provide up-to-the-minute insights, it can also present volatile and unrepresentative figures that may not reflect long-term trends. Striking a balance between real-time and historical data representation is vital for users to identify actionable patterns and make informed decisions.</p><p>Designers should consider implementing a toggle or time slider feature that allows users to switch between real-time and historical views, providing a holistic understanding of the data’s evolution.</p><h3>Data Accuracy and Reliability</h3><p>Unreliable data sources or inaccurate data can significantly compromise the usability of a dashboard. Decision-makers rely on these dashboards to provide accurate insights, and any discrepancies can lead to misguided actions. Ensuring data accuracy and reliability is a crucial step in creating actionable dashboards that can be trusted for business decision-making.</p><p>Regular data auditing and validation processes are essential to maintain the integrity of the dashboard’s insights. Additionally, designers should provide clear information about data sources and update frequency to instill confidence in users.</p><h3>Neglecting User Feedback</h3><p>Dashboards should be dynamic tools that evolve with changing business needs and user requirements. Unfortunately, many designers neglect to gather user feedback and iterate on the dashboard’s design, resulting in stagnant and unactionable displays. Regularly seeking feedback from users and stakeholders can lead to valuable insights, allowing for continuous improvement and the creation of more actionable dashboards.</p><p>Encouraging users to provide feedback and actively incorporating their suggestions fosters a user-centric approach, ensuring that the dashboard remains relevant and effective in meeting their needs.</p><p>In conclusion, the prevalence of dashboards containing a myriad of charts and indicators but lacking actionable insights is a growing concern. These dashboards often overwhelm users, misalign with business objectives, lack context, and misuse visualization techniques. The key to creating actionable dashboards lies in simplicity, contextualization, and alignment with business goals.</p><p>To address this issue, dashboard designers must focus on presenting relevant and concise data that directly impacts decision-making. Prioritizing actionable metrics, providing historical context, and leveraging user feedback are essential steps towards creating effective and valuable dashboards. By streamlining the data visualization process and fostering a user-centric approach, organizations can harness the full potential of dashboards and use data to drive informed and actionable decisions.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=67b775802d1b" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Unraveling the Shortcomings of Google Analytics 4]]></title>
            <link>https://medium.com/@marcheyp/unraveling-the-shortcomings-of-google-analytics-4-bb42178d5fa4?source=rss-695a35bebbfb------2</link>
            <guid isPermaLink="false">https://medium.com/p/bb42178d5fa4</guid>
            <category><![CDATA[matomo]]></category>
            <category><![CDATA[google-analytics]]></category>
            <category><![CDATA[data]]></category>
            <category><![CDATA[ga4]]></category>
            <dc:creator><![CDATA[Marc Heymann]]></dc:creator>
            <pubDate>Wed, 19 Jul 2023 09:50:58 GMT</pubDate>
            <atom:updated>2023-07-19T09:50:58.914Z</atom:updated>
            <content:encoded><![CDATA[<h4>A sad story</h4><p>Google Analytics has been a staple tool for website owners and digital marketers for years. It has provided valuable insights into user behavior, conversions, and overall website performance. However, with the introduction of Google Analytics 4 (GA4) in October 2020, many users have expressed their dissatisfaction with the platform. In this blog post, we will explore some of the major shortcomings of GA4 and why it fails to live up to its predecessor’s reputation.</p><p>I hesitated a lot about writing this post. I’m glad I decided to do so.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*RcExJdl3YgJaFT0Ba2Jbhw.png" /><figcaption>DALL-E 2 generated image</figcaption></figure><h3>Steep Learning Curve</h3><p>One of the most significant drawbacks of GA4 is its steep learning curve. Users familiar with the classic Google Analytics interface may find it challenging to adapt to the new data model and reporting structure. GA4’s event-based model and the emphasis on events, rather than pageviews, require users to relearn how to track and analyze website data.</p><p>While Google has attempted to provide documentation and tutorials to help users transition to GA4, the learning curve remains a significant concern. The lack of comprehensive support and training resources can frustrate users trying to get a grasp of the new platform.</p><h3>Limited Historical Data</h3><p>Another major drawback of GA4 is its inability to import historical data from Universal Analytics (UA). When users migrate from the classic version to GA4, they lose all their historical data, making it challenging to analyze long-term trends and compare performance accurately. This loss of historical data can be detrimental for businesses that heavily rely on data-driven decisions.</p><p>For businesses that have been using Universal Analytics for years, losing historical data means losing valuable insights into past user behavior, marketing efforts, and website performance. The absence of historical data can also affect benchmarking and goal-setting for future strategies.</p><h3>Event Tracking Complexity</h3><p>GA4 relies heavily on event tracking, which can be complex to set up properly. Users need to define events for various user interactions manually, leading to potential inconsistencies and inaccuracies in data collection. The complexity of event tracking can become a significant obstacle for non-technical users, hindering their ability to use GA4 effectively.</p><p>Furthermore, the shift from pageviews to event-based tracking may not be suitable for all types of websites or businesses. For websites that primarily focus on content consumption, such as blogs, the emphasis on events might not provide the same level of insight as the classic pageview-based approach.</p><h3>Reporting and Visualization Limitations</h3><p>GA4’s reporting and data visualization capabilities are also underwhelming compared to the classic version. The standard reports lack customization options, making it difficult to tailor reports to specific business needs. The limited visualization tools may not be sufficient for in-depth analysis and presenting data in a visually appealing manner.</p><p>Custom reporting and advanced data visualization are crucial for businesses that need to present data to stakeholders or clients effectively. GA4’s limitations in this aspect can hamper the ability to communicate insights clearly and make data-driven decisions confidently.</p><h3>Cross-Domain Tracking Challenges</h3><p>For websites with multiple domains, cross-domain tracking is crucial to understanding the user journey accurately. However, GA4’s cross-domain tracking implementation is not as straightforward as it was in the classic version, requiring additional configuration and technical expertise.</p><p>The complexity of cross-domain tracking in GA4 can lead to inaccurate data and incomplete user journey analysis. Without a seamless cross-domain tracking solution, businesses may struggle to understand how users interact with different domains, impacting their ability to optimize the entire customer experience effectively.</p><h3>Uncertain Future Support</h3><p>As GA4 is still relatively new, there are concerns about its future support and development. Google has a track record of sunsetting products that fail to gain significant traction, and some fear GA4 might face a similar fate. This uncertainty can deter businesses from investing time and resources into adopting GA4 fully.</p><p>The lack of clarity surrounding GA4’s long-term viability can be a significant deterrent for businesses seeking a reliable and sustainable analytics platform. With the potential risk of GA4 being discontinued or replaced in the future, businesses may hesitate to invest in a platform that may not provide a stable and supported solution in the long run.</p><h3>Poor API Performance</h3><p>Another significant concern with Google Analytics 4 is its poor API performance. For businesses and developers relying on the API to extract data for custom reporting, integration with other tools, or building custom applications, the performance limitations can be frustrating and hinder overall productivity.</p><p>The GA4 API response times have been reported to be slower compared to the API of the classic version, Universal Analytics. Slow response times can lead to delays in data retrieval and processing, negatively impacting real-time reporting and analysis. For businesses with a heavy reliance on up-to-date analytics data, the lagging API performance in GA4 can be a significant drawback.</p><p>Furthermore, the GA4 API documentation and resources provided by Google are not as comprehensive as those available for the classic version. This lack of detailed documentation can make it challenging for developers to understand and leverage the full capabilities of the API effectively. As a result, developers might encounter difficulties in implementing custom solutions or integrating GA4 data with other platforms.</p><p>But, the most important issue is that the API simply responds with a huge data loss in most of the cases, specially when using custom events. The API even considers as high cardinality a dimension with three different values.</p><p>The limitations in API performance and documentation can hinder businesses’ ability to build advanced analytics solutions tailored to their specific needs. Without a robust and efficient API, businesses may struggle to gain valuable insights from their GA4 data, leading to missed opportunities for data-driven decision-making and optimization.</p><h3>Why Moving to Matomo is a Good Idea</h3><p>Amidst the shortcomings of Google Analytics 4, many businesses are seeking alternative analytics solutions that offer more comprehensive features and greater control over their data. Matomo, formerly known as Piwik, emerges as a strong contender for those looking to make the switch. Let’s explore the reasons why moving to Matomo might be a beneficial decision:</p><h3>Data Ownership and Privacy</h3><p>Unlike Google Analytics, where user data is stored on Google’s servers, Matomo provides businesses with full data ownership. With Matomo, you have complete control over your data, ensuring better compliance with data privacy regulations and reducing concerns about data being shared with third parties. This level of data ownership is crucial for businesses that prioritize user privacy and data security.</p><h3>Open Source and Customizability</h3><p>Matomo is an open-source analytics platform, allowing businesses to access its source code and customize the tool to meet their specific needs. This flexibility is invaluable for businesses with unique tracking requirements, enabling them to create tailor-made analytics solutions that align perfectly with their goals.</p><h3>Comprehensive Tracking and Reporting</h3><p>Matomo offers a wide array of tracking features similar to those in Google Analytics. From pageviews and events to e-commerce tracking and heatmaps, Matomo covers all the essentials for analyzing user behavior and website performance.</p><p>Furthermore, Matomo’s reporting capabilities are highly customizable, allowing businesses to create detailed reports and visualizations tailored to their specific KPIs and objectives. With this level of flexibility, Matomo stands out as a powerful analytics tool for businesses seeking detailed insights and comprehensive reporting.</p><h3>Advanced Segmentation and Tag Manager</h3><p>Matomo’s advanced segmentation capabilities enable businesses to delve deep into their data and analyze specific user segments. Whether you want to understand the behavior of returning users, identify the most engaged audience, or target specific demographics, Matomo’s advanced segmentation makes it all possible.</p><p>Additionally, Matomo offers a built-in Tag Manager that simplifies the process of adding and managing tracking tags without requiring extensive technical knowledge. This feature streamlines the implementation of custom tracking elements and ensures accurate data collection without the complexities associated with manual tagging.</p><h3>Real-Time Analytics</h3><p>Matomo offers real-time analytics, giving businesses immediate insights into website activity. This feature is particularly valuable for businesses that need to monitor campaigns, respond to user behavior in real-time, and optimize their website on the fly.</p><h3>Cross-Domain Tracking Made Easy</h3><p>Unlike the challenges associated with cross-domain tracking in GA4, Matomo provides a straightforward solution for tracking user interactions across multiple domains. This feature is especially beneficial for businesses with complex website structures and diverse web properties.</p><h3>Drawbacks</h3><p>There are two ways we can deploy Matomo: cloud version and hosted version. Both cases have importat drawbacks.</p><ul><li>Hosted version requires a potentially big architecture which eventually leads to high costs, not just in infrastructure and databases, but in manpower as well. This is specially significant for high-traffic websites.</li><li>Cloud version can be very expensive as well. For high-traffic websites the cost could be rivalizing to Google Analytics 360 or Adobe Analytics.</li></ul><p>Google Analytics 4 was introduced as a promising evolution of the classic version, aiming to provide better insights into user behavior and enhance tracking capabilities. However, it has fallen short of expectations due to its steep learning curve, limited historical data migration, incomplete feature set, and challenges with event tracking and third-party integration.</p><p>While GA4 may eventually overcome some of these issues with future updates, it is essential for businesses and digital marketers to carefully assess their analytics needs and the readiness of GA4 before making the switch. For now, many users might find it more prudent to continue using the classic Google Analytics version, especially if they heavily rely on historical data and advanced tracking features. Only time will tell if Google addresses these concerns adequately and if GA4 can live up to the standards set by its predecessor.</p><p>Whether to move into another solution or not, many factors should be weighed in. There is not a unique answer to the question “which tool should I use?” It’s important to consider you own use cases, budget, and techincal capabiliteis. But something still remains: we will deeply miss Universal Analytics.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=bb42178d5fa4" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[More on lagging indicators]]></title>
            <link>https://medium.com/@marcheyp/more-on-lagging-indicators-ddc6141eea5a?source=rss-695a35bebbfb------2</link>
            <guid isPermaLink="false">https://medium.com/p/ddc6141eea5a</guid>
            <category><![CDATA[data]]></category>
            <category><![CDATA[metrics]]></category>
            <category><![CDATA[kpi]]></category>
            <category><![CDATA[reporting]]></category>
            <dc:creator><![CDATA[Marc Heymann]]></dc:creator>
            <pubDate>Tue, 18 Jul 2023 10:51:15 GMT</pubDate>
            <atom:updated>2023-07-18T10:51:15.511Z</atom:updated>
            <content:encoded><![CDATA[<h4>Concrete examples that will make your life easier</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*T-d21QEx6lOjSR2jMtVl9A.png" /><figcaption>DALL-E 2 generated image</figcaption></figure><p>Welcome to the world of lagging indicators, where we’ll dive into the concrete examples of subscription-based KPI metrics! Forget about leading indicators, those are so overrated. Lagging indicators are the real deal when it comes to tracking the success of your subscription-based business. So, get ready to uncover the key metrics that will help you improve customer retention, maximize revenue, optimize conversion rates, and measure customer engagement. Say goodbye to guessing games and hello to data-driven decision-making. Trust me, your business will thank you later. Let’s get started!</p><h3>Understanding Lagging Indicators</h3><p>Understanding Lagging Indicators: So you want to dive into the world of lagging indicators, huh? Well, buckle up because we’re about to embark on a journey through the mystical realm of subscription-based Key Performance Indicators (KPIs). Lagging indicators might sound like something out of a sci-fi movie, but fear not, my friend. I’m here to make sense of it all for you. First things first, let’s unravel the enigma of lagging indicators. These indicators are like detectives that investigate the aftermath of a crime scene to figure out what exactly happened. In the world of KPIs, they provide insights into past performance rather than predicting the future. They’re like rearview mirrors — helpful to know where you’ve been, but useless for predicting the traffic ahead. Now, let’s apply this to subscription-based businesses. Imagine you’re running a subscription box service, delighting customers with mysterious goodies every month. You want to understand how well your business is doing, right? Lagging indicators can help you with that. One example of a lagging indicator in this context is the customer churn rate. This little gem tells you how many subscribers you’ve lost over a specific period. It’s like a heartbreak counter, showing you how many relationships ended. Sad, but oh-so-important. Another example could be the customer lifetime value (CLV). This metric tells you how much moolah you’re making from each subscriber on average during their entire journey with your business. It’s like a crystal ball seeing into your financial future (minus the psychic hotline charges). Now that we’ve decoded the basics, you’re ready to dive deeper into the world of lagging indicators in subscription-based KPI metrics. But remember, even though they can’t predict the future, they are your trusty allies in understanding past performance. So keep your detective hat on, my friend, and let’s solve the mystery of the lagging indicators together! (Check your rearview mirror before we continue… Just kidding, there’s no traffic here!)</p><h3>Improving Customer Retention</h3><p>Improving Customer Retention So, you have a subscription-based business and you want to keep your customers from running away like there’s no tomorrow? Well, my friend, you’ve come to the right place. Improving customer retention is crucial for the long-term success of your business. After all, who needs customers to stick around, right? Analyzing churn rate is the first step to understanding why customers are leaving you faster than you can say “unsubscribe.” Churn rate measures the percentage of customers who cancel their subscriptions during a given period. Dive deep into the data and find out what’s making them jump ship. Is it your hefty price tag? Your lackluster customer support? Or maybe your product just isn’t as shiny as you thought? Once you’ve identified the reasons behind customer churn, it’s time to utilize customer lifetime value (CLV) to keep those revenue streams flowing. CLV is the estimated value a customer will bring to your business over their entire relationship with you. By segmenting your customers based on their CLV, you can prioritize your efforts to retain the high-value ones and maybe give the low-value ones a little nudge towards the exit door. But hey, tracking customer satisfaction metrics is not just about sending out a survey and hoping for the best. It’s about understanding how satisfied your customers are and doing something about it. One way to gauge customer satisfaction is through Net Promoter Score (NPS), which measures how likely customers are to recommend your business to others. So, if your NPS score is lower than the number of friends you have on Facebook, it’s time to roll up your sleeves and work on improving customer satisfaction. But wait, there’s more! Customer satisfaction is just one aspect of the customer experience. You also need to ensure that your customers are engaged with your product or service. So, what can you do? Well, first, analyze active users to see who’s actually using your product or service on a regular basis. Are they engaging with it or just letting it collect digital dust? And if that’s not enough, monitor customer interactions to see if they’re actively engaging with your brand. Are they commenting on your blog posts or responding to your social media posts? If they’re just sitting there like a lifeless mannequin, it’s time to shake things up and get them excited about your business again. Oh, and let’s not forget the onboarding completion rate. This little gem measures the percentage of customers who actually complete your onboarding process. If their progress stalls faster than a tortoise on a treadmill, it’s a clear sign that something’s not quite right. Maybe your onboarding process is as confusing as assembling Ikea furniture without the instructions. Or maybe it’s just too time-consuming. So, make sure your onboarding experience is as smooth as butter and as engaging as a thrilling season finale. Improving customer retention is not for the faint-hearted. It requires analyzing churn rate, utilizing customer lifetime value, and tracking customer satisfaction metrics. So, roll up your sleeves and get ready to show those customers why they should stick around. After all, who needs a revolving door of subscribers when you can have a loyal army of customers? Stay tuned for more tips on maximizing revenue and optimizing conversion rates. This adventure is just getting started! (Hint: Remember, sarcasm and humor can be a great way to keep the readers engaged and entertained. So, don’t be afraid to sprinkle in some witty remarks here and there. But hey, don’t overdo it either. We don’t want the readers laughing so hard that they forget to read the important stuff!)</p><h3>Optimizing Conversion Rates</h3><p>Optimizing Conversion Rates Oh, conversion rates! The pinnacle metric that all subscription-based businesses yearn to improve. After all, what’s the point of having a bunch of leads if they don’t convert into paying customers? That’s like having a fancy restaurant with an empty dining room — an absolute disaster! So, how do we tackle this conundrum? Let’s start by identifying the conversion rate. It’s basically the percentage of visitors who take the desired action, whether it’s signing up for a free trial or subscribing to a paid plan. Sounds simple, right? Well, not quite. To truly optimize your conversion rates, you need to dive deeper and analyze the conversion rate by marketing channel. Which channel is bringing in the most valuable customers? Is it social media ads, email campaigns, or good old word-of-mouth? By identifying the most effective channels, you can focus your efforts where they’ll have the biggest impact and stop wasting time on strategies that are falling flat. But wait, there’s more! The art of conversion rate optimization (CRO) techniques comes into play. It’s like a secret weapon that every subscription-based business should have in their arsenal. CRO involves making data-driven changes to your website or app to encourage more conversions. You could strategically place your call-to-action buttons, optimize your landing pages, or streamline your checkout process to remove any friction that might</p><p>be causing potential customers to abandon their purchase.</p><p>One important aspect of conversion rate optimization is conducting A/B testing. This involves creating two versions of a webpage or an advertisement and testing them against each other to see which one performs better in terms of conversion rates. By analyzing the results of these tests, you can make informed decisions about which elements of your website or marketing strategy are most effective and make the necessary adjustments to improve your conversion rates.</p><p>Another strategy that can greatly impact conversion rates is personalization. By tailoring your messaging and offers to specific segments of your audience, you can increase the likelihood of them taking the desired action. For example, if you have identified that a certain group of customers responds well to a particular type of promotion, you can create targeted campaigns specifically for that segment, leading to higher conversion rates.</p><p>Lastly, it is essential to continuously monitor and analyze your conversion rates. This allows you to track any fluctuations or trends over time and identify areas that need improvement. By staying on top of your conversion rates and regularly making data-driven adjustments, you can maximize your chances of converting visitors into paying customers.</p><p>In conclusion, optimizing conversion rates is a crucial aspect of running a successful subscription-based business. By analyzing your conversion rate by marketing channels, implementing CRO techniques, conducting A/B testing, personalizing your messaging, and diligently monitoring your conversion rates, you can increase the number of visitors who take the desired action and, ultimately, grow your customer base and revenue.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=ddc6141eea5a" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Technical guide: HAVING function in PostgreSQL]]></title>
            <link>https://medium.com/@marcheyp/technical-guide-having-function-in-postgresql-e307baf1896f?source=rss-695a35bebbfb------2</link>
            <guid isPermaLink="false">https://medium.com/p/e307baf1896f</guid>
            <category><![CDATA[data]]></category>
            <category><![CDATA[postgresql]]></category>
            <category><![CDATA[database]]></category>
            <category><![CDATA[function]]></category>
            <dc:creator><![CDATA[Marc Heymann]]></dc:creator>
            <pubDate>Mon, 17 Jul 2023 13:36:29 GMT</pubDate>
            <atom:updated>2023-07-17T13:36:29.950Z</atom:updated>
            <content:encoded><![CDATA[<h4>A very powerful tool</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*9IwFT_JnFD_1Aj8mpMdMWQ.png" /><figcaption>DALL-E 2 Image</figcaption></figure><p>The HAVING function in PostgreSQL allows users to filter the results of a query based on the results of aggregate functions. Unlike the WHERE clause, which filters individual rows, the HAVING clause filters groups of rows resulting from aggregate functions. In essence, the HAVING function is used in conjunction with GROUP BY, making it ideal for summarizing and analyzing data based on certain conditions.</p><p>The syntax of the HAVING function is straightforward and follows this pattern:</p><pre>SELECT column1, column2, aggregate_function(column)<br>FROM table_name<br>GROUP BY column1, column2<br>HAVING condition;</pre><p>Here’s a breakdown of the components:</p><ul><li>SELECT: Specifies the columns to be retrieved from the table.</li><li>aggregate_function: Represents the aggregate function used to summarize data (e.g., COUNT, SUM, AVG, MIN, MAX).</li><li>GROUP BY: Groups the results based on one or more columns specified in the GROUP BY clause.</li><li>HAVING: Filters the grouped data based on the conditions provided.</li></ul><h3>Some examples</h3><p>Suppose we have a table named “sales” with columns “product,” “region,” and “amount.” We want to find products whose total sales amount exceeds a certain threshold, say $10,000.</p><pre>SELECT product, SUM(amount) as total_sales<br>FROM sales<br>GROUP BY product<br>HAVING SUM(amount) &gt; 10000;</pre><p>Assume we have another table named “monthly_sales” with columns “region” and “sales.” We wish to find regions with an average monthly sales value greater than $500.</p><pre>SELECT region, AVG(sales) as avg_sales<br>FROM monthly_sales<br>GROUP BY region<br>HAVING AVG(sales) &gt; 500;</pre><h3>Some powerful combinations</h3><p>The HAVING function can be used in combination with other clauses to perform more sophisticated queries. For instance:</p><ul><li>Using HAVING with JOIN: When using JOINs, we can apply the HAVING clause to filter groups based on combined data from multiple tables.</li><li>Combining HAVING with WHERE: The WHERE clause filters individual rows, and the HAVING clause filters groups. By using both, we can obtain more granular results.</li></ul><h3>Performance</h3><p>When using the HAVING function in PostgreSQL, it’s crucial to be mindful of performance considerations to ensure that your queries run efficiently and don’t put unnecessary strain on your database. Here are some important aspects to consider:</p><ol><li>Indexing: Proper indexing is essential for optimizing queries that involve the HAVING clause. Ensure that the columns used in the GROUP BY and HAVING clauses are indexed appropriately. Indexing allows the database to quickly locate relevant data, significantly improving query performance. Without proper indexing, the database may need to perform full-table scans, which can be slow and resource-intensive.</li><li>Aggregation Functions: The choice of aggregation functions used with the HAVING clause can impact performance. Some aggregate functions, like COUNT or SUM, are generally fast and efficient. However, complex or user-defined aggregate functions might require more processing time and can be slower. Keep in mind the nature of your data and the specific requirements of your queries when choosing aggregation functions.</li><li>Data Volume and Cardinality: The volume of data and the cardinality (number of distinct values) of the columns involved in the GROUP BY clause can affect query performance. If you have a large dataset and a high cardinality column in the GROUP BY clause, the database needs to create and manage a large number of groups, which can increase query execution time. Consider data partitioning, sharding, or other optimization techniques to handle large datasets efficiently.</li><li>ORDER BY and LIMIT: Using ORDER BY in combination with HAVING can have performance implications, especially when the result set is large. Sorting results can be resource-intensive, and it becomes even more critical if you are using the LIMIT clause to retrieve only a subset of the results. To improve performance, consider whether sorting the data is necessary, and if possible, avoid sorting large result sets.</li><li>Query Structure: The structure of your query can significantly impact performance. Avoid writing overly complex queries with multiple nested subqueries unless necessary. Simplify your queries and consider breaking them into smaller, more manageable parts. This will not only improve readability but also make it easier for the database optimizer to generate an efficient execution plan.</li><li>Statistics and Query Planner: PostgreSQL relies on query planning to determine the most efficient way to execute a query. It uses statistics to estimate the size and distribution of data, which plays a crucial role in the query planner’s decision-making process. Regularly update statistics to ensure the query planner has accurate information, enabling it to generate optimal execution plans.</li><li>Materialized Views: For frequently used aggregate queries involving the HAVING function, consider using materialized views. Materialized views are pre-computed result sets stored as tables, allowing you to avoid redundant calculations and significantly speeding up query execution. Keep in mind that materialized views need to be refreshed periodically to ensure data accuracy.</li></ol><p>The HAVING function in PostgreSQL is a powerful tool for filtering and aggregating data based on conditions after using the GROUP BY clause. While it offers great flexibility and analytical capabilities, improper usage can lead to suboptimal query performance. By considering indexing, aggregation functions, data volume, query structure, and other performance factors, you can fine-tune your queries to run efficiently and harness the full potential of PostgreSQL for data analysis and decision-making. Regular monitoring, indexing, and optimization are essential to maintaining a high-performing database system that effectively handles complex queries involving the HAVING function.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=e307baf1896f" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Rethinking Degrees in Tech Hiring: Emphasizing Skills and Continuous Learning]]></title>
            <link>https://medium.com/@marcheyp/rethinking-degrees-in-tech-hiring-emphasizing-skills-and-continuous-learning-521338bd3161?source=rss-695a35bebbfb------2</link>
            <guid isPermaLink="false">https://medium.com/p/521338bd3161</guid>
            <category><![CDATA[hiring]]></category>
            <category><![CDATA[skills]]></category>
            <category><![CDATA[training]]></category>
            <category><![CDATA[tech]]></category>
            <dc:creator><![CDATA[Marc Heymann]]></dc:creator>
            <pubDate>Fri, 14 Jul 2023 09:47:32 GMT</pubDate>
            <atom:updated>2023-07-14T09:47:32.710Z</atom:updated>
            <content:encoded><![CDATA[<h4>My experience as hiring manager</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*VTZCzyOEHb-LcxyxAwGFUw.png" /><figcaption>DALL-E generated image.</figcaption></figure><p>In today’s rapidly evolving world of technology, traditional educational pathways are being challenged, especially in the field of tech hiring. The notion that a degree is the ultimate requirement for success in the industry is being reevaluated. Increasingly, employers are recognizing that skills and the ability to stay up to date are more crucial indicators of a candidate’s potential. This blog post explores the shifting landscape of tech hiring, emphasizing the importance of what candidates can do and how they keep up with advancements, rather than solely relying on degrees.</p><h3>The Changing Nature of Tech Skills</h3><p>The field of technology is ever-changing, and the skills required to thrive in this industry are continuously evolving. A degree obtained several years ago may not necessarily equip individuals with the most up-to-date knowledge and expertise. Technologies such as artificial intelligence, blockchain, and cloud computing have emerged in recent years, and the pace of innovation shows no signs of slowing down.</p><p>In fact, some of the most successful tech professionals today are self-taught or have gained their skills through alternative learning paths. They have demonstrated the ability to adapt to new technologies, acquire relevant skills, and apply them effectively. By focusing on skills rather than degrees, employers can tap into a pool of talent that is not limited by outdated educational standards.</p><h3>The Rise of Alternative Learning Paths</h3><p>The digital age has brought about an abundance of accessible learning resources, allowing individuals to gain knowledge and skills outside of traditional degree programs. Online courses, coding bootcamps, and self-paced tutorials have become popular avenues for acquiring tech skills. These alternative learning paths often focus on practical, hands-on training, equipping learners with industry-relevant competencies in a shorter time frame.</p><p>One of the advantages of alternative learning paths is their flexibility. Individuals can tailor their learning journey to match their specific interests and career goals. They can choose to specialize in specific areas of technology, acquiring the skills that are in high demand in the industry. This targeted learning approach allows candidates to become proficient in specific areas and position themselves as experts in their field.</p><h3>Practical Experience as a Key Differentiator</h3><p>One of the most significant advantages of focusing on skills rather than degrees is the ability to assess candidates based on practical experience. Employers are increasingly valuing hands-on projects, internships, and work experience over formal education. By evaluating real-world contributions and accomplishments, companies can gauge an individual’s problem-solving abilities, teamwork skills, and adaptability — qualities that are invaluable in a fast-paced tech environment.</p><p>Practical experience provides candidates with an opportunity to apply their skills in real-world scenarios, tackling complex challenges and developing innovative solutions. Through internships or personal projects, individuals can demonstrate their ability to work in teams, communicate effectively, and deliver results. These practical experiences serve as a testament to their competence and readiness for the industry.</p><h3>Demonstrating Continuous Learning</h3><p>Tech professionals must be lifelong learners, continually adapting to emerging trends and technologies. In a dynamic industry like technology, an individual’s ability to stay up to date is critical. Candidates who showcase a commitment to ongoing learning and professional development — such as participation in open-source projects, attending tech conferences, or contributing to industry forums — demonstrate their passion and dedication to keeping pace with the ever-changing tech landscape.</p><p>Employers can assess a candidate’s commitment to continuous learning by evaluating their engagement with the tech community. Active participation in relevant forums, engagement in online communities, and contributions to open-source projects showcase a candidate’s willingness to learn and collaborate. These activities highlight an individual’s adaptability and their ability to acquire new skills as technologies evolve.</p><h3>Embracing Diversity and Inclusion</h3><p>Placing less emphasis on degrees in tech hiring can also help address issues of diversity and inclusion. Traditional educational institutions have historically faced challenges in ensuring equal access to opportunities for underrepresented groups. By shifting focus to skills and continuous learning, employers can open doors to individuals from diverse backgrounds who possess the talent and potential but may not have followed a conventional educational path.</p><p>Focusing on skills and practical experience allows organizations to evaluate candidates based on merit rather than their educational background. This shift can help mitigate biases and enable a more diverse and inclusive workforce. By embracing talent from different walks of life, companies can benefit from a broader range of perspectives and innovative ideas, leading to increased creativity and problem-solving abilities within teams.</p><h3>Assessing Skills Effectively</h3><p>While degrees provide a certain level of standardization and structure, assessing skills without relying solely on educational credentials requires a more nuanced approach. Employers can adopt various strategies, such as coding challenges, portfolio reviews, technical interviews, and practical assessments, to evaluate candidates’ capabilities effectively. These methods provide a more accurate representation of an individual’s skills and potential to contribute to the organization.</p><p>Coding challenges and technical interviews can help assess a candidate’s problem-solving skills, analytical thinking, and technical expertise. Portfolio reviews allow candidates to showcase their previous work, demonstrating their ability to apply their skills to real-world projects. Practical assessments, such as coding assignments or simulations, provide employers with insights into a candidate’s ability to execute tasks and deliver results. By utilizing a combination of these evaluation methods, employers can gain a comprehensive understanding of a candidate’s skills and potential.</p><h3>Cultivating a Learning Culture</h3><p>By prioritizing skills and continuous learning, organizations can foster a culture of ongoing development. Encouraging employees to engage in professional growth opportunities, whether through attending workshops or pursuing certifications, helps keep the entire workforce up to date with industry advancements. This emphasis on skills and learning not only benefits individual employees but also enhances the organization’s overall competitiveness and innovation.</p><p>Organizations can support continuous learning by providing employees with access to training resources, mentorship programs, and opportunities for collaboration and knowledge sharing. By investing in their employees’ professional growth, companies can create a culture that values skills and encourages individuals to stay up to date with the latest technologies and industry trends. This learning-focused environment fosters innovation, adaptability, and the ability to tackle complex challenges head-on.</p><h3>Conclusion</h3><p>In an era defined by rapid technological advancement, the traditional reliance on degrees as the sole indicator of a candidate’s potential is becoming obsolete. While degrees still hold value in certain contexts, it is crucial to recognize that skills, practical experience, and a commitment to continuous learning are equally — if not more — important factors in tech hiring. By shifting the focus to what candidates can do and how they stay up to date, employers can tap into a broader talent pool, promote diversity and inclusion, and build teams equipped to thrive in the ever-evolving tech landscape. Ultimately, the future of tech hiring lies in embracing skills and continuous learning as the new benchmarks for success.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=521338bd3161" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Leading Indicators for Data-Driven Analysis of Subscription-Based Business]]></title>
            <link>https://medium.com/@marcheyp/leading-indicators-for-data-driven-analysis-of-subscription-based-business-7693dc043297?source=rss-695a35bebbfb------2</link>
            <guid isPermaLink="false">https://medium.com/p/7693dc043297</guid>
            <category><![CDATA[kpi]]></category>
            <category><![CDATA[analytics]]></category>
            <category><![CDATA[data]]></category>
            <category><![CDATA[lifetime-value]]></category>
            <dc:creator><![CDATA[Marc Heymann]]></dc:creator>
            <pubDate>Thu, 13 Jul 2023 08:55:16 GMT</pubDate>
            <atom:updated>2023-07-13T08:55:16.174Z</atom:updated>
            <content:encoded><![CDATA[<h4>Revisiting this concept with concrete examples</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*l_cNC--ivfrESXow7Ziz1w.png" /><figcaption>DALL-E generated image</figcaption></figure><p>Are you running a subscription-based business? Is it giving you sleepless nights? Don’t worry! You are not alone in this boat. Subscription-based businesses need more attention and analysis than traditional businesses. The reason behind this is the recurring payment system. Sounds attractive, right? Well, you are not alone, even your customers find subscription-based services beneficial and convenient. But, with great power comes great responsibility. And subscription-based businesses are responsible for a monthly or a yearly recurring payment. That’s why data-driven analysis is crucial for the growth and success of your subscription-based business. Data-driven analysis helps businesses to make accurate decisions, understand customer behaviour, and predict future trends. It’s the key to unlock the potential of your subscription-based business. By analysing customer data, you can predict churn rate, customer lifetime value, customer acquisition cost, and monthly recurring revenue. Now, you might be wondering how to implement data-driven analysis in your subscription-based business? Don’t worry, we’ve got you covered. This blog will guide you on leading indicators for data-driven analysis of subscription-based businesses. Stay tuned!</p><h3>Churn Rate</h3><p>Introduction: Subscription-based business models have become increasingly popular in recent years, and it’s not hard to see why. These businesses offer a steady stream of revenue, provide predictable cash flows, and foster long-term customer relationships. However, as with any business, there are risks associated with this model, such as high customer churn rates. To mitigate these risks, subscription-based businesses must utilize data-driven analyses to identify leading indicators of success. Churn Rate: Churn rate refers to the percentage of customers who cancel their subscriptions within a given time period. For subscription-based businesses, churn is a critical metric as it reflects the number of customers who are dissatisfied with the service or have found a better alternative. High churn rates can impact customer acquisition and retention costs as well as revenue. Therefore, it’s essential to reduce this rate by identifying the cause of churn. Churn rate formula and calculation: The churn rate formula involves the number of customers who canceled in a given time period, divided by the total number of customers at the start of the period. For example, if 50 customers cancel their subscriptions in a month, and you have 500 customers at the beginning of the month, your churn rate would be 10%. Churn mitigation strategies: Identifying the root cause of churn can help businesses develop strategies to mitigate it. There are several approaches, such as improving customer service, reducing onboarding time, and personalizing offerings. Offering incentives for customers to upgrade subscriptions can also help to retain them. Another effective strategy is identifying customers with a high propensity to churn and offering them personalized incentives to reduce the likelihood of cancellation. Overall, tracking churn rate is crucial for subscription-based businesses to maintain profitability and grow sustainably. By reducing churn, businesses can increase customer lifetime value and improve their bottom line.</p><h3>Customer Retention</h3><p>Introduction Subscription-based businesses have become increasingly popular, and data-driven analysis is crucial for their growth and success. By leveraging leading indicators, businesses can make informed decisions and tailor their strategies to meet the unique needs and interests of their subscribers. Customer Retention Customer retention is a critical aspect of subscription-based business. Retaining a customer is much more cost-effective than acquiring a new one. Hence, customer retention should be a top priority for any subscription-based business. There are several strategies that businesses can use to retain their customers. One such strategy is providing excellent customer service. Customers want to feel valued and heard, and businesses that take the time to address their concerns and provide solutions are more likely to retain customers. Building emotional connections with customers can also be an effective way to retain them. Tracking key metrics is another way businesses can improve customer retention. For example, monitoring churn rates, or the percentage of customers who stop using a service, can help businesses identify issues and opportunities for improvement. Customer satisfaction surveys and feedback can also provide valuable insights that businesses can use to tailor their offerings and improve retention. In summary, customer retention is vital for the success of any subscription-based business. Strategies such as providing excellent customer service, building emotional connections with customers, and tracking key metrics can help businesses retain their customers and grow their business.</p><h3>Customer Lifetime Value</h3><p>Imagine you’re a new subscriber to a streaming service. You’re excited to explore and binge-watch all your favourite shows, unaware of the strategy behind the launch of this subscription business. Enter Customer Lifetime Value (CLV), one of the most critical leading indicators for data-driven analysis of subscription-based business. CLV is the total value a customer brings to a business throughout their relationship with the brand. After all, customers are the lifeblood of any business, including subscription-based businesses. In simpler terms, the longer a customer stays subscribed to your service, the more revenue they generate for your business. Calculating CLV involves determining the average subscription length and multiplying that by the monthly recurring revenue (MRR). Do you see where we’re going with this? MRR, another leading indicator for subscription-based business, comes into play here. It’s the amount of subscription revenue a business generates per month. Now, let’s get to the fun part of increasing CLV — upselling and cross-selling. Upselling is when a business encourages customers to purchase a higher-priced subscription plan with more features. Cross-selling is when a business suggests additional services or products that complement their subscribed plan. Ever bought a combo meal at a fast-food chain? There you go, cross-selling in action! If done correctly, upselling and cross-selling have the potential to increase CLV significantly. However, be careful not to come across as too pushy or aggressive when promoting additional products or services. Customers must feel like they’re adding value to their subscription and not being coerced into purchasing more. Remember, it’s all about keeping your subscribers engaged, satisfied, and loyal to your brand. CLV helps businesses identify profitable customer segments and develop effective retention strategies. So, keep an eye on this leading indicator and work on increasing your customer’s length of subscription.</p><h3>Customer Acquisition Cost</h3><p>Acquiring customers can be an expensive undertaking for any business, and subscription-based companies are no exception. That’s why understanding your customer acquisition cost (CAC) is critical for the success of your business. Your CAC is the total cost of resources you spend to acquire a new customer. This includes all your marketing efforts, advertising campaigns, referral programs, and any other sales activities that focus on garnering new subscribers. An effective way to calculate your CAC is to divide your total acquisition costs by the number of new customers during a particular period. Once you know your average CAC, you can gauge how profitable your business is and make informed marketing decisions. One way to reduce your CAC is by offering a referral program. Encourage your current subscribers to invite their friends, family, and colleagues to become members. A referral program is a great way to leverage your existing customer base and earn new subscribers. With this method, your current users become advocates, recommending your service to their network. Alongside referral programs, you can use various marketing strategies such as targeted advertising, social media marketing, email newsletters, and other methods to get new subscribers to sign up. Reducing your CAC can increase your subscription-based business’s profitability, but it’s also essential to monitor your CAC regularly. Keeping an eye on the trends allows you to adjust your strategy and keep your business growing. Suppose you see a sudden spike in the customer acquisition costs. In that case, it may result from a shift in the market, a change in consumer behavior, or a problematic ad campaign. Regular monitoring of your CAC ensures that you can adjust your tactics and keep the cost to acquire a new customer low. While CAC is important, it’s essential to consider it within the context of your business goals. You may be willing to pay a higher CAC if the customers you acquire predict higher lifetime value or help you reach other strategic goals. In conclusion, tracking your subscription-based business’s CAC is critical for your business’s success. To reduce your CAC, leverage your existing customer base with referral programs, and use effective marketing strategies to attract new subscribers. Regular monitoring of your CAC provides you with the right information to adjust your tactics and keep your customer acquisition costs low.</p><h3>Monthly Recurring Revenue</h3><p>Monthly Recurring Revenue is a crucial metric for measuring the health and growth of a subscription-based business. MRR is the total revenue generated by your business each month from recurring subscriptions. It is a key metric for tracking the overall health of a subscription-based business. Calculating MRR is vital for predicting future revenue, and it provides a clear picture of the impact of new customers, upgrades, and cancellations on your business. MRR is calculated by multiplying the total number of subscribers by the average monthly fee. This figure reflects the recurring revenue that each customer contributes to your business. The Importance of MRR for subscription business growth cannot be overstated. It is an essential indicator that provides insights into the overall customer base health and the trajectory of business growth. MRR is vital in determining revenue growth and identifying subscription revenue trends, which are key factors to be considered for business growth. To maximize MRR, you need to focus on increasing the number of subscribers and the revenue generated per customer. It’s essential to track MRR regularly to determine if your business is growing, stagnating, or declining. With accurate calculations and interpretation, MRR provides a clear overview of your business model’s sustainability and is critical to long-term stability and profit growth.</p><h3>Conclusion</h3><p>In summary, a subscription-based business needs to pay attention to key indicators for proper data-driven analysis. By keeping track of the churn rate, customer retention, customer lifetime value, customer acquisition cost, and monthly recurring revenue, a business can make better decisions that lead to growth and success. Churn refers to the number of customers who stop subscribing to a service. Monitoring churn rate helps identify areas that need improvement, and businesses can employ various strategies, such as improving customer support, offering incentives to stay, and simplifying sign-up processes. Customer retention is crucial as it costs more to acquire new customers than retain existing ones. Businesses can use strategies such as personalized communication, exclusive content, and excellent customer service to increase retention rates. The customer lifetime value measures the total worth of a customer throughout their subscription period. Upselling and cross-selling can help increase this value, resulting in better revenue and profits. Calculating the customer acquisition cost enables businesses to know how much it costs them to secure a new customer. Leveraging referral programs and effective marketing strategies can help reduce this cost. Lastly, monitoring monthly recurring revenue indicates the overall health of a subscription business. Increasing this revenue requires businesses to balance customer acquisition and retention, pricing, and offering additional value. In conclusion, staying on top of these key indicators allows subscription-based businesses to make data-driven decisions that lead to growth and success. By understanding and improving churn rate, customer retention, customer lifetime value, customer acquisition cost, and monthly recurring revenue, businesses can optimize for sustainable revenue growth.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=7693dc043297" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Data Management Made Easy with PostgreSQL]]></title>
            <link>https://medium.com/@marcheyp/data-management-made-easy-with-postgresql-c32182ffdfc8?source=rss-695a35bebbfb------2</link>
            <guid isPermaLink="false">https://medium.com/p/c32182ffdfc8</guid>
            <category><![CDATA[data-management]]></category>
            <category><![CDATA[postgresql]]></category>
            <category><![CDATA[database]]></category>
            <category><![CDATA[data]]></category>
            <dc:creator><![CDATA[Marc Heymann]]></dc:creator>
            <pubDate>Wed, 12 Jul 2023 14:40:00 GMT</pubDate>
            <atom:updated>2023-07-12T14:40:00.819Z</atom:updated>
            <content:encoded><![CDATA[<h4>A beginners guide to PostgreSQL</h4><h3>Introduction</h3><p>Are you tired of struggling with managing your data? Worry no more! PostgreSQL is here to make your life easier. PostgreSQL is an open-source relational database management system that can efficiently handle complex data and transactions. What makes PostgreSQL stand out from other database management systems is its ability to handle extensive concurrency and high-speed data transactions without compromising on the data integrity. With PostgreSQL, you can easily create and manipulate your database, retrieve and analyze data, and even backup and restore your database with ease. From small businesses to large organizations, PostgreSQL is the go-to solution for effective data management. So, what are you waiting for? Join the PostgreSQL community and simplify your data management today!</p><h3>Installation and Configuration</h3><p>Installation and Configuration: One of the most critical steps in using PostgreSQL for data management is its installation and configuration. Before installing, you must ensure that your system meets the necessary requirements for the latest stable version of PostgreSQL. It includes Linux, Unix-like systems, and Windows operating systems. PostgreSQL requires a few system resources like RAM, available disk space, and processing power; therefore, it is advised to allocate such resources in a way that it doesn’t affect other system components. Once the system requirements are met, downloading and installing PostgreSQL is a smooth process. You can download the binary installer from the official PostgreSQL website, and it installs just like any other application on your PC. If you are using a command-line interface, you can use apt-get in Linux systems or a package installer in Windows systems. Configuring PostgreSQL is also vital for optimal performance. It can be configured to start automatically when a system is booted up, or it can be done manually. Configuration files can be found in $PGDATA/pg_hba.conf or $PGDATA/postgresql.conf, and they customize various aspects of PostgreSQL, like logging levels, buffer pool size, system memory and CPU utilization, connection authentication, and many more. PostgreSQL allows you to customize your installation based on your needs and conditions. It offers several configuration parameters to optimize startup time, tuning of memory, buffer allocation, and I/O optimization. A lot of configurable parameters are available to tune the PostgreSQL optimizer. This ensures that your PostgreSQL works optimally for your organization’s specific requirements.</p><h3>Creating Databases and Tables</h3><p>Are you tired of manually managing your data? Don’t worry, PostgreSQL has got your back! With PostgreSQL, creating databases and tables becomes a walk in the park. First things first, let’s start with creating a database. You can do this by running a simple command that creates a new database. Once your database is created, you can proceed to create tables in it. This involves defining the attributes of the table such as the name of the table, the columns, and the data types. Adding and modifying data involves inserting rows of data into the tables. With PostgreSQL, you can do this by running a simple INSERT query. After adding the data, you can proceed to modify it using UPDATE queries. In addition to these basic features, PostgreSQL offers advanced features such as Views and Materialized Views to simplify your data management process. Views are virtual tables that are derived from existing tables, while materialized views are actual tables created from the results of querying views. You can also use indexes to speed up data retrieval and triggers to automate tasks when certain events occur. Lastly, backup and restoration of your data is a critical aspect of data management. PostgreSQL offers backup and restoration capabilities to help you avoid data loss. You can back up your database by creating a backup file, which you can use to restore your database in case of a failure. With PostgreSQL, creating databases and tables, adding and modifying data, and retrieving data becomes a breeze. So don’t sweat it, hop on the PostgreSQL train and let it do all the work for you.</p><h3>Data Retrieval and Manipulation</h3><p>Data Retrieval and Manipulation: Now that you have created your database and tables, it’s time to retrieve the data you have stored in them. Basic queries are the backbone of any data management system, and PostgreSQL makes it a breeze. By using the SELECT statement, you can extract specific columns or rows from a table. You can also filter data based on one or more conditions using the WHERE clause. Don’t worry; you don’t have to be a SQL expert to master it! PostgreSQL also allows you to sort your data using the ORDER BY clause. You can specify the required sorting order either ASC (Ascending) or DESC (Descending). Sorting is a crucial aspect of data management, and PostgreSQL makes it very easy to perform. Joining multiple tables is another powerful feature provided by PostgreSQL. The JOIN clause allows you to combine data from two or more tables based on a related column. This feature is especially useful when handling large data sets that are distributed across different tables. Overall, PostgreSQL provides a range of tools that make it easy to retrieve and manipulate data. Whether you’re a database administrator or a developer, PostgreSQL can help you manage your data with ease.</p><h3>Advanced Features</h3><p>When it comes to PostgreSQL, there are some advanced features that can take your data management to the next level. Views and materialized views, indexes, triggers, and stored procedures are powerful tools that can help you optimize your database and automate repetitive tasks. Views and materialized views are virtual tables that allow you to query the database as if it was a regular table. The difference is that a view is a saved query that is executed every time you run it, while a materialized view is a physical copy of the query’s result, which can be refreshed periodically. Indexes are structures that speed up data retrieval by allowing you to find specific rows in a table faster. They work by sorting and organizing the data in a way that makes it faster to search. Triggers are custom-made actions that are executed automatically when certain events occur in the database. For example, you can create a trigger that updates a summary table every time a new row is inserted into a specific table. Stored procedures are reusable blocks of code that can be executed on demand. They are useful for automating complex data management tasks that involve multiple steps. By mastering these advanced features, you can make PostgreSQL work for you and provide a smoother and more efficient data management experience overall. Whether you’re working with a small dataset or a massive enterprise database, these features can help you save time and increase productivity. So why not give PostgreSQL a try? With its comprehensive set of features and a vibrant community, this versatile database engine can help you manage your data with ease.</p><h3>Backup and Restoration</h3><p>Backing up and restoring data is an essential aspect of database management. With PostgreSQL, creating backups is as easy as running a single command. The `pg_dump` utility allows us to extract the schema and data of a database to a file, which can later be used as a backup. When it comes to restoring a database from backup, PostgreSQL provides us with the `pg_restore` utility, which is used to reconstruct a PostgreSQL database from an archive created by `pg_dump`. By including the ` — clean` option, we can ensure that the database is completely emptied before restoring its contents. This feature helps prevent inconsistent states in the database. Once you have the backup file, you can restore the data to your PostgreSQL installation using various tools like `pg_restore`, `psql`, and other similar utilities. Whether you want to backup data on a regular basis or just before making changes to the database, PostgreSQL makes the process easy and efficient.</p><h3>Conclusion</h3><p>In conclusion, PostgreSQL is a reliable and efficient data management system that offers numerous benefits to its users. With PostgreSQL, you can easily create and manipulate databases and tables, retrieve and filter data, and use advanced features like views and triggers. In addition, PostgreSQL provides an easy-to-use backup and restoration system for all your important data. With all these benefits, it’s no wonder why PostgreSQL is a popular choice for data management. So why not give it a try and see for yourself how easy data management can be?</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=c32182ffdfc8" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Leading and Lagging Indicators 101]]></title>
            <link>https://medium.com/@marcheyp/leading-and-lagging-indicators-101-c546c0e4ae10?source=rss-695a35bebbfb------2</link>
            <guid isPermaLink="false">https://medium.com/p/c546c0e4ae10</guid>
            <category><![CDATA[metrics]]></category>
            <category><![CDATA[business-intelligence]]></category>
            <category><![CDATA[data]]></category>
            <category><![CDATA[kpi]]></category>
            <category><![CDATA[reporting]]></category>
            <dc:creator><![CDATA[Marc Heymann]]></dc:creator>
            <pubDate>Wed, 26 Apr 2023 06:02:09 GMT</pubDate>
            <atom:updated>2023-04-26T06:02:09.973Z</atom:updated>
            <content:encoded><![CDATA[<h4>Leverage your indicators by detecting what explained and what will explain your business performance.</h4><p>When it comes to measuring the success of a business or organization, indicators are used to track progress and identify areas for improvement. Two common types of indicators are <strong>leading</strong> and <strong>lagging</strong> indicators. While both are important, they serve different purposes and can provide different insights.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*8WKubfbfR2_Mi5He6vChfQ.png" /><figcaption>Leading and lagging. Image generated by DALL-E.</figcaption></figure><h3>Leading Indicators.</h3><p>Leading indicators are measures that provide insight into future performance. They are forward-looking and predictive, and are often used to anticipate trends and changes before they happen. Examples of leading indicators include employee engagement surveys, customer satisfaction surveys, and sales pipelines. These indicators can help organizations identify potential problems before they occur, allowing them to take proactive steps to address them.</p><p>Here are some detailed examples of leading indicators for a standard e-commerce retail business:</p><ol><li>Website Traffic: Tracking the number of visitors to your e-commerce website is a leading indicator that can help you anticipate future sales trends. You can use web analytics tools to monitor website traffic and identify any changes in customer behavior.</li><li>Conversion Rates: Conversion rates indicate the percentage of website visitors who actually make a purchase. By tracking this metric, you can identify areas for improvement in your website design, product offerings, and marketing campaigns.</li><li>Cart Abandonment Rates: Cart abandonment occurs when customers add products to their online shopping cart but then leave the site without completing the purchase. By tracking this metric, you can identify any friction points in your checkout process and take steps to reduce abandonment rates.</li></ol><p>Here are some detailed examples of leading indicators for a SaaS business:</p><ol><li>Free Trial Sign-ups: Free trials are a common way for SaaS businesses to attract new customers. By tracking the number of free trial sign-ups, SaaS businesses can gain insight into how effective their marketing campaigns are at attracting new leads.</li><li>User Engagement: User engagement measures how often users interact with your product or service. This metric can help you identify how often users are logging in, which features are most popular, and where there may be opportunities to improve the user experience.</li><li>Net Promoter Score: The Net Promoter Score (NPS) is a metric that measures customer loyalty by asking customers how likely they are to recommend your product or service to others. A high NPS indicates satisfied customers who are likely to be long-term customers.</li></ol><p>If a company does not track and report leading indicators, they risk missing early warning signs of potential issues or missed opportunities for growth. Leading indicators provide forward-looking insights into a business’s performance and help to identify trends and potential areas for improvement.</p><p>Without tracking and reporting leading indicators, a company may not be able to identify issues that are emerging, such as declining website traffic, low conversion rates, or poor customer engagement. This can result in missed opportunities to take corrective action before the issues become more significant.</p><p>Moreover, leading indicators are often used to make strategic decisions and allocate resources within a company. If a company does not track and report leading indicators, they may not be able to make informed decisions based on data-driven insights, which could lead to ineffective strategies or inefficient resource allocation.</p><h3>Lagging Indicators.</h3><p>Lagging indicators, are measures that provide insight into past performance. They are backward-looking and reactive, and are often used to evaluate the effectiveness of past actions or decisions. Examples of lagging indicators include financial statements, customer retention rates, and employee turnover rates. While lagging indicators are important for evaluating past performance, they do not provide insight into future performance.</p><p>Here are some detailed examples of lagging indicators for a standard e-commerce retail business:</p><ol><li>Sales Revenue: This is a key lagging indicator that measures the total amount of sales revenue generated by your e-commerce business. By tracking this metric over time, you can assess the effectiveness of your marketing campaigns and product offerings.</li><li>Average Order Value: This metric measures the average amount spent by customers on each order. By tracking this metric, you can identify opportunities to increase revenue by encouraging customers to add more products to their shopping carts.</li><li>Return Rates: Return rates indicate the percentage of products that are returned by customers. High return rates can be an indicator of quality issues with your products or a mismatch between customer expectations and product descriptions.</li></ol><p>Here are some detailed examples of lagging indicators for a SaaS business:</p><ol><li>Monthly Recurring Revenue (MRR): MRR is a key metric for SaaS businesses that measures the amount of revenue generated from subscriptions on a monthly basis. By tracking MRR, SaaS businesses can identify revenue trends over time and assess the effectiveness of their pricing strategies.</li><li>Churn Rate: Churn rate measures the percentage of customers who cancel their subscription or stop using your product or service. High churn rates can indicate issues with product quality, poor customer support, or ineffective pricing strategies.</li><li>Customer Acquisition Cost (CAC): CAC measures the cost of acquiring new customers through marketing and sales efforts. By tracking CAC, SaaS businesses can identify how much they are spending to acquire new customers and assess the effectiveness of their marketing and sales strategies.</li></ol><p>Very soon I’ll have a dedicated post to MRR.</p><p>If a company does not track and report lagging indicators, they risk missing important insights into their past performance and may not be able to identify trends or areas for improvement. Lagging indicators provide a retrospective view of a business’s performance over a specific period, and as such, they are essential for assessing the effectiveness of past strategies and making data-driven decisions for the future.</p><p>Without tracking and reporting lagging indicators, a company may not be able to identify issues that have already occurred, such as high customer churn rates, low customer retention, or declining sales. This can result in missed opportunities to improve the company’s strategies, products, or services to prevent further losses.</p><p>Moreover, lagging indicators are often used as performance benchmarks by investors, analysts, and other stakeholders. A company that does not track and report lagging indicators may not be able to demonstrate its past performance to these stakeholders, which could lead to a lack of confidence in the company’s future prospects and potential missed investment opportunities.</p><h3>How to identify you own leading and lagging indicators?</h3><p>To detect leading indicators, businesses should adopt a proactive approach to data analysis and focus on identifying metrics that have a strong correlation with their desired outcomes. Here are some strategies to consider:</p><ol><li>Set clear goals: Before identifying leading indicators, businesses must define their goals and objectives. This will help to identify the key performance indicators (KPIs) that are most relevant to their business.</li><li>Analyze historical data: Analyzing historical data can help to identify patterns and correlations between different metrics. By looking at the data over time, businesses can identify potential leading indicators that have a strong correlation with their desired outcomes.</li><li>Conduct A/B testing: A/B testing involves comparing two versions of a website, product, or service to see which performs better. By testing different variables and tracking the results, businesses can identify leading indicators that have a strong impact on their desired outcomes.</li><li>Monitor social media and customer feedback: Social media and customer feedback can provide valuable insights into customer behavior and sentiment. By monitoring social media and customer feedback, businesses can identify potential leading indicators, such as changes in customer sentiment or spikes in complaints or inquiries.</li><li>Use predictive analytics: Predictive analytics involves using statistical algorithms to analyze historical data and predict future trends. By using predictive analytics, businesses can identify potential leading indicators that have a strong correlation with their desired outcomes.</li></ol><p>To detect lagging indicators, businesses should take a retrospective approach to data analysis and focus on identifying metrics that are most relevant to their past performance. Here are some strategies to consider:</p><ol><li>Analyze historical data: Analyzing historical data is crucial for identifying lagging indicators. By looking at past performance over a specific period, businesses can identify metrics that have a strong correlation with their desired outcomes and use them as lagging indicators.</li><li>Conduct trend analysis: Trend analysis involves looking at past performance over time and identifying patterns and trends. By analyzing trends, businesses can identify potential lagging indicators, such as declining sales, increased customer churn, or declining customer satisfaction.</li><li>Use benchmarking: Benchmarking involves comparing a company’s performance with industry standards or best practices. By benchmarking their performance, businesses can identify potential lagging indicators and use them to identify areas for improvement.</li><li>Track customer feedback: Tracking customer feedback, such as customer satisfaction surveys, can provide valuable insights into past performance. By monitoring customer feedback, businesses can identify potential lagging indicators, such as declining customer satisfaction or increasing complaints.</li><li>Conduct post-mortem analysis: Post-mortem analysis involves analyzing the results of a project or initiative after its completion. By conducting post-mortem analysis, businesses can identify potential lagging indicators, such as missed targets, cost overruns, or delays.</li></ol><h3>I don’t want to track them separately. Or track them at all.</h3><p>If a company does not track leading and lagging indicators separately, they risk missing out on valuable insights into their business performance. Leading and lagging indicators provide different perspectives on a company’s performance, and tracking them separately helps to identify early warning signs of potential issues or missed opportunities for growth.</p><p>If leading and lagging indicators are not tracked separately, a company may not be able to identify trends or patterns that are emerging, or understand the impact of changes made in response to leading indicators. This can result in missed opportunities to take corrective action before issues become more significant, or to capitalize on opportunities for growth.</p><p>Without tracking and reporting lagging indicators, a company may not be able to identify issues that have already occurred, such as high customer churn rates, low customer retention, or declining sales. This can result in missed opportunities to improve the company’s strategies, products, or services to prevent further losses. Without tracking and reporting leading indicators, a company may not be able to identify issues that are emerging, such as declining website traffic, low conversion rates, or poor customer engagement. This can result in missed opportunities to take corrective action before the issues become more significant.</p><h3>How often should be they reported?</h3><p>The reporting frequency and format for leading and lagging indicators may vary depending on the specific business and its goals. However, it is generally recommended to report leading indicators more frequently than lagging indicators.</p><p>Leading indicators are forward-looking and can help businesses anticipate future trends and make proactive changes to their strategies. As a result, they should be monitored regularly, typically on a weekly or monthly basis. Lagging indicators, on the other hand, provide a retrospective view of a business’s performance over a specific period, and as such, they do not require the same level of frequent monitoring.</p><p>In terms of reporting format, leading indicators are typically presented in a dashboard format or in real-time, so businesses can quickly assess their performance and identify any areas for improvement. Lagging indicators, on the other hand, are usually presented in a monthly or quarterly report that provides a more comprehensive view of the business’s performance over a longer period.</p><p>In a nutshell, leading and lagging indicators are both important tools for measuring the success of an organization. While they serve different purposes, they can be used together to provide a comprehensive view of an organization’s performance. When choosing which indicators to track, it is important to consider the specific goals and objectives of the organization, and to use a combination of leading and lagging indicators to gain a complete understanding of performance.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=c546c0e4ae10" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Do you Excel?]]></title>
            <link>https://medium.com/@marcheyp/do-you-excel-b99b3f65cfd1?source=rss-695a35bebbfb------2</link>
            <guid isPermaLink="false">https://medium.com/p/b99b3f65cfd1</guid>
            <category><![CDATA[data]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[excel]]></category>
            <dc:creator><![CDATA[Marc Heymann]]></dc:creator>
            <pubDate>Mon, 24 Apr 2023 09:49:10 GMT</pubDate>
            <atom:updated>2023-04-24T09:49:10.120Z</atom:updated>
            <content:encoded><![CDATA[<h4>Let’s shade some light on the eternal discussion: do I need to know Excel in order to success as an analyst?</h4><p>Excel is a spreadsheet software application that is widely used in many industries, including finance, accounting, and data analysis. However, there are differing opinions on whether Excel should be considered an essential skill for data analysts or data scientists. In this post, we will examine arguments for and against having Excel as part of the skill set of a data analyst or data scientist.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*d4CL4CQyRLTEwAif-FMS3w.png" /><figcaption>Image generated by Dall-E. Taking a decision is hard.</figcaption></figure><p>Arguments in favor of having Excel skills:</p><ol><li>Versatility: Excel is a versatile tool that can be used for a wide range of tasks, from data entry to complex data analysis. Its ability to handle large datasets and perform statistical analysis makes it a valuable tool for data analysts and data scientists.</li><li>Accessibility: Excel is widely available and affordable, which makes it accessible to users with varying levels of expertise. Its user-friendly interface and extensive documentation make it easy to learn and use for beginners.</li><li>Time-efficient: Excel can help save time when dealing with large datasets. Its ability to automate repetitive tasks and perform complex calculations allows data analysts and data scientists to focus on more important aspects of their work.</li><li>Visualization: Excel offers a range of data visualization tools that allow users to create charts, graphs, and other visual representations of data. This can help communicate insights and findings to stakeholders more effectively.</li></ol><p>Arguments against having Excel skills:</p><ol><li>Limited capabilities: While Excel is a versatile tool, it has limitations when it comes to handling large datasets or performing complex analysis. It may not be suitable for certain tasks that require more advanced software or programming languages.</li><li>Error-prone: Excel is prone to errors, particularly when dealing with large datasets or complex calculations. This can lead to incorrect results and analysis, which can have serious consequences.</li><li>Reproducibility: Excel lacks the ability to track changes and reproduce analyses, which can make it difficult to replicate findings or ensure accuracy.</li><li>Not scalable: Excel is not designed for large-scale projects, and its lack of scalability can limit its usefulness in certain contexts.</li></ol><h3>But, what about my “clients”?</h3><p>Another important aspect to consider when discussing the use of Excel in data analysis and data science is the role of Business Intelligence (BI). BI works as a service layer within a company, providing insights and information to stakeholders in a way that can be easily consumed and acted upon.</p><p>One of the key advantages of BI is its ability to adapt to the way stakeholders consume information. BI tools provide a range of visualizations and dashboards that can be customized to meet the needs of different users, from executives to analysts. This allows stakeholders to access the insights they need in a format that is easy to understand and act upon.</p><p>In this context, Excel can be a valuable tool for data analysts and data scientists working within a BI framework. Excel’s ability to handle large datasets and perform statistical analysis, coupled with its wide availability and user-friendly interface, make it a useful tool for creating reports and dashboards that can be consumed by stakeholders.</p><p>However, it is important to note that Excel should not be relied upon as the sole tool for BI. As mentioned earlier, Excel has limitations when it comes to handling large datasets or performing complex analysis. In addition, relying solely on Excel can lead to issues with reproducibility and scalability, as well as potential errors in analysis.</p><p>When stakeholders are used to consuming data through Excel, there can be downsides to imposing a non-Excel way of consuming data. Here are a few potential downsides to consider:</p><ol><li>Familiarity: Stakeholders may be very familiar with Excel and may prefer to consume data in this format. If they are not comfortable with a new tool or format, they may be less likely to use it, which could lead to a lack of adoption.</li><li>Resistance to change: Changing the way stakeholders consume data can be a significant change, which may be met with resistance. This can be particularly true if the change is not well-explained or if stakeholders do not understand the benefits of the new tool or format.</li><li>Training: Introducing a new tool or format may require training stakeholders, which can be time-consuming and costly. If stakeholders are already busy with other tasks, they may be resistant to taking time to learn a new tool or format.</li><li>Compatibility: Depending on the new tool or format, there may be compatibility issues with other systems or tools that stakeholders are already using. This can lead to additional technical issues that need to be resolved.</li><li>Cost: Some non-Excel tools or formats may be costly, which could be a barrier to adoption. This can be particularly true for smaller organizations or those with limited budgets.</li></ol><p>It’s important to note that while there may be downsides to imposing a non-Excel way of consuming data, there are also potential benefits. For example, non-Excel tools may offer greater functionality, better security, or more scalability. The key is to carefully consider the needs of stakeholders and the goals of the organization when deciding on the best tool or format for consuming data.</p><p>In conclusion, while Excel has many advantages for data analysts and data scientists, it is not without its limitations. Whether or not Excel should be considered an essential skill for data analysts or data scientists ultimately depends on the specific needs of the job and the context in which it is being used. As such, it is important for data analysts and data scientists to be familiar with a range of tools and techniques in order to choose the most appropriate tool for a given task.</p><h3>Ok, let’s learn a bit</h3><p>There are many resources available for learning Excel, ranging from free online tutorials to paid courses and certifications. Here are some of the best resources to master Excel:</p><ol><li>Microsoft Excel Documentation: The official Microsoft Excel documentation is a great resource for learning Excel. It includes tutorials, how-to guides, and documentation for all Excel functions.</li><li>YouTube tutorials: YouTube has a wealth of free tutorials and courses for learning Excel, including channels such as ExcelIsFun, MyExcelOnline, and Excel Campus.</li><li>LinkedIn Learning: LinkedIn Learning offers a range of courses and tutorials on Excel, from beginner to advanced levels. It also provides certificates of completion that can be added to your LinkedIn profile.</li><li>Coursera: Coursera offers online courses on Excel and data analysis from top universities and organizations, including the University of Colorado Boulder and IBM.</li><li>Udemy: Udemy offers a wide range of paid Excel courses, from beginner to advanced levels. They often have sales and discounts, making it an affordable option for those on a budget.</li><li>Excel forums and communities: Excel forums and communities, such as MrExcel, Excel Forum, and Reddit’s r/Excel, are great places to ask questions and get help from other Excel users.</li><li>Practice exercises and challenges: To master Excel, it’s important to practice regularly. Sites like Excel Easy and ExcelChamps offer free practice exercises and challenges to help you hone your skills.</li></ol><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=b99b3f65cfd1" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>