Trent Data Analyst Interview Questions and Answers

Financial condition of India

Q1. Analysis and company audit.
Add your answer

Q1. Data Sceince related questions
Add your answer

Q1. Difference between where and having clause?.
Ans. 
WHERE clause filters rows before grouping while HAVING clause filters groups after grouping.
• WHERE clause is used to filter rows based on a condition before grouping them.

• HAVING clause is used to filter groups based on a condition after grouping them.

• WHERE clause is used with SELECT, UPDATE, DELETE statements while HAVING clause is used with GROUP BY clause.

• WHERE clause is faster than HAVING clause as it filters rows be...read more
Answered by AI
Add your answer
Q2. Lead lag questions . Explain windows functions and stored procedure
Add your answer

Q1. Difference between SQL /NON SQL
Ans. 
SQL is a structured query language used for relational databases, while NoSQL is a non-relational database management system.
• SQL is used for structured data with predefined schema, while NoSQL is used for unstructured or semi-structured data.

• SQL databases are vertically scalable, while NoSQL databases are horizontally scalable.

• SQL databases are ACID compliant, ensuring data integrity, while NoSQL databases sacrifice so...read more
Answered by AI
Add your answer

Q1. In Agile development what is the DOR
Ans. 
DOR stands for Definition of Ready in Agile development.
• DOR is a checklist of criteria that a user story must meet before it can be considered ready for development.

• It ensures that the team has a shared understanding of the requirements and that the story is feasible and testable.

• DOR helps to prevent scope creep and ensures that the team is working on the most valuable features.

• Examples of DOR criteria include clear ac...read more
Answered by AI
Add your answer

Q1. Tell about project that you have been Working on
Ans. 
Developed a data analysis tool for tracking customer behavior on e-commerce platform
• Used Python and SQL to extract and analyze data from the database

• Implemented machine learning algorithms to predict customer preferences

• Created visualizations to present findings to stakeholders
Answered by AI
Add your answer

Q1. Tell me about your projects
Ans. 
I have worked on various projects involving data analysis, process improvement, and system implementation.
• Implemented a new CRM system to streamline customer data management

• Conducted data analysis to identify trends and opportunities for cost savings

• Led a cross-functional team to improve inventory management processes

• Developed KPI dashboards to track project performance and ROI
Answered by AI
Add your answer
Q2. What are your day to day activities
Ans. 
As a Business Analyst, my day to day activities include gathering and analyzing data, creating reports, identifying business trends, and collaborating with stakeholders.
• Gathering and analyzing data to identify business opportunities and trends

• Creating reports and presentations to communicate findings to stakeholders

• Collaborating with stakeholders to understand business needs and requirements

• Conducting meetings and inte...read more
Answered by AI
Add your answer

Asked me to prepare a PPT on reliance retail

Q1. We can give only 30% hike.. why would I hire you?
Ans. 
I bring a unique combination of skills, experience, and passion for the role that will drive value beyond just the salary increase.
• My track record of delivering successful projects on time and within budget showcases my ability to add significant value to the organization.

• I possess a diverse skill set including data analysis, problem-solving, and stakeholder management which are crucial for a Business Analyst role.

• My p...read more
Answered by AI
Add your answer