Spinny Business Analyst 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

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);

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

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