Zorky CRMZorky CRM
EN|RU
@termdocs
← All jobs

If I had to start learning data analyst all over again, I'd follow this

leadScore 63.5/100today
Market insights
📊 Data Engineering: salaries and demand on the market
Stack
pandaspythonsql
Apply
Upload your CV — we will connect you with the employer directly through our pool.
Send your CV →
Description
If I had to start learning data analyst all over again, I'd follow this: 1- Learn SQL: ---- Joins (Inner, Left, Full outer and Self) ---- Aggregate Functions (COUNT, SUM, AVG, MIN, MAX) ---- Group by and Having clause ---- CTE and Subquery ---- Windows Function (Rank, Dense Rank, Row number, Lead, Lag etc) 2- Learn Excel: ---- Mathematical (COUNT, SUM, AVG, MIN, MAX, etc) ---- Logical Functions (IF, AND, OR, NOT) ---- Lookup and Reference (VLookup, INDEX, MATCH etc) ---- Pivot Table, Filters, Slicers 3- Learn BI Tools: ---- Data Integration and ETL (Extract, Transform, Load) ---- Report Generation ---- Data Exploration and Ad-hoc Analysis ---- Dashboard Creation 4- Learn Python (Pandas) Optional: ---- Data Structures, Data Cleaning and Preparation ---- Data Manipulation ---- Merging and Joining Data (Merging and joining DataFrames -similar to SQL joins) ---- Data Visualization (Basic plotting using Matplotlib and Seaborn) Hope this helps you 😊
Employer contacts (email/phone/telegram) are hidden from the public preview — send your CV, and we will connect you directly.
Urgent question? Message @termdocs