🚀 Data Analytics Interview Questions & Answers – Case Study Questions Part 8 📊🔥

Case study questions test your analytical thinking, business understanding, problem-solving approach, and communication skills.

Interviewers are usually NOT looking for the exact answer.

They want to understand:

✔ How you think

✔ How you structure problems

✔ Which metrics you analyze

✔ How you reach conclusions

171. Sales Have Dropped by 20%. How Would You Analyze It?

Answer Approach

Step 1: Identify the Problem

Questions:

• Which products are affected?

• Which regions are affected?

• Since when did the decline start?

Step 2: Analyze Key Metrics

Check:

✔ Revenue

✔ Orders

✔ Customers

✔ Average Order Value

Step 3: Segment the Analysis

Analyze by:

✔ Product Category

✔ Region

✔ Customer Segment

✔ Sales Channel

Step 4: Find Root Cause

Possible Reasons:

✔ Competitor activity

✔ Pricing changes

✔ Reduced marketing spend

✔ Inventory issues

Recommendation

Identify affected segments and create targeted recovery strategies.

172. Why Are Customers Leaving a Platform?

Answer Approach

Analyze:

✔ Churn Rate

✔ Customer Lifetime Value

✔ Customer Satisfaction

✔ Product Usage

Questions to Ask

• Which customers are leaving?

• When are they leaving?

• What changed before churn?

Metrics

✔ Retention Rate

✔ Active Users

✔ Subscription Renewals

Recommendation

Identify churn drivers and improve customer engagement.

173. How Would You Improve App Engagement?

Answer Approach

Analyze:

✔ Daily Active Users DAU

✔ Monthly Active Users MAU

✔ Session Duration

✔ Retention Rate

Investigate

✔ Drop-off points

✔ User journey

✔ Feature usage

Possible Solutions

✔ Push notifications

✔ Personalized recommendations

✔ Improved onboarding

174. Delivery Times Have Increased. How Would You Analyze It?

Answer Approach

Check:

✔ Average Delivery Time

✔ Delayed Orders

✔ Region-wise Performance

Analyze

✔ Delivery Partners

✔ Traffic Conditions

✔ Warehouse Performance

Root Causes

✔ Increased demand

✔ Staff shortages

✔ Route inefficiencies

Recommendation

Optimize logistics and improve route planning.

175. Company Profit Is Decreasing Despite Increasing Sales. Why?

Answer Approach

Analyze:

✔ Revenue

✔ Cost

✔ Profit Margin

Possible Reasons

✔ Increased discounts

✔ Higher operating costs

✔ Rising transportation costs

✔ Supplier price increases

Metrics to Review

✔ Gross Margin

✔ Net Margin

✔ Cost per Unit

Recommendation

Focus on cost optimization and profitability analysis.

176. How Would You Analyze a Marketing Campaign?

Answer Approach

Measure:

✔ Impressions

✔ Clicks

✔ Conversions

✔ Revenue

KPIs

Questions

• Which channel performed best?

• Which audience converted most?

Recommendation

Increase budget on high-performing channels.

177. How Would You Detect Fraud?

Answer Approach

Look for unusual patterns.

Examples:

✔ Multiple transactions in seconds

✔ Unusual locations

✔ High-value transactions