Target Interview Experience Data Analyst
Interview Experience
Round 1 Technical Round:The first round was a technical round with questions mainly from SQL, Python, MS Excel, and Quantitative Aptitude.SQL Questions: Order of executio...
Full Details
Round 1 Technical Round: The first round was a technical round with questions mainly from SQL, Python, MS Excel, and Quantitative Aptitude. SQL Questions: Order of execution of queries. Difference between Join and Union Difference between Having and Group by Question based on UPDATE statement Perform data cleaning operation on a SQL table, for a column of dates. PIVOT a table without using PIVOT. Find nth highest salary. Get percent ranks. Find YOY revenue growth for the product category. Python: How to rename a column in pandas. Remove null values from a Panda DF How to extract data from JSON and make it a pdf. OOPS concept questions. Data visualization for a given dataset. ( Usage of BAr, Histogram, Box plot, line chart, etc) MS Excel: Implement HLOOKUP on a given table. Implement Pivot table. Calculate the running sum for a given dataset. Answered everything except date cleaning in SQL.
Verdict Selected for
next round
About This Question
This is a candidate experience report from a target corporation interview for a data science role during the phone screen round reported in 2024.
It covers the following topics: Sql .