Axio Data Analyst Interview Questions and Answers

It was hackerrank test

Q1. Questions based on MS Excel only and provide 1 assignment for data analysis.
Add your answer

Q1. Again easy questions on MS Excel like; Vlookup, pivot, summarize, sumif, etc
Add your answer

45 min , 45 questions

Q1. Technical question( PowerBI, data science)
Add your answer
Q2. Behaviourial question
Add your answer

Q1. Filtering methods in pandas?
Ans. 
Pandas filtering methods allow for selecting data based on conditions, enhancing data analysis and manipulation.
• Boolean indexing: Use boolean conditions to filter rows. Example: df[df['age'] > 30]

• Query method: Use the query() function for filtering. Example: df.query('age > 30')

• loc method: Access a group of rows and columns by labels. Example: df.loc[df['age'] > 30, ['name', 'age']]

• isin method: Filter rows bas...read more
Answered by AI
Add your answer
Q2. Make simple function to create new columns by using existing multiple other fields.
Add your answer
Q3. Write a simple SQL query for department wise budget?
Add your answer

How to improve credit model in order to increase sales growth of the organization?

Q1. Related to relocation?
Add your answer
Q2. Why you want to chnage current organization?
Ans. 
I seek new challenges and opportunities for growth that align with my career goals and passion for data science.
• Desire for professional growth: I want to work on more complex projects that push my analytical skills.

• Interest in innovative technologies: My current organization is not utilizing the latest tools in data science, like machine learning frameworks.

• Cultural fit: I am looking for a company that values collabora...read more
Answered by AI
Add your answer

Q1. Mostly revolves around SQL, A bit of python and in that also specially pandas and might be a bit of excel
Add your answer

Q1. SQL a bit advanced, Pandas and Python, and around your projects some time and if you mentioned ML then some questions around it mostly logistic regression,random foresr
Add your answer

Q1. Tell me about yourself.
Add your answer

The aptitude round consists of approx 20 q's, out of which half the q's were based on LR and aptitude and half based on computer fundamentals.

The coding test consisted of 4 q's. The selection criteria was to complete at least 3 q's.

Q1. Tell me something about yourself
Ans. 
I am a passionate software engineer with experience in developing web applications using various technologies.
• Experienced in developing web applications using HTML, CSS, JavaScript, and frameworks like React and Angular

• Proficient in backend development with Node.js and databases like MongoDB and MySQL

• Familiar with version control systems like Git and project management tools like Jira
Answered by AI
Add your answer
Q2. Questions on React.js, as i had build projects using react.js.
Add your answer

Q1. About experience and work profile
Add your answer

Q1. About salary, position and working location
Add your answer