i
SG
Analytics
Filter interviews by
VLOOKUP is a function in Excel used to search for a value in a table and return a corresponding value from another column.
VLOOKUP stands for 'vertical lookup'
It is commonly used to search for a value in the leftmost column of a table and return a value in the same row from a specified column
Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - searches ...
Environmental, social, governance (ESG) refers to the three central factors in measuring the sustainability and ethical impact of an investment in a company.
Environmental factors focus on a company's impact on the environment, such as carbon emissions, waste management, and resource conservation.
Social factors assess how a company manages relationships with employees, suppliers, customers, and the communities in w...
Documents considered in ESG Research process include company reports, sustainability reports, industry publications, and third-party research.
Company reports such as annual reports and financial statements
Sustainability reports detailing environmental, social, and governance practices
Industry publications providing insights on ESG trends and best practices
Third-party research reports from organizations like MSCI o...
The most recognized certification company for Environmental compliance and Health & Safety management is ISO.
ISO 14001 certification for Environmental compliance
ISO 45001 certification for Health & Safety management
Other relevant certifications include OHSAS 18001 and ANSI/AIHA Z10
Independent board members are not affiliated with the company, while dependent board members have ties to the company.
Independent board members are considered to be more objective and less influenced by company interests.
Dependent board members may include executives, shareholders, or individuals with close ties to the company.
Independent board members are often brought in to provide unbiased perspectives and over...
Duration is a measure of a bond's sensitivity to interest rate changes, while convexity measures the curvature of the relationship between bond prices and yields.
Duration is the weighted average time it takes to receive the bond's cash flows.
It helps investors understand how sensitive a bond's price is to changes in interest rates.
Convexity measures the degree of curvature in the relationship between bond prices a...
Levered beta measures the risk of an asset when it is financed with debt, while unlevered beta measures the risk of an asset without considering its financing structure.
Levered beta takes into account the impact of debt on the asset's risk
Unlevered beta ignores the impact of debt and measures the asset's inherent risk
Levered beta is higher than unlevered beta for assets with debt financing
Unlevered beta is useful ...
The number of tickets a movie theatre can sell in a day depends on factors such as seating capacity, movie popularity, and show timings.
Consider the seating capacity of the movie theatre
Take into account the popularity of the movies being shown
Consider the number of show timings in a day
Factor in the average occupancy rate of the theatre
Consider any special events or promotions that may affect ticket sales
Hedge funds are investment funds that pool capital from accredited individuals or institutional investors and invest in a variety of assets.
Hedge funds aim to generate high returns by using various strategies such as leverage, derivatives, and short selling.
They are typically only available to accredited investors due to their complex and risky nature.
Hedge funds charge both a management fee and a performance fee ...
The population of various states in India varies greatly.
India has a diverse population with different states having different population sizes.
The most populous state in India is Uttar Pradesh with over 200 million people.
Other highly populated states include Maharashtra, Bihar, and West Bengal.
Some states like Sikkim and Mizoram have relatively smaller populations.
The population distribution across states is inf...
I applied via Company Website and was interviewed in Feb 2024. There were 2 interview rounds.
Environmental, social, governance (ESG) refers to the three central factors in measuring the sustainability and ethical impact of an investment in a company.
Environmental factors focus on a company's impact on the environment, such as carbon emissions, waste management, and resource conservation.
Social factors assess how a company manages relationships with employees, suppliers, customers, and the communities in which ...
The most recognized certification company for Environmental compliance and Health & Safety management is ISO.
ISO 14001 certification for Environmental compliance
ISO 45001 certification for Health & Safety management
Other relevant certifications include OHSAS 18001 and ANSI/AIHA Z10
Independent board members are not affiliated with the company, while dependent board members have ties to the company.
Independent board members are considered to be more objective and less influenced by company interests.
Dependent board members may include executives, shareholders, or individuals with close ties to the company.
Independent board members are often brought in to provide unbiased perspectives and oversight...
Documents considered in ESG Research process include company reports, sustainability reports, industry publications, and third-party research.
Company reports such as annual reports and financial statements
Sustainability reports detailing environmental, social, and governance practices
Industry publications providing insights on ESG trends and best practices
Third-party research reports from organizations like MSCI or Sus...
I applied via Recruitment Consulltant and was interviewed in Mar 2024. There were 2 interview rounds.
I am a detail-oriented analyst with a passion for data-driven decision-making and a strong background in research and analysis.
Educational Background: I hold a degree in Economics, where I developed strong analytical skills through coursework and projects.
Professional Experience: I interned at XYZ Corp, where I analyzed market trends and presented findings to senior management, influencing strategy.
Technical Skills: Pr...
VLOOKUP is a function in Excel used to search for a value in a table and return a corresponding value from another column.
VLOOKUP stands for 'vertical lookup'
It is commonly used to search for a value in the leftmost column of a table and return a value in the same row from a specified column
Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - searches for t...
I applied via LinkedIn and was interviewed in Jul 2023. There were 2 interview rounds.
I applied via Approached by Company and was interviewed in May 2022. There were 4 interview rounds.
Assignment focused on financial concepts and excel skills
Levered beta measures the risk of an asset when it is financed with debt, while unlevered beta measures the risk of an asset without considering its financing structure.
Levered beta takes into account the impact of debt on the asset's risk
Unlevered beta ignores the impact of debt and measures the asset's inherent risk
Levered beta is higher than unlevered beta for assets with debt financing
Unlevered beta is useful for c...
Duration is a measure of a bond's sensitivity to interest rate changes, while convexity measures the curvature of the relationship between bond prices and yields.
Duration is the weighted average time it takes to receive the bond's cash flows.
It helps investors understand how sensitive a bond's price is to changes in interest rates.
Convexity measures the degree of curvature in the relationship between bond prices and yi...
I applied via Referral and was interviewed before May 2023. There were 3 interview rounds.
Hedge funds are investment funds that pool capital from accredited individuals or institutional investors and invest in a variety of assets.
Hedge funds aim to generate high returns by using various strategies such as leverage, derivatives, and short selling.
They are typically only available to accredited investors due to their complex and risky nature.
Hedge funds charge both a management fee and a performance fee based...
I applied via LinkedIn and was interviewed in May 2022. There were 2 interview rounds.
Aptitude test
The population of various states in India varies greatly.
India has a diverse population with different states having different population sizes.
The most populous state in India is Uttar Pradesh with over 200 million people.
Other highly populated states include Maharashtra, Bihar, and West Bengal.
Some states like Sikkim and Mizoram have relatively smaller populations.
The population distribution across states is influenc...
The number of tickets a movie theatre can sell in a day depends on factors such as seating capacity, movie popularity, and show timings.
Consider the seating capacity of the movie theatre
Take into account the popularity of the movies being shown
Consider the number of show timings in a day
Factor in the average occupancy rate of the theatre
Consider any special events or promotions that may affect ticket sales
I appeared for an interview in Dec 2016.
Top trending discussions
I applied via Referral and was interviewed before Feb 2021. There was 1 interview round.
EV stands for Enterprise Value, which is the total value of a company's equity and debt.
EV = Market Capitalization + Total Debt - Cash and Cash Equivalents
It is used to determine the total value of a company, including its debt
EV/EBITDA is a common valuation metric that compares a company's EV to its EBITDA
EV/Sales is another common valuation metric that compares a company's EV to its annual sales
EV can be used to comp...
The income statement shows a company's revenues and expenses over a specific period of time.
The income statement is also known as the profit and loss statement.
It includes revenues, cost of goods sold, gross profit, operating expenses, and net income.
Revenues are the money a company earns from selling its products or services.
Cost of goods sold is the cost of producing or purchasing the products or services sold.
Gross ...
I tend to overthink and can be too self-critical at times.
I often spend too much time analyzing details and can lose sight of the bigger picture.
I sometimes struggle with making decisions quickly due to overthinking.
I can be too hard on myself and take criticism too personally.
For example, in my previous job, I spent too much time perfecting a project and missed the deadline.
Another example is when I received construct...
Launching a new product involves several steps, from ideation to market launch.
Conduct market research to identify customer needs and preferences
Develop a product concept and create a prototype
Test the product with focus groups and make necessary adjustments
Create a marketing plan and determine pricing strategy
Launch the product and monitor sales and customer feedback
Make any necessary improvements or adjustments based...
Primary research is original research conducted by the researcher, while secondary research is based on existing research.
Primary research involves collecting new data through surveys, interviews, experiments, etc.
Secondary research involves analyzing existing data from sources like books, journals, websites, etc.
Primary research is more time-consuming and expensive than secondary research.
Secondary research is useful ...
There are approximately 50-60 traffic signals between Aurangabad and Pune.
Consider the distance between Aurangabad and Pune is around 235 km.
Assuming an average distance of 4 km between two signals, there would be around 58-59 signals.
However, the number may vary based on the route taken and the traffic density.
Also, the number of signals may have increased or decreased over time due to road development projects.
Hence,...
I am a highly motivated individual with a passion for problem-solving and continuous learning.
I have a degree in computer science and have worked as a software engineer for 3 years.
I enjoy taking on new challenges and have experience working in both team and individual settings.
In my free time, I enjoy reading books on technology and attending tech conferences to stay up-to-date with the latest trends.
I am also an avid...
Market research involves gathering and analyzing information about a target market to make informed business decisions.
Identify research objectives and target audience
Choose research methods (surveys, focus groups, etc.)
Collect and analyze data
Draw conclusions and make recommendations
Continuously monitor and update research
Example: Conducting a survey to determine customer satisfaction with a product
Example: Analyzing ...
Some of the top questions asked at the SG Analytics Associate Analyst interview -
based on 7 interview experiences
Difficulty level
Duration
based on 90 reviews
Rating in categories
Associate Analyst
454
salaries
| ₹3 L/yr - ₹6.7 L/yr |
Analyst
360
salaries
| ₹3.8 L/yr - ₹8 L/yr |
Senior Analyst
252
salaries
| ₹8.1 L/yr - ₹15 L/yr |
Consultant
220
salaries
| ₹2.5 L/yr - ₹5 L/yr |
Lead Analyst
82
salaries
| ₹12.5 L/yr - ₹22.2 L/yr |
IKS Health
Crisil
Indegene
Acuity Knowledge Partners