Top 20
Prep plan
Updated weekly · Last refresh Aug 30

NBCUniversal Advertising Products & Solutions Business Intelligence Analyst Interview Questions

The questions to prepare for a NBCUniversal Advertising Products & Solutions Business Intelligence Analyst interview. Questions from real interview reports rank first. Updated weekly.

20questions
~3htotal time
Track your progressSign up free to work through all 20 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 10 questions + 3 drills · ~110 min
Handling Missing and Dirty SQL DataMedium

Explain how to profile, clean, and standardize missing or dirty data before analysis.

Data WranglingCase WhenQualityNBCUniversal Advertising Products & Solutions
Detect and Handle Outliers in SQLEasy

Explain common SQL-friendly ways to detect outliers and how to handle them without distorting downstream analysis.

Data WranglingGroup ByAggregationsNBCUniversal Advertising Products & Solutions
Tableau Features for Executive DashboardsMedium

Evaluates your dashboard design choices for executive consumption and decision-making.

dashboardsdata visualizationNBCUniversal Advertising Products & Solutions
PL/SQL Prompting for AnswersMedium

Tests your ability to apply PL/SQL concepts to generate or retrieve answers from data.

pl/sqlNBCUniversal Advertising Products & Solutions
Joining Tables and Filtering MetricsMedium

Tests SQL join logic and translating campaign metric requirements into correct queries.

Joinscampaign performancesqlNBCUniversal Advertising Products & Solutions
Second Highest Trader SalaryEasy
Practice
Practice drill

Find the second highest distinct salary from a single table using basic PostgreSQL ordering and limiting.

SubqueriesRankingSortingeClinicalWorksInformaticaSpectraforce Technologies
Autonomous vs Manual Drive TimeHard
Practice
Practice drill

Compute per-vehicle daily autonomous vs manual seconds from state-change logs using LEAD and conditional aggregation.

JoinsData WranglingGroup By
Top Customers by Net SalesMedium
Practice
Practice drill

Compute top 10 customers by net sales using joins and aggregations, ordering by revenue with deterministic tie-breaking.

SubqueriesJoinsData WranglingGain DigitalTCSZest AI
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership8 questions · ~64 min
Strength and Growth AreaEasy

Tests self-awareness, ownership, and growth mindset through specific examples of a professional strength and an actively managed weakness.

self assessmentfeedbackstrengthsNBCUniversal Advertising Products & Solutions
More Behavioral & Leadership questions with a free account
3
More topics2 questions · ~16 min
Metrics for a New LaunchEasy

Define the core metrics for a new product launch, from early adoption and activation to retention and long-term value.

Lagging IndicatorsKPIsLeading IndicatorsNBCUniversal Advertising Products & Solutions
Investigating Ad Impression DropsHard

Tests your diagnostic approach to metrics anomalies in advertising data pipelines.

Data AnalysisNBCUniversal Advertising Products & Solutions

Sign up to see every question

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

Get my prep plan
The finish line: interview-readyComplete all 20 questions plus 3 hands-on drills to finish this plan.