Truemeds Data Analyst Interview Questions and Answers

Q1. Screening questions
Add your answer
Q2. Name, age, qualification, prior experience etc
Add your answer

Operation questions like vlookups, Hlookups, xlookups etc,.

Reporting questions like pivot tables, typing speed, power pivots, pricing sheet preparation

SQL queries like joins, aggregation functions, filters etc,.

Q1. Advanced analytics and finding trends and patterns with MH - operations data
Add your answer
Q2. How fast can you prepare a bar chart with product operations data
Ans. 
I can prepare a bar chart with product operations data within a few minutes.
• I have experience using data visualization tools like Tableau, Power BI, or Excel to quickly create bar charts.

• I am proficient in organizing and cleaning data to ensure accurate representation in the chart.

• I can customize the chart with relevant labels, colors, and titles to make it visually appealing and easy to understand.
Answered by AI
Add your answer
Q3. How can I do merge multiple excel files together
Ans. 
You can merge multiple Excel files together using the 'Consolidate' feature in Excel.
• Open Excel and go to the 'Data' tab

• Click on 'Consolidate' in the 'Data Tools' group

• Select the files you want to merge and choose the desired options

• Click 'OK' to merge the files together
Answered by AI
Add your answer

Test was based on SQL, coding and MCQ. Coding involved nested query.

There are 2 coding challenges and 7 objective questions

Q1. Technical questions related to role
Add your answer

Q1. SQL query use join
Add your answer

Q1. Interviewer asked me basic SQL questions
Add your answer
Q2. In the second technical round he asked me advanced SQL topics (Windows Functions, Joins & Subqueries)
Add your answer

In the second technical round interview asked me about advanced sql topics, theory questions and two coding questions in joins and window functions.

Number sires, clock, logic, arithmetic, geometry

Code test basic, ans the basic knowledge, write code

Q1. What is python?
Ans. 
Python is a high-level programming language known for its simplicity and readability.
• Python is widely used for web development, data analysis, artificial intelligence, and scientific computing.

• It emphasizes code readability and uses indentation to define code blocks.

• Python has a large standard library and a vibrant community of developers.

• Example: print('Hello, World!')

• Example: import pandas as pd
Answered by AI
View 1 more answer
Q2. What is python used for?
Ans. 
Python is a versatile programming language used for data analysis, web development, artificial intelligence, automation, and more.
• Data analysis and visualization

• Web development (Django, Flask)

• Artificial intelligence and machine learning (TensorFlow, PyTorch)

• Automation and scripting

• Scientific computing (NumPy, SciPy)
Answered by AI
View 1 more answer
Q3. What type of language is python?
Ans. 
Python is a high-level programming language known for its simplicity and readability.
• Python is an interpreted language, meaning it does not need to be compiled before running.

• It supports multiple programming paradigms, including object-oriented, imperative, and functional programming.

• Python has a large standard library and a thriving community, making it versatile and widely used.

• Example: Python is used for web develop...read more
Answered by AI
Add your answer
Q4. What is oops in python?
Ans. 
Object-oriented programming (OOP) is a programming paradigm based on the concept of 'objects', which can contain data and code.
• OOP allows for the organization of code into reusable components called classes.

• Classes can have attributes (variables) and methods (functions) associated with them.

• In Python, everything is an object, and classes can be defined using the 'class' keyword.

• Encapsulation, inheritance, and polymorph
Answered by AI
Add your answer
Q5. What is array in python?
Ans. 
An array in Python is a data structure that stores a collection of elements of the same type.
• Arrays can store elements such as integers, floats, or strings.

• Arrays are indexed starting from 0, with elements accessed using their index.

• Example: arr = ['apple', 'banana', 'cherry']
Answered by AI
Add your answer

Technica questions related to sql

Q1. Some technical questions related to sql and advance excel .
Add your answer

Q1. Some questions related to cars insurance and second cars
Add your answer

Q1. Salary discussion and some hr questions
Add your answer

Q1. What’s your previous experience
Ans. 
I have 3 years of experience as a data analyst in the finance industry.
• Worked with large datasets to extract meaningful insights

• Performed data cleaning, transformation, and visualization

• Created and maintained dashboards and reports for stakeholders

• Conducted statistical analysis and built predictive models

• Collaborated with cross-functional teams to identify business opportunities
Answered by AI
Add your answer
Q2. What’s your skills for the current role
Ans. 
I have strong skills in data analysis, including proficiency in statistical analysis, data visualization, and programming languages such as Python and SQL.
• Proficient in statistical analysis techniques

• Skilled in data visualization using tools like Tableau

• Strong programming skills in Python and SQL

• Experience with data cleaning and preprocessing

• Ability to interpret and communicate insights from data

• Familiarity with machin...read more
Answered by AI
Add your answer