Elective
Operational Analytics
Most cannabis operators read KPI files and learn what to measure, buy a platform and learn what is available, then stall before any of it turns into decisions. This course builds the operating system underneath the dashboards. You will commit to the four-layer dashboard architecture (operational, tactical, strategic, governance) before you draw a single chart, map every metric to one of the five tiers of the KPI hierarchy, and install the dual-currency discipline that gates every margin number in cannabis (reported on one line, cash-effective after 280E directly beneath it). You will build the data plumbing (POS, Metrc, loyalty, ecommerce, COA, labor, banking) with named source-of-truth assignments, integration patterns, the warehouse-or-not decision, and the identity resolution layer that keeps the phone-number join above the 75 percent floor. You will design dashboards by the decision they inform, prune the ones that have not been touched in 90 days, and run the daily floor walk, the weekly KPI standup, the monthly P&L review, the quarterly five-axis scoreboard, and the annual strategy refresh as one layered rhythm. You will learn the category, customer, pricing, vendor, floor-operations, compliance, marketing-attribution, and real-estate analytical methods serious operators use, plus the forecasting and statistical discipline that separates signal from noise. The capstone walks a three-store Michigan independent from kickoff to operating cadence in twelve weeks: a 4,200-dollar-per-month platform stack, a 12-hour-per-week Operations Leader rhythm, and an annual analytics audit that keeps the function honest.
57 lessons21.6 hours0 section quizzes7 chapters
Begin courseFree during early access
What you'll master
Outcomes you can defend.
- Map any cannabis dispensary's analytics work to the four-layer dashboard architecture (operational, tactical, strategic, governance) and the five-tier KPI hierarchy, with every metric routed to one named owner and one decision context.
- Apply the dual-currency 280E discipline to every margin-touching dashboard so reported and cash-effective numbers appear side by side, and split medical from adult-use revenue at the line-item level for any dual-license operator.
- Design the cannabis data stack appropriate to the operator's stage (Launch, Growth, Multi-store, Portfolio), including the source-of-truth map, the integration patterns, the warehouse-or-not decision, the identity resolution layer, and the data-quality monitoring discipline.
- Build operational, tactical, strategic, and governance dashboards from decision-first principles, with a documented owner and a documented next-action per chart, and run a quarterly pruning discipline that retires 20 to 30 percent of the dashboard inventory annually.
- Run the layered analytics cadence (daily floor walk, weekly KPI standup, monthly P&L review, quarterly portfolio scoreboard, annual strategy refresh) as one operating system with documentation, action logs, and follow-through tracked to proof-numbers.
- Execute the category, customer, pricing, vendor, floor-operations, compliance, marketing-attribution, and real-estate analytical methods (ABC, GMROI, KSM, cohort retention, LTV, RFM, price elasticity, PMV decomposition, vendor scorecard, daypart productivity, Metrc reconciliation, multi-touch attribution, trade-area, cannibalization) with cannabis-specific adjustments.
- Forecast weekly revenue inside a 15 to 25 percent MAPE band, design A/B tests with pre-registered sample sizes, read control charts to separate signal from noise, and reject vanity-metric recommendations that fail the dual-currency or cohort-cohort check.
- Run the annual analytics audit across six failure families (measurement, display, decision, cadence, governance, culture) and stand up a 12-week corrective plan that prevents the named failure modes from compounding into a year of bad decisions.
Curriculum
The full syllabus.
Every lesson, in the order we recommend you take them. Click any lesson to begin. Your progress saves automatically.
Part 01
6 lessons • 134 minFoundations: The Analytics Operating System
- 01The Four-Layer Dashboard Architecture: Operational, Tactical, Strategic, GovernanceEvery dispensary analytics surface belongs to one of four layers, each with a named cadence, audience, and decision. Layer 1 (Operational, 4-15 minute refresh) drives the floor; Layer 2 (Tactical, daily-to-weekly) drives shift-level decisions; Layer 3 (Strategic, monthly) drives investment and strategy; Layer 4 (Governance, quarterly to annual) audits the operating system itself. Mixing layers is the single most common analytics failure.20 min
- 02The Five-Tier KPI Hierarchy and the Stage LadderThe five-tier KPI hierarchy is the index every Operations Leader walks day by day and quarter by quarter. Tier 1 floor signals beat the dashboard by 30 to 60 days; Tier 5 catches portfolio drift the consolidated rollup hides. This lesson maps cannabis KPIs to tiers, then gates tier choice against the Launch / Growth / Mature stage ladder so the operator stops measuring metrics the cohort tenure cannot support.26 min
- 03The Dual-Currency Discipline: Reported and Cash-Effective Side by SideEvery margin-touching number in a cannabis dispensary runs in two currencies, and any single-currency view on adult-use revenue is recommending in the wrong currency. A 50 to 55 percent reported gross margin on adult-use revenue typically compresses to 25 to 32 percent cash-effective EBITDA margin after federal 280E tax on gross profit, with variance driven by the store's reported EBITDA profile (thin-margin stores compress toward zero or negative; healthy-margin stores land closer to 30 to 35 percent). This lesson installs the discipline that surfaces both denominators on every Tier 4 and Tier 5 dashboard, splits medical from adult-use at the line-item level post-April-2026, and treats the June 29, 2026 DEA hearing as upside rather than base case.23 min
- 04Segment-Cut Discipline: Group, Entity, Store, CategoryThe four canonical segment cuts every cannabis analytics function uses, and the fixed order they run in. Group first to anchor the aggregate; entity second because federal tax under 280E is calculated per entity; store third for operational execution; category fourth for strategic mix. Reading the cuts out of order, or stopping at the group view, is the most common multi-store analytics failure and the canonical source of multi-quarter capital misallocation.22 min
- 05Floor Reading Beats Dashboard by 30 to 60 DaysEvery cannabis KPI lags the floor by 30 to 60 days. The dashboard is the audit layer, not the early-warning layer. This lesson installs the eight leading signals the GM reads continuously during operating hours, the four-quadrant pre-open and close walk that surfaces them, and the architectural rule that prevents the most expensive misuse of analytics in cannabis retail.18 min
- 06The Analytics Maturity Model and the Analytics-Function Org DesignFour maturity stages map to the cannabis business stage ladder, and each stage names the platform stack, the headcount, and the cadence the operator can sustain. The cardinal mistake is buying a Stage 3 stack at Stage 1 or running a Stage 4 portfolio on a Stage 2 stack. The cardinal hiring rule: hire against pain (a broken operating cadence), not against revenue.25 min
Part 02
6 lessons • 138 minData Plumbing: Sources, Stack, and Identity
- 07The Cannabis Data Source Map and the Source-of-Truth AssignmentEvery cannabis analytics stack pulls from POS, Metrc, loyalty, ecommerce, COA, time-and-attendance, GL, and banking. The discipline is to name one source of truth per metric and forbid synthesis across sources without a documented join key. The 280E dual-currency mandate shapes every financial metric from month one. Most cannabis analytics failures live upstream of the dashboard, not in the math.20 min
- 08Integration Patterns and the Warehouse-or-Not DecisionThe four integration patterns that move POS, loyalty, Metrc, and benchmark data into your analytics stack, and the 5-hour-per-week heuristic that says when a warehouse stops being bloat and starts paying for itself. Walks the platform-by-platform cost bands at three operator scales and the refresh-cadence discipline that keeps you from paying real-time prices for weekly-reviewed metrics.25 min
- 09Transformation and Modeling: dbt, the Star Schema, and the 280E-Aware Fact TableThe transformation layer turns raw POS, Metrc, and loyalty exports into operator-ready facts and dimensions. This lesson installs dbt as the standard, builds the five-fact-table starter pattern, and walks the cannabis-specific dimension challenges (batch granularity, identity confidence, and the line-item recreational vs medical flag) that make or break the dual-currency margin calculation downstream.24 min
- 10Identity Resolution: The Loyalty-to-POS Join and the Phone-Number ProblemIdentity resolution is the highest-leverage and lowest-glamour data engineering investment a cannabis operator can make. The phone number is the de facto cannabis identity primary key, and it carries four documented quality issues. Well-maintained operators land at 75 to 90 percent identity match rate POS-to-loyalty; below 50 percent means half the customer analytics is wrong.22 min
- 11Data Quality and Lineage: Catching the Broken Pipeline Before It Pollutes DecisionsEvery cannabis pipeline fails silently into dashboards that look right to the human eye. This lesson installs the four-category monitoring stack (row-count, freshness, schema-change, business-rule), the dbt test framework that operationalizes it, and the five-attribute lineage documentation that lets any metric be walked from dashboard pixel to source-system row in under five minutes.20 min
- 12Security, Cost Modeling, and the Buy-vs-Build DecisionThe closing data-stack lesson. Tier your data into four sensitivity classes (public-ok, internal-ok, sensitive, restricted) and enforce the tier boundary at the warehouse layer through row-level security. Build the layered cost model across nine stack layers and gross every line up by the 280E cash-cost multiplier on the recreational portion. Run the buy-vs-build framework twice (once for dashboarding, once for data engineering), because they answer different questions and the cannabis source ecosystem forces a different answer at each layer.27 min
Part 03
9 lessons • 221 minDashboards, KPIs, and Reports
- 13Decision-First Dashboard DesignEvery chart on every cannabis dashboard exists to inform one named decision and trigger one named action, or it gets cut. This lesson installs the two-question gate, the four canonical decision contexts that map to the operating cadence, the dual-currency check on adult-use margin, and the named anti-pattern library that explains why most dispensary executive dashboards drift into 25-to-40 metric theater by month 24.18 min
- 14The Operational and Tactical Dashboards: Today and This WeekThe operational dashboard refreshes every 4 to 10 minutes and drives the floor decisions a GM makes in motion. The tactical dashboard refreshes daily and drives the Monday weekly standup. This lesson builds both surfaces with audience, refresh cadence, layout, cannabis-specific metrics, and the documented next-action that every chart has to carry.26 min
- 15The Strategic and Governance Dashboards: Quarterly Strategy and System HealthCornerstone dashboards lesson. The strategic dashboard runs the monthly P&L review with the dual-currency view on every margin chart, the four segment cuts, and the federal-trigger watchlist. The governance dashboard runs the quarterly five-axis scoreboard and gates org-design, capital structure, and expansion decisions. These are the two highest-leverage surfaces in the analytics stack.33 min
- 16Chart Design Discipline and the Quarterly Dashboard PruningPick the chart type that matches the question, cap each layer at 8 to 12 metrics, put a benchmark and a next-action note on every chart, and prune 20 to 30 percent of the dashboard inventory every year. This lesson installs the visual discipline and the quarterly maintenance rhythm that prevents the 47-tile dashboard nobody opens past Wednesday.28 min
- 17Distribution, Embedding, and the Report-vs-Dashboard DistinctionA dashboard surfaces what; a report explains why. Pick the right deliverable for the decision context, then match every dashboard to one of six distribution channels (web interface, embedded, Slack/Teams alert, email digest, BoH pin-up, voice/visual signage) that respects the audience's actual work pattern. The operator who confuses the formats produces worse versions of both; the operator who ships the Looker URL by email to staff without licenses ships a dashboard nobody reads.20 min
- 18Sales KPIs: AOV, Basket, UPT, Conversion, Same-Store Sales, Mix ShiftThe canonical sales KPI library for cannabis operators. Tier 1 (AOV, basket size, UPT, conversion, transactions by daypart) is the weekly floor read; Tier 2 (same-store-sales comp, mix shift, daypart productivity, category penetration) is the monthly leadership read. Every number carries its cannabis adaptation: the daily-limit AOV ceiling, the wholesale-pass-through that drags dollar comp, and the 280E loading that changes what the number tells you to do.21 min
- 19Inventory and Vendor KPIs: Sell-Through, DOS, GMROI, ABC, KSM, ConcentrationThe inventory KPI suite operators run weekly (sell-through, DOS, stockturn, GMROI, fill rate, stockout percent) and the assortment metrics they run quarterly (aged inventory, markdown cadence, vendor concentration, ABC, KSM, brand mix risk). This lesson installs the cannabis benchmark bands per category and the 280E-loaded rationalization math that drives the quarterly 30/70 cut-and-replace cadence.25 min
- 20Customer and Loyalty KPIs: Frequency, Repeat Rate, LTV, RFM, Churn, CAC, Loyalty PenetrationThe customer-side KPI dictionary every GM, owner, and CFO reads monthly. Tier 1 covers frequency, repeat rate, LTV, AOV by cohort, and cohort retention with the bimodal daily-user vs occasional split. Tier 2 covers RFM segmentation, churn, win-back, CAC, and loyalty penetration as the silent gate on every other number. Every metric runs through the cohort cut first and the 280E currency cut second.23 min
- 21Productivity, Promotion, and Financial-Health KPIs: SPLH, Voids, Promo ROI, EBITDA, Owner-Investor DashboardThe owner-investor KPI dictionary. Floor productivity (SPLH, TPLH, IPLH, voids, ring time, labor percent), promotion economics (stack hit, lift, cannibalization, halo, promo ROI), and financial health (blended GM, contribution margin, EBITDA, FCF per store, working capital days, 280E effective rate), all carried in the dual-currency view with the benchmark sources every operator should know.27 min
Part 04
7 lessons • 144 minThe Operating Cadence
- 22The Daily Floor Walk and the Pre-Open BriefingManager-scoped lesson. The daily cadence is owned by the GM and AGM at each store. This lesson walks a GM or AGM through the 60-to-75 minute pre-open four-quadrant route, the mid-day conversion check, and the four-block close-out, with cannabis-specific anchors that add 15 to 20 minutes to the pre-open. The cardinal discipline: the GM on register at peak is a GM not doing GM work, and a dashboard read without a floor walk lags the operating reality by 30 to 60 days.15 min
- 23The Weekly KPI StandupMonday morning, 15 to 30 minutes, before the store opens. Five participants, five segments, three priorities, one written artifact with owner-deadline-proof-number per priority. The weekly is the layer where the five days of daily floor signals become a plan; the standup that does not produce a three-priority list with proof-numbers has failed at its primary purpose, and the Tuesday compliance posture check is a separate meeting, not a segment inside the standup.19 min
- 24The Monthly P&L Review: Where Capital Allocation Actually LandsCornerstone cadence lesson. The monthly P&L review is the capital-allocation layer of the operating system. 60 to 90 minutes per store in the second week of the following month, walking the strategic dashboard with dual-currency margin on every chart and the four segment cuts in standard order. This is where vendor escalations, staffing changes, marketing rebalances, and strategic-fit calls get made against the cash-effective number, not the reported one.24 min
- 25The Quarterly Portfolio Review and the Five-Axis ScoreboardThe quarterly portfolio review is the layer where the trailing three months of monthly P&L drift become next-quarter architecture changes. Half-day to full-day, scheduled in week two or three of the following quarter, walked against the five-axis governance scoreboard (financial, operational, customer, compliance, people) with the one-axis / two-axis / three-axis triggers and a federal-trigger watchlist refreshed against three scenarios. The structure changes operational architecture itself. Skip it and you arrive at the annual strategy refresh with two quarters of accreted architectural debt.20 min
- 26The Annual Strategy RefreshThe annual strategy refresh is the layer where the operator decides what the next twelve months are for and locks the calendar early enough that quarterly, monthly, weekly, and daily cadences below have time to execute against it. Two to four days off-site in October or November, a one-page strategic brief plus a 10 to 30 page supporting memo, a 12-month retail calendar with non-negotiable lock dates, a dual-currency capital plan, an org-design plan, and a federal-trigger watchlist with pre-committed contingent actions. Slide the lock window into January and you arrive at 4/20 with vendor commitments already late.21 min
- 27The Compliance Cadence Overlay and the Documentation DisciplineThe compliance cadence is a parallel layered rhythm that intersects every analytics cadence: weekly Tuesday posture check, monthly Metrc reconciliation with the 2/3/5 threshold ladder, quarterly mock audit against the seven artifact stacks, annual external audit prep 60 days out. Plus the documentation discipline (artifact per meeting, action log per artifact, 7-year retention for compliance-touching) that makes the rhythm durable across staff turnover.20 min
- 28Scaling the Cadence: Single-Store to Three-Store to MSOThe load-bearing scaling rule: the per-store cadence does not change as the portfolio grows. Growth adds consolidation layers above the daily floor walk, the Monday standup, the monthly P&L; it never collapses them. This lesson maps the cadence from single-store through ten-store MSO, names the cannabis-specific hire triggers that reshape the rhythm (DO at three stores or $9M, Director of Compliance at five stores or any multi-state expansion, Regional Director at ten), and walks two calendars (a three-store Michigan independent at ~25 leadership hours per week, a ten-store MSO at ~200-260 hours aggregated across the leadership tier).25 min
Part 05
13 lessons • 321 minBuyer-Side Analytical Methods: Category, Customer, Pricing, Vendor
- 29ABC Analysis: The Foundational Category TierABC analysis is the first framework that runs on the SKU portfolio and the one that anchors every framework that follows. The Buyer runs it twice, once by revenue and once by gross-margin dollars, and reads the four-cell intersection to find the protected core, the volume drivers, the niche profit drivers, and the rationalization candidates. Run it wrong and the C-tier bloats year over year while capital stays trapped at the bottom of the assortment.23 min
- 30GMROI: The Capital-Efficiency LensGMROI reads what ABC cannot: whether contribution is being earned efficiently against the working capital it consumes. Gross Margin Dollars divided by Average Inventory Cost, equivalent to Gross Margin Percent times Sales-to-Stock ratio. Target bands sit at 200-350 percent blended store GMROI; within categories, vape and edibles target 200-400 percent, concentrates 150-300 percent, accessories 150-250 percent. Flower is the anchor category and is read on absolute gross margin dollars paired with GMROI; a healthy mature-market flower position sits at 5.22 GMROI anchor-class read on $600K gross margin (12-18x turns on 22-32 percent margin, producing 264-576 percent GMROI efficiency). Above 6.0 usually means assortment is too narrow or a market-regime shift has occurred. Below 100 percent is a capital trap. Run the two-axis decomposition before any prescription, pull one lever at a time, and translate every adult-use number through the 280E cash-currency overlay.27 min
- 31The Kasavana-Smith Menu Engineering MatrixKasavana-Smith is the synthesis surface where ABC and GMROI outputs land before they convert into rationalization, repositioning, and pitch decisions. Two axes (contribution dollars per unit and share of mix), four quadrants (Stars, Plowhorses, Puzzles, Dogs), one quarterly cadence, three output artifacts. This lesson installs the cannabis-adapted KSM discipline: the dual reported-and-cash-effective contribution view on adult-use lines, the batch-level overlay on high-velocity flower and concentrate, the persona-mix overlay before any cut, the brand-day netting on the share-of-mix axis, and the per-channel matrix at dual-license operators.27 min
- 32Velocity, Sell-Through Curves, and Batch-Level AnalyticsVelocity and sell-through read the assortment at the operating layer that drives the next reorder and the next markdown. In cannabis, the same SKU sold from two batches is functionally two different products, so every velocity report, GMROI calculation, and rationalization decision runs at the batch level for flower and live concentrate, not at the SKU level. This lesson installs the three-window velocity read, the reorder-point formula with the cannabis lead-time stack, the harvest-date markdown ladder, and the package-tag join discipline that keeps batch-level dashboards trustworthy.25 min
- 33RFM Segmentation: The Canonical Customer-Analytics FrameworkRFM (Recency, Frequency, Monetary) is the oldest still-load-bearing customer-segmentation framework in retail analytics, and it survives in cannabis with one mechanical adaptation: the daily-user bimodal break. This lesson builds the score, collapses the 125-cell cube into the 11 canonical cohorts, installs the parallel-quintile discipline that fires above the 30 percent daily-user threshold, and lands the action-per-cohort campaign playbook the Operations Leader runs the monthly customer review against.19 min
- 34Cohort Retention Curves: The Most Diagnostic Customer ChartThe cohort retention curve is the earliest-arriving customer-analytics signal in cannabis retail, surfacing trouble 4 to 6 months before the aggregate revenue line. This lesson builds the curve, splits it the three load-bearing ways (acquisition month, daily-user vs occasional, acquisition channel), and walks the Denver independent operator who closed a 21-point discount-acquired retention gap by restructuring the first-time-customer offer.22 min
- 35LTV Modeling Under 280E: Historical, Predictive, Cash-EffectiveLifetime value is the dollar figure that gates every retention-investment decision, and in cannabis it has to run in cash, not in reported margin. This lesson builds the three LTV approaches (historical, predictive, contractual), loads the 280E wedge that knocks adult-use LTV down 25 to 40 percent, and runs the math on three customer segments so the Buyer can defend per-segment LTV numbers and gate campaign budgets on clean data the BoH lead produces.19 min
- 36Churn Prediction and Propensity Scoring: Rule-Based, Statistical, Machine-LearningThree churn-prediction tiers and when each is right: the no-visit-in-90-days rule, the logistic-regression model with frequency-trend and basket-trend features, and the gradient-boosted-tree model. Plus three propensity-scoring use cases that turn the loyalty database into a targeting engine: next-best-offer, basket affinity, and win-back propensity. The lesson runs the build-vs-buy decision per tier and the cannabis adaptations (bimodal cohorts, 280E margin loading, state-rule offer filtering, identity-match floors) that gate every deployment.25 min
- 37Price Elasticity and the Substitution MapPoint-elasticity formula, cannabis benchmarks by category, and how to build the top-50 elasticity map from 24 months of POS history. Then the cross-elasticity matrix and the substitution map that turns a single price raise into a substitute-capture play worth more than the own-price lift.27 min
- 38Markdown Optimization: Timing, Depth, and the Recovery-vs-Bleed TradeoffGiven elasticity, expiry, and the demand curve, what markdown schedule maximizes recovered margin on aging flower? The 15/25/40/60 default ladder is the strawman; an elasticity-tiered optimization is the substitute. This lesson walks the recovered-margin objective function, the four operator decisions (timing, depth, duration, category sequencing), and the cannabis overlays that make markdown analytically different from any other retail category.27 min
- 39Price-Mix-Volume Decomposition and the Price-Zone TestTwo analytical surfaces that turn pricing from gut into arithmetic. Price-mix-volume decomposition attributes any revenue swing to a price effect, a mix effect, and a volume effect, with the cannabis-specific split that separates wholesale-pass-through from your own strategy. The paired-store price-zone test is the controlled experiment that validates a network-wide price change before you roll it, and the competitive match-vs-hold tree that keeps you from racing to the bottom.30 min
- 40The Vendor Scorecard, Fill-Rate Analytics, and the Safety-Stock MathBuild the 12-metric per-vendor scorecard with cannabis benchmark bands, decompose blended fill rate into order-fill, on-time-fill, and sellable-fill so you can name the failure mode before the conversation, and run the safety-stock formula that turns lead-time variability into a working-capital number the owner can read on the cash-flow statement.29 min
- 41Vendor Concentration Risk and the Joint-Business-Plan Performance AuditVendor concentration is a risk metric, not a procurement metric, and the JBP is a contract, not a folder artifact. This lesson installs the five concentration metrics, the 18-month diversification playbook, the brand-house chassis exception, the six-commitment JBP audit, and the six negotiation levers ranked for adult-use 280E. The goal is a defensible quarterly vendor rationalization the Buyer presents at the quarterly portfolio review.21 min
Part 06
12 lessons • 255 minManager-Side Analytical Methods: Floor, Marketing, Compliance, Finance, Forecasting
- 42Door Traffic, Conversion, and Daypart ProductivityFloor-operations analytics is the most-skipped layer in cannabis retail, which is exactly why it is the highest-leverage one. This lesson installs the four-step traffic diagnostic, the age-verification scan log as the free traffic source, the 60 to 85 percent conversion band, and the 168-cell heatmap that closes the 25 to 40 percent mis-scheduling gap most stores run.28 min
- 43Dwell-Time, Queue Management, and the Multi-Store Comparison FrameworkDwell time per budtender as a consultation-quality signal, the three-metric queue layer that surfaces the abandoned-line revenue most stores never see, and the paired-store, peer-group, and percentile-rank framework that turns a multi-store P&L from a scoreboard into a triage list.19 min
- 44Cannabis-Constrained Channels and the Multi-Touch Attribution ModelsCannabis forecloses the channels non-cannabis retail leans on (paid Meta, Google Search, broadcast TV), which compresses the mix to 6-9 channels and makes attribution more valuable, not less. This lesson walks the constrained-channels reality and the six multi-touch attribution models for a marketing owner or small MSO marketing lead deciding budget reallocation. Store operators and back-of-house leads read this to understand which data-quality signals in a market scan report suggest attribution drift or a receiving process failure.24 min
- 45The SMS Funnel, Email Funnel, Brand-Day Attribution, and Constrained-Channels ROISMS is the dominant cannabis marketing channel, so the funnel that reads it stage by stage is the highest-leverage marketing-analytics artifact a store has. This lesson walks the seven-stage SMS funnel and its leak diagnosis, the email funnel with the Apple Mail open-rate caveat, the ecommerce-pickup cannibalization split, the five-element brand-day template, and the four-input 280E-loaded ROAS calculation that drives the quarterly channel rebalance. The marketing owner runs the rebalance; the GM and back-of-house lead read the same numbers to catch stockouts, queue failures, and identity-join drift that show up as funnel leaks.20 min
- 46Metrc Reconciliation and Shrinkage Variance AnalyticsThe daily Metrc reconciliation discipline and the shrinkage variance analytics that sit on top of it. The four named variance patterns, the threshold ladder that decides when a variance becomes a full physical count, the shrink-by-employee-by-SKU-by-shift cross-tab that finds where the margin is actually leaking, and the compliance-manager dashboard that runs the whole thing daily.16 min
- 47Age-Verification, Waste, Destruction, and the Regulator-Audit-Readiness DashboardThe three compliance surfaces that turn a single store's drift into a portfolio enforcement event: door age-verification fail-rate tracking with its counterintuitive color logic, waste-by-cause analytics with the destruction-vs-donation documentation discipline, and the 10-metric audit-readiness dashboard built backward from the 15-minute evidence-pack benchmark. Closes with the state-by-state regulator overlay and the compliance-as-margin-defense frame.20 min
- 48The Three-Way Match and Cash-Room Variance AnalyticsCannabis is the most cash-heavy regulated retail format in the US, which means the POS is the only authoritative ledger and every dollar has to be traced from ring to drawer to deposit to bank credit. This lesson installs the daily three-way match, the variance-threshold ladder, and the per-shift cash-room discipline that keeps unreconciled variance under 1 percent before leakage eats a margin that 280E has already thinned. **Audience: General Managers, Store Controllers, and single-store operators.** Operations Leaders at multi-store operators should see 'Multi-store Cash Operations Governance' for the portfolio-level view.25 min
- 49Void/Refund Analytics, FinCEN Reporting, and the Cannabis-Banking Cost AnalyticsThe void rate is the highest-resolution theft signal in the cash room after per-shift variance, and the refund and discount-stack ledgers decode the same skim from a different angle. This lesson installs the loss-prevention dashboard (per-cashier voids, reason-code discipline, the void-on-the-limit detector), the FinCEN CTR/SAR framework and the structuring trap, and the cannabis-banking fee benchmark that recovers real cash every renewal cycle.19 min
- 50Forecasting Methods, Accuracy Tracking, and the Demand-Planning WorkflowThe four forecasting methods a cannabis operator actually uses, the accuracy metrics that keep the forecast honest, and the demand-planning workflow that turns a number into a purchase order. Moving average is the wrong default for almost every store; Holt-Winters is the workhorse; regression answers why. A 15-25 percent weekly MAPE is the realistic band, not a failing grade.14 min
- 51Seasonality Decomposition, A/B Testing, and Control ChartsThe three statistical disciplines that separate signal from noise in a cannabis operation: classical seasonal decomposition (trend plus seasonal plus irregular) to answer is-this-dip-real, A/B test design with pre-registered sample sizes to read promotion and operational-change results honestly, and control charts with Western Electric rules to catch drift weeks before the P&L does. Plus the minimum statistical literacy that lets an operator reject a p-hacked vendor deck. As of April 22, 2026, state-licensed medical cannabis is Schedule III and runs on normal pre-tax math; adult-use cannabis remains Schedule I, so 280E still grosses up the cash math on the recreational side.23 min
- 52Trade-Area Definition, Drive-Time Analytics, and Cannibalization MeasurementThe trade-area-and-cannibalization framework the Operations Leader runs before any new-store decision. Define the primary and secondary trade area with drive-time isochrones, measure how much a new store steals from its siblings, and maintain the standing portfolio-overlap map that gates positioning and consolidation decisions.22 min
- 53Store-Grade Scoring and the New-Store Revenue ForecastLearn the seven-factor store-grade rubric and how operators use it for portfolio decisions, then understand how the hybrid regression-plus-benchmark revenue forecast works and where the BoH lead's data-validation role sits in the forecast lifecycle. The output is a defensible go/no-go decision that runs the breakeven-floor check on cash-effective EBITDA, not reported.25 min
Part 07
4 lessons • 83 minGovernance and Capstone
- 54The Six-Family Analytics Failure-Mode TaxonomyCannabis analytics functions fail in named, patterned ways that sort into six families: measurement (the number is wrong), display (the chart lies), decision (the right number drives the wrong action), cadence (the rhythm breaks), governance (nobody owns the number), and cultural (analytics as theater). This lesson teaches you the vocabulary to name analytics failures when you observe them on the floor, in the Metrc data, or in the menu, so you can escalate them to the right tier (GM, buyer, Operations Leader) with enough specificity that the remediation lands on the structural cause instead of the surface symptom.16 min
- 55The Eighteen Named-Operator Failure Catalog and the Anti-Pattern Remediation CaseEighteen anonymized cannabis-operator analytics failures, each with the root cause, the warning signal, the remediation, and the proof-number that confirms the failure has cleared. Then the worked anti-pattern remediation case: a drifted four-store Oregon chain walked from a vanity-metric culture to a clean analytics function in a 12-week reset, with the cost-to-benefit math that justifies the engagement.27 min
- 56The Annual Analytics Audit FrameworkThe once-a-year governance mechanism that keeps the analytics function honest: a six-track audit (measurement, display, decision, cadence, governance, culture) that runs every November alongside the strategy refresh, surfaces 8 to 12 major findings, and produces a one-page prioritized remediation plan the budget cycle can fund. The operator who runs it catches the failure modes before they compound; the operator who skips it inherits the eighteen-case catalog by default.22 min
- 57Capstone: The Twelve-Month Analytics Build for a Three-Store Michigan IndependentThe integrating capstone. Greenhouse Collective is a three-store Michigan adult-use independent at $11M aggregate revenue, 47 FTE, on Treez plus Alpine IQ plus Headset plus Dutchie plus Confident Cannabis. This lesson walks the twelve-month build end to end: the source-of-truth map and warehouse decision, the identity-resolution layer to an 85 percent match rate, the four-layer dashboard with dual-currency 280E throughout, the daily-through-annual cadence at 12 hours per week of Operations Leader time, the 13-week forecast, the six-month pricing build, the fourth-store site decision, and the month-12 annual audit that keeps the function honest. The output is one coherent operating system, not a pile of reports.18 min
Ready when you are
Operational Analytics starts with one lesson.
The Four-Layer Dashboard Architecture: Operational, Tactical, Strategic, Governance, 20 minutes. Pick it up here whenever you have time.
Start lesson 1