TresVista Interview Questions, Process, and Tips

Q1. Write me a query to get the last month's data and it only runs 1st of everymonth
Ans. 
Query to retrieve last month's data on the 1st of every month
• Use the DATEADD function to subtract a month from the current date

• Filter the results to only include data from the 1st of the month

• Example: SELECT * FROM table_name WHERE date_column = DATEADD(month, -1, DATEADD(month, DATEDIFF(month, 0, GETDATE()), 0))
Answered by AI
Add your answer

Medium level of questions across all sections of aptitude

Q1. Related to SQL and python Power BI dax questions Project related questions
Add your answer

Sql, python, power bi

Q1. Cte functions in sql
Ans. 
CTE functions in SQL are Common Table Expressions used to create temporary result sets for complex queries.
• CTEs are defined using the WITH keyword

• They can be referenced multiple times in a query

• They improve readability and maintainability of complex queries
Answered by AI
Add your answer
Q2. Power bi related questions
Add your answer

Q1. Salary negotiations
Add your answer
Q2. Salary expectation
Add your answer

The aptitude test contained word problems, logical reasoning, math questions and grammar related questions. Basic to mid level

Q1. Technical round was more around, 'why you wanna join the company', accounting and investment banking and private equity related questions. 'What is PE/IB'?, 'Explain the flow of transactions in the books o...read more
Add your answer

Q1. This was the final round with one of the VPs where again questions related to GAAP, Investment banking and accounting were asked. Questions such as ''Prepare a basic Cash Flow and Income Statement", "Line...read more
Add your answer

Asked about analytical and communication related domain questions.

Q1. Asked about business financial related topics questions.
Add your answer
Q2. X company is selling product. what market should it targer?
Ans. 
x company should target the market segment that has a high demand for their product and where they can differentiate themselves from competitors.
• Identify the target demographic based on age, gender, income level, etc.

• Analyze market trends and consumer behavior to determine potential demand.

• Consider geographical locations where the product is likely to be popular.

• Evaluate competitors' target markets to find gaps or oppo...read more
Answered by AI
Add your answer

Aptitude test based on Mathematics, Reasoning and English