Filter interviews by
Clear (1)
Skil set for My relevant job update
Communication discussion
I applied via Recruitment Consulltant and was interviewed in Jun 2024. There were 2 interview rounds.
Developed a predictive analytics model to forecast customer churn for a telecom company
Used Python and SQL to clean and analyze customer data
Implemented machine learning algorithms such as logistic regression and random forest
Evaluated model performance using metrics like accuracy, precision, and recall
I have experience in time series forecasting using statistical models and machine learning algorithms.
Utilized ARIMA model to forecast sales data for a retail company
Implemented Prophet algorithm to predict stock prices for a financial institution
Used LSTM neural network for demand forecasting in supply chain management
Excel assessment- was made to make a report from multiple sheets
I applied via LinkedIn and was interviewed before Apr 2022. There were 2 interview rounds.
The diagonals AC and BD of a cyclic quadrilateral ABCD intersect each other at the point P. Then, it is always true that
Samsung interview questions for designations
I rate myself 8/10 in Advanced Excel and 9/10 in SQL.
Advanced Excel: proficient in pivot tables, VLOOKUP, macros, and data visualization
SQL: skilled in writing complex queries, joins, subqueries, and stored procedures
Experience in using Excel and SQL together to analyze large datasets
To work with dynamic data, remove duplicates and fix errors, use data cleaning techniques.
Use software tools like OpenRefine or Excel to clean data
Identify and remove duplicate data using unique identifiers
Fix errors by standardizing data formats and using regular expressions
Use data validation to ensure accuracy and completeness
Create a data cleaning plan and document all changes made
Test the cleaned data to ensure it
Formula is a mathematical expression while function is a pre-built formula that performs a specific task.
Formula is a combination of mathematical operators and values used to calculate a result.
Function is a pre-built formula that performs a specific task, such as finding the average of a range of numbers.
Formulas can be customized and modified, while functions are fixed and cannot be changed.
Examples of functions incl
Top trending discussions
SQL rank order function explanation
Rank order function in SQL assigns a rank to each row based on a specified column
It can be used to determine the top or bottom N records in a dataset
Example: SELECT column1, column2, RANK() OVER (ORDER BY column3 DESC) AS rank_order FROM table_name
Merging two tables involves combining data from both tables based on a common key.
Identify a common key between the two tables
Use SQL JOIN statements to merge the tables
Choose the appropriate type of join (e.g. inner join, outer join)
Consider the size of the tables and the performance implications of the merge
Join in SQL is used to combine rows from two or more tables based on a related column between them.
Join is used to retrieve data from multiple tables based on a related column
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
Primary key is a unique identifier for each record in a database table.
Primary key ensures each record in a table is uniquely identified
It must contain unique values and cannot have NULL values
Primary key can be a single column or a combination of columns
Example: 'ID' column in a 'Users' table can be a primary key
1 hour baisc on general aptitude
I applied via Naukri.com and was interviewed in Oct 2024. There were 2 interview rounds.
It was simple but lengthy
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
based on 4 interviews
Interview experience
based on 9 reviews
Rating in categories
Sales Executive
1.1k
salaries
| ₹0 L/yr - ₹0 L/yr |
Assistant Manager
959
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Engineer
871
salaries
| ₹0 L/yr - ₹0 L/yr |
Manager
526
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Engineer
481
salaries
| ₹0 L/yr - ₹0 L/yr |
Apple
LG Electronics
Sony
Xiaomi