Data Analyst Interview Resources

🔥 SQL Interview Question of the Day

📌 Scenario:

A company wants to identify employees who share the same salary with at least one other employee.

You have one table:

employees

• employee_id
• employee_name
• salary

☑ Solution:

SELECT
employee_id,
employee_name,
salary
FROM employees
WHERE salary IN (
SELECT salary
FROM employees
GROUP BY salary
HAVING COUNT(*) > 1
);

💡 Concept Tested:

Subquery + GROUP BY + HAVING

❤️ React if you want more SQL interview questions.

🔥 SQL Interview Question of the Day

📌 Scenario:

An organization wants to find employees who earn more than their managers.

You have one table:

employees

• employee_id
• employee_name
• salary
• manager_id

☑ Solution:

SELECT
e.employee_name,
e.salary,
m.employee_name AS manager_name,
m.salary AS manager_salary
FROM employees e
JOIN employees m
ON e.manager_id = m.employee_id
WHERE e.salary > m.salary;

💡 Concept Tested:

SELF JOIN

❤️ React if you want more SQL interview questions.

💡 Excel Tips & Tricks 🧠📊
Part 2 — Tips That Save Time

🔹 Tip 11: Use Flash Fill
When Excel recognizes a pattern, press: Ctrl + E
📌 Great for splitting, combining, or reformatting text without writing formulas.

🔹 Tip 12: Quickly Insert a New Line Inside a Cell
Press: Alt + Enter
📌 Useful when you need multiple lines of text within one cell.

🔹 Tip 13: Select Only Visible Cells
After filtering data, press: Alt + ;
📌 This selects only visible cells, preventing you from accidentally modifying hidden or filtered-out rows.

🔹 Tip 14: Use Absolute References When Needed
If a formula needs to always refer to the same cell or range, use $.
Example: =B2*E1
📌 E1 remains fixed when you copy the formula.

🔹 Tip 15: Quickly Copy a Formula Down
Double-click the fill handle (small square at the bottom-right of the selected cell).
📌 Excel automatically fills the formula down alongside the neighboring data.

🔹 Tip 16: Use Ctrl + 1 to Open Format Cells
Instead of navigating through menus, press: Ctrl + 1
📌 Quickly change number formats, alignment, borders, protection, and more.

🔹 Tip 17: Use SUM() with AutoSum
Press: Alt + =
📌 Excel automatically suggests a range and inserts a SUM() formula.

🔹 Tip 18: Quickly Create a Chart
Select your data and press: Alt + F1
📌 Excel creates a chart directly on the current worksheet.

🔹 Tip 19: Use Ctrl + Shift + $ for Currency Format
Select the values and press: Ctrl + Shift + $
📌 Quickly applies currency formatting.

🔹 Tip 20: Use Named Ranges for Important Data
Instead of repeatedly using ranges such as B2:B1000, give the range a meaningful name.

Example: SalesData
📌 Formulas become easier to understand and maintain.

💬 Double Tap ♥️ For More Excel Tips!

If you are interested to learn SQL for data analytics purpose and clear the interviews, just cover the following topics

1)Install MYSQL workbench
2) Select
3) From
4) where
5) group by
6) having
7) limit
8) Joins (Left, right , inner, self, cross)
9) Aggregate function ( Sum, Max, Min , Avg)
9) windows function ( row num, rank, dense rank, lead, lag, Sum () over)
10)Case
11) Like
12) Sub queries
13) CTE
14) Replace CTE with temp tables
15) Methods to optimize Sql queries
16) Solve problems and case studies at Ankit Bansal youtube channel

Trick: Just copy each term and paste on youtube and watch any 10 to 15 minute on each topic and practise it while learning , By doing this , you get the basics understanding

17) Now time to go on youtube and search data analysis end to end project using sql

18) Watch them and practise them end to end.

17) learn integration with power bi

In this way , you will not only memorize the concepts but also learn how to implement them in your current working and projects and will be able to defend it in your interviews as well.

Like for more

✅ Excel Scenario-Based Questions for Interview & Practice 🧠📊

📌 Scenario 101
Question: You have a list of employees and their sales. You need to return the employee name who achieved the highest sales. How would you do it?

Answer: Use "XLOOKUP()" with "MAX()".

Example: "=XLOOKUP(MAX(B2:B100),B2:B100,A2:A100)"

This returns the employee associated with the highest sales.

📊 Scenario 102
Question: Your manager wants to calculate the total sales for the current month automatically. How would you do it?

