Macquarie Group Product Data Manager Interview Questions and Answers

Q1. SQL and Python and Spark related questions
Add your answer
Q2. Project-oriented questions
Add your answer

Q1. Coding and AWS cloud-related questions like GLUE, LAMBDA, Redshift etc
Add your answer
Q2. Project and managerial-related questions
Add your answer

Q1. How you calculate the tdi and mdi of a customer in sql
Ans. 
To calculate TDI and MDI of a customer in SQL, you need to aggregate and analyze the customer's transaction data.
• Calculate Total Daily Income (TDI) by summing up the income of the customer for each day.

• Calculate Monthly Daily Income (MDI) by averaging the TDI for each day in a month.

• Use SQL functions like SUM, AVG, and GROUP BY to perform the calculations.

• Example: SELECT SUM(income) AS TDI, AVG(income) AS MDI FROM tran
Answered by AI
Add your answer

They asked about the sas,sql,and power bi

Q1. SQL Window functions
Add your answer
Q2. Excel computed fields in pivot tables
Ans. 
Excel pivot tables allow users to create computed fields using formulas.
• In Excel pivot tables, computed fields are created by adding a new field with a formula.

• Formulas can be simple arithmetic operations or more complex calculations.

• Computed fields can be used to perform calculations on existing data in the pivot table.

• Examples: calculating profit margin by dividing revenue by cost, calculating average sales per month
Answered by AI
Add your answer
Q3. Difference in precision and recall
Ans. 
Precision is the ratio of correctly predicted positive observations to the total predicted positives, while recall is the ratio of correctly predicted positive observations to the all observations in actual class.
• Precision focuses on the accuracy of positive predictions, while recall focuses on the proportion of actual positives that were correctly identified.

• Precision = TP / (TP + FP)

• Recall = TP / (TP + FN)

• Example: In...read more
Answered by AI
Add your answer

Q1. About past experience
Add your answer
Q2. Past project details
Add your answer

Basic aptitude questions

Data structure and algorithms

Q1. Java, SQL questions
Add your answer

Q1. Casual talk about roles
Add your answer

Q1. PartitionBy vs bucketBy in spark
Add your answer

Q1. Python data types, SQL medium to complex, Spark medium question
Add your answer

Q1. SQL complex, Spark theory
Add your answer

Q1. Basic HR questions
Add your answer

Q1. Advanced sql on ctl
Add your answer
Q2. Python data structure
Add your answer