Premium Employer

i

This company page is being actively managed by ZS Team. If you also belong to the team, you can get access from here

ZS Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

ZS Business Intelligence Analyst and Tableau Developer Interview Questions and Answers

Updated 25 Nov 2024

ZS Business Intelligence Analyst and Tableau Developer Interview Experiences

1 interview found

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Find Top 5 and Botton 5 sales in same sheet
  • Ans. 

    Use Tableau to create a sheet displaying the top 5 and bottom 5 sales.

    • Create a new worksheet in Tableau

    • Drag the sales measure to the Rows shelf

    • Sort the sales measure in descending order

    • Limit the view to show only the top 5 sales

    • Duplicate the sheet and change the sort order to ascending to show the bottom 5 sales

  • Answered by AI
  • Q2. User safety filter

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via LinkedIn and was interviewed in Sep 2024. There were 3 interview rounds.

Round 1 - Technical 

(4 Questions)

  • Q1. Top and Bottom in one sheet
  • Ans. 

    Use LOD calculations to display top and bottom values in one sheet in Tableau.

    • Use Level of Detail (LOD) calculations to create separate calculated fields for top and bottom values.

    • Use these calculated fields in the same sheet to display both top and bottom values.

    • For example, create a calculated field for top values using {FIXED [Dimension]: MAX([Measure])} and another for bottom values using {FIXED [Dimension]: MIN([M

  • Answered by AI
  • Q2. Usage of parameter and filters
  • Ans. 

    Parameters and filters are key features in Tableau for dynamic data analysis and visualization.

    • Parameters allow users to input values that can be used in calculations, filters, and reference lines.

    • Filters are used to limit the data displayed in a visualization based on specified criteria.

    • Parameters can be used to create dynamic filters that allow users to interact with the data in real-time.

    • Combining parameters and fil...

  • Answered by AI
  • Q3. Types of LOD and its use case
  • Ans. 

    Types of LOD include Fixed, Include, and Exclude LOD calculations for different use cases.

    • Fixed LOD: Used to ignore the level of detail in the view and compute an aggregate value.

    • Include LOD: Used to compute an aggregate value at a higher level of detail than the view.

    • Exclude LOD: Used to compute an aggregate value at a lower level of detail than the view.

  • Answered by AI
  • Q4. Performance Optimization
Round 2 - Technical 

(3 Questions)

  • Q1. Project Overview and Size
  • Q2. Performance Optimization
  • Q3. Open for work in different technologies
Round 3 - Behavioral 

(3 Questions)

  • Q1. Introduction and Role
  • Q2. Tableau Prep and its usage
  • Ans. 

    Tableau Prep is a data preparation tool that allows users to clean, combine, and shape data for analysis in Tableau.

    • Tableau Prep helps in cleaning and transforming data before visualizing it in Tableau Desktop.

    • It allows users to easily combine multiple data sources and perform data cleaning tasks like removing duplicates, splitting columns, and aggregating data.

    • Tableau Prep also provides a visual interface for creating...

  • Answered by AI
  • Q3. Snowflake vs Star Schema
  • Ans. 

    Snowflake schema is a normalized form of Star schema with multiple levels of dimension tables.

    • Snowflake schema has normalized dimension tables, while Star schema has denormalized dimension tables.

    • Snowflake schema is more complex and requires more joins compared to Star schema.

    • Star schema is easier to understand and query, making it more suitable for smaller datasets.

    • Snowflake schema is more suitable for larger datasets

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - First round was purely technical, rest two were combined of technical and managerial.

Analyst Interview Questions & Answers

Citco user image Anonymous

posted on 14 Nov 2021

I applied via Recruitment Consultant and was interviewed before Nov 2020. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. What is hedge fund and its type of structure
  • Ans. 

    A hedge fund is an investment fund that pools capital from accredited individuals or institutional investors and invests in a variety of assets.

    • Hedge funds are typically only available to accredited investors due to their high-risk nature.

    • They use a variety of investment strategies, including long and short positions, leverage, and derivatives.

    • Hedge funds are structured as limited partnerships, with the fund manager as...

  • Answered by AI
  • Q2. Basic questions about financial markets, equities, bond, derivatives

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare for basics of financial markets
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed before Feb 2022. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Case Study 

Practise very well in advance with sample cases in mock sessions

Round 3 - Case Study 

Practise very well in advance with real cases with your friends

Round 4 - HR 

(2 Questions)

  • Q1. Friendly conversation with open perspective and consideration for your asks
  • Q2. Be ready to discuss your expectations in this round

Interview Preparation Tips

Interview preparation tips for other job seekers - research very well be authentic and curious during the process

I applied via Referral and was interviewed in May 2021. There was 1 interview round.

Interview Questionnaire 

3 Questions

  • Q1. About past project's
  • Q2. Standalone cost model
  • Q3. PMO

Interview Preparation Tips

Interview preparation tips for other job seekers - Be calm

Interview Questionnaire 

1 Question

  • Q1. Focus on SQL related things, some accounting basic concepts need.

I applied via Campus Placement and was interviewed before Feb 2021. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Aptitude Test 

Tests are Pymetrics and an online case. Pymetrics is a personality test of sorts (risk aversion, pattern recognition, etc.) this was benchmarked against successful Consultants. Online case is multiple choice but the questions flow like a normal case interview. You will get a final round interview if you do really well on them. If you just ‘pass’, you have to have an internal designation of a high priority or very high priority candidate. (See advice)

Round 3 - Group Discussion 

Standard 2 case interviews with senior leaders, already a lot of material on this elsewhere

Interview Preparation Tips

Interview preparation tips for other job seekers - I led campus recruiting for 2 top MBA programs. Every interaction before an interview is important. You really want to be on the high priority or very high priority lists. The coffee chats are not just to answer your questions, we make a 25-minute determination of whether you had an impressive background, we’re inquisitive, and passed the airport test. Make sure you bring your energy to all of it. It determines how much support you get and how many interactions you have with senior leaders during the recruiting process to give you advice.

I applied via Campus Placement and was interviewed before May 2021. There were 3 interview rounds.

Round 1 - Case Study 

Internal case of a biscuit manufacturing company. Details about company background, sales, figures are given and based on those 3 questions were asked.

Round 2 - Case Study 

Part 2 of the same case study was asked where the company should go for IPO or expansion in local market. based on the facts, decision and justification had to be given

Round 3 - One-on-one 

(1 Question)

  • Q1. Tell me about yourself
  • Ans. 

    I am a highly experienced consultant with a strong background in problem-solving and strategic planning.

    • Over 10 years of experience in consulting for various industries

    • Expertise in analyzing complex business challenges and providing effective solutions

    • Proven track record of delivering successful projects on time and within budget

    • Strong communication and interpersonal skills, able to build rapport with clients

    • Ability to...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Confidence is key for this job. Even if the background is not an exact match they are willing to give you a shot if you think you are better.

I applied via Approached by Company and was interviewed before Sep 2021. There were 3 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Basic devops question
  • Q2. Agile process discussion
Round 2 - Technical 

(2 Questions)

  • Q1. Kubernetes deployment
  • Q2. Ansible basic question
Round 3 - HR 

(2 Questions)

  • Q1. Salary discussion with HR manager
  • Q2. Negotiation salary with HR manager

Interview Preparation Tips

Topics to prepare for Ernst & Young Consultant interview:
  • Devops
Interview preparation tips for other job seekers - 1st round is technical, 2nd round tech with manager 3rd is HR round for salary discussion

Interview Questionnaire 

1 Question

  • Q1. General Accounting Concept

Interview Preparation Tips

Interview preparation tips for other job seekers - Be positive and be explanatory with your answers with your accounting knowledge

ZS Interview FAQs

How many rounds are there in ZS Business Intelligence Analyst and Tableau Developer interview?
ZS interview process usually has 1 rounds. The most common rounds in the ZS interview process are Technical.
What are the top questions asked in ZS Business Intelligence Analyst and Tableau Developer interview?

Some of the top questions asked at the ZS Business Intelligence Analyst and Tableau Developer interview -

  1. Find Top 5 and Botton 5 sales in same sh...read more
  2. User safety fil...read more

Tell us how to improve this page.

ZS Business Intelligence Analyst and Tableau Developer Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more
Join ZS Where passion changes lives

Interview Questions from Similar Companies

Deloitte Interview Questions
3.8
 • 2.9k Interviews
PwC Interview Questions
3.4
 • 1.4k Interviews
Ernst & Young Interview Questions
3.4
 • 1.2k Interviews
KPMG India Interview Questions
3.5
 • 804 Interviews
BCG Interview Questions
3.7
 • 197 Interviews
Citco Interview Questions
3.1
 • 142 Interviews
Bain & Company Interview Questions
3.8
 • 107 Interviews
WSP Interview Questions
4.2
 • 95 Interviews
View all
Associate Consultant
2k salaries
unlock blur

₹9.3 L/yr - ₹27 L/yr

Decision Analytics Associate
1.7k salaries
unlock blur

₹7.5 L/yr - ₹18.5 L/yr

Business Technology Associate
1.2k salaries
unlock blur

₹7 L/yr - ₹17.4 L/yr

Associate Decision Analytics Consultant
922 salaries
unlock blur

₹10.4 L/yr - ₹27.2 L/yr

Consultant
672 salaries
unlock blur

₹14.7 L/yr - ₹37 L/yr

Explore more salaries
Compare ZS with

Deloitte

3.8
Compare

Ernst & Young

3.4
Compare

PwC

3.4
Compare

KPMG India

3.5
Compare
Did you find this page helpful?
Yes No
write
Share an Interview