Filter interviews by
I applied via Referral and was interviewed before Jan 2024. There was 1 interview round.
Yes, I can automate dashboards on Excel for daily routines and I am familiar with proper formulation of dashboards.
I can use Excel functions like VLOOKUP, SUMIF, and PivotTables to create dynamic dashboards
I can set up macros and scripts to automate data import and visualization
I can design visually appealing charts and graphs to present data effectively
I can schedule automatic updates and refreshes for the dashboard o
Top trending discussions
I applied via Walk-in and was interviewed in Jun 2021. There was 1 interview round.
Vlookup is a function in Excel used to search for a value in a table and return a corresponding value from another column.
Vlookup stands for vertical lookup.
It is commonly used to find and retrieve data from large datasets.
The function requires a lookup value, a table range, and the column index number.
Vlookup can be used to perform approximate or exact matches.
It is often used for data analysis, data validation, and d...
A pivot table is a data summarization tool used in spreadsheet programs like Excel.
It allows users to quickly summarize and analyze large amounts of data.
Users can easily group data by different categories and perform calculations on them.
Pivot tables are useful for creating reports and visualizations.
They can help identify trends and patterns in data.
Example: A pivot table can be used to summarize sales data by produc
There are two types of Vlookup: Exact Match and Approximate Match.
Exact Match Vlookup searches for an exact match of the lookup value in the first column of the table array.
Approximate Match Vlookup searches for an approximate match of the lookup value in the first column of the table array.
Exact Match Vlookup is denoted by 0 or FALSE in the formula, while Approximate Match Vlookup is denoted by 1 or TRUE in the formul
Filters can be applied to rows in a table to display specific data.
Select the row(s) you want to filter
Click on the filter icon in the toolbar
Choose the filter criteria and apply
The table will display only the rows that meet the filter criteria
I applied via Walk-in and was interviewed in Feb 2023. There were 2 interview rounds.
I want to work with you because of your reputation in the industry and the exciting opportunities for growth and learning.
I am impressed by your company's reputation in the industry and the positive feedback I have heard from current and former employees.
Your organization offers a dynamic and challenging work environment, which aligns with my career goals and aspirations.
I am excited about the opportunity to work with ...
I applied via AmbitionBox and was interviewed in Nov 2022. There were 2 interview rounds.
I was interviewed in Jan 2025.
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...
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
I applied via Campus Placement and was interviewed before Oct 2023. There were 2 interview rounds.
Easy Aptitude and SQL questions
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
I applied via Approached by Company and was interviewed before May 2023. There was 1 interview round.
SQL query to find the top 5 employee having the max salary
I applied via Naukri.com and was interviewed in Nov 2024. There was 1 interview round.
based on 1 interview
Interview experience
based on 1 review
Rating in categories
Team Lead
52
salaries
| ₹0 L/yr - ₹0 L/yr |
Business Manager
32
salaries
| ₹0 L/yr - ₹0 L/yr |
Territory Sales Manager
26
salaries
| ₹0 L/yr - ₹0 L/yr |
Assistant Manager
25
salaries
| ₹0 L/yr - ₹0 L/yr |
Sales Executive
16
salaries
| ₹0 L/yr - ₹0 L/yr |
Tata Play
DISH TV
SUNDIRECT
Videocon d2h