CentralSquare Technologies Data Analyst Interview Questions
The questions to prepare for a CentralSquare Technologies Data Analyst interview. Questions from real interview reports rank first. Updated weekly.
Explain how to detect and handle NULL values in SQL using filtering, COALESCE, CASE, and business-aware imputation.
CentralSquare TechnologiesExplain how INNER JOIN and LEFT JOIN affect missing records and when to use each while debugging data mismatches.
CentralSquare TechnologiesExplain INNER, LEFT, RIGHT, FULL OUTER, CROSS, and SELF JOINs with examples and when to use each.
CentralSquare TechnologiesExplain how INNER JOIN and LEFT JOIN differ, and when to use each for matched-only versus all-left-row analysis.
CentralSquare TechnologiesCompute per-vehicle daily autonomous vs manual seconds from state-change logs using LEAD and conditional aggregation.
Compute top 10 customers by net sales using joins and aggregations, ordering by revenue with deterministic tie-breaking.
Gain Digital
TCS
Zest AIMerge CRM orders with GA events via an identity map to build a customer-level view using joins, window functions, and monthly rollups.
ArtefactShare how you used data to shape a business decision, including the analysis, recommendation, and outcome.
CentralSquare TechnologiesExplain how to design and evaluate an A/B test for a product feature, including metrics, MDE, sample size, and guardrails.
CentralSquare TechnologiesTests ability to derive metrics and interpret transaction data for behavioral trends.
CentralSquare TechnologiesTests tool familiarity and your ability to translate data into clear stakeholder-ready visuals.
CentralSquare TechnologiesSign up to see every question
Create a free account to unlock this list and practice real interview questions.