Top 100 Data Analyst Interview Questions

✅ Data Analytics Basics
1. What is data analytics?
2. Difference between data analytics and data science?
3. What problems does a data analyst solve?
4. What are the types of data analytics?
5. What tools do data analysts use daily?
6. What is a KPI?
7. What is a metric vs KPI?
8. What is descriptive analytics?
9. What is diagnostic analytics?
10. What does a typical day of a data analyst look like?

Data and Databases
11. What is structured data?
12. What is semi-structured data?
13. What is unstructured data?
14. What is a database?
15. Difference between OLTP and OLAP?
16. What is a primary key?
17. What is a foreign key?
18. What is a fact table?
19. What is a dimension table?
20. What is a data warehouse?

SQL for Data Analysts
21. What is SELECT used for?
22. Difference between WHERE and HAVING?
23. What is GROUP BY?
24. What are aggregate functions?
25. Difference between INNER and LEFT JOIN?
26. What are subqueries?
27. What is a CTE?
28. How do you handle duplicates in SQL?
29. How do you handle NULL values?
30. What are window functions?

Excel for Data Analysis
31. What are pivot tables?
32. Difference between VLOOKUP and XLOOKUP?
33. What is conditional formatting?
34. What are COUNTIFS and SUMIFS?
35. What is data validation?
36. How do you remove duplicates in Excel?
37. What is IF formula used for?
38. Difference between relative and absolute reference?
39. How do you clean data in Excel?
40. What are common Excel mistakes analysts make?

Data Cleaning and Preparation
41. What is data cleaning?
42. How do you handle missing data?
43. How do you treat outliers?
44. What is data normalization?
45. What is data standardization?
46. How do you check data quality?
47. What is duplicate data?
48. How do you validate source data?
49. What is data transformation?
50. Why is data preparation important?

Statistics for Data Analysts
51. Difference between mean and median?
52. What is standard deviation?
53. What is variance?
54. What is correlation?
55. Difference between correlation and causation?
56. What is an outlier?
57. What is sampling?
58. What is distribution?
59. What is skewness?
60. When do you use median over mean?

Data Visualization
61. Why is data visualization important?
62. Difference between bar and line chart?
63. When do you use a pie chart?
64. What is a dashboard?
65. What makes a good dashboard?
66. What is a KPI card?
67. Common visualization mistakes?
68. How do you choose the right chart?
69. What is drill down?
70. What is data storytelling?

Power BI or Tableau
71. What is Power BI or Tableau used for?
72. What is a data model?
73. What is a relationship?
74. What is DAX?
75. Difference between measure and calculated column?
76. What is Power Query?
77. What are filters and slicers?
78. What is row level security?
79. What is refresh schedule?
80. How do you optimize reports?

Business and Case Questions
81. How do you analyze a sales drop?
82. How do you define success metrics?
83. What business metrics have you worked on?
84. How do you prioritize insights?
85. How do you validate insights?
86. What questions do you ask stakeholders?
87. How do you handle vague requirements?
88. How do you measure business impact?
89. How do you explain numbers to managers?
90. How do you recommend actions?

Projects and Real World
91. Explain your best project.
92. What data sources did you use?
93. How did you clean the data?
94. What insight had the most impact?
95. What challenge did you face?
96. How did you solve it?
97. How did stakeholders use your dashboard?
98. What would you improve in your project?
99. How do you handle tight deadlines?
100. Why should we hire you as a data analyst?

Stay Tuned ❤️👍

Hello Data Engineers 👋

Daily Job alert 📢

Data Engineering Jobs:

#jobopportunity #jobalert #dailyjobalert

https://artha.link/@adityabansal095/jobs/accordion-india-senior-data-engineer-accordion-india-hyderabad-4ea93726

https://artha.link/@adityabansal095/jobs/senior-data-engineer-anblicks-hyderabad-46466b1e

https://artha.link/@adityabansal095/jobs/data-engineer-valuemomentum-hyderabad-25b140e0

Top Data Analyst Projects That Impress Recruiters 📈💼

1. Sales Data Analysis
→ Analyze monthly/quarterly sales trends
→ Segment by product, region, and sales reps
→ Tools: Excel, SQL, Power BI/Tableau

2. Customer Retention Dashboard
→ Churn analysis and retention KPIs
→ Use cohort analysis, funnel visualization
→ Tools: Python, Tableau

3. E-commerce Data Exploration
→ Study user behavior, conversion rate
→ Analyze cart abandonment, top-selling products
→ Tools: SQL, Python (Pandas, Matplotlib)

4. HR Data Insights
→ Track hiring trends, attrition, diversity metrics
→ Build dashboards showing tenure, department stats
→ Tools: Excel, Power BI

5. Financial Data Modeling
→ Actual vs. forecasted revenue/costs
→ Include profitability ratios and variance analysis
→ Tools: Excel, Power BI, SQL

6. Web Traffic Analysis
→ Analyze Google Analytics or log data
→ Focus on user paths, bounce rates, session duration
→ Tools: Python, SQL

7. Survey Data Insights
→ Clean raw survey data, visualize trends
→ Sentiment analysis on feedback (optional NLP)
→ Tools: Excel, Python, Tableau

Tips:
• Explain the business impact of your insights
• Show your workflow: data cleaning → analysis → visualization
• Host projects on GitHub or portfolio site

Stay Tuned❤️👍

#Dataanalyst #SQL #InterviewPrep

🔥 New YouTube Video Alert

Can You Solve This Deloitte SQL Interview Question?

You’re given a products table where the category is available only for the first product, while the following rows contain NULL.

Beverages → Coca Cola
NULL → Pepsi
NULL → Sprite
NULL → Fanta

Snacks → Lays
NULL → Doritos
NULL → Kurkure

🎯 Challenge:
How would you fill those NULL category values with the correct category?

💡 Hint: Think about Window Functions 👀

This is a great SQL problem to test your understanding of NULL handling + data transformation.

👇 What would you use?

🅰️ LAG()
🅱️ LEAD()
🅲️ LAST_VALUE()
🅳️ ROW_NUMBER()

🎬 Solution video
Fill Missing Categories in SQL | Hard Deloitte Interview Question
https://youtu.be/IX9NBK3Yx-M
🚀

Check it out now and let me know in comments ,What did you learn?

#SQL #SQLInterview #Deloitte #SQLChallenge #DataEngineering #Snowflake

🚀 Azure and ETL data engineering roles worth exploring

If you are working with SQL, Spark, Airflow, Databricks, or cloud pipelines, these roles align well with practical data engineering workflows.

💼 Role: Azure Data Engineer
🏢 Company: Tata Consultancy Services
📍 Location: Bengaluru
🌎 Work mode: onsite
✨ Why it is worth checking: Strong Azure stack with ADF, Databricks, Synapse, PySpark, ETL/ELT, and data warehousing exposure.
🔗 https://artha.link/@adityabansal095/jobs/azure-data-engineer-tata-consultancy-bengaluru-abb0b3eb

💼 Role: Senior Data Engineer
🏢 Company: Satwic
📍 Location: India
🌎 Work mode: remote
✨ Why it is worth checking: Good fit for engineers working on Azure migrations, Synapse, Databricks, Spark, and large-scale data pipelines.
🔗 https://artha.link/@adityabansal095/jobs/senior-data-engineer-satwic-inc-india-8610633d

💼 Role: Data Engineer
🏢 Company: TIGI HR
📍 Location: Gurugram
🌎 Work mode: remote
✨ Why it is worth checking: Covers Airflow, ADF, SQL, Python, ETL workflows, and data warehouse projects.
🔗 https://artha.link/@adityabansal095/jobs/data-engineer-tigi-hr-gurugram-e0612e8f

Share with someone preparing for their next data engineering move.

#DataEngineering #AzureDataEngineer #SQL #Databricks #ETL #Airflow #CloudDataEngineering

This is me @adityabansal095

You can ping me directly here if you need any assistance or any help.

Power BI Roadmap: Step-by-Step Guide to Master Power BI 📊💻

Whether you're aiming to be a data analyst, business intelligence pro, or dashboard expert - this roadmap has you covered 👇

📍 1. Power BI Basics
⦁ Get familiar with Power BI Desktop interface
⦁ Connect to data sources (Excel, CSV, databases)
⦁ Learn Basic visualizations: tables, charts, slicers

📍 2. Data Transformation & Modeling
⦁ Use Power Query Editor to clean & shape data
⦁ Create relationships between tables
⦁ Understand data types & formats

📍 3. DAX Fundamentals
⦁ Master calculated columns & measures
⦁ Learn core functions: SUM, CALCULATE, FILTER, RELATED
⦁ Use variables and time intelligence functions

📍 4. Advanced Visualizations
⦁ Build interactive reports and dashboards
⦁ Use bookmarks, buttons & drill-throughs
⦁ Customize visuals & layouts for storytelling

📍 5. Data Refresh & Gateway
⦁ Set up scheduled refresh with data gateways
⦁ Understand live vs import modes
⦁ Manage refresh performance

📍 6. Row-Level Security (RLS)
⦁ Learn to restrict data access by user roles
⦁ Implement roles & test security in reports

📍 7. Power BI Service & Collaboration
⦁ Publish reports to Power BI Service
⦁ Share dashboards and collaborate with teams
⦁ Use workspaces, apps, and permissions

📍 8. Power BI Mobile & Embedded
⦁ Optimize reports for mobile devices
⦁ Embed Power BI visuals in apps or websites

📍 9. Performance Optimization
⦁ Use Performance Analyzer to tune reports
⦁ Optimize data models & DAX queries
⦁ Best practices for large datasets

📍 10. Power BI API & Automation
⦁ Use Power BI REST API for automation
⦁ Integrate with Power Automate & Azure services

📍 11. Real Projects & Practice
⦁ Build sample dashboards: Sales, Marketing, Finance
⦁ Join challenges on platforms like Enterprise DNA, Radacad

📍 12. Certification & Career Growth
⦁ Prepare for DA-100 / PL-300 certification
⦁ Build portfolio & LinkedIn presence
⦁ Apply for BI Analyst & Power BI Developer roles

💡 Pro Tip: Combine Power BI skills with SQL and Python for a powerful data career combo!

Pandas Interview Q&A (Frequently Asked)

📊 Q1. What is Pandas and why is it used?

👉 Python library for data manipulation & analysis
👉 Provides powerful data structures like DataFrame & Series
👉 Used for cleaning, transforming, and analyzing data

📊 Q2. What is the difference between Series and DataFrame?

👉 Series → 1D labeled array (single column)
👉 DataFrame → 2D tabular structure (rows & columns)
👉 DataFrame is a collection of multiple Series

📊 Q3. How do you handle missing values in Pandas?

👉 isnull() / notnull() to detect missing values
👉 fillna() to replace missing data
👉 dropna() to remove missing records

📊 Q4. What is the difference between loc[] and iloc[]?

👉 loc[] → Label-based indexing
👉 iloc[] → Integer position-based indexing
👉 Use loc for named indexes, iloc for numeric positions

📊 Q5. What is groupby() in Pandas?

👉 Used for splitting data into groups
👉 Apply aggregation functions (sum, mean, count)
👉 Essential for data summarization

📊 Q6. What is the difference between merge() and concat()?

👉 merge() → SQL-like joins (inner, left, right, outer)
👉 concat() → Stacks data vertically or horizontally
👉 Use merge for relational data combining

📊 Q7. How do you filter data in Pandas?

👉 Use boolean conditions (df[df['col'] > value])
👉 Multiple conditions using & and |
👉 Helps in extracting specific insights

📊 Q8. What is apply() function?

👉 Applies a function across rows or columns
👉 Used for custom transformations
👉 More flexible than built-in functions

🚀 Data engineering roles worth checking for SQL learners



💼 Role: Data Engineer
🏢 Company: EXL
📍 Location: India, IN
🌎 Work mode: remote
✨ Why it is worth checking: Strong exposure to AWS Glue, Redshift, Athena, PySpark, ETL/ELT pipelines, and data warehousing concepts.
🔗 https://artha.link/@adityabansal095/jobs/data-engineer-exl-india-ab6b2cd2

💼 Role: Data Engineer
🏢 Company: Newtap Finance
📍 Location: Bengaluru, Karnataka, IN
🌎 Work mode: onsite
✨ Why it is worth checking: Hands-on work with Airflow, EMR, Spark, Athena, CDC ingestion, and lakehouse architecture.
🔗 https://artha.link/@adityabansal095/jobs/data-engineer-newtap-finance-bengaluru-36d7cd70

💼 Role: Data Engineer – Analytics & Aws
🏢 Company: Health Catalyst
📍 Location: Hyderabad, Telangana, IN
🌎 Work mode: remote
✨ Why it is worth checking: Good mix of data engineering and analytics using AWS Glue, Snowflake, SQL, Python, Kafka, and Airflow.
🔗 https://artha.link/@adityabansal095/jobs/data-engineer-analytics-aws-health-catalyst-hyderabad-14f9084d

Save this for later or share with someone preparing for data engineering interviews.

#DataEngineering #SQL #AWS #Snowflake #Airflow #ETL #Python #Jobs #JobAlert

Most people still get confused between RANK, DENSE_RANK and ROW_NUMBER.

I made a short video explaining the exact difference with a simple example.

Took only 30 seconds.

Watch it here: https://youtube.com/shorts/vptXC6QRjOE

Save it if you have interviews coming up.

𝐒𝐐𝐋 𝐂𝐚𝐬𝐞 𝐒𝐭𝐮𝐝𝐢𝐞𝐬 𝐟𝐨𝐫 𝐈𝐧𝐭𝐞𝐫𝐯𝐢𝐞𝐰:

1. Danny’s Diner:
Restaurant analytics to understand the customer orders pattern.
Link: https://8weeksqlchallenge.com/case-study-1/

2. Pizza Runner
Pizza shop analytics to optimize the efficiency of the operation
Link: https://8weeksqlchallenge.com/case-study-2/

3. Foodie Fie
Subscription-based food content platform
Link: https://lnkd.in/gzB39qAT

4. Data Bank: That’s money
Analytics based on customer activities with the digital bank
Link: https://lnkd.in/gH8pKPyv

5. Data Mart: Fresh is Best
Analytics on Online supermarket
Link: https://lnkd.in/gC5bkcDf

6. Clique Bait: Attention capturing
Analytics on the seafood industry
Link: https://lnkd.in/ggP4JiYG

7. Balanced Tree: Clothing Company
Analytics on the sales performance of clothing store
Link: https://8weeksqlchallenge.com/case-study-7

8. Fresh segments: Extract maximum value
Analytics on online advertising
Link: https://8weeksqlchallenge.com/case-study-8

🚀 Data engineering roles with strong cloud stack exposure

If you are working on SQL, ETL pipelines, Databricks, Snowflake, or PySpark projects, these roles are worth checking.

💼 Role: Aws Data Engineer
🏢 Company: Tata Consultancy Services
📍 Location: Bengaluru, Noida, Gandhi Nagar, Pune, Chennai
✨ Why it is worth checking: Strong focus on Databricks on AWS, Delta Lake, Structured Streaming, CDC, and Medallion Architecture.
🔗 https://artha.link/@adityabansal095/jobs/aws-data-engineer-tata-consultancy-gandhinagar-92feef28

💼 Role: Azure Data Engineer
🏢 Company: Recro
📍 Location: Hyderabad, Bangalore, Pune
🌎 Work mode: hybrid
✨ Why it is worth checking: Good match if you are building Azure data pipelines with ADF, SQL, Python, PySpark, and Databricks.
🔗 https://artha.link/@adityabansal095/jobs/azure-data-engineer-recro-pune-district-75c72d64

💼 Role: Azure Data Engineer
🏢 Company: EXL
📍 Location: Noida, Gurgaon, Pune, Bangalore, Hyderabad, Chennai
🌎 Work mode: remote
✨ Why it is worth checking: Useful for engineers working with ADF, DBT, Snowflake, and ETL/ELT workflows.
🔗 https://artha.link/@adityabansal095/jobs/azure-data-engineer-exl-noida-6c18eb62

Save this for later or send it to someone job hunting.

#DataEngineering #SQL #Databricks #Snowflake #AzureDataFactory #PySpark #ETL

💥𝐌𝐲 𝐟𝐫𝐢𝐞𝐧𝐝 𝐣𝐮𝐬𝐭 𝐠𝐨𝐭 𝐚 𝟏𝟐 𝐋𝐏𝐀 𝐃𝐚𝐭𝐚 𝐀𝐧𝐚𝐥𝐲𝐬𝐭 𝐫𝐨𝐥𝐞 𝐚𝐭 𝐏𝐰𝐂.

🎯What stood out in his interviews wasn’t basic SELECT and WHERE.
He was comfortable with JOINs, CTEs, window functions, and actual problem-solving questions.

That’s the gap I see with a lot of people preparing right now.
They know the syntax.

But when the question gets a bit messy, they freeze.

🧠If you’re preparing for data roles, focus less on memorising commands and more on solving real problems.

𝐒𝐭𝐚𝐫𝐭 𝐟𝐫𝐨𝐦 𝐬𝐜𝐫𝐚𝐭𝐜𝐡. 𝐋𝐞𝐚𝐫𝐧. 𝐁𝐮𝐢𝐥𝐝. 𝐑𝐞𝐩𝐞𝐚𝐭.

Don’t mean to offend anyone
But if anyone does not find value in this post or things shared in this channel

Please leave or please ping me on what needs to be improved

Data Science Interview Prep Guide

1️⃣ Core Data Science Concepts
• What is Data Science vs Data Analytics vs ML
• Descriptive, diagnostic, predictive, prescriptive analytics
• Structured vs unstructured data
• Data-driven decision making
• Business problem framing

2️⃣ Statistics Probability (Non-Negotiable)
• Mean, median, variance, standard deviation
• Probability distributions (normal, binomial, Poisson)
• Hypothesis testing p-values
• Confidence intervals
• Correlation vs causation
• Sampling bias

3️⃣ Data Cleaning EDA
• Handling missing values outliers
• Data normalization scaling
• Feature engineering
• Exploratory data analysis (EDA)
• Data leakage detection
• Data quality validation

4️⃣ Python SQL for Data Science
• Python (NumPy, Pandas)
• Data manipulation transformations
• Vectorization performance optimization
• SQL joins, CTEs, window functions
• Writing business-ready queries

5️⃣ Machine Learning Essentials
• Supervised vs unsupervised learning
• Regression vs classification
• Model selection baseline models
• Overfitting, underfitting
• Bias–variance tradeoff
• Hyperparameter tuning

6️⃣ Model Evaluation Metrics
• Accuracy, precision, recall, F1
• ROC AUC
• Confusion matrix
• RMSE, MAE, log loss
• Metrics for imbalanced data
• Linking ML metrics to business KPIs

7️⃣ Real-World Deployment Knowledge
• Feature stores
• Model deployment (batch vs real-time)
• Model monitoring drift
• Experiment tracking
• Data model versioning
• Model explainability (business-friendly)

8️⃣ Must-Have Projects
• Customer churn prediction
• Fraud detection
• Sales or demand forecasting
• Recommendation system
• End-to-end ML pipeline
• Business-focused case study

9️⃣ Common Interview Questions
• Walk me through an end-to-end DS project
• How do you choose evaluation metrics?
• How do you handle imbalanced data?
• How do you explain a model to leadership?
• How do you improve a failing model?

🔟 Pro Tips
✔️ Always connect answers to business impact
✔️ Explain why, not just how
✔️ Be clear about trade-offs
✔️ Discuss failures learnings
✔️ Show structured thinking