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