HGS Data Analyst Interview Questions and Answers

Aptitude test on reasoning and problem solving

Q1. What is list and tuple
Ans. 
List and tuple are both data structures in Python. Lists are mutable, ordered collections of items, while tuples are immutable, ordered collections.
• List is mutable, meaning its elements can be changed after creation

• Tuple is immutable, meaning its elements cannot be changed after creation

• List is defined using square brackets [], while tuple is defined using parentheses ()

• Example of list: my_list = [1, 2, 3]

• Example of tu
Answered by AI
Add your answer
Q2. How tableau works
Ans. 
Tableau is a data visualization tool that helps users create interactive and shareable dashboards and reports.
• Tableau connects to various data sources such as Excel, SQL databases, and cloud services.

• Users can drag and drop fields to create visualizations like charts, graphs, and maps.

• Tableau allows for interactive filtering and drilling down into data for deeper insights.

• Users can create dashboards and stories to pres...read more
Answered by AI
Add your answer

Q1. Walk through your project?
Ans. 
Developed a predictive model to forecast sales based on historical data
• Collected and cleaned historical sales data

• Performed exploratory data analysis to identify trends and patterns

• Built and trained a machine learning model using regression techniques

• Evaluated model performance using metrics like RMSE and MAE
Answered by AI
Add your answer
Q2. Behavioral questions?
Add your answer

Q1. Questions based on Advanced Excel like Vlookup, Index match, sumifs, pivot tables
Add your answer
Q2. Behavioral questions
Add your answer

Q1. Salary negotiation
Add your answer

Power BI report for shoe case analysis.

Q1. Basic introduction about previous projects and skillsets.
Add your answer
Q2. Related to Power BI, SQL
Add your answer

SAS basic Programming questions

Q1. What questions can arise based on the projects mentioned in your resume?
Ans. 
Questions can arise about data sources, methodologies, insights gained, and impact of projects mentioned in resume.
• Data sources used in the projects

• Methodologies employed for data analysis

• Insights gained from the analysis

• Impact of the projects on decision-making or outcomes
Answered by AI
Add your answer

Q1. Tell me about your self
Add your answer
Q2. If experienced, then Tell me about your previous job role and responsibilities of previous job role.
Add your answer
Q3. Tell me about your resume.
Ans. 
My resume showcases my experience in data analysis, including proficiency in SQL, Python, and data visualization tools.
• Proficient in SQL for data querying and manipulation

• Skilled in Python for data analysis and automation

• Experience with data visualization tools like Tableau and Power BI

• Strong analytical and problem-solving skills

• Previous projects include analyzing sales data to identify trends and patterns
Answered by AI
Add your answer
Q4. Tell me about your memorable Moment of life.
Ans. 
My memorable moment was when I graduated from college.
• Graduating from college after years of hard work

• Celebrating with family and friends

• Feeling a sense of accomplishment and pride
Answered by AI
Add your answer

Be well prepared with Excel especially

Q1. How do you handle critical work situation?
Add your answer
Q2. Team work, collaboration, managerial involvement
Add your answer

Q1. How do you handle co-worker's task when given to you?
Add your answer
Q2. Inform the manager and have a clear communication with the co worker on the progress and perquisites.
Add your answer

Q1. Self introduction
Ans. Thank you for shortlisting me to the personal interview round. I am bhavina jeeva. I am from namakkal. I completed my B.E computer science in April 2016. 2 year's i worked as a data analyst in a tnq technologies and private ltd. My hobbies are helping people's and reading motivational books. And my strength is my honest character and my boldness. However, if you like any for the details i glad to share it.
Answered Anonymously
Add your answer
Q2. What is meaning of data analyst
Ans. 
A data analyst is a professional who collects, analyzes, and interprets data to help organizations make informed decisions.
• Data analysts collect and organize large sets of data from various sources.

• They use statistical techniques and tools to analyze the data and identify patterns, trends, and insights.

• Data analysts interpret the findings and present them in a clear and concise manner to stakeholders.

• They help organiza...read more
Answered by AI
View 1 more answer
Q3. How long should you stay in a job
Add your answer
Q4. Why do you want to work for our company
Ans. Good Team work, good salary, good improvement of this company.
Answered Anonymously
Add your answer
Q5. What are you greatest strength and weakness
Ans. Be honest, I am great team player and i am also a self motivated my weakness is loneliness
Answered Anonymously
Add your answer

Q1. Introduce yourself,why should we hire u
Add your answer

Basic questions on SQL, Python