Tredence Interview Questions, Process, and Tips

Q1. Windows questions SQL
Add your answer
Q2. Prior projects in resume
Add your answer

Q1. Sql questions joins
Add your answer
Q2. Pandas question group by
Add your answer

Pizza chain distance calculation

Q1. Databricks questions
Add your answer
Q2. Spark optimisation
Add your answer
Q3. 2nd highest salary sql query
Ans. 
Use SQL query with ORDER BY and LIMIT to find the 2nd highest salary.
• Use ORDER BY clause to sort the salaries in descending order

• Use LIMIT 1,1 to skip the highest salary and get the 2nd highest salary
Answered by AI
Add your answer
Q4. Python dictionary code
Add your answer

Coding test which requires python and few aptitude and technical questions

Q1. Python questions and questions based on resume
Add your answer

Q1. Deal closing process
Add your answer
Q2. Custom reports in Salesforce
Ans. 
Custom reports in Salesforce allow users to create personalized reports based on specific criteria.
• Custom reports can be created by selecting the desired fields, filters, and grouping criteria.

• Users can also add charts, graphs, and tables to visualize the data in the report.

• Custom reports can be scheduled to run at specific times and be shared with other users.

• Examples of custom reports include sales performance by reg...read more
Answered by AI
Add your answer
Q3. PMO work experience
Add your answer

Q1. Brief overview of implementations in Salesforce
Ans. 
Salesforce is a CRM platform used for various implementations like sales, marketing, customer service, etc.
• Sales Cloud for sales automation

• Service Cloud for customer service management

• Marketing Cloud for marketing automation

• Community Cloud for building online communities

• Einstein Analytics for data analysis
Answered by AI
Add your answer
Q2. Explaining company's expectations
Ans. 
Company's expectations should be clearly communicated to employees to ensure alignment and success.
• Clearly outline job responsibilities and performance metrics

• Provide regular feedback and opportunities for growth

• Encourage open communication and collaboration within teams
Answered by AI
Add your answer

55 ML questions and aptitude and 3 python questions and 2 sql questions

Q1. Normal distribution plot
Add your answer
Q2. Standardisation vs normalisation
Ans. 
Standardisation and normalisation are techniques used to scale and transform data in order to improve model performance.
• Standardisation (Z-score normalisation) scales the data to have a mean of 0 and a standard deviation of 1.

• Normalisation (Min-Max scaling) scales the data to a specific range, typically between 0 and 1.

• Standardisation is less affected by outliers compared to normalisation.

• Standardisation is preferred w...read more
Answered by AI
Add your answer
Q3. How to handle outliars
Ans. 
Outliers can be handled by identifying, analyzing, and either removing or transforming them in the data.
• Identify outliers using statistical methods like Z-score or IQR.

• Analyze the outliers to understand if they are errors or valid data points.

• Remove outliers if they are errors or transform them using techniques like winsorization or log transformation.

• Consider using robust statistical methods that are less sensitive to...read more
Answered by AI
Add your answer
Q4. Draw Box-plot and explain its characteristics
Ans. 
Box-plot is a visual representation of the distribution of a dataset, showing the median, quartiles, and outliers.
• Box-plot displays the median (middle line), quartiles (box), and outliers (dots or lines).

• The length of the box represents the interquartile range (IQR).

• Whiskers extend to the smallest and largest non-outlier data points within 1.5 times the IQR from the quartiles.

• Outliers are plotted individually as dots o...read more
Answered by AI
Add your answer

Q1. How do you manage your time
Ans. 
I manage my time by prioritizing tasks, creating schedules, setting deadlines, and using time management tools.
• Prioritize tasks based on importance and deadlines

• Create daily or weekly schedules to allocate time for different tasks

• Set deadlines for each task to stay on track

• Use time management tools like calendars, to-do lists, and productivity apps

• Avoid multitasking and focus on one task at a time

• Take breaks to avoid b
Answered by AI
Add your answer
Q2. Why you want to join Tredence
Ans. 
I want to join Tredence because of their reputation for cutting-edge data science projects and collaborative work environment.
• Tredence is known for their innovative data science projects

• I value the collaborative work environment at Tredence

• I believe Tredence will provide opportunities for professional growth and development
Answered by AI
Add your answer