Data Interview Questions
Practice real interview questions for Data & AI roles, and build the skills that get you hired.
Showing 322 of 322 questions
VisaCross-border share by card tierSQLhard
MetaAverage reactions per post typeSQLmedium
SpotifyTop track per listenerSQLmedium
UberCompleted trips by hour of daySQLeasy
InstacartLatest order statusPandasmedium
MicrosoftSalary against department totalSQLeasy
StripeLongest streak of successful paymentsPythoneasy
VisaMonthly approved spendPandasmedium
NetflixWatch time by genrePandaseasy
WalmartTotal completed revenueSQLeasy
ShopifyRevenue by plan and monthPandasmedium
PhonePeFailures in a rowPremiumSQLhard
PinterestTop pin categoriesPythonmedium
GooglePaid above the department averageSQLhard
DatadogQuiet time between incidentsSQLmedium
UberAverage rating by vehicle typePandasmedium
AmazonProducts with no brandSQLeasy
AtlassianSlowest ticket per projectSQLmedium
LyftLowest and highest farePythoneasy
Best BuyPro productsSQLeasy
ZillowTwo homes that match a budgetPythonmedium
Capital OneMissed minimum paymentsPremiumSQLmedium
AmazonLargest order per customerPandashard
ZerodhaPosition after each tradeSQLmedium
AirbnbLongest trip without repeat citiesPremiumPythonhard
EtsyTrusted shop reviewsPandaseasy
MetaHighest paid in each departmentSQLhard
WalmartMissing order numberPythoneasy
AmazonTop spending customersSQLmedium
StripeOutliers by z-scoreStatisticsmedium
TargetProducts launched in 2024SQLeasy
SwiggyDelivery time by cityPandaseasy
FanDuelPlace within the contestPandasmedium
TargetMerge sales by regionPythoneasy
CoinbaseDrawdown from the peakSQLhard
DoorDashDelivery time by cuisineSQLmedium
SalesforceWin rate by sales repPremiumSQLmedium
MicrosoftFizzBuzzPythoneasy
RobinhoodOpen positions by userSQLmedium
NetflixMerge viewing sessionsPythonmedium
AmazonCustomers without ordersSQLmedium
MetaPosting on consecutive daysPremiumSQLhard
WalmartRotate a shift schedulePythoneasy
StripeMonthly completed revenueSQLhard
Best BuyBig orders or a loyal customerSQLmedium
TargetShow missing discounts as zeroSQLeasy
LinkedInReverse the wordsPythoneasy
BlinkitLongest stockout runSQLhard
DraftKingsStandard deviation of scoresStatisticsmedium
SalesforceDepartment headcount and paySQLmedium
AmazonOrders from enterprise customersSQLmedium
WalmartOrder sequence per customerSQLmedium
RobinhoodBest single tradePythonmedium
FlipkartReturns by reasonPremiumSQLmedium
AirbnbCancellation rate by room typeSQLmedium
DatadogSeverity mix per serviceSQLmedium
MastercardMerchants with high fraud ratesSQLmedium
StripeRunning account balancePremiumPandasmedium
AmazonStage times per packageSQLmedium
NykaaSpend to datePremiumSQLmedium
ZillowListings missing a pricePandaseasy
LyftBusiest hour per cityPremiumPandashard
Best BuyFind a price in a sorted listPythoneasy
CoinbaseThree day averageSQLmedium
MyntraDeepest cut per productSQLmedium
DoorDashTop restaurant in each cityPremiumSQLhard
MastercardRead a nested settingPythonmedium
SpotifyListening time so farSQLmedium
EtsyMost common review wordPythonmedium
NykaaCost per order gridPremiumPandashard
WorkdaySort employee recordsPythonmedium
AmazonThe busiest customerSQLmedium
AirbnbLongest palindrome in a namePythonhard
UberFare per kilometer by citySQLmedium
ZerodhaPrice moved since last tradePremiumSQLmedium
AmazonAverages that skip NULLsSQLhard
NetflixMost-watched title in each countryPremiumSQLhard
InstacartMinutes from order to doorstepPremiumSQLhard
WalmartPrice after discountSQLmedium
TargetBest week of salesPythoneasy
StripeNet balance by accountSQLmedium
DoorDashMerge sorted delivery timesPythoneasy
MetaCorrelation between metricsStatisticshard
SwiggyRevenue against targetPremiumSQLmedium
PinterestEach user's top categoryPremiumSQLhard
StripeRevenue by countrySQLmedium
TargetUnfinished orders over 50SQLeasy
AmazonLarge orders with customer namesSQLeasy
PhonePeMoney moved by payment typeSQLmedium
PandoraListening minutes per listenerPandaseasy
ShopifyRevenue to date per merchantSQLmedium
NetflixCompletion rate by content typeSQLmedium
Best BuyCompare with the previous orderSQLhard
SalesforceTop earner per departmentPandasmedium
WalmartProducts under 50SQLeasy
PagerDutyHours lost by dayPandashard
FlipkartTop reason per categoryPremiumSQLmedium
AtlassianResolution time by priorityPremiumPandasmedium
UberDrivers without ridesPandasmedium
AirbnbBooked revenue by cityPandasmedium
ZillowPrice changes month to monthPythoneasy
DraftKingsEveryone in the top threeSQLmedium
StripeCompleted versus other ordersSQLmedium
AmazonRevenue by categoryPandaseasy
RobinhoodBest and worst day per assetPandashard
DatadogThe 95th percentileStatisticsmedium
DoorDashMost visited locationPythonmedium
PhonePeRetries before it workedPremiumSQLhard
TargetCustomers who came backPythonmedium
MetaFirst and last position of a userPythonmedium
VisaAny duplicate transaction ids?Pythoneasy
WalmartOrders per calendar monthSQLmedium
MyntraLongest price holdPremiumSQLhard
WayfairWhich products repeat?Pythonmedium
PinterestPins by categoryPandasmedium
InstacartFirst item bought twicePythoneasy
AmazonPrice bandsSQLeasy
Best BuyElectronics and accessoriesSQLeasy
FanDuelLineups above their contest averagePandasmedium
SwiggyTop partners per cityPremiumSQLmedium
CoinbaseDaily returnSQLmedium
EtsyShops per tagPandasmedium
TargetOrders per customerSQLeasy
ShopifyPlan changesSQLmedium
ZerodhaBusiest stock per clientSQLmedium
AmazonFirst unique characterPythoneasy
Best BuyEven-numbered ordersSQLeasy
SpotifyBack to back repeatsSQLmedium
StripeOrder amount with taxSQLeasy
NykaaSpend by channelPremiumSQLmedium
Capital OneHigh credit utilizationSQLmedium
GoogleEmployee senioritySQLmedium
UberCompleted trips by cityPandaseasy
WalmartCounting what is recordedSQLmedium
StripeSplit requests into batchesPythoneasy
BlinkitHow often it ran outSQLmedium
UberCompress a status logPythonmedium
LyftBusiest request hourPythoneasy
LinkedInHires per yearSQLeasy
AmazonRevenue by statePandasmedium
SalesforceAverage sales cycleSQLmedium
WorkdayEmployees and their managersSQLmedium
RobinhoodBest stretch of daysPythonmedium
ZerodhaThe day the position closedPremiumSQLhard
Best BuyMove zero-sale days to the endPythoneasy
AmazonPackages still movingSQLmedium
RobinhoodMonthly traded valuePandasmedium
WalmartCustomers outside the US and MexicoSQLeasy
AirbnbMirror promo codesPythoneasy
InstacartItems and aisles per orderPandaseasy
DraftKingsPrize ranks with tiesSQLmedium
PinterestNormalize hashtagsPythoneasy
AtlassianSubtasks that outlived the parentPremiumSQLmedium
FlipkartRefunds so farPremiumSQLmedium
NetflixRemove duplicates, keep the orderPythoneasy
StripeRunning revenue over timeSQLhard
PandoraShare of plays cut shortPandasmedium
TargetCustomers with repeat ordersSQLmedium
PelotonLongest run of consecutive daysPythonmedium
SwiggyDay over day swingPremiumSQLmedium
NetflixTwo episodes before landingPythonhard
ShopifyUnbroken runs of monthsSQLhard
AmazonStock statusSQLeasy
DatadogIncidents that overlappedSQLhard
EtsyAnagram checkPythoneasy
CoinbaseLongest rising streakSQLhard
UberLow-rated driversSQLmedium
ZillowPrice per square foot by citySQLmedium
AmazonHours between scansSQLmedium
TargetClearance candidatesSQLeasy
ZillowWhere a new price fitsPythonmedium
WalmartOrders above the averageSQLeasy
SalesforceBalanced bracketsPythonmedium
DoorDashStretches that hit a targetPremiumPythonhard
BlinkitEvery stockout windowPremiumSQLhard
PagerDutyLongest incident per servicePandasmedium
AmazonOrders per customer segmentSQLmedium
SpotifyListening sessionsPremiumSQLhard
AirbnbNights booked per citySQLmedium
DraftKingsPoints above the contest averageSQLmedium
ZerodhaNet position gridPremiumPandashard
Best BuyOrders placed in March 2024SQLeasy
StripeThree transactions that cancel outPythonhard
AirbnbMedian order valueStatisticseasy
GoogleFactorialPythoneasy
SwiggyCancellation split by restaurantSQLmedium
StripeOrders in a price rangeSQLeasy
MetaReactions by post typePandasmedium
WalmartInventory valueSQLeasy
AtlassianPriority mix per projectSQLmedium
MyntraPrice dropsPremiumSQLmedium
AmazonFlatten a category treePythonmedium
TargetActive productsSQLeasy
InstacartKth largest orderPythonmedium
NetflixSalary rank within departmentSQLmedium
PhonePeMoney moved so farPremiumSQLmedium
AmazonPrime vs. standard order valueSQLmedium
PinterestGroup anagramsPythonmedium
DatadogMerged outage windowsSQLhard
Best BuyIn-stock electronicsSQLeasy
MastercardCard-testing patternsPremiumSQLhard
UberSearch a rotated schedulePremiumPythonhard
NykaaCheapest channel per campaignSQLmedium
WalmartWeekend ordersSQLmedium
RobinhoodHoldings in long formatPremiumPandashard
Capital OneInvert team assignmentsPythonmedium
EtsyVerified rating by shopSQLmedium
StripeDays from signup to first orderSQLmedium
TargetOrders by statusSQLeasy
LyftSurge share by citySQLeasy
VisaMonth-over-month spend changePremiumSQLhard
FlipkartDamage share of refundsSQLmedium
AmazonSlowest package per facilitySQLhard
DoorDashSlow deliveries by cuisinePandasmedium
UberA hundred against a hundred and thirtyA/B testingeasy
MyntraCorrelation and causationCausal inferenceeasy
NotionDid the pricing change move it?Statisticseasy
eBayETL or ELTData warehouseeasy
SpotifyExplaining analysis to a stakeholderBehavioraleasy
ShopifyHow precise is that conversion rate?Statisticseasy
WalmartInner, left or full outerSQLeasy
WayfairMean or median?Statisticseasy
CoinbaseOwning a project end to endBehavioraleasy
RedditType I and Type II errorsStatisticseasy
FlipkartWhy switch into dataBehavioraleasy
DatadogWill the whole run finish?Probabilityeasy
DoorDashA daily orders pipelineData pipelinemedium
IntuitA t-test or a chi-squareStatisticsmedium
CREDActivation fell last weekProduct sensemedium
LinkedInAn ML project end to endMachine learningmedium
SwiggyBeyond delivery timeProduct sensemedium
NvidiaBias and varianceMachine learningmedium
GoogleBuilding a spam filterPremiumMachine learningmedium
FigmaChanging a decision with dataBehavioralmedium
StripeDashboard disagrees with financeData qualitymedium
MastercardData leakageMachine learningmedium
ShopifyDesigning an orders fact tableData modelingmedium
AmazonDisagreeing with a stakeholderBehavioralmedium
CohereFine-tuning or RAGLLMmedium
InstacartFlat overall, up in one marketA/B testingmedium
RobinhoodGetting an analysis wrongBehavioralmedium
Hugging FaceHow attention worksLLMmedium
FlipkartHow long the test has to runA/B testingmedium
AtlassianInfluence without authorityBehavioralmedium
AirbnbInstant Book as the defaultProduct sensemedium
GoogleIs the coin fair?Probabilitymedium
DatabricksIs the model overfitting?Machine learningmedium
LyftLeading indicators after launchProduct sensemedium
PelotonLearning something fastBehavioralmedium
MetaMarketplace health metricProduct sensemedium
AirbnbMeasuring a good stayPremiumProduct sensemedium
AmazonMeasuring Buy AgainProduct sensemedium
UberMeasuring driver satisfactionProduct sensemedium
GoogleMeasuring search result qualityPremiumProduct sensemedium
ZillowMonitoring a live modelMLOpsmedium
PlaidMonitoring data qualityData qualitymedium
SpotifyOffline or online evaluationMachine learningmedium
AmazonOne metric for app healthProduct sensemedium
DoorDashPaying out on late ordersProbabilitymedium
DropboxPicking a materializationAnalytics engineeringmedium
DuolingoPicking a North StarProduct sensemedium
SwiggyPizzas delivered on a Friday nightGuesstimatesmedium
PalantirPushing backBehavioralmedium
ZomatoRaising repeat ordersProduct sensemedium
MicrosoftReading a confidence intervalStatisticsmedium
OpenAISame question, different answersLLMmedium
MicrosoftSample ratio mismatchA/B testingmedium
AirbnbShip on a significant resultPremiumA/B testingmedium
DraftKingsShipping under a deadlineBehavioralmedium
PinterestShipping without significancePremiumA/B testingmedium
SpotifyShuffle does not feel randomProbabilitymedium
StripeSignup to paid funnelPremiumAnalytics engineeringmedium
SnowflakeSlowly changing dimensionsData modelingmedium
FlipkartSmartphones sold in India in a yearGuesstimatesmedium
ZeptoStanding up a first dashboardAnalytics engineeringmedium
TargetStar or snowflakeData warehousemedium
NetflixStoring viewing historyPremiumData modelingmedium
NotionStructuring a dbt projectAnalytics engineeringmedium
UberSunday orders down in one cityProduct sensemedium
GoogleTennis balls in a passenger jetGuesstimatesmedium
AirbnbTesting host onboardingA/B testingmedium
RampTesting in dbtAnalytics engineeringmedium
MetaTesting Save for LaterPremiumA/B testingmedium
RampThe first data hireAnalytics engineeringmedium
NetflixThe lift the test can promiseA/B testingmedium
TwilioTwo definitions of one metricBehavioralmedium
AdobeUnclear requirementsBehavioralmedium
SalesforceWarehouse or BI toolAnalytics engineeringmedium
LinkedInWhat a bigger sample buysStatisticsmedium
VisaWhat a fraud alert is worthProbabilitymedium
NetflixWhat a p-value meansStatisticsmedium
MetaWhat counts as a DAUPremiumProduct sensemedium
Scale AIWhat makes a response goodLLMmedium
SwiggyWhat the review sample picks upProbabilitymedium
PayPalWhen one class is rareMachine learningmedium
EtsyWhen to retrainMLOpsmedium
AmazonWhy Prime signups fellPremiumProduct sensemedium
NetflixWhy randomize an experimentA/B testingmedium
MetaWhy Reels viewing fellPremiumProduct sensemedium
ShopifyWorking with ambiguous dataBehavioralmedium
Capital OneXGBoost or a neural networkMachine learningmedium
RazorpayYour first week on the jobBehavioralmedium
AppleYour proudest projectBehavioralmedium
NetflixData a streaming service pushes in a dayGuesstimateshard
AnthropicEvaluating a coding assistantLLMhard
AirbnbFinding fake reviewsPremiumMachine learninghard
DatabricksFine-tuning on private dataPremiumLLMhard
SierraHallucinations in productionLLMhard
DuolingoHow many users the test needsA/B testinghard
PhonePeImpact without an experimentPremiumCausal inferencehard
UberIs Comfort eating UberX?PremiumProduct sensehard
PinterestLow latency model servingPremiumML system designhard
NetflixPowering Continue WatchingPremiumData pipelinehard
PerplexityRAG for legal searchLLMhard
GoogleRecommending to a new userML system designhard
ZeptoRiders a city needs at the dinner peakGuesstimateshard
GoogleSimpson's paradoxStatisticshard
UberSpotting fraud in trip dataPremiumMachine learninghard
DatadogSub-second at scaleData pipelinehard
NetflixWarehousing A/B test dataPremiumData warehousehard
RampWhat the traffic can detectA/B testinghard
StripeWhen short IDs collideProbabilityhard