AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Saras Analytics Data Analyst Interview Questions, Process, and Tips
Top Saras Analytics Data Analyst Interview Questions and Answers
- Q1. Difference between Having and where clause?
- Q2. Difference between Rank and Dense rank function?
- Q3. What is LOD in Tableau?
Saras Analytics Data Analyst Interview Experiences
4 interviews found
Anonymous
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
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
Vinayak Patil
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
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
Saras Analytics interview questions for designations
Interview questions from similar companies
I appeared for an interview in Mar 2017.
Interview Questionnaire
1 Question
- Q1. Views on their recruiting process
- Ans.
I believe the recruiting process is thorough and well-organized.
The company uses a combination of resume screening, interviews, and assessments to evaluate candidates.
They have a clear timeline for the hiring process and keep candidates informed of their progress.
Feedback is provided to candidates after interviews to help them improve for future opportunities.
Interview Preparation Tips
Experience:
I applied via Walk-in and was interviewed before Jun 2021. There were 2 interview rounds.
(1 Question)
- Q1. What is EPS? Why balance sheet always match?
- Ans.
EPS stands for Earnings Per Share. Balance sheet always matches due to the fundamental accounting equation.
EPS is a financial metric that measures the profit earned by a company per outstanding share of common stock.
It is calculated by dividing the net income of the company by the total number of outstanding shares.
Balance sheet always matches because of the fundamental accounting equation which states that assets must...
(1 Question)
- Q1. What is depreciation and amortization?
- Ans.
Depreciation and amortization are accounting methods used to allocate the cost of assets over their useful lives.
Depreciation is the allocation of the cost of tangible assets, such as buildings or equipment, over their useful lives.
Amortization is the allocation of the cost of intangible assets, such as patents or copyrights, over their useful lives.
Both depreciation and amortization are non-cash expenses that reduce t...
Interview Preparation Tips
- Accounting principles
I applied via Naukri.com
Interview Questionnaire
1 Question
- Q1. About education qualification. Experience, knowledge about the position.
Interview Preparation Tips
I applied via Company Website and was interviewed in Apr 2022. There were 2 interview rounds.
Improve your skills
Interview Preparation Tips
I appeared for an interview in Apr 2021.
Round duration - 120 Minutes
Round difficulty - Easy
After the resume shortlisting, we were given a test link which needs to be done within 24 hours after getting it.
There were questions from Aptitude , Machine Learning, Probability , Excel and SQL
Round duration - 120 Minutes
Round difficulty - Easy
(1 Question)
Round duration - 45 Minutes
Round difficulty - Medium
We were asked to explain the Tableau Dashboard in detail. Some additional questions were also asked from Tableau. ML and Deep Learning questions were also asked along with a standard gfg puzzle.
- Q1. What questions were you asked regarding Machine Learning, specifically in exploratory data analysis, the basics of deep learning, and can you describe the puzzle that was presented?
Round duration - 30 Minutes
Round difficulty - Easy
One business case study was asked.
Round duration - 20 minutes
Round difficulty - Easy
Standard HR questions were asked.
Interview Preparation Tips
Tip 1 : We need to be clear with basics of differentiation calculus and probability to get a good understanding of ML algorithms.
Tip 2 : Also, we tend to ignore statistics , but statistics should not be skipped at any cost.
Tip 3 : There should be atleast 2-3 good ML projects for which you are fully confident. You can have one project for topics like supervised learning , unsupervised learning, recommendation systems and if possible deep learning project can also be included.
Tip 4 : You should be fair enough with any one visualisation tool like Tableau, Power BI etc.
Tip 5 : Practice as much as you can from kaggle
Tip 1 : Needs to have atleast 2 ML projects.
Tip 2 : Things like Excel, SQL , and Tableau should be mentioned in the resume.
Tip 3 : Certifications for ML and Excel, SQL and Tableau will help you getting shortlisted.
Tip 4 : And last but not the least, any false thing should not be included if you are not at all aware of it.
Skills evaluated in this interview
I appeared for an interview in Apr 2021.
Round duration - 120 minutes
Round difficulty - Easy
After the resume shortlisting, we were given a test link which needs to be done within 24 hours after getting it.
There were questions from Aptitude , Machine Learning, Probability , Excel and SQL
(1 Question)
Round duration - 45 Minutes
Round difficulty - Medium
We were asked to explain the Tableau Dashboard in detail. Some additional questions were also asked from Tableau. ML and Deep Learning questions were also asked along with a standard gfg puzzle.
- Q1. What questions were you asked regarding Machine Learning, specifically in exploratory data analysis, the basics of deep learning, and can you describe the puzzle that was presented?
Round duration - 30 Minutes
Round difficulty - Easy
One business case study was asked.
Round duration - 20 minutes
Round difficulty - Easy
Standard HR questions were asked.
Interview Preparation Tips
Tip 1 : We need to be clear with basics of differentiation calculus and probability to get a good understanding of ML algorithms.
Tip 2 : Also, we tend to ignore statistics , but statistics should not be skipped at any cost.
Tip 3 : There should be atleast 2-3 good ML projects for which you are fully confident. You can have one project for topics like supervised learning , unsupervised learning, recommendation systems and if possible deep learning project can also be included.
Tip 4 : You should be fair enough with any one visualisation tool like Tableau, Power BI etc.
Tip 5 : Practice as much as you can from kaggle
Tip 1 : Needs to have atleast 2 ML projects.
Tip 2 : Things like Excel, SQL , and Tableau should be mentioned in the resume.
Tip 3 : Certifications for ML and Excel, SQL and Tableau will help you getting shortlisted.
Tip 4 : And last but not the least, any false thing should not be included if you are not at all aware of it.
Skills evaluated in this interview
Saras Analytics Interview FAQs
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 Front end Developer Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Analyst Interview Questions
- Junior Data Analyst Interview Questions
- Data Analyst Intern Interview Questions
- Data Engineer Interview Questions
- Data Research Analyst Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Analyst Interview Questions
- Show more
Saras Analytics Data Analyst Interview Process
based on 3 interviews
1 Interview rounds
- Technical Round
Data Analyst Interview Questions from Similar Companies
Saras Analytics Data Analyst Reviews and Ratings
based on 5 reviews
Rating in categories
|
Business Analyst
47
salaries
|  ₹4.6 L/yr - ₹17 L/yr |
|
Senior Business Analyst
15
salaries
| ₹13 L/yr - ₹25 L/yr |
|
Data Analyst
11
salaries
| ₹4.4 L/yr - ₹13 L/yr |
|
Senior Data Analyst
9
salaries
| ₹16.8 L/yr - ₹20.9 L/yr |
|
Junior Business Analyst
8
salaries
| ₹6.5 L/yr - ₹8.3 L/yr |
EXL Service
Access Healthcare
S&P Global
AGS Health
- Home >
- Interviews >
- Saras Analytics Interview Questions >
- Saras Analytics Data Analyst Interview Questions
