Sonata Software MIS Analyst Interview Questions and Answers

Provided sales case study, asked to analyse the same ans provide insights

Q1. Core python,python library and data science
Add your answer

Q1. Mathematics,python and sql and data science are complete
Add your answer

Q1. How SQL DB works
Ans. 
SQL DB works by storing and managing data in a structured format using tables and relationships.
• SQL DB uses tables to store data in rows and columns.

• It allows for querying data using SQL commands like SELECT, INSERT, UPDATE, DELETE.

• Relationships between tables can be established using foreign keys.

• Indexes can be used to optimize query performance.

• ACID properties ensure data integrity and consistency.
Answered by AI
Add your answer

Q1. About your self
Add your answer
Q2. Communication skills
Add your answer

Q1. Programming language
Add your answer
Q2. What tools do you utilize for data analysis?
Ans. 
I utilize tools such as Excel, Python, SQL, and Tableau for data analysis.
• Excel for basic data manipulation and visualization

• Python for advanced data analysis and machine learning

• SQL for querying databases

• Tableau for creating interactive visualizations
Answered by AI
Add your answer
Q3. Pandas numpy seaborn matplot
Add your answer

Data analysis of code in the context of data analysis.

Coding logical question paper.

SQL and python questions are very easy.

I was asked 2 programming questions.

Q1. Scenario based question. What if someone creates new user with 1st name and last name but backend developer forgot to write code to store last name. How will data be corrected.
Add your answer