Data Analyst Interview Questions
Data Analyst interviews are mostly SQL: filtering, joins, grouping, date logic and window functions, with some pandas and Python. These 190+ questions come from 42 companies. Start solving and check your level of preparation.
By company
By topic
All the questions
- Active productsSQL
Targeteasy - Anagram checkPython
Etsyeasy - Any duplicate transaction ids?Python
Visaeasy - Best week of salesPythonTargeteasy
- Clearance candidatesSQLTargeteasy
- Completed trips by cityPandas
Ubereasy - Completed trips by hour of daySQLUbereasy
- Customers outside the US and MexicoSQL
Walmarteasy - Delivery time by cityPandas
Swiggyeasy - Electronics and accessoriesSQL
Best Buyeasy - Even-numbered ordersSQLBest Buyeasy
- FactorialPython
Googleeasy - Find a price in a sorted listPythonBest Buyeasy
- First unique characterPython
Amazoneasy - FizzBuzzPython
Microsofteasy - Hires per yearSQL
LinkedIneasy - In-stock electronicsSQLBest Buyeasy
- Inventory valueSQLWalmarteasy
- Items and aisles per orderPandas
Instacarteasy - Large orders with customer namesSQLAmazoneasy
- Listening minutes per listenerPandas
Pandoraeasy - Listings missing a pricePandas
Zilloweasy - Lowest and highest farePython
Lyfteasy - Merge sales by regionPythonTargeteasy
- Missing order numberPythonWalmarteasy
- Move zero-sale days to the endPythonBest Buyeasy
- Order amount with taxSQL
Stripeeasy - Orders above the averageSQLWalmarteasy
- Orders by statusSQLTargeteasy
- Orders in a price rangeSQLStripeeasy
- Orders per customerSQLTargeteasy
- Orders placed in March 2024SQLBest Buyeasy
- Price bandsSQLAmazoneasy
- Pro productsSQLBest Buyeasy
- Products launched in 2024SQLTargeteasy
- Products under 50SQLWalmarteasy
- Products with no brandSQLAmazoneasy
- Remove duplicates, keep the orderPython
Netflixeasy - Revenue by categoryPandasAmazoneasy
- Reverse the wordsPythonLinkedIneasy
- Rotate a shift schedulePythonWalmarteasy
- Salary against department totalSQLMicrosofteasy
- Show missing discounts as zeroSQLTargeteasy
- Split requests into batchesPythonStripeeasy
- Stock statusSQLAmazoneasy
- Surge share by citySQLLyfteasy
- Total completed revenueSQLWalmarteasy
- Trusted shop reviewsPandasEtsyeasy
- Unfinished orders over 50SQLTargeteasy
- Watch time by genrePandasNetflixeasy
- Average rating by vehicle typePandasUbermedium
- Average reactions per post typeSQL
Metamedium - Average sales cycleSQL
Salesforcemedium - Back to back repeatsSQL
Spotifymedium - Balanced bracketsPythonSalesforcemedium
- Best stretch of daysPython
Robinhoodmedium - Big orders or a loyal customerSQLBest Buymedium
- Booked revenue by cityPandas
Airbnbmedium - Busiest stock per clientSQL
Zerodhamedium - Cancellation rate by room typeSQLAirbnbmedium
- Cancellation split by restaurantSQLSwiggymedium
- Cheapest channel per campaignSQL
Nykaamedium - Completed versus other ordersSQLStripemedium
- Completion rate by content typeSQLNetflixmedium
- Compress a status logPythonUbermedium
- Counting what is recordedSQLWalmartmedium
- Customers with repeat ordersSQLTargetmedium
- Customers without ordersSQLAmazonmedium
- Daily returnSQL
Coinbasemedium - Damage share of refundsSQL
Flipkartmedium - Day over day swingSQLPremiumSwiggymedium
- Days from signup to first orderSQLStripemedium
- Deepest cut per productSQL
Myntramedium - Delivery time by cuisineSQL
DoorDashmedium - Department headcount and paySQLSalesforcemedium
- Drivers without ridesPandasUbermedium
- Employee senioritySQLGooglemedium
- Employees and their managersSQL
Workdaymedium - Everyone in the top threeSQL
DraftKingsmedium - Fare per kilometer by citySQLUbermedium
- First and last position of a userPythonMetamedium
- Flatten a category treePythonAmazonmedium
- Group anagramsPython
Pinterestmedium - High credit utilizationSQL
Capital Onemedium - Hours between scansSQLAmazonmedium
- How often it ran outSQL
Blinkitmedium - Invert team assignmentsPythonCapital Onemedium
- Kth largest orderPythonInstacartmedium
- Latest order statusPandasInstacartmedium
- Lineups above their contest averagePandas
FanDuelmedium - Listening time so farSQLSpotifymedium
- Longest incident per servicePandas
PagerDutymedium - Longest run of consecutive daysPython
Pelotonmedium - Low-rated driversSQLUbermedium
- Merchants with high fraud ratesSQL
Mastercardmedium - Missed minimum paymentsSQLPremiumCapital Onemedium
- Money moved by payment typeSQL
PhonePemedium - Money moved so farSQLPremiumPhonePemedium
- Monthly approved spendPandasVisamedium
- Monthly traded valuePandasRobinhoodmedium
- Most visited locationPythonDoorDashmedium
- Net balance by accountSQLStripemedium
- Nights booked per citySQLAirbnbmedium
- Open positions by userSQLRobinhoodmedium
- Order sequence per customerSQLWalmartmedium
- Orders from enterprise customersSQLAmazonmedium
- Orders per calendar monthSQLWalmartmedium
- Orders per customer segmentSQLAmazonmedium
- Packages still movingSQLAmazonmedium
- Pins by categoryPandasPinterestmedium
- Place within the contestPandasFanDuelmedium
- Plan changesSQL
Shopifymedium - Points above the contest averageSQLDraftKingsmedium
- Position after each tradeSQLZerodhamedium
- Price after discountSQLWalmartmedium
- Price dropsSQLPremiumMyntramedium
- Price moved since last tradeSQLPremiumZerodhamedium
- Price per square foot by citySQLZillowmedium
- Prime vs. standard order valueSQLAmazonmedium
- Priority mix per projectSQL
Atlassianmedium - Prize ranks with tiesSQLDraftKingsmedium
- Quiet time between incidentsSQL
Datadogmedium - Reactions by post typePandasMetamedium
- Read a nested settingPythonMastercardmedium
- Refunds so farSQLPremiumFlipkartmedium
- Resolution time by priorityPandasPremiumAtlassianmedium
- Returns by reasonSQLPremiumFlipkartmedium
- Revenue against targetSQLPremiumSwiggymedium
- Revenue by countrySQLStripemedium
- Revenue by plan and monthPandasShopifymedium
- Revenue by statePandasAmazonmedium
- Revenue to date per merchantSQLShopifymedium
- Running account balancePandasPremiumStripemedium
- Salary rank within departmentSQLNetflixmedium
- Severity mix per serviceSQLDatadogmedium
- Share of plays cut shortPandasPandoramedium
- Shops per tagPandasEtsymedium
- Slow deliveries by cuisinePandasDoorDashmedium
- Slowest ticket per projectSQLAtlassianmedium
- Sort employee recordsPythonWorkdaymedium
- Spend by channelSQLPremiumNykaamedium
- Spend to dateSQLPremiumNykaamedium
- Stage times per packageSQLAmazonmedium
- Subtasks that outlived the parentSQLPremiumAtlassianmedium
- The busiest customerSQLAmazonmedium
- Three day averageSQLCoinbasemedium
- Top earner per departmentPandasSalesforcemedium
- Top partners per citySQLPremiumSwiggymedium
- Top reason per categorySQLPremiumFlipkartmedium
- Top track per listenerSQLSpotifymedium
- Verified rating by shopSQLEtsymedium
- Weekend ordersSQLWalmartmedium
- Where a new price fitsPythonZillowmedium
- Which products repeat?Python
Wayfairmedium - Win rate by sales repSQLPremiumSalesforcemedium
- Averages that skip NULLsSQLAmazonhard
- Best and worst day per assetPandasRobinhoodhard
- Busiest hour per cityPandasPremiumLyfthard
- Card-testing patternsSQLPremiumMastercardhard
- Cost per order gridPandasPremiumNykaahard
- Cross-border share by card tierSQLVisahard
- Drawdown from the peakSQLCoinbasehard
- Each user's top categorySQLPremiumPinteresthard
- Every stockout windowSQLPremiumBlinkithard
- Failures in a rowSQLPremiumPhonePehard
- Highest paid in each departmentSQLMetahard
- Holdings in long formatPandasPremiumRobinhoodhard
- Hours lost by dayPandasPagerDutyhard
- Incidents that overlappedSQLDatadoghard
- Largest order per customerPandasAmazonhard
- Listening sessionsSQLPremiumSpotifyhard
- Longest palindrome in a namePythonAirbnbhard
- Longest price holdSQLPremiumMyntrahard
- Longest rising streakSQLCoinbasehard
- Longest stockout runSQLBlinkithard
- Merged outage windowsSQLDatadoghard
- Minutes from order to doorstepSQLPremiumInstacarthard
- Month-over-month spend changeSQLPremiumVisahard
- Monthly completed revenueSQLStripehard
- Most-watched title in each countrySQLPremiumNetflixhard
- Net position gridPandasPremiumZerodhahard
- Paid above the department averageSQLGooglehard
- Posting on consecutive daysSQLPremiumMetahard
- Retries before it workedSQLPremiumPhonePehard
- Running revenue over timeSQLStripehard
- Search a rotated schedulePythonPremiumUberhard
- Slowest package per facilitySQLAmazonhard
- Stretches that hit a targetPythonPremiumDoorDashhard
- The day the position closedSQLPremiumZerodhahard
- Three transactions that cancel outPythonStripehard
- Top restaurant in each citySQLPremiumDoorDashhard
- Top spending customersSQLAmazonhard
- Unbroken runs of monthsSQLShopifyhard
Questions last reviewed 19 October 2026.