MASAI School Data Analyst Interview Questions and Answers

A general apti round

Data analysis assignment

Q1. Sql questions askes
Add your answer

Q1. Product sense round
Add your answer

Q1. Culture fit round
Add your answer

Q1. How would you use your skill for sales
Add your answer

Q1. SQL question difference between having and where
Ans. 
HAVING is used with GROUP BY to filter groups, WHERE is used to filter rows
• HAVING is used with GROUP BY to filter groups based on aggregate functions

• WHERE is used to filter rows based on conditions

• HAVING is applied after GROUP BY, WHERE is applied before GROUP BY

• Example: SELECT department, AVG(salary) FROM employees GROUP BY department HAVING AVG(salary) > 50000;

• Example: SELECT * FROM employees WHERE department = 'S...read more
Answered by AI
Add your answer

Q1. SQL queries , python pandas and numpy , power bi related questions
Add your answer

Q1. Previous experience, skills and expertise
Add your answer

Q1. What is DAX and its use in power bi
Ans. 
DAX (Data Analysis Expressions) is a formula language used in Power BI for data modeling and analysis.
• DAX is used to create calculated columns and measures in Power BI.

• It allows for advanced data analysis, such as time intelligence functions (e.g., YEAR, MONTH).

• Example: A measure to calculate total sales could be defined as: Total Sales = SUM(Sales[Amount]).

• DAX supports filtering and context manipulation, enabling dyna...read more
Answered by AI
Add your answer
Q2. Role of power query in power bi
Ans. 
Power Query is a data connection technology that enables data transformation and preparation in Power BI.
• Data Import: Power Query allows users to connect to various data sources like Excel, SQL Server, and web APIs.

• Data Transformation: Users can clean and reshape data using functions like filtering, merging, and pivoting.

• User-Friendly Interface: It provides a graphical interface for data manipulation, making it accessi...read more
Answered by AI
Add your answer

Data structures, particularly strings, play a crucial role in problem-solving.

Q1. Please tell me about yourself.
Ans. First of all , thank you! For this opportunity to introduce my self. I am Akash kumar kushwaha, I was born in bihar 2001 , but I live in ghaziabad now. I m currently pursuing my b.tech from IMS engineering college ghaziabad. And I completed my 10th and 12th from co-operative uchh vidyalaya jagdishpur with score 60% in 10th and 65% in 12th . And my hobby is playing cricket and travelling.
Answered by AKASH KUMAR KUSHWAHA
Add your answer
Q2. Why should we hire you?
Ans. 
I have a strong technical background, excellent problem-solving skills, and a passion for software development.
• I have a Bachelor's degree in Computer Science and 5 years of experience in software development.

• I am proficient in multiple programming languages such as Java, Python, and JavaScript.

• I have a track record of delivering high-quality code on time and within budget.

• I am a quick learner and always eager to stay u...read more
Answered by AI
Add your answer
Q3. What are your strength and weakness .
Ans. 
Strength: Problem-solving skills, Weakness: Impatience
• Strength: Strong problem-solving skills demonstrated through successful projects

• Weakness: Impatience when tasks take longer than expected, working on improving patience through time management techniques
Answered by AI
Add your answer
Q4. Why did you choose career in software developer.
Ans. 
Passion for problem-solving and creating innovative solutions drove me to pursue a career in software development.
• Fascination with technology and its potential to improve lives

• Enjoyment of logical thinking and coding challenges

• Desire to constantly learn and adapt in a fast-paced industry

• Previous experience in programming projects or internships
Answered by AI
Add your answer

Q1. What is your area of expertise in programming languages?
Ans. 
My area of expertise in programming languages is in web development, specifically with JavaScript, HTML, and CSS.
• Proficient in JavaScript for client-side scripting and server-side development with Node.js

• Experienced in building responsive and interactive web applications using HTML and CSS

• Familiar with popular frameworks and libraries like React, Angular, and Bootstrap
Answered by AI
Add your answer
Q2. What is JavaScript, and what are its benefits?
Ans. 
JavaScript is a high-level, interpreted programming language used for creating interactive websites.
• JavaScript is commonly used for client-side web development.

• It allows for dynamic content updates without reloading the page.

• JavaScript can be used to create interactive elements like forms, animations, and games.

• It is supported by all major web browsers.

• JavaScript can also be used for server-side development with Node.j...read more
Answered by AI
Add your answer

Q1. About Myself in details
Add your answer
Q2. Past internships and work experiences
Add your answer

Q1. Primary keys, Unique key
Add your answer
Q2. Usage advantages and disadvantages of Indexing
Ans. 
Indexing improves data retrieval speed but can increase storage and maintenance costs.
• Faster query performance: Indexes allow for quicker data retrieval. For example, searching for a user by ID is faster with an index.

• Reduced I/O operations: Indexes minimize the number of disk reads required to find data, enhancing performance.

• Increased storage requirements: Indexes consume additional disk space, which can be significa...read more
Answered by AI
Add your answer

SQL- 1 departments with no users
2 dept_id and their respective no. of users

DSA1: Most frequent no. in an array
DSA2: Zero Sum subarray exists