Answer: Use "SUMIFS()" with date boundaries.

Example: "=SUMIFS(B:B,A:A,">="&EOMONTH(TODAY(),-1)+1,A:A,"<="&EOMONTH(TODAY(),0))"

This calculates sales from the first day through the last day of the current month.

📅 Scenario 103
Question: You need to determine the number of days between an order date and delivery date, but negative values should not appear. How would you handle it?

Answer: Use "MAX()".

Example: "=MAX(0,C2-B2)"

This returns the actual number of days when the delivery date is later, otherwise it returns "0".

📈 Scenario 104
Question: Your dataset contains sales values with occasional negative numbers representing refunds. Your manager wants total sales excluding refunds. How would you calculate it?

Answer: Use "SUMIF()" with a condition greater than zero.

Example: "=SUMIF(B2:B1000,">0",B2:B1000)"

This adds only positive sales values.

🔍 Scenario 105
Question: You have a column containing "First Name", "Last Name", and "Department", and you need to create a unique employee identifier such as "John_Smith_IT". How would you do it?

Answer: Combine the fields using "&" or "TEXTJOIN()".

Example: "=TEXTJOIN("_",TRUE,A2,B2,C2)"

This combines the values using an underscore separator.

💬 Double Tap ♥️ For More!

🔥 Most Asked SQL JOIN Patterns (Real Business Problems)

🔹 Find Customers Who Never Placed an Order → LEFT JOIN + NULL Check

🔹 Match Employees With Their Managers → SELF JOIN

🔹 Find Products Without Suppliers → LEFT JOIN

🔹 Generate Complete Sales Reports → INNER JOIN Across Multiple Tables

🔹 Compare Current & Previous Month Sales → SELF JOIN / CTE

🔹 Find Orders With Missing Customer Records → LEFT JOIN

🔹 Identify Common Customers Across Two Platforms → INNER JOIN

🔹 Find Products Purchased Together → SELF JOIN

🔹 Combine Sales From Multiple Sources → UNION ALL

🔹 Build Customer Purchase History → Multiple JOINs

❤️ React if you want more SQL interview patterns based on real company problems!

✅ Excel Scenario-Based Questions for Interview & Practice 🧠📊

📌 Scenario 96

Question: You have a dataset with thousands of rows and want to quickly identify the highest sales transaction for each region. How would you do it?

Answer: Use "MAXIFS()".

Example:

"=MAXIFS($B$2:$B$1000,$A$2:$A$1000,D2)"

Where "A" contains Region, "B" contains Sales, and "D2" contains the region you want to analyze.

📊 Scenario 97

Question: Your manager wants to calculate the number of unique products sold in each region. How would you do it in modern Excel?

Answer: Use "FILTER()", "UNIQUE()", and "COUNTA()".

Example:

"=COUNTA(UNIQUE(FILTER(B2:B1000,A2:A1000=D2)))"

This counts distinct products for the region specified in "D2".

📅 Scenario 98

Question: You have a monthly sales report and want users to select a month from a dropdown and automatically display the corresponding sales. How would you do it?

Answer: Create a dropdown using Data Validation and use "XLOOKUP()".

Example:

"=XLOOKUP(E2,A2:A13,B2:B13,"Not Found")"

Where "E2" contains the selected month.

📈 Scenario 99

Question: Your Excel report contains formulas that should not be visible to users, but users still need to enter data into specific cells. How would you protect the workbook?

Answer:

1. Select input cells → Format Cells → Protection → Unlock them.

2. Keep formula cells locked.

3. Go to Review → Protect Sheet.

4. Set a password if required.

This allows users to edit only the designated input cells.

🔍 Scenario 100

Question: Your manager gives you a large, messy dataset containing duplicates, missing values, inconsistent formats, and multiple files. You need to create a clean, refreshable report. What approach would you take?

Answer: Use a combination of Power Query, Excel Tables, Pivot Tables, and Data Validation.

A practical workflow would be:

➡️ Import and combine files using Power Query

➡️ Remove duplicates and handle missing values

➡️ Standardize data formats

➡️ Load the cleaned data into an Excel Table

➡️ Build Pivot Tables/Pivot Charts for analysis

➡️ Add Slicers for interactive filtering

➡️ Refresh the report whenever new data is received

💬 Double Tap ♥️ For More!

✅ Excel Scenario-Based Questions for Interview & Practice 🧠📊

📌 Scenario 91

Question: You have sales data for multiple regions and want to automatically return the region with the highest sales. How would you do it?

