Example Data Analyst Interview Question - Can you solve this? πŸ€” @chandoo_
Example Data Analyst Interview Question - Can you solve this? πŸ€”  @chandoo_
Uploaded July 2023 | Updated November 2026, 3 hours ago
πŸ’₯ Need to ace your Excel interviews? Get Excel School πŸ‘‰ chandoo.org/wp/excel-school-program

~

Here is a tricky Excel interview question. How do you figure out who our loyal customers are?

In this video, let me show you how to answer such tricky, hard interview questions using Excel functions.

We are going to use functions like FILTER, UNIQUE, MINIFS etc. to solve the problem.

⏱ In this video:
=============

0:00 - The hard Excel interview questions
0:40 - Calculating the next order date & gap to next order
3:04 - First question: How many customer place repeat order in 7 days and who are they?
4:06 - Second question: Of the customers who ordered in April 2023, who placed a repeat order in 2 weeks?
7:25 - How to solve questions like this using Excel?

πŸ“Sample file & answers:
=====================

Check the problem file & answers here - chandoo.org/wp/wp-content/uploads/2023/07/interview-question-loyal-customers-.xlsx

πŸ“Ί WATCH NEXT:
===============

Beginner to PRO - Advanced Excel Class - youtu.be/v2oNWja7M2E
How to clean, analyze and present data - youtu.be/H6k28jhclwI
15 Advanced Excel Formulas - youtu.be/B5hayFelHDU
Top 10 Data Analyst Interview Questions - youtu.be/MX6Ee_ubE1s

πŸ‘©β€πŸ’» Excel School Program - chandoo.org/wp/excel-school-program

~

#excelinterviewquestions #excel
Example Data Analyst Interview Question - Can you solve this? πŸ€”Cumulative Averages in Excel - Easy FormulaBest Excel Formulas in an hour - Beginner to PRO MasterclassIntroduction to DAX SVG Charts (way better than default Power BI visuals)XLOOKUP in Excel | Step-by-Step Tutorial for Beginners (better than VLOOKUP)How I easily deal with 100s of columns in Excel ~ PRO TrickπŸ’‘Email Excel Reports with Power Automate & Office Scrips - One Click Automation πŸ€–Combine Excel Sheets with *this* simple formulaExcel for Managers [FREE Masterclass]How to Remove Duplicate Values in Excel - Data Cleaning Tips🧹Easy XLOOKUP Hacks You Need To Try in Excel!Excel Magic Revealed: Unstacking Data Like a Pro! ✨
Chandoo |

Example Data Analyst Interview Question - Can you solve this? πŸ€”

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER