Spinny Business Analyst Interview Questions and Answers for Experienced

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

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...read more

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...read more