Market Share KPI - survey data (volume, sales)

<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 sales and 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 survey data and extract date and time information.</p></li><li><p>Import competition prices</p></li><li><p>Count how many people responded "YES" to the survey</p></li><li><p>Multiply the number of units sold for medium price to get the market size </p></li><li><p>Multiple each product for its prize to calculate revenue</p></li><li><p>Apply both KPI formula</p></li><li><p>Create a visualization</p></li></ol>