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 and Answers
7 Interview questions
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 ...
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...
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 o...
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
Dimensions are categorical fields used for grouping and filtering data, while measures are numerical fields used for calculations and aggregation.
Dimensions are qualitative data like names, dates, or categories.
Measures are quantitative data like sales, profit, or quantity.
Dimensions are used for slicing and dicing data, while measures are used for calculations and aggregations.
Example: In a sales dataset, 'Produc...
What are the roles & responsibilities of a Business Analyst at Spinny?
Read full roles & responsibilities 
Parameters in Tableau are dynamic values that can replace constant values in calculations, filters, and reference lines.
Parameters allow users to change the value of a calculation without modifying the calculation itself.
They can be used in filters to allow users to dynamically control which data is displayed.
Parameters can also be used in reference lines to dynamically set thresholds or targets.
For example, a par...
Spinny HR Interview Questions
A subquery in SQL is a query nested within another query, used to return a subset of data from a larger dataset.
A subquery is enclosed within parentheses and can be used in SELECT, INSERT, UPDATE, or DELETE statements.
It can be used to filter results based on a condition, retrieve data from multiple tables, or perform calculations.
Example: SELECT * FROM table1 WHERE column1 IN (SELECT column2 FROM table2 WHERE con...
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
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
I appeared for an interview 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 appeared for an interview 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.
Dimensions are categorical fields used for grouping and filtering data, while measures are numerical fields used for calculations and aggregation.
Dimensions are qualitative data like names, dates, or categories.
Measures are quantitative data like sales, profit, or quantity.
Dimensions are used for slicing and dicing data, while measures are used for calculations and aggregations.
Example: In a sales dataset, 'Product Cat...
- Q2. What are parameters in Tableau?
- Ans.
Parameters in Tableau are dynamic values that can replace constant values in calculations, filters, and reference lines.
Parameters allow users to change the value of a calculation without modifying the calculation itself.
They can be used in filters to allow users to dynamically control which data is displayed.
Parameters can also be used in reference lines to dynamically set thresholds or targets.
For example, a paramete...
- Q3. What is a subquery in SQL?
- Ans.
A subquery in SQL is a query nested within another query, used to return a subset of data from a larger dataset.
A subquery is enclosed within parentheses and can be used in SELECT, INSERT, UPDATE, or DELETE statements.
It can be used to filter results based on a condition, retrieve data from multiple tables, or perform calculations.
Example: SELECT * FROM table1 WHERE column1 IN (SELECT column2 FROM table2 WHERE conditio...
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
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 Software Engineer Interview Questions
- Spinny Relationship Manager Interview Questions
- Spinny Backend Developer Interview Questions
- Spinny Sales Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
Overall Interview Experience Rating
based on 8 interview experiences
Difficulty level
Duration
Interview Questions from Similar Companies
Spinny Business Analyst Reviews and Ratings
based on 21 reviews
Rating in categories
|
Operations Analyst
498
salaries
|  ₹2.2 L/yr - ₹6.5 L/yr |
|
Relationship Manager
268
salaries
| ₹2.7 L/yr - ₹5.1 L/yr |
|
Team Lead
206
salaries
| ₹3.4 L/yr - ₹7.8 L/yr |
|
CAR Consultant
178
salaries
| ₹2.1 L/yr - ₹4.5 L/yr |
|
Assistant Manager
159
salaries
| ₹4.5 L/yr - ₹10.8 L/yr |
Truebil
Udaan
Swiggy
Oyo Rooms
- Home >
- Interviews >
- Spinny Interview Questions
