Top 12
Prep plan
Updated weekly · Last refresh Oct 17

Red Global Data Analyst Interview Questions

The questions to prepare for a Red Global Data Analyst interview. Questions from real interview reports rank first. Updated daily.

12questions
~2htotal time
Track your progressSign up free to work through all 12 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 7 questions + 3 drills · ~86 min
Optimizing Slow Power BI ReportsMedium

Assesses your troubleshooting and performance optimization skills for Power BI report responsiveness.

performance optimizationpower bireportingRed Global
Implementing and Troubleshooting RLSMedium

Evaluates your ability to secure data access and debug RLS behavior in production.

TroubleshootingproductionRed Global
Modeling Many-to-Many in Power BIHard

Evaluates your data modeling skills for complex relationships in Power BI.

power biData ModelingRed Global
Star vs Snowflake SchemaMedium

Tests your dimensional modeling knowledge and tradeoffs for analytics performance and maintainability.

snowflake schemastar schemaData ModelingRed Global
Incremental Refresh for Large DatasetsMedium

Assesses your approach to efficient refresh strategies and performance for large data volumes.

large datasetsdata managementRed Global
Building Complex DAX for Business ProblemsHard

Evaluates your DAX proficiency and ability to translate business needs into correct calculations.

daxbusiness problemRed Global
Optimizing Power BI ModelsMedium
Practice
Practice drill

Identify the largest Power BI tables and their refresh impact using joins and aggregation.

database optimizationperformance optimizationdatabase managementAdobe
Star vs Snowflake for Uber DataMedium
Practice
Practice drill

Aggregate completed Uber trips through normalized location dimensions and explain the star versus snowflake trade-off at scale.

fact tablessnowflake schemastar schemaUber
Advanced Data Modeling for PerformanceHard
Practice
Practice drill

Calculate Citi business-unit performance variance against targets and identify the largest shortfalls.

business problemdata managementtechnical experienceCiti
More SQL & Data Manipulation questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
2
Behavioral & Leadership5 questions · ~40 min
Explaining a Technical Concept ClearlyEasy

Tests communication, ownership, and stakeholder management when translating technical complexity into actionable business understanding.

Problem SolvingData Structurestechnical fundamentalsRed Global
Motivation for the RoleEasy

Tests career motivation, self-awareness, professionalism, and ownership when explaining a job transition.

account executiveCommunicationbehavioral interviewRed Global
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 12 questions plus 3 hands-on drills to finish this plan.