Spectra Management Consultancy Pvt. Ltd. Senior Analyst Interview Questions and Answers

Q1. Normal questions asked
Add your answer

Q1. SQL questions were asked
Add your answer

Basic aptitude of charts.

Q1. What are the VA and NVA for a company
Ans. 
VA (Value-Added) and NVA (Non-Value-Added) activities are used to identify processes that add value to a company's products or services.
• VA activities are those that directly contribute to meeting customer requirements and are willing to pay for.

• NVA activities are those that do not add value to the final product or service and should be minimized or eliminated.

• Examples of VA activities include product design, manufactur...read more
Answered by AI
Add your answer
Q2. Difference between standard time and normal time.
Ans. 
Standard time is the time used in a specific region or country, while normal time refers to the regular time on a clock.
• Standard time is based on the time zone of a specific region or country.

• Normal time is the time displayed on a clock, typically in hours and minutes.

• Standard time may vary depending on the location, while normal time remains constant.

• For example, standard time in New York (EST) is different from stand...read more
Answered by AI
Add your answer
Q3. Relaxation Allowance in hot working zone for a man.
Ans. 
Relaxation allowance in hot working zone refers to breaks or time off provided to employees to rest and cool down in high temperature environments.
• Allow employees to take frequent breaks to hydrate and rest in a cool area

• Provide access to cold water or electrolyte drinks to prevent dehydration

• Implement a rotating schedule to limit exposure to extreme heat

• Encourage employees to wear appropriate clothing and use cooling ...read more
Answered by AI
Add your answer

Q1. General salary and expectation discussion
Add your answer

Q1. Guesstimate questions and general aptitude question. Example, what is the difference between public and private companies?
Add your answer

Q1. Give trends if a specific market.
Ans. 
The trend in the smartphone market is towards larger screens and 5G connectivity.
• Increasing demand for smartphones with larger screens for better multimedia experience

• Growing popularity of 5G technology in smartphones for faster internet speeds and improved connectivity

• Rise of foldable smartphones as a new trend in the market
Answered by AI
Add your answer

Q1. Basic finance question and
Add your answer
Q2. Tell me about yourself
Add your answer

Excel case study with values and referencing

Q1. What is happening in the global industry right now? Current Trends in interest rates How will you increase profitability of swiggy? Market sizing guesstimate
Ans. 
Global industry is experiencing fluctuating interest rates, focus on increasing profitability of companies like Swiggy, and market sizing guesstimates.
• Interest rates are currently fluctuating due to economic uncertainties and central bank policies.

• To increase profitability of Swiggy, focus on optimizing operational efficiency, expanding customer base, and enhancing delivery services.

• Market sizing guesstimates involve e...read more
Answered by AI
Add your answer
Q2. Introduce yourself. Why Redseer. Why consulting
Add your answer

Questions like sql erc

Q1. Salary discussions
Add your answer

Q1. Prepaid expenses, accumulated depreciation,sale of fixed assets,bad debts,
Add your answer

Q1. When do you use vlookup in excel
Ans. 
VLOOKUP in Excel is used to search for a value in a table and return a corresponding value from another column.
• Use vlookup to find specific data in a large dataset

• Use vlookup to merge data from different tables

• Use vlookup to create dynamic reports by pulling data from multiple sources

• Example: =VLOOKUP(A2, Sheet2!A:B, 2, FALSE) - this formula searches for the value in cell A2 in the first column of Sheet2 and returns th
Answered by AI
Add your answer
Q2. Can you explain about joins in sql
Ans. 
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
• Joins are used to retrieve data from multiple tables based on a related column

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• INNER JOIN returns rows when there is at least one match in both tables

• LEFT JOIN returns all rows from the left table and the matched rows from the right table

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

Q1. Which model is using for classification?
Ans. 
We are using the Random Forest model for classification.
• Random Forest model is an ensemble learning method that builds multiple decision trees and merges them together to get a more accurate and stable prediction.

• It is widely used for classification tasks due to its ability to handle large datasets with high dimensionality.

• Random Forest is a popular choice in machine learning for its robustness and ability to reduce ov...read more
Answered by AI
Add your answer

Q1. Salary discussion
Add your answer