A beginner-friendly roadmap for aspiring data analysts covering foundational concepts and practical skills. The guide progresses through six steps: understanding data basics and types, getting started with Excel/Metabase/SQL, exploring and preparing data through filtering and cleaning, summarizing data using aggregations and statistics, working across multiple tables with joins, and creating visualizations and dashboards. Each section provides curated resources and links to tutorials for hands-on learning across three main tools: spreadsheets, Metabase BI tool, and SQL databases.
Table of contents
Step 1: Data basicsStep 2: Getting started with your toolsStep 3: Exploring and preparing dataStep 4: Summarizing and analyzing dataStep 5: Analysis across data tablesStep 6: Data visualization and dashboardsConclusionSort: