Scribd
Upload
2 views3 pages

Data Analytics Interview Notes

This document is a quick revision guide for data analytics interviews, covering key topics such as data analytics overview, data analysis processes, SQL, Excel, Power BI, statistics, Python libraries, KPIs, and scenario-based questions. It includes common interview questions and a sample self-introduction. The guide aims to prepare candidates for various aspects of data analytics roles.

Uploaded by

Saloni Kumari
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
2 views3 pages

Data Analytics Interview Notes

This document is a quick revision guide for data analytics interviews, covering key topics such as data analytics overview, data analysis processes, SQL, Excel, Power BI, statistics, Python libraries, KPIs, and scenario-based questions. It includes common interview questions and a sample self-introduction. The guide aims to prepare candidates for various aspects of data analytics roles.

Uploaded by

Saloni Kumari
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Data Analytics Interview Notes

Quick Revision Guide for Interviews

1. Data Analytics Overview


Data Analytics is the process of collecting, cleaning, transforming, and analyzing data to support
business decisions. Types: Descriptive, Diagnostic, Predictive, and Prescriptive Analytics.

2. Data Analysis Process


Business Understanding → Data Collection → Data Cleaning → Data Exploration → Data
Visualization → Insights → Decision Making.

3. SQL Interview Topics


SELECT, WHERE, GROUP BY, HAVING, ORDER BY, JOINs (INNER, LEFT, RIGHT, FULL),
Subqueries, CTEs, Window Functions, Indexes, Normalization.

Common SQL Questions


Difference between WHERE and HAVING.
Types of JOINs.
Rank vs Dense Rank.
Find second highest salary.
Difference between DELETE, TRUNCATE and DROP.

4. Excel Interview Topics


VLOOKUP, XLOOKUP, INDEX-MATCH, Pivot Tables, Conditional Formatting, Data Validation,
Power Query, Charts, IF, SUMIF, COUNTIF.

5. Power BI Interview Topics


DAX, Measures vs Calculated Columns, Relationships, Star Schema, Dashboards, Reports, Power
Query, Data Refresh.

6. Statistics Basics
Mean, Median, Mode, Variance, Standard Deviation, Correlation vs Causation, Probability,
Sampling.

7. Python for Data Analytics


Libraries: Pandas, NumPy, Matplotlib, Seaborn, Scikit-Learn. DataFrame operations, filtering,
grouping, handling missing values.

8. KPI & Business Metrics


Revenue, Profit, Gross Margin, Customer Retention, Churn Rate, Conversion Rate, ROI, CAC,
LTV.

9. Scenario-Based Questions
How would you identify sales decline?
How would you clean duplicate records?
How would you create an executive dashboard?
How would you handle missing values?

10. Self Introduction Sample


Hello, my name is Saloni Sharma. I have experience working with ERP systems, business
reporting, and client-facing projects. I work with national and international clients and have
experience analyzing business data, preparing reports, and supporting decision-making through
insights. My strengths include SQL, Excel, reporting, ERP processes, and problem solving.
Top 20 Rapid-Fire Interview Questions
1. What is Data Analytics?
2. Difference between Data Analyst and Data Scientist?
3. What is ETL?
4. What is a KPI?
5. What is Data Cleaning?
6. Explain INNER JOIN.
7. Explain LEFT JOIN.
8. What is a Primary Key?
9. What is a Foreign Key?
10. What is Normalization?
11. Difference between SQL and NoSQL?
12. What is a Dashboard?
13. What is Power BI?
14. What is DAX?
15. What is Pivot Table?
16. Mean vs Median?
17. Correlation vs Causation?
18. What is Data Visualization?
19. Explain a project you worked on.
20. Why should we hire you?

You might also like