Answer: Use "INDEX()" with "MATCH()" and "MAX()".

Example:

"=INDEX(A2:A10,MATCH(MAX(B2:B10),B2:B10,0))"

This returns the region corresponding to the highest sales value.

📊 Scenario 92

Question: You need to calculate the average sales for transactions greater than ₹50,000. How would you do it?

Answer: Use "AVERAGEIF()".

Example:

"=AVERAGEIF(B2:B100,">50000",B2:B100)"

This calculates the average of only those sales values greater than ₹50,000.

📅 Scenario 93

Question: You have a list of dates and want to group them into months for reporting. How would you do it?

Answer: Use a Pivot Table.

Add the Date field to Rows → Right-click any date → Group → Select Months (and Years if required).

📈 Scenario 94

Question: Your manager wants to see sales performance visually and interactively by region, product, and month. What would you use?

Answer: Create a Pivot Chart with Slicers.

Create a Pivot Table → Insert Pivot Chart → Add slicers for Region, Product, and other relevant fields. This allows users to filter the report interactively.

🔍 Scenario 95

Question: You need to identify the 3rd highest unique sales value, even when duplicate sales amounts exist. How would you do it?

Answer: In modern Excel, combine "UNIQUE()" and "LARGE()".

Example:

"=LARGE(UNIQUE(B2:B100),3)"

This returns the 3rd highest distinct sales value.

💬 Double Tap ♥️ For More!

🚀 𝗪𝗶𝗽𝗿𝗼 𝗘𝗹𝗶𝘁𝗲 𝗡𝗧𝗛 & 𝗧𝘂𝗿𝗯𝗼 𝗙𝗥𝗘𝗘 𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄 𝗞𝗶𝘁 💻🔥

Get access to a FREE interview preparation kit and prepare smarter for your upcoming assessment & interview rounds.

📚 Prepare For:-
✅ Technical Interview Questions
✅ Software Engineer Interview Rounds
✅ Interview Preparation Resources

🎯 Perfect for Students | Freshers | Engineering Graduates | Wipro Aspirants

🔗 𝗚𝗲𝘁 𝗙𝗥𝗘𝗘 𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄 𝗞𝗶𝘁 👇:-

https://pdlink.in/4zh9E6g

🔥 Start preparing early and improve your chances of cracking the Wipro hiring process!

✅ Excel Scenario-Based Questions for Interview & Practice 🧠📊

📌 Scenario 86

Question: You have a sales dataset with multiple transactions for the same customer. Your manager wants to calculate each customer's total sales without creating a Pivot Table. How would you do it?

Answer: Use SUMIF().

Example:

=SUMIF($A$2:$A$100,A2,$B$2:$B$100)

Where A contains Customer IDs and B contains Sales.

📊 Scenario 87

Question: You need to find the percentage of sales contributed by each region compared with total company sales. How would you calculate it?

Answer: Divide the region's sales by the total sales.

Example:

=B2/SUM($B$2:$B$10)

Format the result as a Percentage.

📅 Scenario 88

Question: Your manager wants to know whether each transaction occurred on a weekend. How would you identify it?

Answer: Use WEEKDAY() with IF().

Example:

=IF(WEEKDAY(A2,2)>5,"Weekend","Weekday")

With 2 as the second argument, Monday = 1 and Sunday = 7.

📈 Scenario 89

Question: You have a list of sales values and need to calculate the median sales amount instead of the average. Which function would you use?

Answer: Use MEDIAN().

Example:

=MEDIAN(B2:B100)

This returns the middle value when the sales values are arranged in order.

🔍 Scenario 90

Question: Your dataset contains product names with unwanted line breaks copied from another system. How would you remove them?

Answer: Use CLEAN().

Example:

=CLEAN(A2)

For extra spaces as well, you can combine it with TRIM():

=TRIM(CLEAN(A2))

💬 Double Tap ♥️ For More!

🚀 𝗔𝗜 & 𝗠𝗮𝗰𝗵𝗶𝗻𝗲 𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴 𝗙𝗥𝗘𝗘 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲

🔥 Upgrade your skills and prepare for exciting career opportunities in AI!

✅ Beginner-friendly course
✅ Learn AI & Machine Learning fundamentals
✅ Gain practical, job-ready skills
✅ Earn a FREE certificate
✅ Boost your resume and LinkedIn profile
✅ Ideal for students, freshers and professionals

🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗳𝗼𝗿 𝗙𝗥𝗘𝗘 👇:-

https://pdlink.in/4zrkYNg

