Add office photos
Filter interviews by
DaMENSCH Analyst Interview Questions, Process, and Tips
DaMENSCH Analyst Interview Experiences
1 interview found
Anonymous
Selected
I applied via Approached by Company and was interviewed in Aug 2022. There were 3 interview rounds.
(8 Questions)
- Q1. Basic Introduction and previous work experience
- Q2. What is SQL and which memory management it use?
- Ans.
SQL is a programming language used for managing relational databases. It uses dynamic memory management.
SQL stands for Structured Query Language
It is used for managing and manipulating data in relational databases
SQL uses dynamic memory management, which means that memory is allocated and deallocated as needed
Examples of SQL-based relational database management systems include MySQL, Oracle, and Microsoft SQL Server
- Q3. What is RDBMS and why we use SQL?
- Ans.
RDBMS is a relational database management system that organizes data into tables. SQL is used to query and manipulate data in RDBMS.
RDBMS stands for Relational Database Management System
It organizes data into tables with rows and columns
SQL (Structured Query Language) is used to interact with RDBMS
SQL allows querying, inserting, updating, and deleting data
RDBMS and SQL provide a structured and efficient way to store an
- Q4. How to you check which query is good?
- Ans.
To check which query is good, consider factors like execution time, resource usage, and accuracy of results.
Check the execution time of the query and compare it with other queries.
Analyze the resource usage of the query, such as CPU and memory usage.
Check the accuracy of the results and compare them with the expected output.
Consider the complexity of the query and its impact on the database.
Take into account the scalab...
- Q5. What is the use of aggregation functions?
- Ans.
Aggregation functions are used to perform calculations on a set of values and return a single value as output.
Aggregation functions are commonly used in databases and data analysis to summarize and analyze large amounts of data.
Examples of aggregation functions include SUM, AVG, MAX, MIN, COUNT, and GROUP BY.
These functions can be used to calculate totals, averages, maximum and minimum values, and counts of specific da...
- Q6. When can we use group by? Can we use group by without where clause?
- Ans.
Group by is used to group data based on a common attribute. It can be used without a where clause.
Group by is used to group data based on a common attribute
It is used with aggregate functions like sum, count, avg, etc.
It can be used without a where clause to group all the data in the table
Group by is often used with having clause to filter the groups based on some condition
- Q7. What is normalisation?
- Ans.
Normalisation is the process of organizing data in a database to reduce redundancy and dependency.
It involves breaking down a table into smaller tables and defining relationships between them.
The goal is to eliminate data redundancy and ensure data consistency.
Normalization is achieved through a series of normal forms, with each level building on the previous one.
For example, a customer's address should not be repeated...
- Q8. What major libraries used in python?
- Ans.
Python has several major libraries including NumPy, Pandas, Matplotlib, and Scikit-learn.
NumPy is used for numerical computing and data analysis.
Pandas is used for data manipulation and analysis.
Matplotlib is used for data visualization.
Scikit-learn is used for machine learning and data mining.
(1 Question)
- Q1. Round 2 interview Interview duration was 1 hour. The interviewer asked me to write some ecommerce SQL queries given condition. (1 hour) 1) Find the pair of products that sells together in the cart. 2) To...
Interview Preparation Tips
2. For this role, you should be good enough in SQL, MongoDB basics, Google Analytics, Big query and python scripting.
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Selected
I applied via Approached by Company and was interviewed in Mar 2024. There was 1 interview round.
(1 Question)
- Q1. About cashkaro working operations, and affiliate marketing advance excel ,basic sql
Ujjyant Chaudhary
Selected
I applied via Referral and was interviewed before Mar 2022. There were 3 interview rounds.
(1 Question)
- Q1. Trigonometric questions Fehling A and B was asked
(1 Question)
- Q1. Chemical analysis Lab procedures
- Ans.
Chemical analysis involves various lab procedures to identify and quantify chemical components in a sample.
Chemical analysis can involve techniques such as chromatography, spectroscopy, and mass spectrometry.
Lab procedures may include sample preparation, calibration of instruments, and data analysis.
Chemical analysis is used in various fields such as pharmaceuticals, environmental monitoring, and forensic science.
Interview Preparation Tips
- Nothing
Selected
I applied via Naukri.com and was interviewed in Nov 2024. There were 2 interview rounds.
SQL -- LeetCode style questions Medium lvl
(2 Questions)
- Q1. Past experiences
- Q2. How one can help with eshopbox
- Ans.
One can help with eshopbox by analyzing data to improve customer experience and optimize sales.
Conduct data analysis to identify trends and patterns in customer behavior
Use data to personalize marketing strategies and recommend products to customers
Optimize website layout and user experience based on data insights
Implement data-driven pricing strategies to maximize sales and profits
(3 Questions)
- Q1. I will explain about interview
- Q2. Please give interview
- Q3. No response, disconnected
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Nov 2024. There were 2 interview rounds.
SQL, excel, tableau , looker studio
(1 Question)
- Q1. What is your notice period.
I applied via campus placement at SRM Institute of Science & Technology, Chennai and was interviewed in Apr 2024. There was 1 interview round.
(2 Questions)
- Q1. Difference between logistic regression and svm
- Ans.
Logistic regression is a linear model used for binary classification, while SVM is a non-linear model that can handle complex decision boundaries.
Logistic regression is a probabilistic model that predicts the probability of a binary outcome based on input features.
SVM aims to find the hyperplane that best separates the classes in a high-dimensional space.
Logistic regression is more interpretable and easier to implement...
- Q2. Data augmentation related questions
Interview Preparation Tips
- Machine Learning
Skills evaluated in this interview
Selected
I applied via Referral and was interviewed in Mar 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Medium level SQL question
- Q2. Case study on Bigbasket/Instagram
Selected
I applied via Referral and was interviewed in Feb 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Difference between Drop and Truncate ?
- Ans.
Drop deletes the table structure and data, while truncate only deletes the data.
Drop is a DDL (Data Definition Language) command, while truncate is a DML (Data Manipulation Language) command.
Drop removes the table from the database, while truncate only removes the rows from the table.
Drop is slower and requires more permissions than truncate.
Example: DROP TABLE table_name; TRUNCATE TABLE table_name;
- Q2. To write SQL queries
(2 Questions)
- Q1. Why you are switching to non-core?
- Ans.
I am switching to non-core because I want to explore new opportunities and challenges outside of my current field.
Seeking new challenges and opportunities
Exploring different industries and roles
Developing new skills and gaining diverse experience
- Q2. What are your expected salary?
- Ans.
I am looking for a competitive salary that reflects my skills and experience in the data analysis field.
Research the average salary for Data Analysts in your area to have a realistic expectation
Consider your level of experience, education, and any specialized skills you bring to the table
Be prepared to negotiate based on the company's budget and benefits package
Skills evaluated in this interview
I applied via Campus Placement
(2 Questions)
- Q1. They asked based on your resume few excel questions also
- Q2. They explained about their company
(1 Question)
- Q1. About company little bit about project
Interview Preparation Tips
DaMENSCH Interview FAQs
Tell us how to improve this page.
DaMENSCH Interviews By Designations
- DaMENSCH Analyst Interview Questions
- DaMENSCH Business Analyst Interview Questions
- DaMENSCH Customer Service Executive Interview Questions
- DaMENSCH Customer Support Executive Interview Questions
- DaMENSCH Product Development Executive Interview Questions
- DaMENSCH Senior Customer Support Executive Interview Questions
Interview Questions for Popular Designations
Analyst Interview Questions from Similar Companies
DaMENSCH Analyst Reviews and Ratings
based on 1 review
Rating in categories
|
Store Manager
11
salaries
|  ₹3.3 L/yr - ₹4.7 L/yr |
|
Product Manager
9
salaries
| ₹17 L/yr - ₹24 L/yr |
|
Business Analyst
8
salaries
| ₹8 L/yr - ₹13.2 L/yr |
|
Data Entry Operator
7
salaries
| ₹2.5 L/yr - ₹3.2 L/yr |
|
Sales Executive
7
salaries
| ₹4.1 L/yr - ₹7.8 L/yr |
Myntra
Flipkart
Amazon
Snapdeal
Calculate your in-hand salary
- Home >
- Interviews >
- DaMENSCH Interview Questions >
- DaMENSCH Analyst Interview Questions
