Tesco Financial Planning Analyst Interview Questions and Answers

Road daily revenue collection

Q1. SQL question, Python coding
Add your answer
Q2. Highest salary in a table
Ans. 
To find the highest salary in a table, use SQL queries or data manipulation techniques in programming languages.
• Use SQL: SELECT MAX(salary) FROM employees;

• In Python with pandas: df['salary'].max() where df is your DataFrame.

• In Excel: Use the formula =MAX(A1:A100) where A1:A100 contains salary data.

• Consider handling NULL values if applicable, as they can affect the result.
Answered by AI
Add your answer

Q1. Salary Negotiation
Add your answer

It was Python based basic questions only

Q1. Basic question, strength, weakness
Add your answer

Write a a python code to reverse string without slicing.

45 mins and too many technical questions

Too many technical questions

Q1. General question on powerbi and sql
Add your answer
Q2. Had solve sone queries on sql
Ans. 
I have resolved various SQL queries to extract, manipulate, and analyze data effectively.
• Used SELECT statements to retrieve specific columns from a table, e.g., SELECT name, age FROM patients;

• Implemented JOIN operations to combine data from multiple tables, e.g., SELECT orders.id, customers.name FROM orders JOIN customers ON orders.customer_id = customers.id;

• Utilized WHERE clause to filter records based on conditions, ...read more
Answered by AI
Add your answer

Q1. Find top 3 students in a class
Ans. 
Identify the top 3 students based on their grades in a class.
• Calculate the average grade for each student

• Sort the students based on their average grades in descending order

• Select the top 3 students
Answered by AI
View 1 more answer

Guesstimate questions

Q1. Directors ask behavioural questions
Add your answer

Q1. Python questions dataframe creata
Ans. 
Creating a DataFrame in Python using pandas for data analysis.
• Import pandas: Use 'import pandas as pd' to access DataFrame functionalities.

• Create DataFrame: Use 'pd.DataFrame(data)' where 'data' can be a dictionary, list, or array.

• Example: df = pd.DataFrame({'A': [1, 2], 'B': [3, 4]}) creates a DataFrame with two columns.

• Read from CSV: Use 'pd.read_csv('file.csv')' to create a DataFrame from a CSV file.

• Inspect DataFram...read more
Answered by AI
Add your answer
Q2. SQL questions joins , windows function,cte
Add your answer