⚡ Limited opportunity—start learning today!

☁️ 𝟰 𝗙𝗥𝗘𝗘 𝗚𝗼𝗼𝗴𝗹𝗲 𝗖𝗹𝗼𝘂𝗱 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 | 𝗕𝘂𝗶𝗹𝗱 𝗜𝗻-𝗗𝗲𝗺𝗮𝗻𝗱 𝗖𝗹𝗼𝘂𝗱 𝗦𝗸𝗶𝗹𝗹𝘀

Explore these Google Cloud learning resources covering cloud fundamentals, infrastructure, networking, security, data and AI/ML.

🔥 4 Courses to Explore:
1️⃣ Cloud Computing Fundamentals
2️⃣ Infrastructure in Google Cloud
3️⃣ Networking & Security in Google Cloud
4️⃣ Data, ML & AI in Google Cloud

🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇:- 

https://pdlink.in/4zrksPn

🎯 Perfect for Students | Freshers | Developers | Cloud & DevOps Aspirants

✅ Excel Scenario-Based Questions for Interview & Practice 🧠📊

📌 Scenario 81

Question: You have a list of sales transactions and need to calculate a running total that updates as you move down the rows. How would you do it?

Answer: Use SUM() with an expanding range.

Example:

=SUM($B$2:B2)

Copy the formula down. Each row will show the cumulative sales up to that transaction.

📊 Scenario 82

Question: Your manager wants to compare this year's sales with last year's sales and calculate the growth percentage. How would you do it?

Answer: Use the percentage growth formula.

Example:

=(B2-C2)/C2

Where B2 is the current year's sales and C2 is the previous year's sales. Format the result as a Percentage.

📅 Scenario 83

Question: You have a list of employee joining dates and want to identify employees who joined within the last 30 days. How would you do it?

Answer: Use IF() with TODAY().

Example:

=IF(AND(A2>=TODAY()-30,A2<=TODAY()),"Joined Last 30 Days","Older")

📈 Scenario 84

Question: Your sales report contains values such as "₹1,000", "₹2,500", and "₹5,000" stored as text. How would you convert them into numbers?

Answer: Remove the currency symbol and convert the remaining text to a number.

Example:

=VALUE(SUBSTITUTE(A2,"₹",""))

This converts the text value into a numeric value that can be used in calculations.

🔍 Scenario 85

Question: You need to compare two lists of Employee IDs and identify which IDs are missing from the second list. How would you do it?

Answer: Use XLOOKUP() with ISNA().

Example:

=IF(ISNA(XLOOKUP(A2,List2!A:A,List2!A:A)),"Missing","Found")

This identifies whether each Employee ID from the first list exists in the second list.

💬 Double Tap ♥️ For More!

🔥 SQL Interview Concept You MUST Know: COUNT()

COUNT() is one of the most commonly asked SQL functions in Data Analyst interviews.

It helps you count rows, records, or unique values, making it essential for reporting and data analysis.

📌 Key points:

🔹 Counts rows in a table
🔹 Can count non-NULL values using a column
🔹 COUNT(*) includes all rows
🔹 COUNT(DISTINCT column) counts unique values
🔹 Frequently used with GROUP BY

💡 Common interview use cases:

✅ Counting total customers
✅ Finding the number of orders per customer
✅ Counting unique products sold
✅ Measuring website visits
✅ Creating summary reports and dashboards

❤️ React if you want more SQL interview concepts explained in a simple way.

𝗪𝗢𝗥𝗞 𝗙𝗥𝗢𝗠 𝗛𝗢𝗠𝗘 𝗝𝗢𝗕 𝗢𝗣𝗣𝗢𝗥𝗧𝗨𝗡𝗜𝗧𝗬 😍

Company Name :- AI InsurTech Company

💼 𝗥𝗼𝗹𝗲: Backend Developer
💰 𝗦𝗮𝗹𝗮𝗿𝘆: ₹5 LPA
🏠 𝗪𝗼𝗿𝗸 𝗠𝗼𝗱𝗲: Work From Home
📍 𝗟𝗼𝗰𝗮𝘁𝗶𝗼𝗻: Hyderabad / Remote

🎓 𝗪𝗵𝗼 𝗖𝗮𝗻 𝗔𝗽𝗽𝗹𝘆?
✅ BTech/BE graduates
✅ Branches: CS, IT, AI, ML and Data-related streams
✅ Graduation Years: 2025 and 2026

