Bharti Airtel Data Analyst Interview Questions, Process, and Tips for Experienced

In my previous role, I was responsible for analyzing data, creating reports, and providing insights to support decision-making.

• Performed data cleaning, transformation, and analysis using tools like Excel, SQL, and Python.

• Generated reports and dashboards to visualize data trends and patterns.

• Collaborated with cross-functional teams to identify key metrics and KPIs for business performance.

• Presented findings and recommen...read more

I was responsible for data cleaning, transformation, and visualization to create interactive dashboards for stakeholders.

• Performed data cleaning and transformation to ensure accuracy and consistency of data

• Utilized tools like SQL, Python, and Tableau to manipulate and visualize data

• Collaborated with stakeholders to understand their requirements and design interactive dashboards

• Generated insights from data analysis to d

I optimize and manage large datasets by using tools like SQL, Python, and Excel. I utilize various data sources such as databases, APIs, and web scraping.

• Utilize SQL queries to efficiently extract and manipulate data from databases

• Use Python for data cleaning, analysis, and visualization tasks

• Leverage Excel for organizing and summarizing data in a user-friendly format

• Obtain data from sources like internal databases, ex

There are approximately 500-600 traffic signals in Noida.

• Estimate based on the size and population of Noida

• Consider the number of major intersections and roads in the city

• Take into account the traffic density and need for traffic management

• Consult local traffic authorities for more accurate data

Joins are used to combine rows from two or more tables based on a related column between them.

• Inner Join: Returns rows when there is a match in both tables.

• Left Join: Returns all rows from the left table and the matched rows from the right table.

• Right Join: Returns all rows from the right table and the matched rows from the left table.

• Full Outer Join: Returns rows when there is a match in one of the tables.

• Cross Join:

Writing SQL queries in Python allows for seamless integration of data analysis and manipulation.

• Use libraries like pandas or sqlalchemy to execute SQL queries in Python

• Remember to establish a connection to the database before executing queries

• Utilize Python's flexibility to manipulate and analyze data retrieved from SQL queries