Dataford
Top 15
Prep plan
Updated weekly · Last refresh Aug 30

Lg Ad Solutions Business Analyst Interview Questions

The questions to prepare for a Lg Ad Solutions Business Analyst interview. Questions from real interview reports rank first. Updated weekly.

15questions
~2htotal time
Track your progressSign up free to work through all 15 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 5 questions + 3 drills · ~70 min
Window Functions Ranking ChoiceMedium

Tests understanding of SQL window functions and choosing the right ranking behavior.

Window FunctionsRankingCase WhenLg Ad Solutions
Excel Cleaning for Campaign ReportsEasy

Tests practical Excel skills for transforming and summarizing campaign data.

PivotData WranglingReconciliationLg Ad Solutions
Deduplicate Without Primary KeyMedium

Tests data-cleaning strategy and SQL techniques for deduplication at scale.

null handlingData WranglingReconciliationLg Ad Solutions
Clean Null Campaign MetricsEasy
Practice
Practice drill

Use CASE and COALESCE to standardize missing StackAdapt campaign metrics and count incomplete rows by campaign.

null handlingData WranglingReconciliationStackadaptCvent
SQL Window Functions Moving AverageMedium
Practice
Practice drill

Calculate a three-day moving average of active-client revenue using aggregation and SQL window functions.

Window FunctionsData AnalysissqlAAreteMITREGlassdoor
Unify Campaign Performance SourcesMedium
Practice
Practice drill

Use CTEs, joins, aggregations, and CASE logic to combine Salesforce, Marketo, and Google Analytics into one monthly campaign report.

Data WranglingperformanceReconciliationPalo Alto Networks
More SQL & Data Manipulation questions with a free account
2
Strategy3 questions · ~24 min
Estimate Active Smart TVsMedium

Tests estimation skills and ability to build a defensible top-down model.

EstimationProblem SolvingMarket SizingLg Ad Solutions
Optimize Inventory YieldMedium

Tests data-driven decision-making for inventory strategy across sales channels.

adoptionCost-Benefit AnalysisBusiness AcumenLg Ad Solutions
Investigate Conversion DropMedium

Tests analytical troubleshooting and hypothesis-driven investigation for ad performance issues.

root causecampaign performanceDiagnosisLg Ad Solutions

Sign up to see every question

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

Get my prep plan
3
Statistics & Probability4 questions · ~32 min
A/B Test New LG Home Ad FormatMedium

Tests experimental design, metrics, and statistical thinking for ad product changes.

experiment designStatistical SignificanceA/B TestingLg Ad Solutions
Correlation vs Causation in ReportsEasy

Tests statistical literacy and responsible interpretation of performance data.

BiasCorrelationCausal InferenceLg Ad Solutions
More Statistics & Probability questions with a free account
4
Behavioral & Leadership3 questions · ~24 min
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 15 questions plus 3 hands-on drills to finish this plan.