Add office photos
Filter interviews by
Saras Analytics Interview Questions, Process, and Tips
Top Saras Analytics Interview Questions and Answers
- Q1. Difference between Having and where clause?asked in Data Analyst interview
- Q2. SQL: What is the difference between HAVING and WHERE? Can WHERE be replaced with HAVING?asked in Senior Business Analyst interview
- Q3. Assumptions of linear regressionasked in Data Scientist interview
Saras Analytics Interview Experiences
12 interviews found
Anonymous
(4 Questions)
- Q1. SQL: What is the difference between UNION and UNION ALL?
- Ans.
UNION combines and removes duplicates, UNION ALL combines without removing duplicates
UNION merges the result sets of two or more SELECT statements and removes duplicates
UNION ALL merges the result sets of two or more SELECT statements without removing duplicates
UNION is slower than UNION ALL as it involves removing duplicates
Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;
Example: SELECT column1 FR
- Q2. SQL: What is the difference between HAVING and WHERE? Can WHERE be replaced with HAVING?
- Ans.
HAVING is used with GROUP BY to filter grouped rows, WHERE is used to filter individual rows. WHERE cannot be replaced with HAVING.
WHERE is used to filter individual rows before grouping, HAVING is used to filter grouped rows after grouping
HAVING is used in conjunction with GROUP BY clause, WHERE is used independently
WHERE filters rows based on conditions, HAVING filters groups based on conditions
Example: SELECT depart...
- Q3. Aptitude: There are 2 jugs: one measures 7L and another measures 11L. How do you measure 15L?
- Q4. Guesstimate: How many ballons can fill in an aeroplane?
- Ans.
The number of balloons that can fill an airplane depends on the size of the airplane and the size of the balloons.
The size of the airplane (e.g. small private plane vs. commercial airliner) will greatly impact the number of balloons that can fit.
The size of the balloons (e.g. standard party balloons vs. large weather balloons) will also affect the total number that can be accommodated.
Consider the available space insid...
Interview Preparation Tips
Skills evaluated in this interview
Senior Business Analyst Interview Questions asked at other Companies
Selected
I applied via LinkedIn and was interviewed in Dec 2023. There were 2 interview rounds.
(1 Question)
- Q1. 1. Puzzle 2. Self join question
(1 Question)
- Q1. Where and having clause difference
- Ans.
The difference between WHERE and HAVING clauses in SQL.
WHERE clause is used to filter rows based on a condition before the data is grouped or aggregated.
HAVING clause is used to filter groups based on a condition after the data is grouped or aggregated.
WHERE clause is used with SELECT, UPDATE, DELETE statements, while HAVING clause is used with SELECT statements that include GROUP BY clause.
WHERE clause filters individ...
Skills evaluated in this interview
Data Analyst Interview Questions asked at other Companies
I applied via LinkedIn and was interviewed in Jan 2024. There was 1 interview round.
The position is for SBA but they expect you to be as good as developer in coding. They want someone as good as developer but they don't call him/her as developer and give the designation as BA which I did not like. No questions regarding BA or PM or any Agile or waterfall methodologies 3 rounds every thing about coding (SQL, Python, ) and tools like Alteryx, AWS glue
Interview Preparation Tips
Senior Business Analyst Interview Questions asked at other Companies
Happen to meet changes
(2 Questions)
- Q1. Hike percentage?
- Q2. Like and dislike
Business Analyst Interview Questions asked at other Companies
Saras Analytics interview questions for popular designations
Selected
I applied via Referral and was interviewed before Oct 2023. There were 2 interview rounds.
Decision tree criteria
(2 Questions)
- Q1. Decision Tree Criteria
- Q2. Assumptions of linear regression
- Ans.
Assumptions of linear regression include linearity, independence, homoscedasticity, and normality.
Linearity: The relationship between the independent and dependent variables is linear.
Independence: The residuals are independent of each other.
Homoscedasticity: The variance of the residuals is constant across all levels of the independent variables.
Normality: The residuals are normally distributed.
Skills evaluated in this interview
Data Scientist Interview Questions asked at other Companies
Selected
I was interviewed before Jul 2022.
Test is simple. Make sure You make atleast 70% correct answers
(1 Question)
- Q1. Based on Data structures
(1 Question)
- Q1. Somewhat DSA and system design
(1 Question)
- Q1. About how you deal with work and pressure as a person.
Software Engineer Interview Questions asked at other Companies
Jobs at Saras Analytics
I applied via AngelList and was interviewed in Feb 2022. There were 3 interview rounds.
There were two parts ,One is theoretical and another one is practical.
In theoretical round questions on SQL and ETL tools (MCQs).
In practical round, mystery puzzle was given, in which we have to solve the puzzle using SQL ( Different tables were given and few conditions were given)
(5 Questions)
- Q1. Difference between Having and where clause?
- Ans.
HAVING clause is used with GROUP BY to filter the results based on aggregate functions, while WHERE clause is used to filter individual rows.
HAVING clause is used after GROUP BY clause.
HAVING clause is used to filter the results based on aggregate functions like SUM, COUNT, AVG, etc.
WHERE clause is used before GROUP BY clause.
WHERE clause is used to filter individual rows based on conditions.
HAVING clause cannot be use...
- Q2. Some questions on online e commerce business
- Q3. What is LOD in Tableau?
- Ans.
LOD stands for Level of Detail. It is a technique used in Tableau to perform complex calculations on aggregated data.
LOD expressions allow users to compute values at different levels of detail in a visualization
They can be used to create custom aggregations, filters, and calculations
There are three types of LOD expressions: FIXED, INCLUDE, and EXCLUDE
FIXED LOD expressions define a level of detail that is independent of...
- Q4. Difference between Rank and Dense rank function?
- Ans.
Rank function assigns unique rank to each distinct row, while Dense rank function assigns same rank to rows with same values.
Rank function is used to assign a unique rank to each distinct row based on the order specified in the ORDER BY clause.
Dense rank function is used to assign the same rank to rows with the same values, skipping the next rank if there are ties.
Rank function returns consecutive ranks, while dense ra...
- Q5. Some questions on Excel
2 questions on Aptitude test asked by Hiring manager and 1 SQL question
Interview Preparation Tips
- SQL
- Aptitude
- Basic Maths
- Power Bi
- Excel
- Good problem solving skills
Skills evaluated in this interview
Data Analyst Interview Questions asked at other Companies
I applied via Campus Placement and was interviewed before Apr 2023. There were 2 interview rounds.
(1 Question)
- Q1. OOPs, Linear vs Non Linear DS, DS definitions, JAVA, Puzzles.
(1 Question)
- Q1. Case study question regarding e-commerce. DSA question: Find pairs of given sum and triplets of given sum in an optimised way.
Interview Preparation Tips
Software Engineer Intern Interview Questions asked at other Companies
Vinayak Patil
Selected
I applied via AngelList and was interviewed before Feb 2023. There were 2 interview rounds.
SQL test comprises of Warehouse Theoretical question and one SQL Murder Mystery Practical question.
(1 Question)
- Q1. Difference between Group by Where clause. LOD in Tableau Questions Regarding Projects.
Interview Preparation Tips
- SQL
- Data Warehousing
- Power Bi
- Tableau
- Excel
- E commerce
Data Analyst Interview Questions asked at other Companies
I applied via Instahyre and was interviewed in Mar 2022. There were 3 interview rounds.
Good problem solving skills. Good knowledge of angular and JavaScript.
(1 Question)
- Q1. Coding question on problem solving .
(1 Question)
- Q1. Discussion about the work i do and past self -project i have done .
Interview Preparation Tips
Front end Developer Interview Questions asked at other Companies
Top trending discussions
Saras Analytics Interview FAQs
The duration of Saras Analytics interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
Saras Analytics Interviews By Designations
- Saras Analytics Data Analyst Interview Questions
- Saras Analytics Business Analyst Interview Questions
- Saras Analytics Senior Business Analyst Interview Questions
- Saras Analytics Analyst Interview Questions
- Saras Analytics Data Scientist Interview Questions
- Saras Analytics Front end Developer Interview Questions
- Saras Analytics Software Engineer Interview Questions
- Saras Analytics Software Engineer Intern Interview Questions
- Show more
Interview Questions for Popular Designations
Saras Analytics Interview Process
based on 9 interviews
Interview experience
Interview Questions from Similar Companies
Saras Analytics Reviews and Ratings
based on 33 reviews
Rating in categories
0-1 Yrs
Not Disclosed
5-7 Yrs
Not Disclosed
|
Business Analyst
47
salaries
|  ₹4.9 L/yr - ₹16.3 L/yr |
|
Senior Business Analyst
15
salaries
| ₹9.5 L/yr - ₹22.1 L/yr |
|
Data Analyst
11
salaries
| ₹3.6 L/yr - ₹13 L/yr |
|
Junior Business Analyst
8
salaries
| ₹5 L/yr - ₹8.3 L/yr |
|
Senior Data Analyst
8
salaries
| ₹16.8 L/yr - ₹20.9 L/yr |
Fractal Analytics
Mu Sigma
Tiger Analytics
LatentView Analytics
- Home >
- Interviews >
- Saras Analytics Interview Questions
