Hgs Services Data Analyst Interview Questions and Answers

Q1. Sum and sumif, date functions, text join, pivot tables
Add your answer

Critical question in maths

General topic about current situation

Q1. About ourselves and resume
Add your answer

Q1. Capital budgeting & cash flow statement
Add your answer

Q1. Fundamentals, financial statements
Add your answer
Q2. Project details, intrests
Add your answer

Q1. Introduction . project
Add your answer
Q2. General information , Finance knowledge
Add your answer

Analysing the company's document and finding out the answer which will be given in choose

Q1. Details of ESG(Environmental, social and governance)
Ans. 
ESG stands for Environmental, Social and Governance. It is a set of criteria used to evaluate a company's performance in these areas.
• Environmental criteria include a company's impact on the environment, such as its carbon footprint and use of renewable energy.

• Social criteria include a company's relationships with its employees, customers, and communities, as well as its impact on human rights.

• Governance criteria includ...read more
Answered by AI
Add your answer
Q2. What is mean by renewable and non renewable energy
Ans. 
Renewable energy is derived from natural resources that can be replenished, while non-renewable energy is finite and cannot be replenished.
• Renewable energy sources include solar, wind, hydro, geothermal, and biomass

• Non-renewable energy sources include fossil fuels like coal, oil, and natural gas

• Renewable energy is considered more sustainable and environmentally friendly

• Non-renewable energy sources are finite and will e...read more
Answered by AI
Add your answer

Q1. About data science basics
Add your answer
Q2. About sql and basic question like 2nd highest salary
Ans. Use sub query to get only two records and then reverse it and limit to 1 record output
Answered Anonymously
Add your answer
Q3. Python code for factorial
Ans. 
Python code to calculate factorial of a number.
• Use a loop to iterate from 1 to the given number.

• Multiply each number with the previous result.

• Return the final result.
Answered by AI
View 1 more answer
Q4. What is recursion, list, and few more basic questions
Add your answer

Some random case study related to fraud analytics , like how to prevent fraud in bank. If u know certain places show high fraud numbers getting reported, wht will you do to prevent.
Answer: confirm if there is really fraud going on or some tech glitch. If yes report . Do deep dive analysis.
Find areas where high fraud frequency is found. Find its located to certain machines or shops ( if its localized ) or distributed over various shops or channels like atm, bank ,shop card swiping etc.
Once analysed either out these sources on hold until further investigation is complete.

Q1. This was basically salary Negotiation
Add your answer

A train running at the speed of 60 km/hr crosses a pole of 9 seconds. what is hte length of train?

Print all prime numbers

Q1. Tell me about yourself
Ans. 
I am a data analyst with a strong background in statistics and programming.
• Experienced in analyzing large datasets and extracting meaningful insights

• Proficient in statistical analysis and data visualization tools such as Python, R, and Tableau

• Skilled in SQL for data querying and manipulation

• Strong problem-solving and critical thinking abilities

• Effective communication skills for presenting findings to stakeholders
Answered by AI
Add your answer
Q2. Projects you have done
Ans. 
Developed a predictive model to forecast customer churn for a telecommunications company.
• Used machine learning algorithms to analyze customer data

• Performed feature engineering to identify key predictors of churn

• Built and trained a model using historical data

• Evaluated model performance and provided actionable insights to reduce churn
Answered by AI
Add your answer