TOP CONCEPTS FOR DATA ANALYST INTERVIEW PREPARATION
TOP 10 SQL Concepts
- Aggregate Functions (SUM/AVG)
- Group By and Order By
- JOINs (Inner/Left/Right)
- Union and Union All
- Date and Time processing
- String processing
- Window Functions (Partition by)
- Subquery
- View and Index
- Common Table Expression (CTE)
TOP 10 Statistics Concepts
- Sampling
- Experiments (A/B tests)
- Descriptive Statistics
- p-value
- Probability Distributions
- t-test
- ANOVA
- Correlation
- Linear Regression
- Logistics Regression
TOP 10 Python Concepts
- Reading data from file/table
- Writing data to file/table
- Data Types
- Function
- Data Preprocessing (numpy/pandas)
- Data Visualisation (Matplotlib/seaborn/bokeh)
- Machine Learning (sklearn)
- Deep Learning (Tensorflow/Keras/PyTorch)
- Distributed Processing (PySpark)
- Functional and Object Oriented Programming