Plum Benefits Data Analyst Interview Questions and Answers

Moving Average is a statistical technique used to analyze data points by creating a series of averages of different subsets of the full data set.

• Moving Average helps in smoothing out fluctuations in data to identify trends over time.

• It is calculated by taking the average of a specific number of data points within a defined window.

• For example, a 3-day moving average for stock prices would be the average of the stock pri...read more

Decorators in Python are functions that modify the behavior of other functions.

• Decorators are denoted by the @ symbol followed by the decorator function name.

• They allow you to add functionality to an existing function without modifying its code.

• Common use cases include logging, timing, and authentication.

• Example: @decorator_function def function_to_decorate(): pass

Object Oriented Programming is a programming paradigm based on the concept of objects, which can contain data and code.

• OOP focuses on creating objects that interact with each other to solve complex problems.

• Objects have attributes (data) and methods (functions) that can manipulate the data.

• Encapsulation, inheritance, and polymorphism are key principles of OOP.

• Example: In a car simulation program, a 'Car' object can hav...read more

Classes are blueprints for creating objects in object-oriented programming.

• Classes define the properties and behaviors of objects

• Objects are instances of classes

• Classes can inherit properties and behaviors from other classes

• Classes can have constructors to initialize objects

• Classes can have methods to perform actions

Functions are blocks of code that perform a specific task and can be reused multiple times in a program.

• Functions help in organizing code and making it more modular.

• They can take input parameters and return output values.

• Functions can be called multiple times from different parts of the program.

• Examples: summing two numbers, finding the maximum value in a list.

Swap L1 and L5 in a list

• Create a temporary variable to store the value of L1

• Assign the value of L5 to L1

• Assign the value of the temporary variable to L5

Calculate the number of rows after joining two datasets.

• Count the number of rows in each dataset

• Perform the join operation

• Count the number of rows in the resulting dataset

Use Excel's text to columns feature to split person names into separate columns.

• Select the column containing the full names

• Go to the Data tab and click on Text to Columns

• Choose 'Delimited' and select the delimiter that separates the names (e.g. space)

• Click Finish to split the names into separate columns

Key metrics for EaseMyTrip include booking conversion rate, customer acquisition cost, average booking value, and customer retention rate.

• Booking conversion rate - percentage of website visitors who make a booking

• Customer acquisition cost - cost to acquire a new customer

• Average booking value - average amount spent per booking

• Customer retention rate - percentage of customers who return to book again