The market share KPI definition is:
"Measures the percentage of the target market accounted for by the business, from the overall existing market."
It can be measured by sales, your_sales / all_market_sales, or by volume, your_units_sold / all_market_unit_sold
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).
We assume that the people who participated to the survey are representative of the population in the area.
These are the steps:
Import data and extract date and time information
Count how many people responded "YES" to the survey
Count how many items were bought per product type
Apply the KPI formula
Create a visualization