Build your analytics foundations.

Learn to apply what data analytics really is to a realistic business question, work through a small example, and explain the result and its limitations.

Sample data: synthetic KPI CSV. Exercise: write one finding and one follow-up question; use the downloaded outline for the day-specific task.

Learn to apply ask better business questions to a realistic business question, work through a small example, and explain the result and its limitations.

Sample data: synthetic KPI CSV. Exercise: write one finding and one follow-up question; use the downloaded outline for the day-specific task.

Learn to apply data types and measurement scales to a realistic business question, work through a small example, and explain the result and its limitations.

Sample data: synthetic KPI CSV. Exercise: write one finding and one follow-up question; use the downloaded outline for the day-specific task.

Learn to apply meet your dataset: rows and columns to a realistic business question, work through a small example, and explain the result and its limitations.

Sample data: synthetic KPI CSV. Exercise: write one finding and one follow-up question; use the downloaded outline for the day-specific task.

Learn to apply collecting data responsibly to a realistic business question, work through a small example, and explain the result and its limitations.

Sample data: synthetic KPI CSV. Exercise: write one finding and one follow-up question; use the downloaded outline for the day-specific task.

Learn to apply spreadsheet basics for analysts to a realistic business question, work through a small example, and explain the result and its limitations.

Sample data: synthetic KPI CSV. Exercise: write one finding and one follow-up question; use the downloaded outline for the day-specific task.

Learn to apply clean messy data to a realistic business question, work through a small example, and explain the result and its limitations.

Sample data: synthetic KPI CSV. Exercise: write one finding and one follow-up question; use the downloaded outline for the day-specific task.

Learn to apply sort, filter, and freeze panes to a realistic business question, work through a small example, and explain the result and its limitations.

Sample data: synthetic KPI CSV. Exercise: write one finding and one follow-up question; use the downloaded outline for the day-specific task.

Learn to apply formulas: sum, average, min, max to a realistic business question, work through a small example, and explain the result and its limitations.

Sample data: synthetic KPI CSV. Exercise: write one finding and one follow-up question; use the downloaded outline for the day-specific task.

Learn to apply percentages and percentage change to a realistic business question, work through a small example, and explain the result and its limitations.

Sample data: synthetic KPI CSV. Exercise: write one finding and one follow-up question; use the downloaded outline for the day-specific task.

Learn to apply count, counta, and countif to a realistic business question, work through a small example, and explain the result and its limitations.

Sample data: synthetic KPI CSV. Exercise: write one finding and one follow-up question; use the downloaded outline for the day-specific task.

Learn to apply if logic and categories to a realistic business question, work through a small example, and explain the result and its limitations.

Sample data: synthetic KPI CSV. Exercise: write one finding and one follow-up question; use the downloaded outline for the day-specific task.

Learn to apply lookups and joining tables to a realistic business question, work through a small example, and explain the result and its limitations.

Sample data: synthetic KPI CSV. Exercise: write one finding and one follow-up question; use the downloaded outline for the day-specific task.

Learn to apply dates and time periods to a realistic business question, work through a small example, and explain the result and its limitations.

Sample data: synthetic KPI CSV. Exercise: write one finding and one follow-up question; use the downloaded outline for the day-specific task.

Learn to apply pivot tables for quick answers to a realistic business question, work through a small example, and explain the result and its limitations.

Sample data: synthetic KPI CSV. Exercise: write one finding and one follow-up question; use the downloaded outline for the day-specific task.

Learn to apply charts that tell the truth to a realistic business question, work through a small example, and explain the result and its limitations.

Sample data: synthetic KPI CSV. Exercise: write one finding and one follow-up question; use the downloaded outline for the day-specific task.

Learn to apply mean, median, and mode to a realistic business question, work through a small example, and explain the result and its limitations.

Sample data: synthetic KPI CSV. Exercise: write one finding and one follow-up question; use the downloaded outline for the day-specific task.

Learn to apply range, quartiles, and iqr to a realistic business question, work through a small example, and explain the result and its limitations.

Sample data: synthetic KPI CSV. Exercise: write one finding and one follow-up question; use the downloaded outline for the day-specific task.

Learn to apply spot outliers carefully to a realistic business question, work through a small example, and explain the result and its limitations.

Sample data: synthetic KPI CSV. Exercise: write one finding and one follow-up question; use the downloaded outline for the day-specific task.

Learn to apply correlation is not causation to a realistic business question, work through a small example, and explain the result and its limitations.

Sample data: synthetic KPI CSV. Exercise: write one finding and one follow-up question; use the downloaded outline for the day-specific task.

Learn to apply sampling and representativeness to a realistic business question, work through a small example, and explain the result and its limitations.

Sample data: synthetic KPI CSV. Exercise: write one finding and one follow-up question; use the downloaded outline for the day-specific task.

Learn to apply ask useful questions of data to a realistic business question, work through a small example, and explain the result and its limitations.

Sample data: synthetic KPI CSV. Exercise: write one finding and one follow-up question; use the downloaded outline for the day-specific task.

Learn to apply sql: tables and select to a realistic business question, work through a small example, and explain the result and its limitations.

Sample data: synthetic KPI CSV. Exercise: write one finding and one follow-up question; use the downloaded outline for the day-specific task.

Learn to apply sql: where and order by to a realistic business question, work through a small example, and explain the result and its limitations.

Sample data: synthetic KPI CSV. Exercise: write one finding and one follow-up question; use the downloaded outline for the day-specific task.

Learn to apply sql: aggregations and group by to a realistic business question, work through a small example, and explain the result and its limitations.

Sample data: synthetic KPI CSV. Exercise: write one finding and one follow-up question; use the downloaded outline for the day-specific task.

Learn to apply sql: case when to a realistic business question, work through a small example, and explain the result and its limitations.

Sample data: synthetic KPI CSV. Exercise: write one finding and one follow-up question; use the downloaded outline for the day-specific task.

Learn to apply sql: null values to a realistic business question, work through a small example, and explain the result and its limitations.

Sample data: synthetic KPI CSV. Exercise: write one finding and one follow-up question; use the downloaded outline for the day-specific task.

Learn to apply sql: join fundamentals to a realistic business question, work through a small example, and explain the result and its limitations.

Sample data: synthetic KPI CSV. Exercise: write one finding and one follow-up question; use the downloaded outline for the day-specific task.

Learn to apply build your first kpi report to a realistic business question, work through a small example, and explain the result and its limitations.

Sample data: synthetic KPI CSV. Exercise: write one finding and one follow-up question; use the downloaded outline for the day-specific task.

Learn to apply beginner capstone: retail sales story to a realistic business question, work through a small example, and explain the result and its limitations.

Sample data: synthetic KPI CSV. Exercise: write one finding and one follow-up question; use the downloaded outline for the day-specific task.