21/12/2025
*Data Analyst Interview Questions with Answers: Part-1* 🧠
*1️⃣ What is the role of a data analyst?*
A data analyst collects, processes, and analyzes data to help businesses make data-driven decisions. They use tools like SQL, Excel, and visualization software (Power BI, Tableau) to identify trends, patterns, and insights.
*2️⃣ Difference between data analyst and data scientist*
- *Data Analyst:* Focuses on descriptive analysis, reporting, and visualization using structured data.
- *Data Scientist:* Works on predictive modeling, machine learning, and advanced statistics using both structured and unstructured data.
*3️⃣ What are the steps in the data analysis process?*
1. Define the problem
2. Collect data
3. Clean and preprocess data
4. Analyze data
5. Visualize and interpret results
6. Communicate insights to stakeholders
*4️⃣ What is data cleaning and why is it important?*
Data cleaning is the process of fixing or removing incorrect, incomplete, or duplicate data. Clean data ensures accurate analysis, improves model performance, and reduces misleading insights.
*5️⃣ Explain types of data: structured vs unstructured*
- *Structured:* Organized data (e.g., tables in SQL, Excel).
- *Unstructured:* Text, images, audio, video — data that doesn’t fit neatly into tables.
*6️⃣ What are primary and foreign keys in databases?*
- *Primary key:* Unique identifier for a table row (e.g., Employee_ID).
- *Foreign key:* A reference to the primary key in another table to establish a relationship.
*7️⃣ Explain normalization and denormalization*
- *Normalization:* Organizing data to reduce redundancy and improve integrity (usually via multiple related tables).
- *Denormalization:* Combining tables for performance gains, often in reporting or analytics.
*8️⃣ What is a JOIN in SQL? Types of joins?*
A JOIN combines rows from two or more tables based on related columns.
Types:
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- FULL OUTER JOIN
- CROSS JOIN
*9️⃣ Difference between INNER JOIN and LEFT JOIN*
- *INNER JOIN:* Returns only matching rows in both tables.
- *LEFT JOIN:* Returns all rows from the left table and matching rows from the right; unmatched right-side values become NULL.
*🔟 Write a SQL query to find duplicate rows*
```sql
SELECT column_name, COUNT(*)
FROM table_name
GROUP BY column_name
HAVING COUNT(*) > 1;
```
This identifies values that appear more than once in the specified column.
