Entrust Infotech Business Analyst Interview Questions and Answers for Freshers

Q1. Roles and responsibilities as Data Analyst on Google products.
Ans. 
As a Data Analyst on Google products, roles include analyzing user data, identifying trends, creating reports, and providing insights to improve product performance.
• Analyzing user data to identify patterns and trends

• Creating reports and dashboards to track key metrics

• Providing insights and recommendations to improve product performance

• Collaborating with cross-functional teams to drive data-informed decisions

• Utilizing t...read more
Answered by AI
Add your answer
Q2. Explain some products and projects done.
Ans. 
Developed a customer relationship management system for a retail company.
• Designed database schema to store customer information and purchase history

• Implemented user interface for sales representatives to input customer data and track interactions

• Integrated system with existing inventory management software for seamless data flow
Answered by AI
Add your answer
Q3. Questions related to Looker Studio, Google Suites.
Add your answer

Q1. What is roadmap
Add your answer
Q2. Metrics you capture
Add your answer

Q1. What are different types of joins
Ans. 
Different types of joins include inner join, outer join, left join, and right join.
• Inner join: Returns rows when there is a match in both tables

• Outer join: Returns all rows when there is a match in one of the tables

• Left join: Returns all rows from the left table and the matched rows from the right table

• Right join: Returns all rows from the right table and the matched rows from the left table
Answered by AI
Add your answer
Q2. What is inner join, cross join, left outer join
Ans. 
Inner join, cross join, and left outer join are types of SQL joins used to combine data from multiple tables.
• Inner join: Returns rows when there is a match in both tables based on the join condition

• Cross join: Returns the Cartesian product of the two tables, combining every row from the first table with every row from the second table

• Left outer join: Returns all rows from the left table and the matched rows from the ri...read more
Answered by AI
Add your answer
Q3. Scenario based questions
Add your answer

It was a general aptitude with a logical reasoning section and quantitative aptitude section

The topic of the gd was whether moonlighting good or bad

Basic to medium level aptitude questions not too tough

Q1. >Project based questions on ur resume >Coding questions based on the language in ur resume very basic. >Guesstimates >No of active credit cards user in india >Puzzles:from GFG >Standard Sql questions like ...read more
Add your answer

Q1. What is your future aspirations >Standard questions from statistics >Central tendency >Standard deviations >How much will you rate yourself out of 10
Ans. 
My future aspiration is to become a successful business analyst and contribute to the growth of the company.
• I aim to enhance my skills in data analysis and problem-solving.

• I want to work on diverse projects and gain experience in different industries.

• I plan to take up leadership roles and mentor junior analysts.

• I aspire to be a valuable asset to the organization and help achieve its goals.
Answered by AI
Add your answer