AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Saras Analytics Interview Questions and Answers
Saras Analytics Interview Experiences
14 interviews found
Anonymous
Selected
I appeared for an interview before Jul 2024, where I was asked the following questions.
- Q1. Knowledge on analytics
- Q2. Certifications on analytical tools
- Q3. Knowledge on their products
(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
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
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
Happen to meet changes
(2 Questions)
- Q1. Hike percentage?
- Q2. Like and dislike
Selected
I appeared for an interview before Feb 2024.
(1 Question)
- Q1. All kinda SQL questions, covering basic to advanced.
(1 Question)
- Q1. It was with director who tries to understand your analytical thoughts
(1 Question)
- Q1. Salary discussion
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
Selected
I appeared for an interview 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.
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?
- 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
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
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 Senior Business Analyst Interview Questions
- Saras Analytics Business Analyst Interview Questions
- Saras Analytics Data Scientist Interview Questions
- Saras Analytics Analyst Interview Questions
- Saras Analytics Software Engineer Interview Questions
- Saras Analytics Software Engineer Intern Interview Questions
- Saras Analytics Growth and Marketing Manager Interview Questions
- Show more
Interview Questions for Popular Designations
Overall Interview Experience Rating
based on 11 interview experiences
Difficulty level
Duration
Interview Questions from Similar Companies
Saras Analytics Reviews and Ratings
based on 41 reviews
Rating in categories
|
Business Analyst
50
salaries
|  ₹5 L/yr - ₹20 L/yr |
|
Senior Business Analyst
15
salaries
| ₹13 L/yr - ₹25 L/yr |
|
Data Analyst
12
salaries
| ₹4.6 L/yr - ₹13 L/yr |
|
Junior Business Analyst
9
salaries
| ₹5 L/yr - ₹8.3 L/yr |
|
Data Engineer
8
salaries
| ₹9.5 L/yr - ₹18.8 L/yr |
Access Healthcare
S&P Global
IKS Health
AGS Health
- Home >
- Interviews >
- Saras Analytics Interview Questions
