MGB Data Analyst Interview Questions and Answers

Basic English, Quants and Statistics

Easy, relevant to pandemic

Q1. Python, Tableau, SQL, Stats, ML, all questions easy to medium level
Add your answer

Q1. Behavioural Questions
Add your answer
Q2. Statistics Case Study
Add your answer

Q1. What is the number of tourist per day in jaipur
Ans. 
The number of tourists per day in Jaipur varies depending on the season and events happening in the city.
• Tourist numbers fluctuate based on time of year (peak season vs off-peak season)

• Events like festivals or cultural events can attract more tourists

• Historical sites like Amer Fort and Hawa Mahal are popular attractions

• Tourist numbers can be estimated based on hotel occupancy rates and ticket sales for attractions
Answered by AI
Add your answer

Q1. Almost everything on Power BI
Add your answer

Q1. Behavioral skills
Add your answer

Regarding problem-solving

Regarding sql question

General Quant, DA questions like ratio, numbers etc

Q1. What is the difference between extend and append in Python?
Ans. 
Extend adds elements of an iterable to a list, while append adds a single element to the end of a list.
• Extend can add multiple elements from an iterable (list, tuple, string) to the end of a list.

• Append adds a single element to the end of a list.

• Extend modifies the original list, while append does not.

• Example: list1 = [1, 2, 3], list2 = [4, 5], list1.extend(list2) will result in list1 = [1, 2, 3, 4, 5], list1.append(6)
Answered by AI
Add your answer
Q2. How can you join 2 dataframes one after the other in Python?
Ans. 
You can join 2 dataframes one after the other in Python using the concat() function from the pandas library.
• Use pd.concat() function from the pandas library to join two dataframes one after the other.

• Specify the dataframes to be concatenated as arguments to the concat() function.

• Make sure the columns of both dataframes match or use the ignore_index parameter to reset the index after concatenation.
Answered by AI
Add your answer

Business problems were asked and analyzed the approach to solve the problem. Reading case studies would help you here

Q1. Few Statistics questions were asked. Some coding. And all about our resume in depth. Prepare your resume and Stats well.
Add your answer