Landmark Group Business Analyst Interview Questions and Answers

Key metrics for tracking growth in brick and mortar business.

• Sales revenue

• Customer footfall

• Average transaction value

• Customer retention rate

• Inventory turnover rate

• Gross profit margin

• Net promoter score

• Employee productivity

• Marketing ROI

KPIs are interrelated in a tree-like structure, with higher-level KPIs being influenced by lower-level ones.

• KPIs are Key Performance Indicators that measure the success of a business or project.

• KPIs can be organized in a tree-like structure, with higher-level KPIs being influenced by lower-level ones.

• For example, a company's overall revenue might be a high-level KPI, with lower-level KPIs such as sales revenue and customer retention influencing it.

• A KPI tree can help business...read more

Subquery is a query nested within another query, while CTE is a temporary result set defined within a query. Both have their own use cases.

• Subquery is enclosed in parentheses and can be used in SELECT, INSERT, UPDATE, or DELETE statements.

• CTE is defined using the WITH keyword and can be referenced multiple times in a query.

• CTEs are more readable and easier to maintain compared to subqueries.

• Subqueries are useful when the result set is needed only once, while CTEs are benefici...read more

Advertising a new store opening in a location

• Identify target audience and their preferences

• Create a catchy slogan and design attractive visuals

• Utilize social media platforms and local newspapers for promotion

• Offer discounts and promotions to attract customers

• Organize a grand opening event to create buzz and excitement

Pivoting a table in SQL using case when statements

• Use the CASE WHEN statement to create new columns based on specific conditions

• Use the SUM or COUNT function to aggregate data in the pivoted table

• Group by the remaining columns to ensure correct aggregation

• Example: SELECT id, SUM(CASE WHEN category = 'A' THEN value END) AS A_total FROM table_name GROUP BY id;

Vlookup searches for a value in the first column of a range and returns a value in the same row from a specified column. Xlookup is a more powerful and flexible function that can search in any direction and return multiple results.

• Vlookup searches vertically in a table and returns a value from a specified column.

• Xlookup can search in any direction (horizontal, vertical, or both) and return multiple results.

• Vlookup requires the lookup value to be in the first column of the tab...read more

Logistic regression is a statistical method used to analyze and model the relationship between a binary dependent variable and one or more independent variables.

• It is a type of regression analysis used for predicting binary outcomes

• It uses a logistic function to model the probability of the dependent variable

• It is commonly used in fields such as healthcare, finance, and marketing

• Example: Predicting whether a customer will buy a product based on their age, income, and past pur...read more