TOP CONCEPTS FOR DATA ANALYST INTERVIEW PREPARATION

Deepshika

Updated on:

21-Day Project Plan to Build Web Development Skills

TOP CONCEPTS FOR DATA ANALYST INTERVIEW PREPARATION

TOP 10 SQL Concepts

  1. Aggregate Functions (SUM/AVG)
  2. Group By and Order By
  3. JOINs (Inner/Left/Right)
  4. Union and Union All
  5. Date and Time processing
  6. String processing
  7. Window Functions (Partition by)
  8. Subquery
  9. View and Index
  10. Common Table Expression (CTE)

TOP 10 Statistics Concepts

  1. Sampling
  2. Experiments (A/B tests)
  3. Descriptive Statistics
  4. p-value
  5. Probability Distributions
  6. t-test
  7. ANOVA
  8. Correlation
  9. Linear Regression
  10. Logistics Regression

TOP 10 Python Concepts

  1. Reading data from file/table
  2. Writing data to file/table
  3. Data Types
  4. Function
  5. Data Preprocessing (numpy/pandas)
  6. Data Visualisation (Matplotlib/seaborn/bokeh)
  7. Machine Learning (sklearn)
  8. Deep Learning (Tensorflow/Keras/PyTorch)
  9. Distributed Processing (PySpark)
  10. Functional and Object Oriented Programming
WhatsAppJoin us on
WhatsApp!