Top 19
Prep plan
Updated weekly · Last refresh Oct 17

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 daily.

19questions
~3htotal time
Track your progressSign up free to work through all 19 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 9 questions + 3 drills · ~102 min
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
Handling Missing and Dirty SQL DataMedium
Recently asked

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

Data WranglingCase WhenQualityNBCUniversal Advertising Products & Solutions
Partitioning in SQLHard

Assesses your understanding of SQL window functions and partitioning for analytical calculations.

sqlpartitioningNBCUniversal Advertising Products & Solutions
Tableau Features for Executive DashboardsMedium

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

dashboardsdata visualizationNBCUniversal 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
Recently asked
Practice drill

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

SubqueriesRankingSortingeClinicalWorksNNeenOpal CanadaInformatica
Freight Volume YoY GrowthMedium
Practice
Practice drill

Calculate 2024 freight volume growth by Uber Freight region compared with 2023.

Date FunctionsJoinsData AnalysisUber Freight
Analyzing Nursing Data with SQLHard
Practice
Practice drill

Analyze CMS nursing staffing records by facility, handling missing data and classifying facilities against a staffing benchmark.

JoinsData Analysiscase studyClipboard Health
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership8 questions · ~64 min
Strength and Growth AreaEasy
Recently asked

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 19 questions plus 3 hands-on drills to finish this plan.