Datagrokr Data Analyst Interview Questions

Use a CTE, join, date truncation, and distinct user logic to calculate monthly active users in TransUnion CreditVision.

Date FunctionsGroup ByAggregationsDatagrokr

Join customer and order records, then return completed orders of at least 100 for North-region customers.

null handlingJoinsData WranglingDatagrokr

Approach for handling missing data in an ML data pipeline, including validation, imputation, and safe downstream consumption.

InfrastructureETLBatch ProcessingDatagrokr

Approach for maintaining data quality and integrity across ETL pipelines.

IdempotencyData ModelingQualityDatagrokr

Choose visuals that make trend direction, comparisons, and KPI drivers easy to understand at a glance.

KPIsLeading IndicatorsDiagnosisDatagrokr

Assess the 15% drop in user engagement after a new app feature release and propose metric decomposition strategies.

Datagrokr