Market Share KPI - sales company 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 company sales data and survey data. 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 sales and 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 and what products they purchased </p></li><li><p>Compute revenue from sales data </p></li><li><p>Use the market share from the survey and the sales data to estimate the reference market </p></li><li><p>Apply both KPI formula</p></li><li><p>Create a visualization</p></li></ol>