Market Share KPI - survey data (volume)

<p>The market share KPI definition is: </p><p>"Measures the percentage of the target market accounted for by the business, from the overall existing market." </p><p>It can be measured by sales, <strong>your_sales / all_market_sales,</strong> or by volume, <strong>your_units_sold / all_market_unit<em>_</em>sold</strong></p><p>In this workflow we compute the market share KPI according to units sold in 2023, using data from a survey. We assume that customers only buy one product per year (ex. car, fridge).</p><p>We assume that the people who participated to the survey are representative of the population in the area.</p><p>These are the steps:</p><ol><li><p>Import data and extract date and time information</p></li><li><p>Count how many people responded "YES" to the survey</p></li><li><p>Count how many items were bought per product type</p></li><li><p>Apply the KPI formula</p></li><li><p>Create a visualization</p></li></ol>