Top 22
Prep plan
Updated weekly · Last refresh Aug 30

Dexian Business Analyst Interview Questions

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

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

Tests data quality handling strategies to ensure accurate reporting and analysis.

Data Qualitydata handlingDexian
Excel Automation with Advanced FunctionsMedium

Tests practical Excel automation skills to reduce manual effort and improve reporting accuracy.

Data Manipulationexcel functionsDexian
Excel vs Power BI for StakeholdersMedium

Tests tool selection judgment based on stakeholder needs, usability, and reporting requirements.

data visualizationstakeholder communicationDexian
Power BI Vendor Performance DashboardsMedium

Tests dashboard design, data modeling, and stakeholder-focused reporting using Power BI.

power biDexian
Python for Cleaning and VisualizationMedium

Tests data cleaning and visualization capabilities using Python libraries on large datasets.

data cleaningdata visualizationpythonDexian
SQL Joins and AggregationsMedium

Tests SQL proficiency for joining datasets and producing reliable aggregated metrics.

Joinssql queriesDexian
SQL for Monthly AggregatesHard
Practice
Practice drill

Calculate monthly DigitalOcean CSAT for active paid customers, deduplicate responses, and show month-over-month changes.

sql queriesdata visualizationDigitalOcean
SQL Bookstore Schema PracticeEasy
Practice
Practice drill

Use a CTE, joins, and distinct aggregates to calculate Meta Logistics bookstore payment metrics.

sql queriessqlpythonMeta Logistics
Clean Incomplete Salesforce Lead RecordsMedium
Practice
Practice drill

Clean Salesforce lead data with CTEs, LEFT JOINs, CASE, and COALESCE to standardize missing values for analysis.

missing valuesdata preparationdata cleaningSalesforce
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership10 questions · ~80 min
Data-Driven Decision That Changed CourseMedium

Tests whether you can use analysis to change a decision, align stakeholders, and own the outcome.

Stakeholder ManagementCommunicationOwnershipDexian
More Behavioral & Leadership questions with a free account
3
More topics1 question · ~8 min
The finish line: interview-readyComplete all 22 questions plus 3 hands-on drills to finish this plan.