AST Corporation Data Analyst Intern Interview Questions and Answers for Freshers

Window functions like lag and lead are used to analyze data over a specific range or window.

• Lag function can be used to calculate the difference between current and previous values in a time series data.

• Lead function can be used to calculate the difference between current and future values in a time series data.

• Window functions can be used to calculate moving averages, cumulative sums, and other statistical measures.

• Fo...read more

I tackle challenges by breaking them down into smaller tasks and staying focused on the end goal.

• I analyze the challenge and identify the root cause

• I break down the challenge into smaller, manageable tasks

• I prioritize the tasks and create a plan of action

• I stay focused on the end goal and remain persistent

• I seek help or advice when needed

• Example: When faced with a tight deadline, I prioritize tasks and delegate respons...read more