Bharti Airtel Senior Data Analyst Interview Questions and Answers

Q1. Difference between Data Warehouse, Data Lakes and Tables
Ans. 
Data Warehouse stores structured data for reporting and analysis, Data Lakes store raw and unstructured data, Tables are basic data structures.
• Data Warehouse is used for storing structured data from various sources for reporting and analysis.

• Data Lakes store raw and unstructured data in its native format for future processing and analysis.

• Tables are basic data structures used to organize and store data in a structured ...read more
Answered by AI
Add your answer
Q2. Query difference betweeen Group by and Partition by
Ans. 
Group by is used to group rows that have the same values into summary rows, while Partition by is used to divide the result set into partitions to which the function is applied separately.
• Group by is used with aggregate functions to group rows based on a column or set of columns.

• Partition by is used with window functions to divide the result set into partitions.

• Group by is used with SELECT statement, while Partition by...read more
Answered by AI
Add your answer
Q3. Machine Learning questions such as Regression, Trees etc
Add your answer

Q1. Explain difference between joins
Add your answer
Q2. What is your area of intrest
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

Q1. Can you automate dashobaord on excel on daily routine, Do you know proper formulation of dashboard.
Add your answer
Q2. How many years experience do you have in sql. Please provide solution for some sql technical questions. Or can you properly provide adhoc requirement by urgently analysing on compony database. There was s...read more
Add your answer

Q1. Basic ML questions were asked.
Add your answer

Q1. All technical questions related to profile
Add your answer

Q1. Data science questions
Add your answer

Q1. Current role and experience related
Add your answer

Q1. Technical questions
Add your answer
Q2. Data science questions by onshore team
Add your answer

Q1. Salary joining date
Add your answer
Q2. Expected salary joining date
Add your answer

There was a question which say, write the string in the reverse order.

Q1. What are your strengths and weakness.
Ans. 
My strengths include strong analytical skills and attention to detail. My weakness is that I can be overly critical of my own work.
• Strength: Strong analytical skills

• Strength: Attention to detail

• Weakness: Overly critical of my own work
Answered by AI
Add your answer
Q2. Tell me about yourself
Ans. 
I am a data analyst with experience in analyzing and interpreting complex data sets to drive business insights.
• Proficient in SQL, Python, and Excel for data analysis

• Skilled in data visualization using Tableau and Power BI

• Experience in conducting statistical analysis and creating predictive models

• Strong problem-solving and critical thinking skills

• Effective communication and presentation skills

• Ability to work collaborati
Answered by AI
Add your answer

Q1. Basic SQL, Basic questions around discriptive stats and ML concepts. Questions around previous projects
Add your answer

Q1. Basic Stats and ML questions, questions around linear models, outliers handling. End to end model pipeline for scinario.
Add your answer

Simple EDA and model building on toy data.

Q1. Managers access story telling and articulation skills.
Add your answer