Zenith Software Analyst Interview Questions and Answers

Odd man out series , reasoning 60 mins 40 questions

Print string reverse ,print even or odd numbers

Q1. Explain recent project
Ans. 
Developed a predictive model for customer churn in a telecom company
• Collected and cleaned customer data from various sources

• Performed exploratory data analysis to identify patterns and trends

• Built a machine learning model using logistic regression to predict customer churn

• Evaluated the model's performance using metrics such as accuracy, precision, and recall
Answered by AI
Add your answer
Q2. Cloud technologies used
Ans. 
Various cloud technologies like AWS, Azure, and Google Cloud are commonly used for data analysis.
• AWS (Amazon Web Services)

• Azure (Microsoft Azure)

• Google Cloud Platform
Answered by AI
Add your answer

Performance based questions

Simple coding of python

Q1. Simple questions on python
Add your answer

The first round was a combination of MCQs and SQL Coding test. It consisted of 23 MCQs on SQL, 10 MCQs on Power BI and 5 SQL Coding questions.

Q1. Simple questions on SQL were asked.
Add your answer

Q1. What is pivot table in Excel?
Ans. 
A pivot table in Excel is a data summarization tool that allows you to reorganize and summarize selected columns and rows of data.
• Pivot tables allow you to analyze and summarize large amounts of data in a spreadsheet.

• You can easily rearrange the layout of the data to view it from different perspectives.

• Pivot tables can perform functions like sum, average, count, and more on the data.

• They are useful for creating reports...read more
Answered by AI
Add your answer
Q2. What is 'Data Validation' in Excel?
Ans. 
Data Validation in Excel ensures that data entered in a cell meets certain criteria or conditions.
• Data Validation allows you to set rules for what can be entered in a cell, such as a range of values, a list of items, or a custom formula.

• Examples of Data Validation include setting a drop-down list of options for a cell, restricting input to a certain number range, or ensuring dates are entered in a specific format.

• Data ...read more
Answered by AI
Add your answer
Q3. What is the order of execution of an SQL query?
Ans. 
The order of execution of an SQL query involves multiple steps to retrieve data from a database.
• 1. Parsing: The SQL query is first parsed to check for syntax errors.

• 2. Optimization: The query optimizer creates an execution plan to determine the most efficient way to retrieve data.

• 3. Compilation: The optimized query is compiled into an executable form.

• 4. Execution: The compiled query is executed by the database engine t...read more
Answered by AI
Add your answer
Q4. What is the difference between Tree Map and Heatmap in Tableau?
Ans. 
Tree Map visualizes hierarchical data using nested rectangles, while Heatmap displays data values using color gradients.
• Tree Map displays data hierarchically with nested rectangles, where the size and color represent different measures.

• Heatmap visualizes data values using color gradients, with darker colors indicating higher values.

• Tree Map is useful for showing hierarchical data structures, while Heatmap is effective ...read more
Answered by AI
Add your answer
Q5. What is the difference between 'Extract Data' and 'Live Connection' in Tableau?
Ans. 
Extract Data saves a snapshot of data in Tableau workbook, while Live Connection directly connects to data source.
• Extract Data creates a static copy of data in Tableau workbook, while Live Connection directly queries data source in real-time.

• Extract Data is useful for working offline or with small datasets, while Live Connection is ideal for large datasets or when data is frequently updated.

• Extract Data can improve per...read more
Answered by AI
Add your answer

Q1. Introduce yourself. what is Salesforce , profile , permission set , Security Question , Workflow , approval process limits What is STLC , Test plan , integration , performance , regression, functional tes...read more
Add your answer

Q1. Questions related to projects and exp. If you left a major bug in project then how you handle the situation.- I haven't faced such situation as of now because i was a junior.
Add your answer

Q1. What are your salary expectations?
Add your answer
Q2. What is your family background?
Add your answer
Q3. Why are you looking for a change?
Add your answer
Q4. What are your strengths and weaknesses?
Add your answer
Q5. Tell me about yourself.
Add your answer

Q1. General questions about SQL ( Using Group By, Rank, Dense Rank, Views, Limit, Aggregates)
Add your answer
Q2. Tasks in Power BI ( How you will transform data to visualize it)
Ans. 
In Power BI, data transformation involves cleaning, shaping, and modeling data to create visualizations.
• Import data from various sources such as Excel, SQL databases, or online services

• Clean and transform data using Power Query Editor

• Create relationships between different data tables

• Use DAX formulas to calculate new columns or measures

• Design visualizations like charts, graphs, and tables to present insights
Answered by AI
Add your answer
Q3. What visualizations you use for different forms of data and contexts?
Ans. 
I use a variety of visualizations such as bar charts, line graphs, scatter plots, and heat maps depending on the type of data and context.
• Bar charts are useful for comparing categories of data

• Line graphs are great for showing trends over time

• Scatter plots help in identifying relationships between variables

• Heat maps are effective for visualizing large datasets and identifying patterns
Answered by AI
Add your answer

Q1. What are your roles and responsibilities as a business analyst
Add your answer
Q2. What projects have you worked on?
Add your answer
Q3. Scenario based questions
Add your answer
Q4. Analytical Questions
Add your answer
Q5. Write a user story
Ans. 
As a user, I want to be able to search for products by category so that I can easily find what I need.
• User can select a category from a dropdown menu

• User can see a list of products within the selected category

• User can filter the products by price or other attributes
Answered by AI
Add your answer

Q1. What are your goals and aspirations
Add your answer
Q2. What does your day look like at your company
Add your answer
Q3. What are your expectations from your next company
Add your answer

Q1. SQL and excel questions intermediate
Add your answer