Data Skills

step-by-step pricing analysis tutorial with a real sample dataset. price elasticity, conversion-by-price, and the spreadsheet workflow that sets the right number.

step-by-step inventory turnover analysis tutorial with a real sample dataset. turnover formula, dead stock detection, and reorder timing for small ecommerce.

step-by-step sales forecasting tutorial for Google Sheets. real sample dataset, FORECAST formula, seasonality, and the pipeline-weighted method that beats gut feel.

step-by-step cohort retention curve tutorial with a real sample dataset. monthly cohort table, retention curve chart, and the patterns that predict LTV.

step-by-step ROAS analysis tutorial with a real sample dataset. campaign-level math, true ROAS vs platform ROAS, and the fixes that actually improve return.

step-by-step LTV calculation tutorial with a real sample dataset. simple formula, cohort version, segment breakdowns, and the LTV/CAC ratio every solopreneur needs.

step-by-step churn analysis tutorial with a real sample dataset. cohort retention, churn formulas, churn-by-segment pivots, and the fixes that actually retain.

step-by-step marketing funnel analysis tutorial. real sample dataset, conversion math, drop-off diagnosis, and the practical fixes that move the needle.

step-by-step tutorial for building a working sales tracker in Google Sheets. real sample dataset, formulas, dashboard charts, and the metrics solopreneurs actually need.

step-by-step Excel tutorial for analyzing customer support tickets. real sample dataset, formulas, pivot tables, and the patterns that actually drive product fixes.