Skip to main content

Posts

Showing posts from August, 2025

Data Analysis + Automation Testing 12-week starter study plan

  🔹 Step 1: Foundation (Weeks 1–4) Focus on core building blocks that overlap both fields. Week 1–2: Excel + Git basics Excel: Formulas, Pivot Tables, Charts, Filtering, Conditional Formatting. Git: init, clone, add, commit, push, pull, branching basics. Small project: Create a mini sales dashboard in Excel and upload it to GitHub. Week 3–4: Python (basics) Python: Variables, loops, functions, data structures (lists, dicts). Libraries: pandas (basic data analysis), matplotlib (basic plotting). Small project: Load a CSV in pandas, clean it, and plot graphs. Push code to GitHub. 🔹 Step 2: Specialized Tracks (Weeks 5–10) Now split time between Data Analysis and QA Automation . Week 5–6: SQL + JavaScript basics SQL: SELECT, WHERE, JOIN, GROUP BY, ORDER BY. Practice on sample databases. JS: Variables, arrays, objects, functions, loops. Mini-projects: Write SQL queries for a mock e-commerce DB. JS program that manipulates arrays (e.g., filt...