Xiaomi Data Analyst Interview Questions and Answers

Q1. Tell me about the project you have worked recently
Ans. 
Developed a predictive analytics model to forecast customer churn for a telecom company
• Used Python and SQL to clean and analyze customer data

• Implemented machine learning algorithms such as logistic regression and random forest

• Evaluated model performance using metrics like accuracy, precision, and recall
Answered by AI
Add your answer
Q2. What kind of forecasting have you done
Ans. 
I have experience in time series forecasting using statistical models and machine learning algorithms.
• Utilized ARIMA model to forecast sales data for a retail company

• Implemented Prophet algorithm to predict stock prices for a financial institution

• Used LSTM neural network for demand forecasting in supply chain management
Answered by AI
Add your answer

Excel assessment- was made to make a report from multiple sheets

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. Tell me about yourself
Add your answer

Q1. About yourself n work profile
Add your answer

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

The diagonals AC and BD of a cyclic quadrilateral ABCD intersect each other at the point P. Then, it is always true that

Q1. Nding Now DSA Data Structures Algorithms Interview Preparation Data Science Topic-wise Practice C C++ Java JavaScript Python Competitive Programming Machine Learning Aptitude Write & Earn Web Development P...read more
Add your answer
Q2. Everything you need to know about the job-search process itself.nding Now DSA Data Structures Algorithms Interview Preparation Data Science Topic-wise Practice C C++ Java JavaScript Python Competitive Prog...read more
Add your answer

Q1. Questions were based on DSA and C
Add your answer
Q2. It was basically a coding round with simple logic
Add your answer