Top 100 Data Visualization Interview Questions and Answers

I will share Power BI reports through email, shared folders, and scheduled data refreshes.

• Share reports via email with stakeholders

• Store reports in shared folders for easy access

• Schedule data refreshes to ensure reports are up-to-date

Treemaps display hierarchical data using nested rectangles, while heat maps show data values using color intensity.

• Treemaps visually represent hierarchical data with nested rectangles of varying sizes, where the size of each rectangle represents a quantitative value.

• Heat maps use color intensity to represent data values, with darker colors indicating higher values and lighter colors indicating lower values.

• Treemaps are useful for displaying hierarchical data structures, such ...read more

Power BI is a Microsoft product focused on business intelligence and data visualization, while Tableau is a standalone data visualization tool.

• Power BI is more user-friendly and integrates well with other Microsoft products.

• Tableau is known for its powerful data visualization capabilities and flexibility in creating complex visualizations.

• Power BI is often preferred by organizations already using Microsoft products, while Tableau is popular among data analysts and visualizati...read more

To change visualizations in a dashboard using parameters in Tableau, follow these steps:

• Create a parameter in Tableau

• Create calculated fields that use the parameter to control the visualization

• Drag the calculated fields onto the dashboard

• Use the parameter control to change the visualization

Use Tableau to highlight the minimum and maximum sales for each year.

• Create a new worksheet in Tableau

• Drag the 'Year' field to the Columns shelf

• Drag the 'Sales' field to the Rows shelf

• Drag the 'Sales' field again to the Color shelf

• Right-click on the 'Sales' field in the Color shelf and select 'Measure' > 'Min'

• Right-click on the 'Sales' field in the Color shelf again and select 'Measure' > 'Max'

• Format the visualization as desired

I have used Tableau versions 10.0, 10.1, 10.2, and 2018.1.

• Tableau 10.0

• Tableau 10.1

• Tableau 10.2

• Tableau 2018.1

Tableau is a data visualization tool that helps users create interactive and shareable dashboards and reports.

• Tableau connects to various data sources such as Excel, SQL databases, and cloud services.

• Users can drag and drop fields to create visualizations like charts, graphs, and maps.

• Tableau allows for interactive filtering and drilling down into data for deeper insights.

• Users can create dashboards and stories to present their data in a visually appealing way.

• Tableau also of...read more

LOD (Level of Detail) in Tableau is used to control the level of aggregation in visualizations.

• LOD expressions allow you to compute values at different levels of detail in a visualization.

• They can be used to create calculated fields that are independent of the visualization's level of detail.

• Examples of LOD expressions include FIXED, INCLUDE, and EXCLUDE.

• FIXED LOD expressions compute values using a specific dimension or set of dimensions.

• INCLUDE LOD expressions compute values...read more

Tableau has introduced new features like Explain Data, Ask Data, and Tableau Prep Builder.

• Explain Data allows users to get insights and explanations for their data with a single click.

• Ask Data enables users to ask questions in natural language and get answers in the form of visualizations.

• Tableau Prep Builder helps users to clean, combine, and transform their data before analysis.

• Tableau has also improved its mapping capabilities with the introduction of Vector Maps and Spati...read more

Tableau is a data visualization tool that helps in analyzing and presenting data in an interactive and meaningful way.

• Tableau allows users to create interactive dashboards and reports

• It can connect to various data sources and perform data blending

• Tableau provides advanced analytics capabilities like forecasting and trend analysis

• It helps in identifying patterns and trends in data that might not be visible otherwise

• Tableau is user-friendly and requires minimal coding knowledge

Tableau is used for data visualization and analysis in various industries such as finance, healthcare, retail, and marketing.

• Helping businesses track key performance indicators (KPIs)

• Creating interactive dashboards for real-time data analysis

• Identifying trends and patterns in data for informed decision-making

• Visualizing sales data to identify opportunities for growth

• Analyzing patient outcomes in healthcare to improve treatment plans

Tableau is a powerful data visualization tool used to create interactive and shareable dashboards.

• Tableau allows users to create visually appealing charts, graphs, and maps to represent data.

• Users can easily drag and drop data fields to create visualizations without needing to write code.

• Tableau offers various interactive features like filters, drill-downs, and tooltips to explore data in depth.

• Users can create dashboards by combining multiple visualizations to tell a story o...read more

Tableau Server is a business intelligence tool that allows organizations to share and collaborate on data visualizations.

• Tableau Server is a platform for sharing and distributing Tableau workbooks and dashboards.

• It allows users to access and interact with visualizations through a web browser.

• Administrators can manage permissions, schedules, and data sources on Tableau Server.

• Tableau Server can be integrated with other data sources and applications for a seamless data analytic...read more

Context filter in Tableau allows users to filter data across multiple worksheets or dashboards.

• Context filters are applied to a specific worksheet or dashboard and affect all other worksheets or dashboards connected to the same data source.

• Context filters are useful for creating interactive dashboards where users can easily filter data across different views.

• To create a context filter in Tableau, right-click on a filter and select 'Add to Context'.

Tableau is a data visualization tool used for creating interactive and shareable dashboards.

• Tableau components include Tableau Desktop, Tableau Server, and Tableau Online.

• Tableau is used for data analysis, data visualization, and creating interactive dashboards.

• Tableau can connect to various data sources such as Excel, SQL databases, and cloud services.

• Tableau allows users to create visualizations like bar charts, line graphs, maps, and more.

• Tableau helps in making data-drive...read more

Tableau is a data visualization tool that allows users to create interactive and shareable dashboards.

• Tableau helps in analyzing and visualizing large datasets

• Users can create various types of charts, graphs, and maps

• It allows for easy sharing and collaboration of data insights

• Tableau can connect to multiple data sources such as Excel, SQL, and cloud databases

Sets in Tableau are custom fields that define a subset of data based on certain conditions.

• Sets can be used to group related data together for analysis

• Sets can be created based on dimensions or measures

• Sets can be used in calculations, filters, and visualizations

• Examples: creating a set of top customers, creating a set of high-value products

Date Trunc in Tableau is used to truncate date values to a specified level of granularity.

• Date Trunc function is used to truncate date values to a specific level of granularity, such as year, quarter, month, etc.

• It helps in aggregating data at a higher level of detail than the original date field.

• Example: DATE_TRUNC('month', [Order Date]) will truncate the date values to the month level.

Tableau offers a range of products for data visualization and analytics, including Tableau Desktop, Tableau Server, and Tableau Online.

• Tableau Desktop is a self-service analytics tool for creating interactive visualizations

• Tableau Server allows sharing and collaboration of data visualizations within an organization

• Tableau Online is a cloud-based platform for publishing and sharing dashboards online

There are two types of refresh in Tableau: Extract Refresh and Data Source Refresh.

• Extract Refresh: Refreshes the data in Tableau extract, which is a snapshot of data from the original data source.

• Data Source Refresh: Refreshes the data directly from the original data source.

• Examples: Extract Refresh is useful when working with large datasets to improve performance, while Data Source Refresh ensures real-time data updates.

LOD expressions in Tableau allow you to compute values at different levels of detail in a visualization.

• LOD expressions include FIXED, INCLUDE, and EXCLUDE functions

• FIXED LOD expressions compute values at a specific level of detail regardless of the visualization level

• INCLUDE LOD expressions compute values at the specified level of detail and include other dimensions in the visualization

• EXCLUDE LOD expressions compute values at the specified level of detail while excluding ot...read more