Add office photos
Spinny logo
Employer?
Claim Account for FREE

Spinny

3.7
based on 1.4k Reviews
Video summary
Filter interviews by
Business Analyst
Clear (1)

Spinny Business Analyst Interview Questions and Answers

Updated 6 Nov 2024
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 Category' would be a dimension, and 'Sales Amount' would be a...read more

Add your answer
right arrow

Q2. 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 vehicles and their emissions

  • Data on the use of alternative mo...read more

Add your answer
right arrow
Q3. 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 parameter can be created to allow users to switch between viewing ...read more

Add your answer
right arrow
Q4. 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 condition);

Add your answer
right arrow
Discover Spinny interview dos and don'ts from real experiences

Q5. 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 often used as filters while measures are used in charts and gr...read more

Add your answer
right arrow

Q6. 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

Add your answer
right arrow

Q7. 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 special events that may impact order volume

Add your answer
right arrow

More about working at Spinny

Back
Awards Leaf
AmbitionBox Logo
#13 Best Tech Startup - 2022
Awards Leaf
HQ - Gurgaon,Haryana, India
Contribute & help others!
Write a review
Write a review
Share interview
Share interview
Contribute salary
Contribute salary
Add office photos
Add office photos

Interview Process at Spinny Business Analyst

based on 8 interviews
2 Interview rounds
Technical Round
Case Study Round
View more
interview tips and stories logo
Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories

Top Business Analyst Interview Questions from Similar Companies

Infosys Logo
3.6
 • 88 Interview Questions
Accenture Logo
3.8
 • 37 Interview Questions
Genpact Logo
3.8
 • 29 Interview Questions
Deloitte Logo
3.8
 • 22 Interview Questions
Mphasis Logo
3.4
 • 11 Interview Questions
HCLTech Logo
3.5
 • 10 Interview Questions
View all
Recently Viewed
INTERVIEWS
Bharti Enterprises
No Interviews
SALARIES
Snapdeal
INTERVIEWS
Spinny
No Interviews
SALARIES
Snapdeal
DESIGNATION
INTERVIEWS
Spinny
No Interviews
JOBS
Reliance Industries
No Jobs
JOBS
Reliance Industries
No Jobs
SALARIES
Snapdeal
REVIEWS
Bharti Enterprises
No Reviews
Share an Interview
Stay ahead in your career. Get AmbitionBox app
play-icon
play-icon
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
75 Lakh+

Reviews

5 Lakh+

Interviews

4 Crore+

Salaries

1 Cr+

Users/Month

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter