Dataford
Dataford
Top 16
Prep plan
Updated weekly · Last refresh Oct 17

Southern Wine & Spirits Data Analyst Interview Questions

The questions to prepare for a Southern Wine & Spirits Data Analyst interview. Questions from real interview reports rank first. Updated daily.

16questions
~2htotal time
Track your progressSign up free to work through all 16 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 6 questions + 3 drills · ~78 min
Basic Excel and SQLEasy

Evaluates practical proficiency with Excel and SQL fundamentals for day-to-day data analysis.

sqlExcelSouthern Wine & Spirits
SQL and Data ConceptsMedium

Assesses your understanding of common data architecture concepts and how they support analytics.

normalizationdatabase conceptsSouthern Wine & Spirits
Database Normalization and SQLHard

Evaluates your ability to apply core database concepts and write correct SQL for analytics tasks.

sqldatabase conceptsSouthern Wine & Spirits
Joining and Aggregating with SQLMedium

Tests your SQL skills for integrating and summarizing data across systems.

JoinsData WranglingAggregationsSouthern Wine & Spirits
Join Types and Lake vs WarehouseMedium
Practice
Practice drill

Explain LEFT JOIN behavior and compare data lakes with data warehouses using a concise SQL example.

null handlingJoinssqlCA Firm in KolkataPwC IndiaPwC
Weekly Service KPI by TeamMedium
Practice
Practice drill

Analyze weekly service delivery performance by team using joins, a CTE, date aggregation, and KPI calculations.

KPIJoinssqlDeloitteReputation
SQL Self Joins and ExplodeMedium
Practice
Practice drill

Transform comma-separated employee tags, join employees to managers, and aggregate active direct reports by manager and tag.

pysparkaggregationJoinsTredence
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership7 questions · ~56 min
Choosing the Right Analysis ToolEasy

Tests ownership and prioritization in choosing the right analysis approach as data scale and stakeholder needs outgrow Excel.

Data AnalysisExceltechnical experienceSouthern Wine & Spirits
More Behavioral & Leadership questions with a free account
3
More topics3 questions · ~24 min
Diagnosing Sudden Sales DropsMedium

Tests your diagnostic thinking using sales, inventory, and distribution signals.

sales performanceKPIDiagnosisSouthern Wine & Spirits
Warehouse Outbound Shipments DashboardMedium

Tests your ability to translate operational needs into actionable BI metrics and visuals.

User Needsdashboard designUse CasesSouthern Wine & Spirits
Measuring Inventory Turnover HealthEasy

Tests your understanding of inventory KPIs and how to evaluate turnover performance.

KPIefficiencySouthern Wine & Spirits

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