Morgan Advanced Materials Global Operations Analyst Interview Questions and Answers

Q1. What is an inactive relationship in PBI
Ans. 
An inactive relationship in Power BI is a relationship that is not being used in any visualizations or calculations.
• Inactive relationships can occur when a relationship is created but not utilized in any measures or visuals.

• These relationships do not impact the data model or query performance, but can clutter the model view.

• To remove an inactive relationship, you can delete it from the relationship view in Power BI.

• Ina...read more
Answered by AI
Add your answer
Q2. Import vs Direct Query vs Live connection
Ans. 
Import vs Direct Query vs Live connection
• Import: Data is imported into the tool for analysis, suitable for small datasets or when real-time data is not required

• Direct Query: Data is queried directly from the source in real-time, suitable for large datasets or when up-to-date data is needed

• Live connection: Data is connected live to the source, allowing for real-time updates and analysis without storing data locally
Answered by AI
Add your answer

Regular aptitude test like puzzles and trick questions. A few excel based questions.

Q1. Previous projects, Important Web Metrics
Add your answer
Q2. Important Web Metrics
Ans. 
Important web metrics include traffic, bounce rate, conversion rate, and average session duration.
• Traffic: Measure of the number of visitors to a website.

• Bounce Rate: Percentage of visitors who navigate away from the site after viewing only one page.

• Conversion Rate: Percentage of visitors who take a desired action on the site.

• Average Session Duration: Average amount of time visitors spend on the site.
Answered by AI
Add your answer
Q3. What happens when you type google.com on browser addressbar
Ans. 
Typing google.com in the browser address bar will take you to the Google search engine website.
• Typing google.com in the address bar sends a request to the DNS server to resolve the domain name to an IP address.

• The browser then sends a request to the IP address associated with google.com.

• The server hosting Google's website responds with the necessary files to display the webpage.

• The browser renders the webpage and displ...read more
Answered by AI
Add your answer

Scenario-based questions, Previous Projects

Q1. Why should we hire you
Add your answer
Q2. Why did you choose Dell
Add your answer
Q3. Why different would you bring to the table
Add your answer

Skil set for My relevant job update

Communication discussion

Q1. About My profile and knowledge
Add your answer
Q2. About My attitude and experience
Add your answer

Q1. Excel formula and macro MS word and PowerPoint dashboard advanced Excel and power bi
Add your answer

Q1. Based on case study
Add your answer
Q2. Sql queries and other works
Add your answer