Lesson 1Sales performance metrics: units sold, average order value, conversion rateDis part explain sales performance KPIs like units sold, AOV, and conversion rate. You go connect funnel steps to metrics, divide results by channel and product, and use trends to find problems with pricing, assortment, and UX.
Traffic, sessions, and visit qualityDefining and measuring conversion rateAverage order value and driversUnits per transaction and basket sizeSegmenting sales KPIs by channelLesson 2Three to five additional retail BI KPIs discovered via research (examples: basket affinity, markdown rate, lost sales estimate)Dis part bring advanced retail BI KPIs like basket affinity, markdown rate, and lost sales estimates. You go see how dis metrics show behavior, make pricing and assortment better, and add to main operation KPIs.
Basket affinity and cross-sell analysisMarkdown rate and price realizationEstimating lost sales from stock-outsIdentifying emerging KPIs from dataPrioritizing new KPIs for deploymentLesson 3Gross margin, margin by product and promotion, and contribution marginDis part explain gross margin, margin by product and promotion, and contribution margin. You go link revenue, discounts, and costs to profit, and use margin KPIs to guide pricing, assortment, and promo spending decisions.
Gross margin vs markup definitionsAllocating discounts and promo spendMargin by product, category, and channelContribution margin and fixed costsPromo margin and cannibalization impactLesson 4Customer metrics: return rate, repeat purchase rate, customer lifetime value (CLV)Dis part cover customer KPIs like return rate, repeat purchase rate, and CLV. You go divide customers, track life value, and connect customer metrics to getting new ones, keeping dem, and making experience better.
Return rate by product and channelRepeat purchase and retention cohortsCLV models and key assumptionsCustomer segmentation by valueLinking CX initiatives to KPIsLesson 5Channel and campaign metrics: channel attribution, marketing ROI, CACDis part cover marketing channel and campaign KPIs, like attribution, CAC, and ROI. You go see how to track spending, check performance across channels, and link marketing metrics to sales and profit wey come after.
Single- vs multi-touch attribution modelsCalculating CAC by channel and campaignMarketing ROI and incremental liftAttribution data requirements and qualityOptimizing budget allocation by KPILesson 6Fulfillment and operations metrics: order cycle time, on-time delivery, fulfillment cost per orderDis part look at fulfillment and operations KPIs like order cycle time, on-time delivery, and fulfillment cost per order. You go connect service levels and cost, and use metrics to make logistics, staffing, and process better.
Order cycle time componentsOn-time delivery and SLA adherenceFulfillment cost per order driversPick, pack, and ship productivityBalancing speed, cost, and qualityLesson 7Revenue and revenue segmentation (what it measures, why it matters, data sources)Dis part define revenue and revenue segmentation KPIs, saying wetin dem measure, why e matter, and main data sources. You go cut revenue by channel, product, and customer to find growth and mix better chances.
Recognized vs booked revenue rulesRevenue by channel and store typeProduct and category revenue mixCustomer and region revenue splitsUsing segmentation to find growthLesson 8Metric definitions and calculation rules to ensure consistencyDis part focus on defining metrics and calculation rules to keep everything same. You go standardize formulas, time periods, and filters, manage KPI versions, and write definitions so everybody read dashboards di same way.
Creating a KPI dictionary and ownersStandardizing formulas and filtersHandling returns, cancels, and fraudVersioning and deprecating KPIsGovernance for KPI changesLesson 9Inventory metrics: stock level, stock-out rate, days of inventory, sell-through rateDis part detail inventory KPIs like stock level, stock-out rate, days of inventory, and sell-through. You go connect dis metrics to restocking, sharing, and markdown decisions, balancing availability, cost, and working money.
On-hand vs available-to-sell stockMeasuring stock-out rate and lost demandDays of inventory and coverage targetsSell-through rate by product and channelInventory KPIs for replenishment rulesLesson 10Mapping each KPI to required source systems (POS, e-commerce, ERP, WMS, CRM, web analytics)Dis part map each KPI to its needed source systems, like POS, e-commerce, ERP, WMS, CRM, and web analytics. You go find who own am, detail level, and delay time, and design data flows wey support steady, trusted KPI reports.
KPI-to-source system responsibility matrixPOS and e‑commerce transaction data needsERP and WMS links to cost and inventoryCRM and loyalty data for customer KPIsWeb analytics for traffic and behaviorLesson 11Financial health: net revenue retention, refunds and chargebacks impactDis part explore financial health KPIs like net revenue retention and impact of refunds and chargebacks. You go match revenue with cuts, watch for leaks, and link financial KPIs to customer and risk behaviors.
Net revenue retention componentsRefunds, returns, and allowancesChargebacks and dispute analyticsRevenue leakage root-cause analysisAligning finance and BI views
