8️⃣ You receive a dataset with inconsistent date formats. How would you clean it?

Sample Answer:

"I would first determine whether Excel recognizes the values as actual dates or text.

If they are text, I would convert them into proper date values using Power Query, Text to Columns, DATEVALUE, or other appropriate methods depending on the format.

After conversion, I would apply a consistent date format and validate a sample of records."

9️⃣ Your Excel file contains 500,000+ rows and is becoming slow. What would you do?

Sample Answer:

"I would first identify what is causing the performance issue.

I would avoid unnecessary formulas across entire columns, reduce volatile formulas, remove unnecessary formatting, and check whether duplicate or unused data can be removed.

For large datasets or repeatable transformations, I would consider Power Query or connecting Excel to a database instead of performing everything directly in worksheet formulas.

I would choose the solution based on the size, frequency, and complexity of the analysis."

🔟 A manager says the dashboard shows ₹10 crore in sales, but the finance report shows ₹9.5 crore. How would you investigate?

Sample Answer:

"I would not immediately assume that either report is incorrect.

First, I would compare the source datasets and definitions being used.

I would check:

• Date range

• Sales definition

• Filters

• Currency conversion

• Duplicate transactions

• Cancelled or reversed transactions

• Missing records

• Data refresh timing

• Inclusion or exclusion criteria

Then I would reconcile the numbers step by step until I identify the exact reason for the ₹50 lakh difference.

This is important because data analysts should validate the business logic behind a number, not just the number itself."

📌 Double Tap ❤️ For More