TSH

Data Analysis

Turn raw numbers into decisions that actually matter.

Medium4 to 6 monthsanalyze
Your Progress0%

Overview

Data analysts collect, clean, and interpret data to help organizations make informed decisions. You work with spreadsheets, SQL, Python, and visualization tools to find patterns and tell stories with data.

Who is this for?

  • ✓ Students starting from zero who want structure
  • ✓ Self-taught learners who need a clear path
  • ✓ Career switchers ready to commit consistently

What can you build?

  • Business dashboards
  • Sales performance reports
  • Customer behavior analyses
  • Financial forecasting models

Jobs you can get

Data AnalystBusiness Intelligence AnalystReporting AnalystOperations Analyst

Salary range: $45,000 to $100,000/year

Roadmap

Follow each stage in order. Mark stages complete as you finish them.

  1. Stage 12 to 3 weeks

    Spreadsheets & Excel

    • Formulas & functions
    • Pivot tables
    • Charts & visualization
    • Data cleaning in Excel
    • VLOOKUP / INDEX-MATCH
  2. Stage 24 to 5 weeks

    SQL Fundamentals

    • SELECT, WHERE, ORDER BY
    • Aggregations: COUNT, SUM, AVG
    • JOINs: INNER, LEFT, RIGHT
    • Subqueries and CTEs
    • Window functions
  3. Stage 35 to 6 weeks

    Python for Data

    • Pandas: data manipulation
    • NumPy: numerical operations
    • Matplotlib & Seaborn
    • Handling missing data
    • Merging and reshaping data
  4. Stage 43 to 4 weeks

    BI & Visualization Tools

    • Power BI fundamentals
    • Tableau Public
    • Google Looker Studio
    • Dashboard design principles
  5. Stage 52 to 3 weeks

    Statistics Basics

    • Mean, median, mode
    • Standard deviation
    • Correlation vs causation
    • Basic hypothesis testing

Resources

SQL Full Course

FREE

Complete SQL covering everything from SELECT to window functions.

www.youtube.com/watch?v=HXV3zeQKqGY

SQLZoo

FREE

Interactive SQL practice. The best place to drill queries until they feel natural.

sqlzoo.net

Pandas Full Course

FREE

Learn Python Pandas, loading, cleaning, transforming, and analyzing data.

www.youtube.com/watch?v=vmEHCJofslg

Kaggle Learn

FREE

Free micro-courses on Python, Pandas, SQL, and data viz. Highly practical.

www.kaggle.com/learn

Excel Full Course

FREE

Master Excel for data analysis, formulas, pivot tables, charts, power query.

www.youtube.com/watch?v=Vl0H-qTclOg

Power BI Full Course

FREE

Complete Power BI course, connect data and build interactive reports.

www.youtube.com/watch?v=TmhQCQr_DCA

Kaggle Datasets

FREE

Thousands of free datasets to practice on. Download and analyze anything.

www.kaggle.com/datasets

Select Star SQL

FREE

Interactive SQL book. Best way to learn SQL for real analytical queries.

selectstarsql.com

Projects

beginner

#01

Sales Dashboard

Analyze a sales dataset and build an interactive dashboard with KPIs.

ExcelPower BI
#02

SQL Dataset Analysis

Download a Kaggle dataset, write 15+ SQL queries, and document insights.

SQLPostgreSQL

intermediate

#01

Student Performance Analysis

Analyze academic dataset with Pandas: trends, outliers, correlations.

PythonPandasMatplotlib
#02

Financial Report Dashboard

Build a Tableau Public dashboard from a financial CSV dataset.

TableauData Viz

AI Guide

What AI helps with

  • ✓ Writing SQL queries from plain English
  • ✓ Explaining dataset columns
  • ✓ Suggesting chart types
  • ✓ Writing Pandas cleaning scripts
  • ✓ Interpreting statistical results

What AI cannot replace

  • ✗ Interpreting business context it does not know
  • ✗ Replacing statistical understanding
  • ✗ Making business decisions, that is your job

Recommended Tools

ChatGPT Code Interpreter

Upload CSVs and ask AI to analyze and chart them

Julius AI

Dedicated data analysis AI with chart generation

Claude

SQL generation, Pandas scripts, insight interpretation

Sample Prompts

Write a SQL query that finds the top 10 customers by total order value in the past 6 months, grouped by region. Schema: orders(id, customer_id, amount, date, region).
I have a Pandas DataFrame with a "date" column stored as strings in dd/mm/yyyy format. Write code to convert it to datetime, extract month and year, and create a monthly sales summary by product category.

Career Path

Data AnalystBusiness Intelligence AnalystReporting AnalystOperations Analyst

$45,000 to $100,000/year

Domain knowledge multiplies your value. A data analyst who understands finance, healthcare, or logistics is far more valuable than one who only knows SQL.

Full Career Prep Guide