Tredence Interview Questions, Process, and Tips for Experienced

Q1. When would you use Parameters and constant in m query.
Ans. 
Parameters are used for dynamic values that can be changed, while constants are used for fixed values in M query.
• Use parameters for values that may change frequently, such as dates or file paths

• Use constants for values that are fixed, such as column names or static calculations
Answered by AI
Add your answer
Q2. Some questions related to the projects I have worked on.
Add your answer
Q3. Some wueations related to the Banking sector overview and KPI'S
Add your answer

Q1. Few dax and sql queries
Add your answer

Q1. Salary discussion
Add your answer

Q1. SQL Window functions
Add your answer
Q2. Tableau LOD functions
Add your answer

Q1. What is the difference between method and function.
Ans. 
Methods are functions associated with objects; functions are standalone blocks of code.
• A method is called on an object (e.g., `list.append(1)`), while a function is called independently (e.g., `print('Hello')`).

• Methods can access and modify the object's state, whereas functions do not have access to object-specific data.

• In Python, methods are defined within a class, while functions can be defined outside of any class.

• E...read more
Answered by AI
Add your answer
Q2. Explain one of your projects mentioned in resume
Add your answer
Q3. What are mutable and immutable objects in python.
Ans. 
Mutable objects can be changed after creation; immutable objects cannot be altered once created.
• Mutable objects: Lists, Dictionaries, Sets.

• Example of mutable: list1 = [1, 2, 3]; list1.append(4) results in [1, 2, 3, 4].

• Immutable objects: Tuples, Strings, Frozensets.

• Example of immutable: str1 = 'hello'; str1[0] = 'H' raises an error.
Answered by AI
Add your answer

Q1. Basic intro about profile
Add your answer
Q2. Background of scm
Ans. 
SCM stands for Supply Chain Management, which involves the planning, coordination, and execution of all activities involved in sourcing, procurement, production, and logistics.
• SCM involves the management of the flow of goods and services from the point of origin to the point of consumption.

• It includes activities such as inventory management, demand forecasting, supplier relationship management, and distribution.

• Effecti...read more
Answered by AI
Add your answer

In this round, we have to answer a case study within two days and present are findings to the panel

Q1. In depth grilling on scm
Add your answer

Q1. Salary discussion
Add your answer

3 hours, Basic aptitude questions, 3 coding questions, MCQ programming questions

Q1. Applications of data science in other industries. 1 guestimate and puzzel
Ans. 
Data science is used in various industries like finance, marketing, healthcare, and transportation to analyze trends, make predictions, and optimize processes.
• Finance: Predictive analytics for stock market trends and risk assessment.

• Marketing: Customer segmentation and targeted advertising campaigns.

• Healthcare: Predictive modeling for disease diagnosis and treatment.

• Transportation: Route optimization and demand forecas
Answered by AI
Add your answer

Q1. Where do you see yourself in 5 years.
Add your answer