i
Innovaccer
Filter interviews by
Clear (1)
Use the DISTINCT keyword in a SELECT query to remove duplicates from a dataset.
Use the SELECT DISTINCT statement to retrieve unique rows from a table
Example: SELECT DISTINCT column1, column2 FROM table_name;
Another way is to use the GROUP BY clause with aggregate functions like COUNT() or SUM() to remove duplicates
Use a subquery to find the third highest salary in a table using SQL.
Use the ORDER BY clause to sort the salaries in descending order.
Use the LIMIT clause to limit the results to the third row.
Use a subquery to select the third highest salary from the sorted list.
Different roles in Power BI include Power BI Developer, Power BI Analyst, Power BI Administrator, and Power BI User.
Power BI Developer - responsible for creating and maintaining Power BI reports and dashboards
Power BI Analyst - analyzes data using Power BI to provide insights and recommendations
Power BI Administrator - manages security, access, and data sources in Power BI
Power BI User - consumes reports and dashboards
I applied via Instahyre and was interviewed before Sep 2023. There was 1 interview round.
Top trending discussions
I applied via Referral
I applied via LinkedIn and was interviewed before Nov 2020. There was 1 interview round.
I applied via Company Website and was interviewed in Apr 2022. There were 2 interview rounds.
Puzzles
Case Study
I applied via LinkedIn and was interviewed in Apr 2020. There were 4 interview rounds.
Reducing delivery time can be achieved by optimizing the supply chain, improving communication, and automating processes.
Analyze the supply chain and identify bottlenecks
Implement automation tools to streamline processes
Improve communication between departments and with customers
Use data analytics to forecast demand and plan accordingly
Consider outsourcing or partnering with third-party logistics providers
Invest in tec...
I applied via Naukri.com and was interviewed in Apr 2021. There were 3 interview rounds.
Estimating sales of umbrellas in Bangalore without any inputs.
Analyze historical sales data of umbrellas in Bangalore
Consider weather patterns and forecast for the year
Evaluate competition and market trends
Assess population density and demographics
Factor in events and festivals that may affect sales
Use statistical models and regression analysis
Consider potential impact of COVID-19 on sales
I applied via IIM Jobs and was interviewed before Mar 2023. There were 3 interview rounds.
SQL + Python based questions
A data set was given and the questions were asked around strategies to handle cancellations.
based on 4 interviews
Interview experience
based on 16 reviews
Rating in categories
Data Analyst
307
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Data Analyst
171
salaries
| ₹0 L/yr - ₹0 L/yr |
Associate Software Engineer
96
salaries
| ₹0 L/yr - ₹0 L/yr |
Data Engineer
68
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Development Engineer II
61
salaries
| ₹0 L/yr - ₹0 L/yr |
Practo
Lybrate
Portea Medical
PharmEasy