i
Innovaccer
Filter interviews by
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 Naukri.com and was interviewed in Dec 2024. There were 2 interview rounds.
I applied via Approached by Company and was interviewed in Nov 2024. There were 3 interview rounds.
posted on 12 Dec 2024
Questions related to Python and SQL, as well as a few multiple-choice questions in data science.
posted on 26 Jan 2025
I was interviewed before Jan 2024.
I applied via Referral and was interviewed in Nov 2024. There were 2 interview rounds.
It contain both Aptitude and Coding about base models and Deep learning too
Different models techniques include linear regression, decision trees, random forests, support vector machines, and neural networks.
Linear regression is used for predicting continuous values.
Decision trees are used for classification and regression tasks.
Random forests are an ensemble method based on decision trees.
Support vector machines are used for classification tasks.
Neural networks are used for complex pattern re
Different performance metrics are used for different types of machine learning models to evaluate their effectiveness.
For classification models, metrics like accuracy, precision, recall, F1 score, and ROC-AUC are commonly used.
For regression models, metrics like mean squared error (MSE), mean absolute error (MAE), and R-squared are commonly used.
For clustering models, metrics like silhouette score and Davies-Bouldin in...
Highly interactive and technical
1 hr test with focus on math and analytical thinking
I applied via Naukri.com and was interviewed in Jan 2024. There was 1 interview round.
Interview experience
based on 13 reviews
Rating in categories
Data Analyst
283
salaries
| ₹5 L/yr - ₹17 L/yr |
Senior Data Analyst
165
salaries
| ₹7.9 L/yr - ₹25 L/yr |
Associate Software Engineer
96
salaries
| ₹6 L/yr - ₹10 L/yr |
Data Engineer
69
salaries
| ₹4.6 L/yr - ₹16 L/yr |
Software Development Engineer II
64
salaries
| ₹16 L/yr - ₹33 L/yr |
Practo
Lybrate
Portea Medical
PharmEasy