Target Senior Data Analyst Interview Questions and Answers

SQL - 3 set of sql questions

1 Design Question, do ER diagram, 1 JSON parsing question

Q1. Mandate to be on-site
Ans. 
Being on-site is essential for effective collaboration, communication, and access to necessary resources.
• On-site presence allows for real-time collaboration with team members and stakeholders.

• Face-to-face communication can help clarify requirements and expectations more effectively.

• Access to physical resources such as servers or data centers may be necessary for certain tasks.

• Being on-site can also facilitate quicker d...read more
Answered by AI
Add your answer

Q1. Salary question expectations were asked
Add your answer
Q2. Timeline question to join and move to required state
Add your answer

Q1. Basic behavioral, tell me about yourself, why walmart.
Add your answer

Hackerrank - 1 hour interview

Sql questions - self join, window functions, CTEs

Q1. Explain p value in layman terms
Ans. 
P value is a measure that helps determine the significance of results in a statistical hypothesis test.
• P value is the probability of obtaining results as extreme as the observed results, assuming the null hypothesis is true.

• A small p value (typically ≤ 0.05) indicates strong evidence against the null hypothesis, leading to its rejection.

• A large p value (> 0.05) suggests weak evidence against the null hypothesis, failin...read more
Answered by AI
Add your answer
Q2. AB testing - null hypothesis
Add your answer

Q1. Culture fit questions
Add your answer
Q2. Hiring manager explained the profile
Add your answer

Q1. Average totals for last 3 months
Add your answer
Q2. Running totals in a year using dax
Ans. 
Running totals in a year using DAX
• Use the DAX function CALCULATE to create running totals

• Use the FILTER function to specify the date range for the running total

• Example: CALCULATE(SUM(Sales[Amount]), FILTER(ALL('Date'[Date]), 'Date'[Date] <= MAX('Date'[Date])))
Answered by AI
Add your answer

Sql and python questions were asked

Q1. Why are you fit for the role?
Ans. 
I am fit for the role due to my extensive experience in data analysis, strong analytical skills, and ability to communicate insights effectively.
• Extensive experience in data analysis

• Strong analytical skills

• Ability to communicate insights effectively
Answered by AI
Add your answer
Q2. Explain a project where you used data analytics to solve a business problem
Ans. 
Implemented predictive analytics model to optimize inventory management for a retail company
• Identified key factors affecting inventory levels such as seasonality, promotions, and supplier lead times

• Utilized historical sales data to forecast demand and optimize inventory levels

• Developed a predictive analytics model using machine learning algorithms to predict future sales and recommend optimal inventory levels

• Implemente...read more
Answered by AI
Add your answer

Q1. What is your expected compensation?
Add your answer
Q2. When can you relocate?
Add your answer