Data Analyst
Interview
Preparation
Guide
Nimra Ayaz
1. SQL Essentials:
SELECT statements including WHERE, ORDER
BY, GROUP BY, HAVING by
Basic JOINS: INNER, LEFT, RIGHT, FULL
Aggregate functions: COUNT, SUM, AVG, MAX,
MIN
Subqueries, Common Table Expressions (WITH
clause)
CASE statements, advanced JOIN techniques,
and Window functions (OVER, PARTITION BY,
ROW_NUMBER, RANK)
2. EXCEL:
Cell operations, formulas (SUMIFS,
COUNTIFS, AVERAGEIFS, LOOKUPS)
PivotTables, PivotCharts, Data
validation, What-if analysis
Advanced formulas, Data Model & Power
Pivot
3. Power bi Skills:
Data modeling (importing data, managing
relationships)
Data transformation with Power Query, DAX for
calculated columns/measures
Creating interactive reports and dashboards,
visualizations
4. Data Warehousing:
Concepts of OLAP vs. OLTP
Star and Snowflake schema designs
ETL processes: Extract, Transform, Load
Data lake vs. data warehouse
5. Python Programming:
Basic syntax, control structures, data
structures (lists, dictionaries)
Pandas & NumPy for data manipulation:
DataFrames, Series, groupby
plotting with Matplotlib, Seaborn for
visualization
6. Statistics Fundamentals:
Mean, Median, Mode, Standard Deviation,
Variance
Probability distributions, Hypothesis Testing,
P-values
Confidence Intervals, Correlation, Simple
Linear Regression
If you find this helpful
Like
Comment
Share
Nimra Ayaz