All company names, logos, and trademarks are the property of their respective owners. Their use is for identification purposes only and does not imply endorsement.
LDS Data Scientist Interview Prep 75 — 75 Curated Python Problems
A 6-round simulator of the modern DS onsite: SQL screen, SQL analytics, A/B testing & experiment analysis, pandas coding, statistical reasoning, and an ML feature-engineering capstone. Seventy-five problems across SQL and Python on 15 production-grade schemas — including a dedicated A/B testing round with Welch's t-test, chi-square, ANOVA, and CUPED, drilled the way interviewers actually ask it.
Problems included in LDS Data Scientist Interview Prep 75
- Active Search Campaigns by Budget
- Verified High-Balance Checking Accounts
- Active Verified Users by Income
- Active PPO Plans With Prescription Coverage
- High-Value Direct Bookings
- Gold-Tier Business Customers
- Prime Members With Card Payment
- Active Sellers With High Rating
- Active Users in Target Countries
- High-Rated Titles with Reviews
- Campaigns Launched in Last 30 Days
- Recent Filled Trades Last 30 Days
- Rank Accounts by Balance Within Account Type
- Rank Providers by Claim Volume
- Properties Above Average Revenue
- Monthly Order Volume Trend
- Daily Revenue Running Total
- Daily Platform Revenue Running Total
- Daily Platform Fee Running Total
- Users With Both Inquiries and Tours
- Seller Performance Scorecard
- Customer 360 Summary
- Creative Type A/B Test — CTR by Variant
- Plan Tier A/B Test — Watch Engagement by Variant
- Post Visibility A/B Test — Reaction Rate by Variant
- Fulfillment Channel A/B Test — Order Completion by Variant
- A/B Significance Sanity Check (Z-score)
- Sample-Size Adequacy Check for A/B Test
- A/B Mean Comparison: Image vs Video CTR (t-test)
- A/B Proportion Test: Fulfillment Conversion (chi-square)
- Multi-arm A/B: Watch Time by Plan Tier (ANOVA)
- CUPED-Style Covariate Adjustment for Variance Reduction
- Active Advertiser Profiles
- Verified Customer Profiles
- Active User Profiles
- Line Items With Procedure Details
- Payments with Booking Channel
- Total Freight Cost by Carrier
- Total Revenue by Cuisine Type
- Rank Drivers by Trip Count
- Standardize Payment Brands to Categories
- Price Change From Previous Event
- 7-Day Moving Average Order Value
- Invoice With Payment Details
- Campaign Budget Descriptive Stats
- Account Balance Descriptive Statistics
- Portfolio Value Descriptive Stats by Strategy
- Claim Amount Descriptive Stats by Place of Service
- Nightly Rate Descriptive Stats
- Shipment Freight Quartile Bucketing
- Restaurant Revenue Quartile Bucketing
- Driver Earnings Quartile Bucketing
- Merchant Charge Volume Quartile
- Usage vs Satisfaction Correlation
- Watch Time vs Rating Correlation
- Two-Sample t-Test: Card vs Wallet Charge Amounts
- Chi-Square Test: Payment Method vs Order Completion
- Bootstrap 95% Confidence Interval for Mean Invoice Amount
- Campaign Spend Quartile Bucketing
- Transaction Amount Quartile Bucketing
- Trade Amount Quartile Bucketing
- Claim Amount Quartile Bucketing
- Reservation Value Quartile Bucketing
- Time-Based Order Features
- Time-Based Order Features
- Time-Based Trip Features
- Merchant Feature Matrix
- Listing Feature Matrix
- Customer Feature Matrix
- Organization Feature Matrix
- Campaign ROAS by Attribution Model
- Customer Portfolio Health Scorecard
- Linear Regression: List Price ~ Area + Beds + Baths
- Train/Test R² Evaluation: Customer Lifetime Value
- Precision / Recall / F1: Claim Denial Predictions