Changejar Technologies Data Analyst Intern Interview Questions and Answers

Q1. Tell me brief about your self
Ans. 
I am a data analyst with a strong background in statistics and data visualization.
• Experienced in analyzing large datasets using SQL, Python, and R

• Skilled in creating insightful reports and dashboards using Tableau and Power BI

• Strong communication skills to present findings to stakeholders

• Certified in data analysis and machine learning techniques
Answered by AI
Add your answer
Q2. What are youre strenth and weekness
Ans. 
My strength lies in my analytical skills and attention to detail, while my weakness is sometimes getting too caught up in the details.
• Strength: Strong analytical skills

• Strength: Attention to detail

• Weakness: Getting caught up in details (provide example)
Answered by AI
Add your answer

Code signal , SQL python questions

Take home coding assignment - 10 days analysis and recommendations

Q1. 4 rounds - 1 behavioralm 2 case studies 1 presentation
Add your answer

Data Coding, 1hr, series of questions in excel

Excel based data group discussion round. You were given 1 individual task for 10 mins and a group discussion task for 50 mins.

Q1. Business case study
Add your answer
Q2. How you can increase the profit of the ice cream company.
Ans. 
To increase the profit of the ice cream company, focus on product innovation, expanding distribution channels, and implementing targeted marketing strategies.
• Introduce new and unique flavors to attract more customers

• Collaborate with local cafes or restaurants to sell your ice cream products

• Utilize social media and online advertising to reach a wider audience

• Offer promotions or discounts to encourage repeat purchases

• Imp...read more
Answered by AI
Add your answer

Q1. What is the order of execution in sql
Ans. 
The order of execution in SQL is: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.
• 1. FROM: Specifies the tables involved in the query.

• 2. WHERE: Filters the rows based on specified conditions.

• 3. GROUP BY: Groups the rows that have the same values into summary rows.

• 4. HAVING: Filters groups based on specified conditions.

• 5. SELECT: Selects the columns to be included in the result set.

• 6. ORDER BY: Sorts the result set base
Answered by AI
Add your answer

Q1. How to do conditional formatting in excel
Ans. 
Conditional formatting in Excel allows users to format cells based on specified conditions.
• Select the range of cells you want to apply conditional formatting to

• Go to the 'Home' tab and click on 'Conditional Formatting'

• Choose the desired formatting option, such as color scales, data bars, or icon sets

• Set the conditions for when the formatting should be applied, such as greater than, less than, or equal to a certain valu...read more
Answered by AI
Add your answer

Q1. Detailed discussion on past experience and projects.
Add your answer

Q1. 2 Hackerrank SQL Questions
Add your answer
Q2. 1 Hackerrank Python Question
Add your answer

Topics were, DSA, SQL, PL/SQL, Data Augmentation

Customer churn classification using a classification ML model

Q1. Write a pseudo code for Bubble sort
Ans. 
Bubble sort is a simple sorting algorithm that repeatedly steps through the list, compares adjacent elements, and swaps them if they are in the wrong order.
• Start with the first element and compare it with the next element, swapping if necessary

• Repeat this process for each pair of adjacent elements in the array until the entire array is sorted

• Continue this process for each element in the array until no more swaps are ne
Answered by AI
Add your answer
Q2. What is an API
Ans. 
An API (Application Programming Interface) is a set of rules and protocols that allows different software applications to communicate with each other.
• APIs define the methods for requesting and receiving data between software applications

• APIs can be used to access data from external sources, such as social media platforms or weather services

• Examples of APIs include the Twitter API, Google Maps API, and Spotify API
Answered by AI
Add your answer

Q1. Tell me about yourself
Ans. 
I am a data analyst with a strong background in statistics and data visualization.
• Graduated with a degree in Statistics

• Proficient in programming languages like Python and R

• Experience in analyzing large datasets and creating data visualizations

• Strong problem-solving skills and attention to detail
Answered by AI
Add your answer
Q2. Salaray compensation how much
Add your answer