Free lessons
Data skills, explained one lesson at a time.
Every lesson from Bampaa in plain English, with a worked example and practice questions. When you're ready, try any of them as a hands-on level, free.
SQL137 lessons · SQL lessons for data analysts, from your first SELECT to window functions, data cleaning and advanced analytics.Excel & Google Sheets20 lessons · Spreadsheet lessons for data analysts: formulas, SUMIFS, IFS, XLOOKUP, pivot tables and reports.Python32 lessons · Python for data analysts, from print() and loops to pandas, groupby, cleaning and charts.Power BI15 lessons · Power BI lessons: dashboards, honest charts, data models and DAX measures.Retail & Allocation20 lessons · The KPIs retail store and allocation analysts use every week, worked out step by step.Demand Planning & Forecasting9 lessons · Demand planning and forecasting: moving averages, seasonality, forecast bias and accuracy, promotion uplift, event stock and S&OP, in Excel and Power BI.Assortment & Category Planning10 lessons · Assortment and category planning: sales velocity, ABC analysis, SKU productivity, store grading, distribution and line reviews, in Excel and Power BI.Retail Supply Chain14 lessons · Replenishment and supply chain KPIs: weeks of supply, reorder points, safety stock, fill rate, lead times, DC deployment and launches.