Flatworld Solutions Data Analyst Interview Questions and Answers

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

There are approximately 10 million cars in Delhi.

• Delhi has a population of over 18 million people.

• The number of cars per household in Delhi is increasing.

• There are over 1,000 new cars registered in Delhi every day.

• Traffic congestion is a major issue in Delhi due to the high number of cars.

• The Delhi government has implemented measures to reduce the number of cars on the road, such as the odd-even rule.