Filter interviews by
I am a data analyst with a strong background in statistics and data visualization.
Graduated with a degree in Statistics
Proficient in programming languages like Python and R
Experience in analyzing large datasets and creating data visualizations
Strong problem-solving skills
Top trending discussions
posted on 16 Apr 2024
I applied via Campus Placement
Basic 10 apti question
Basic 5 python question
Basic 5 SQL question
I applied via Naukri.com and was interviewed in Jan 2024. There was 1 interview round.
SQL is a programming language used for managing and manipulating relational databases. Different joins in SQL include inner join, outer join, left join, and right join.
SQL is a standard programming language for managing and manipulating relational databases.
Different types of joins in SQL include inner join, outer join, left join, and right join.
Inner join returns rows when there is at least one match in both tables.
Ou...
Use Python to separate portion before and after @ in an email address.
Use the split() method to separate the email address into two parts based on the @ symbol.
Access the parts using index 0 for the portion before @ and index 1 for the portion after @.
Example: email = 'example@email.com'; parts = email.split('@'); before = parts[0]; after = parts[1];
Rank, Dense Rank, and Row Number are functions used in SQL to assign a ranking to rows in a result set.
Rank function assigns a unique rank to each row based on the specified column values.
Dense Rank function assigns a unique rank to each row without any gaps.
Row Number function assigns a sequential integer to each row in the result set.
I applied via Naukri.com and was interviewed before Oct 2022. There were 2 interview rounds.
posted on 5 Sep 2023
I applied via Walk-in and was interviewed in Aug 2023. There were 2 interview rounds.
I applied via Recruitment Consulltant and was interviewed in Jul 2021. There were 2 interview rounds.
Feature engineering is the process of selecting and transforming relevant features from raw data to improve model performance.
Identify relevant features based on domain knowledge and data exploration
Transform features to improve their quality and relevance
Create new features by combining or extracting information from existing features
Select the most important features using feature selection techniques
Iterate the proc
I have used logistic regression and decision tree models for classification.
Logistic regression is a linear model used for binary classification.
Decision tree is a non-linear model used for multi-class classification.
Logistic regression is simple and easy to interpret while decision tree can handle non-linear relationships.
I chose these models based on the nature of the data and the problem at hand.
Tableau Dashboard actions allow users to interact with the data and visualizations by clicking on specific elements.
Dashboard actions can be used to filter data, highlight specific data points, or navigate to other dashboards.
There are four types of actions in Tableau: filter, highlight, URL, and parameter.
For example, a user can click on a bar chart to filter the data in a related table or click on a map to highlight ...
I applied via Recruitment Consultant and was interviewed before Mar 2020. There were 4 interview rounds.
posted on 16 Apr 2024
I applied via Campus Placement
Basic 10 apti question
Basic 5 python question
Basic 5 SQL question
I applied via Naukri.com and was interviewed in Sep 2024. There were 3 interview rounds.
5 sql coding questions from hacker rank. Basic sql questions, if you are experienced you will solve them in 15 to 20 min
Use SQL string functions like SUBSTRING and CHARINDEX to separate name from emails.
Use CHARINDEX to find the position of the '@' symbol in the email address.
Use SUBSTRING to extract the characters before the '@' symbol as the name.
Consider handling cases where there are multiple names or special characters in the email address.
Calculate the number of matches won and lost by each team based on the given data in the matches table.
Group the data by team and count the number of matches won and lost for each team.
Use the winner column to determine the outcome of each match.
Create a query to calculate the number of matches won and lost for each team.
Example: Team A won 2 matches and lost 1 match.
Example: Team B won 1 match and lost 2 matches.
The resultant rows for all joins between table a and table b with given values.
Inner join: 1
Left join: 1, 1, 0, 0, null
Right join: 1, 0, null, null
Full outer join: 1, 1, 0, 0, null, null
I have worked on various projects involving data analysis, visualization, and predictive modeling.
Developed predictive models to forecast sales trends and customer behavior
Created interactive dashboards using Tableau for data visualization
Performed data cleaning and preprocessing to ensure accuracy and consistency
Utilized machine learning algorithms such as regression and clustering for analysis
Collaborated with cross-...
Use SUBSTRING_INDEX function in SQL to separate first name, middle name, and last name from full name.
Use SUBSTRING_INDEX function to extract first name by specifying space as delimiter
Use SUBSTRING_INDEX function to extract last name by specifying space as delimiter and -1 as position
Use combination of SUBSTRING_INDEX and REPLACE functions to extract middle name if present
based on 1 interview
Interview experience
based on 1 review
Rating in categories
Marketing Executive
216
salaries
| ₹1.2 L/yr - ₹3.6 L/yr |
Senior Executive
199
salaries
| ₹2 L/yr - ₹4.8 L/yr |
Branch Manager
171
salaries
| ₹3.2 L/yr - ₹8.5 L/yr |
Executive Accountant
162
salaries
| ₹1.4 L/yr - ₹3.8 L/yr |
Assistant Manager
158
salaries
| ₹2.2 L/yr - ₹7 L/yr |
ICICI Lombard General Insurance Company
Bajaj Allianz General Insurance
HDFC Ergo General Insurance
Reliance General Insurance