Coding Ninjas Data Analyst Interview Questions and Answers for Experienced

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

Q1. Previous experience, skills and expertise
Add your answer

Sql, numpy, pandas, dictionary, pandas group by, merging

Q1. Normal questions
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
Add your answer

Aptitude test is easy.

Really tuff

Q1. What are your salary expectations?
Ans. 
I am open to discussing salary based on the responsibilities and opportunities offered by the position.
• I am flexible and willing to negotiate based on the overall compensation package.

• I am more interested in the growth potential and learning opportunities than a specific salary number.

• I would like to be compensated fairly for my skills and experience in the industry.

• I am open to discussing salary range during the inter
Answered by AI
Add your answer
Q2. What is your family background?
Ans. 
My family background is diverse and includes individuals from various professions and cultural backgrounds.
• My father is a doctor and my mother is a teacher.

• I have two siblings, one is an engineer and the other is a lawyer.

• We have relatives who are artists, entrepreneurs, and scientists.

• Our family gatherings are always filled with interesting conversations and different perspectives.
Answered by AI
Add your answer
Q3. Where do you see yourself in 5 years?
Ans. 
In 5 years, I see myself as a senior software developer leading a team and working on complex projects.
• Leading a team of developers

• Working on complex projects

• Continuously learning and improving my skills

• Contributing to the growth and success of the company
Answered by AI
Add your answer
Q4. Why should we hire you?
Ans. 
I have a strong technical background and a passion for software development.
• I have a solid understanding of programming languages and software development principles.

• I have experience working on various software projects, including [example project].

• I am a quick learner and adapt easily to new technologies and frameworks.

• I am a team player and have excellent communication skills, which are essential for collaborating w...read more
Answered by AI
Add your answer

2 coding questions with aptitude question(logical aptitude and quantitative aptitude)

This was a Machine Coding. We need to design a system and then they will check our design by running test cases. It was 2.5 hrs long.

Q1. Basic questions on computer core subjects(Deadlock, Networking, Tcp connection, process scheduling etc, DNS Lookup etc)
Add your answer
Q2. Questions on React, Node and the libraries which I used in my project(My project was a full stack project)
Add your answer

Basic coding and MySQL queries. Like Types of join, having and where difference etc.

Q1. Salary Discussion.
Add your answer