Target Interview Experience Data Analyst

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