🔗 𝗔𝗽𝗽𝗹𝘆 𝗡𝗼𝘄 👇:-

https://pdlink.in/4xIfsE4

⚡ Apply early and share this opportunity with your friends!

𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝗰𝗲 𝗙𝗥𝗘𝗘 𝗢𝗻𝗹𝗶𝗻𝗲 𝗠𝗮𝘀𝘁𝗲𝗿𝗰𝗹𝗮𝘀𝘀 😍

💫Kickstart Your Data Science Career

💫Join this Masterclass for an expert-led session on Data Science

Eligibility :- Students ,Freshers & Working Professionals

𝗥𝗲𝗴𝗶𝘀𝘁𝗲𝗿 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘 👇:-

https://pdlink.in/4xOh5jA

(Only few slots left )

Date & Time :- 21st August 2026 & 7PM

🔥 SQL Interview Concept You MUST Know: LEAD()

LEAD() is a powerful SQL window function that lets you access data from the next row without using a self join.
It's widely used in analytics to compare current values with future values in a dataset.

📌 Key points:

🔹 Retrieves values from the next row
🔹 Uses the OVER() clause
🔹 Eliminates the need for self joins
🔹 Ideal for sequential and time-series analysis
🔹 Common in advanced SQL interview questions

💡 Common interview use cases:

✅ Comparing current and next month's sales
✅ Calculating future growth trends
✅ Identifying changes between consecutive records
✅ Tracking customer activity over time
✅ Building analytical business reports

❤️ React if you want more SQL interview concepts explained in a simple way.

🎓 𝟰 𝗙𝗥𝗘𝗘 𝗖𝗲𝗿𝘁𝗶𝗳𝗮𝘁𝗶𝗼𝗻𝘀 𝗧𝗼 𝗠𝗮𝘀𝘁𝗲𝗿 𝗜𝗻 𝟮𝟬𝟮𝟲 🚀

Want to build job-ready skills and strengthen your resume? Start learning these in-demand technologies for FREE! 🔥

📊 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 :- https://pdlink.in/4qn5q94

💫 𝗔𝗜 & 𝗠𝗮𝗰𝗵𝗶𝗻𝗲 𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴 :- https://pdlink.in/4zrkYNg

☁️ 𝗖𝗹𝗼𝘂𝗱 𝗖𝗼𝗺𝗽𝘂𝘁𝗶𝗻𝗴 :- https://pdlink.in/4wzy6Ny

🛡️ 𝗖𝘆𝗯𝗲𝗿 𝗦𝗲𝗰𝘂𝗿𝗶𝘁𝘆 :- https://pdlink.in/4xMJNl5

🔁 𝗦𝗵𝗮𝗿𝗲 this with your friends and classmates!

📊 𝗪𝗮𝗻𝘁 𝘁𝗼 𝗕𝗲𝗰𝗼𝗺𝗲 𝗮 𝗣𝗿𝗼 𝗶𝗻 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀? 🚀

Learning Excel, SQL and Power BI is only the beginning. To stand out as a Data Analyst, focus on practical experience, visibility and networking.

🔥 4 Ways to Level Up Your Data Analytics Career:

💡 Master the Skills → Build Projects → Create Your Portfolio → Get Noticed

🔗 𝗖𝗵𝗲𝗰𝗸 𝘁𝗵𝗲 𝗖𝗼𝗺𝗽𝗹𝗲𝘁𝗲 𝗚𝘂𝗶𝗱𝗲 👇

https://pdlink.in/4cIfLqn

🎯 Perfect for Students | Freshers | Data Analyst Aspirants | Career Switchers

🚀 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲 📊🔥

𝗕𝘂𝗶𝗹𝗱 𝗝𝗼𝗯-𝗥𝗲𝗮𝗱𝘆 𝗦𝗸𝗶𝗹𝗹𝘀 & Learn the tools companies actually use and prepare for high-growth Data Analyst opportunities.

💼 60+ Hiring Drives Every Month
🤝 500+ Hiring Partners
👨‍🏫 1-on-1 Expert Mentorship
📝 Resume & Interview Preparation
🚀 Dedicated Placement Assistance

🔗 𝗕𝗼𝗼𝗸 𝗮 𝗙𝗥𝗘𝗘 𝗖𝗮𝗿𝗲𝗲𝗿 𝗖𝗼𝘂𝗻𝘀𝗲𝗹𝗹𝗶𝗻𝗴👇:-

https://pdlink.in/45vk5ph

🎓 Perfect for Students | Freshers | Working Professionals | Career Switchers