Filter interviews by
I was interviewed before Aug 2023.
Union combines and removes duplicates, Union All combines without removing duplicates.
Union combines result sets and removes duplicates
Union All combines result sets without removing duplicates
Union is slower than Union All as it involves removing duplicates
Union All is faster than Union as it does not remove duplicates
Sets in Tableau are custom fields that define a subset of data based on certain conditions.
Sets can be used to group related data together for analysis
Sets can be created based on dimensions or measures
Sets can be used in calculations, filters, and visualizations
Examples: creating a set of top customers, creating a set of high-value products
Query to find 2nd highest salary in a database table
Use the ORDER BY clause to sort the salaries in descending order
Use the LIMIT clause to retrieve the second row
Given some pointers, how will I manage the stakeholders and plan.
I applied via Company Website and was interviewed in Oct 2024. There was 1 interview round.
Data Warehouse stores structured data for reporting and analysis, Data Lakes store raw and unstructured data, Tables are basic data structures.
Data Warehouse is used for storing structured data from various sources for reporting and analysis.
Data Lakes store raw and unstructured data in its native format for future processing and analysis.
Tables are basic data structures used to organize and store data in a structured ...
Group by is used to group rows that have the same values into summary rows, while Partition by is used to divide the result set into partitions to which the function is applied separately.
Group by is used with aggregate functions to group rows based on a column or set of columns.
Partition by is used with window functions to divide the result set into partitions.
Group by is used with SELECT statement, while Partition by...
I applied via LinkedIn and was interviewed in Jul 2024. There were 3 interview rounds.
Assignment on credit risk
I applied via LinkedIn and was interviewed in Apr 2024. There was 1 interview round.
Linear regression is used for predicting continuous values, while classification is used for predicting discrete values.
Linear regression is used when the output variable is continuous, such as predicting house prices based on features like size and location.
Classification is used when the output variable is categorical, such as predicting whether an email is spam or not based on its content.
Linear regression aims to f...
An outlier is a data point that differs significantly from other data points in a dataset.
Outliers can skew statistical analyses and machine learning models.
Examples of outliers include a person's weight being recorded as 1000 lbs, when the average weight is around 150 lbs.
Outliers can be detected using statistical methods like Z-score or IQR.
K-means algorithm is a clustering technique that partitions data into k clusters based on similarity.
Divides data points into k clusters based on centroids
Iteratively assigns data points to the nearest centroid and updates centroids
Continues until centroids no longer change significantly
Example: Grouping customers based on purchasing behavior
Classification metrics are used to evaluate the performance of a classification model.
Accuracy: measures the proportion of correctly classified instances out of total instances
Precision: measures the proportion of true positive predictions out of all positive predictions
Recall: measures the proportion of true positive predictions out of all actual positive instances
F1 Score: harmonic mean of precision and recall, balan...
I expect challenging projects, opportunities for growth, collaborative team environment, and work-life balance.
Challenging projects that allow me to apply my data science skills and learn new techniques
Opportunities for growth and advancement within the company
Collaborative team environment where I can share ideas and work together towards common goals
Work-life balance to ensure I can perform at my best both profession
Topic was joining and calculating
posted on 31 Jul 2024
Power BI case study to see the expertise in Power BI
AI is the broader concept of machines being able to carry out tasks in a way that we would consider smart. Machine learning is a subset of AI that allows machines to learn from data. Deep learning is a subset of machine learning that uses neural networks with many layers to model and solve complex problems.
AI is the broader concept of machines being able to carry out tasks in a way that we would consider smart.
Machine ...
posted on 7 Oct 2023
Basic DP, Array Questions
based on 1 review
Rating in categories
Associate
343
salaries
| ₹1.5 L/yr - ₹7 L/yr |
Associate Engineer
268
salaries
| ₹2.8 L/yr - ₹6.9 L/yr |
Financial Analyst
259
salaries
| ₹7.4 L/yr - ₹23 L/yr |
Project Manager
230
salaries
| ₹6 L/yr - ₹25 L/yr |
Network Engineer
220
salaries
| ₹2.8 L/yr - ₹8.7 L/yr |
Vodafone Idea
Bharti Airtel
Jio
Tata Communications