AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Spinny Business Analyst Interview Questions, Process, and Tips
Top Spinny Business Analyst Interview Questions and Answers
- Q1. What is the difference between a dimension and a measure in Tableau?
- Q2. Problem statement - What data would you need to reduce air polutation in NCR?
- Q3. What are parameters in Tableau?
Spinny Business Analyst Interview Experiences
10 interviews found
Anonymous
(2 Questions)
- Q1. SQL Question using window functions
- Q2. Guesstimate on Number of McD orders
- Ans.
The number of McDonald's orders can be estimated based on factors like location, time of day, and day of the week.
Consider the population density of the area where the McDonald's is located
Take into account the time of day - more orders during meal times
Factor in the day of the week - weekends may have higher order volumes
Look at historical data or industry averages for similar locations
Consider any promotions or speci
I applied via Naukri.com and was interviewed in Jul 2024. There were 2 interview rounds.
Ques of python if a number divisible by 3 print T , divisible by 5 print F if both 3 and 5 then N
Flipkart sales drop from last month to current month , reasons
Interview Preparation Tips
How many cars in this world
(2 Questions)
- Q1. SQL ( Joins) - Theoretical and practical knowledge
- Q2. SQl - Window functions
Interview Preparation Tips
Spinny interview questions for designations
I applied via Referral and was interviewed in Feb 2024. There were 2 interview rounds.
(1 Question)
- Q1. Excel, SQL, Pandas
Round 2,3,4 are Business round
Interview Preparation Tips
Get interview-ready with Top Spinny Interview Questions
I was interviewed in Mar 2023.
(3 Questions)
- Q1. 2 SQL Questions were given, and asked to write query for the same.
- Q2. 1 question was asked from Excel
- Q3. 1 Aptitude question
Interview Preparation Tips
I applied via Referral and was interviewed in Apr 2022. There were 4 interview rounds.
(1 Question)
- Q1. Understanding of Basic SQL was checked. Writing Basic SQL queries with where condition. SQL query question using Analytical function. ( 2nd most revenue-generating country) Difference between Rank and Dens...
Guestimate the number of people travelling in Metro at 6:30pm on weekday.
Case Study- Funnel Drop in a value chain( customer journey)
find out the reasons, and give the ideas to overcome and rank the ideas based on priority.
(1 Question)
- Q1. Business Round with Project Manager: Basically, tell about yourself more(not about work), what kind of person you are, future plans, expectations from the company, what you know about spinny, are you rea...
Interview Preparation Tips
Learn all techniques and difference type of Case Studies how to solve.
Increasing your business skills by watching different business case studies.
Learn SQL.
I was interviewed in Sep 2021.
(3 Questions)
Round duration - 45 minutes
Round difficulty - Easy
Technical round with questions on DBMS, SQL , Tableu etc.
- Q1. What is the difference between a dimension and a measure in Tableau?
- Ans.
A measure is a field that can be aggregated in some way, such as a sum or an average. Think of it as something that can be collected, counted, or combined in some way to return a single value.
A dimension is a field that can be used to split up another field or measure into distinct groups. It can be used to define the level of detail to perform an aggregation on - Q2. What are parameters in Tableau?
- Ans.
The parameters in Tableau are the workbook variables like a number, date, or calculated field that allows users to replace a constant value in a calculation, filter, or reference line.
For example, the user can create a new calculated field that returns True if the aggregate of total marks is greater than 90% and returns False if it is less than 90%. Users can replace the constant value of "90%" in the formula with the ... - Q3. What is a subquery in SQL?
- Ans.
A subquery is a query in a query. It is also called an inner query or a nested query. A subquery can be used anywhere an expression is allowed. It is a query expression enclosed in parentheses. Subqueries can be used with SELECT, INSERT, UPDATE, or DELETE statements.
Round duration - 30 minutes
Round difficulty - Easy
HR round with typical behavioral problems.
Interview Preparation Tips
Tip 1 : Practice SQL queries. Topics - Aggregate function, Windows Function, sub queries. Should know basics of Tableau.
Tip 2 : Have hands on with Tableau, SQL and Excel.
Tip 3 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Sep 2021. There were 4 interview rounds.
Interview Questionnaire
5 Questions
- Q1. Problem statement - What data would you need to reduce air polutation in NCR?
- Ans.
To reduce air pollution in NCR, data on sources of pollution, weather patterns, and population density is needed.
Sources of pollution such as industries, vehicles, and construction sites
Weather patterns such as wind direction and speed, temperature, and humidity
Population density and distribution to identify areas with high pollution levels
Data on emissions from power plants and factories
Information on the types of veh...
- Q2. Difference between drop, delete and truncate.
- Ans.
Drop, delete and truncate are SQL commands used to remove data from a table.
DROP command removes the entire table and its data
DELETE command removes specific rows from the table
TRUNCATE command removes all the data from the table
- Q3. SQL queries -write queries using Subquery, Windows Function etc
- Q4. Difference between dimension and measure.
- Ans.
Dimensions are attributes used to group data while measures are numerical values used to perform calculations.
Dimensions are qualitative data while measures are quantitative data.
Dimensions are used for slicing and dicing data while measures are used for analysis and calculations.
Examples of dimensions include date, location, and product while examples of measures include sales, profit, and quantity.
Dimensions are ofte...
- Q5. What are parameters in Tableau
- Ans.
Parameters in Tableau are user-defined values that can be used to control aspects of a visualization.
Parameters allow users to interact with a visualization by changing values such as filters, calculations, and reference lines.
They can be used to create dynamic visualizations that respond to user input.
Parameters can be created by right-clicking on a field or by selecting 'Create Parameter' from the Analysis menu.
Examp...
Interview Preparation Tips
Should know basics of Tableau.
Have hands on with Tableau, SQL and Excel.
Skills evaluated in this interview
Selected
I applied via Approached by Company and was interviewed before Jan 2022. There were 4 interview rounds.
Business knowledge and simple cognizance of data points
(2 Questions)
- Q1. Advance Sql, Google sheet, Data Analysis with Python
- Q2. From beginner to advance level
Guesstimate, Case study, process oriented
Interview Preparation Tips
Top trending discussions
Spinny Interview FAQs
Tell us how to improve this page.
Spinny Interviews By Designations
- Spinny Operations Analyst Interview Questions
- Spinny Business Analyst Interview Questions
- Spinny Evaluator Interview Questions
- Spinny CAR Consultant Interview Questions
- Spinny Backend Developer Interview Questions
- Spinny Relationship Manager Interview Questions
- Spinny Sales Analyst Interview Questions
- Spinny Software Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
- Business Development Executive Interview Questions
- Business Development Manager Interview Questions
- Business Development Associate Interview Questions
- Senior Business Analyst Interview Questions
- Business Associate Interview Questions
- Business Development Interview Questions
- Business Executive Interview Questions
- Business Manager Interview Questions
- Show more
Spinny Business Analyst Interview Process
based on 8 interviews
2 Interview rounds
- Technical Round
- Case Study Round
Business Analyst Interview Questions from Similar Companies
Spinny Business Analyst Reviews and Ratings
based on 17 reviews
Rating in categories
|
Operations Analyst
487
salaries
|  ₹2.2 L/yr - ₹6.4 L/yr |
|
Relationship Manager
250
salaries
| ₹2.7 L/yr - ₹5.1 L/yr |
|
Team Lead
193
salaries
| ₹2.8 L/yr - ₹8.5 L/yr |
|
CAR Consultant
161
salaries
| ₹2.1 L/yr - ₹4.5 L/yr |
|
Assistant Manager
131
salaries
| ₹3.8 L/yr - ₹12 L/yr |
Truebil
Carwale
Cartrade.com
CARS24
- Home >
- Interviews >
- Spinny Interview Questions >
- Spinny Business Analyst Interview Questions
