C.M.Annamalai Polytechnic College Interview Questions and Answers

Parameters are used to define values in a report, while filters are used to limit the data displayed in a report.

• Parameters are used to make a report more dynamic by allowing users to input values such as dates or names.

• Filters are used to limit the data displayed in a report based on specific criteria such as date range or product type.

• Parameters are set before a report is run, while filters can be applied during or after a report is run.

• Examples of parameters include start ...read more

Choose Live or Extract Connection based on data size, frequency of updates, and performance needs.

• Use Live Connection for real-time data analysis and Extract Connection for large data sets.

• Live Connection requires a stable network connection while Extract Connection can work offline.

• Extract Connection allows for faster performance as data is stored locally.

• Consider the frequency of data updates and the need for real-time analysis when choosing a connection type.

• Examples: Use ...read more

Extracts are subsets of data from a larger dataset. Refresh time can be set in the data source settings.

• Extracts are created by selecting a subset of data from a larger dataset.

• They can be used to improve performance by reducing the amount of data that needs to be processed.

• Refresh time can be set in the data source settings to ensure the extract is up-to-date.

• The refresh time can be set to occur at regular intervals or manually triggered.

• Examples of tools that use extracts i...read more

Yes, I have worked on Tableau Server.

• I have experience in installing and configuring Tableau Server.

• I have created and managed user accounts and permissions.

• I have published workbooks and data sources to Tableau Server.

• I have monitored server performance and troubleshooted issues.

• I have worked with Tableau Server APIs to automate tasks.

• I have provided training and support to end-users.

Extract is faster than Live.

• Extract refers to retrieving data from a database or system, which is faster as it doesn't involve real-time processing.

• Live refers to real-time processing, which can be slower as it involves processing data as it comes in.

• For example, extracting data from a database is faster than live streaming data from a sensor.

• However, live processing is necessary for certain applications such as real-time monitoring or control systems.

Transformation steps involve planning, analysis, implementation, and evaluation.

• Planning: Identify the need for transformation and set goals.

• Analysis: Assess the current state and identify areas for improvement.

• Implementation: Execute the planned changes and monitor progress.

• Evaluation: Measure the effectiveness of the transformation and make adjustments if necessary.