Spinny
Sasken Interview Questions and Answers
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
Q2. Problem statement - What data would you need to reduce air polutation in NCR?
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
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
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);
Q5. Difference between dimension and measure.
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
Q6. Difference between drop, delete and truncate.
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
Q7. Guesstimate on Number of McD orders
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
More about working at Spinny
Interview Process at Sasken
Top Business Analyst Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month