Morningstar Senior Data Analyst Interview Questions, Process, and Tips

Q1. About end to end Investment banking terminology. SQL Quires
Add your answer

Q1. Some SQL Questions and Behavioral questions Capital Market question.. Like what is CDS and how it works
Add your answer

Q1. Is it ok for Relocation,
Ans. 
Yes, I am open to relocation for the right opportunity.
• I am willing to relocate for a position that aligns with my career goals and offers growth opportunities.

• I am open to considering relocation packages and assistance.

• I am excited about the prospect of exploring new cities and cultures.

• Examples: I have previously relocated for a job and found it to be a positive experience.

• I am willing to discuss relocation during th
Answered by AI
Add your answer

Q1. Talked about previous experience in detail.
Add your answer
Q2. Asked some case studies regarding their products
Add your answer

Top 7 th employee salary
Find Duplicates

Q1. Trigger Stored procedure
Ans. 
A trigger is a special type of stored procedure that is automatically executed when certain events occur in a database.
• Triggers are used to enforce business rules, maintain data integrity, and automate tasks.

• They can be set to execute before or after INSERT, UPDATE, or DELETE operations on a table.

• For example, a trigger can be created to update a log table whenever a new record is inserted into a main table.
Answered by AI
Add your answer
Q2. Gateway Different modes in power bi
Ans. 
Power BI has different modes like View, Edit, and Data Source.
• View mode allows users to interact with reports and dashboards

• Edit mode enables users to modify existing reports and create new ones

• Data Source mode allows users to connect to and manipulate data sources
Answered by AI
Add your answer
Q3. Nothing to get importance no words
Add your answer

Q1. Define your dataset and what difficulties you have faced while preparing your model ?
Ans. 
The dataset consists of customer purchase history and demographic information. Difficulties faced include data cleaning and missing values.
• Dataset includes customer ID, purchase amount, purchase date, age, gender, and location.

• Difficulties faced include handling missing values in the age and location columns.

• Data cleaning involved removing duplicates and outliers to ensure accurate analysis.

• Normalization and standardiz
Answered by AI
Add your answer
Q2. What is Normalization and standardization
Ans. 
Normalization and standardization are techniques used to rescale data to have a mean of 0 and a standard deviation of 1.
• Normalization is the process of rescaling the data to have values between 0 and 1.

• Standardization is the process of rescaling the data to have a mean of 0 and a standard deviation of 1.

• Normalization is useful when the features have different ranges.

• Standardization is useful when the features have diff...read more
Answered by AI
Add your answer

Q1. What is K means
Ans. 
K-means is a popular clustering algorithm used to partition data points into K clusters based on similarity.
• K-means aims to minimize the sum of squared distances between data points and their respective cluster centroids.

• It requires the number of clusters (K) to be specified in advance.

• The algorithm iteratively assigns data points to the nearest cluster centroid and updates the centroids until convergence.

• K-means is se...read more
Answered by AI
Add your answer
Q2. Type 1 and Type 2 error
Add your answer