ZET Data Analyst Interview Questions and Answers

Q1. Prepare excel ll;;
Add your answer
Q2. Why we use vlookup
Add your answer

Q1. Assignment discussion
Add your answer
Q2. Additional excel and python questions
Add your answer

Q1. Excel and python basic questions
Add your answer

Q1. Excel: Convert Mobile number to masked number
Ans. 
Masking a mobile number in Excel involves replacing part of the number with asterisks for privacy.
• Use the CONCATENATE function to combine parts of the number: =CONCATENATE('***-****-', RIGHT(A1, 4))

• Alternatively, use the REPLACE function: =REPLACE(A1, 1, 6, '******')

• You can also use TEXT functions to format the number: =TEXT(A1, '000-000-0000')

• For a more visual approach, apply custom formatting: Right-click cell > F...read more
Answered by AI
Add your answer
Q2. Sql: Write query a second highest sales
Ans. 
To find the second highest sales, we can use SQL queries with subqueries or the DISTINCT keyword to filter results.
• Using Subquery: SELECT MAX(sales) FROM sales_table WHERE sales < (SELECT MAX(sales) FROM sales_table);

• Using DISTINCT: SELECT DISTINCT sales FROM sales_table ORDER BY sales DESC LIMIT 1 OFFSET 1;

• Using ROW_NUMBER: SELECT sales FROM (SELECT sales, ROW_NUMBER() OVER (ORDER BY sales DESC) AS rank FROM sales_...read more
Answered by AI
Add your answer
Q3. Python: different between list and tuple
Ans. 
Lists are mutable and can change, while tuples are immutable and cannot be altered after creation.
• Lists are defined using square brackets: `my_list = [1, 2, 3]`.

• Tuples are defined using parentheses: `my_tuple = (1, 2, 3)`.

• Lists can be modified (e.g., `my_list.append(4)`), while tuples cannot be changed after creation.

• Lists have more built-in methods (e.g., `sort()`, `reverse()`), whereas tuples have fewer methods.

• Lists...read more
Answered by AI
Add your answer

Excel based assignment with 5-6 questions, involving index match, vlookup, etc
Can be solved using python as well.

Q1. Discussion on assignnent and its solutions. You will have to explain how you arrived at the solutions. Other than that, basic questions were asked.
Add your answer

Q1. Final round with involves solving 4-5 questions on excel/python while you are live on the interview. Basic generic questions
Add your answer

Excel based data group discussion round. You were given 1 individual task for 10 mins and a group discussion task for 50 mins.

Q1. Business case study
Add your answer
Q2. How you can increase the profit of the ice cream company.
Ans. 
To increase the profit of the ice cream company, focus on product innovation, expanding distribution channels, and implementing targeted marketing strategies.
• Introduce new and unique flavors to attract more customers

• Collaborate with local cafes or restaurants to sell your ice cream products

• Utilize social media and online advertising to reach a wider audience

• Offer promotions or discounts to encourage repeat purchases

• Imp...read more
Answered by AI
Add your answer

Code signal , SQL python questions

Take home coding assignment - 10 days analysis and recommendations

Q1. 4 rounds - 1 behavioralm 2 case studies 1 presentation
Add your answer

Data Coding, 1hr, series of questions in excel