Data Visualization
Top 100 Data Visualization Interview Questions and Answers 2024
129 questions found
Updated 30 Nov 2024
Q1. What is meant by discrete and continous in tableau
In Tableau, discrete and continuous are two types of data that can be used to categorize and analyze information.
Discrete data consists of distinct, separate values that cannot be measured or divided further.
Examples of discrete data in Tableau include categories like product names, customer segments, or regions.
Continuous data represents measurements or values that can be divided infinitely and can take on any value within a range.
Examples of continuous data in Tableau inclu...read more
Q2. What is Book marks in PBI?
Bookmarks in Power BI are a feature that allows users to save and organize specific views of a report or dashboard.
Bookmarks help users to easily navigate and switch between different report views.
They can be used to save filters, slicer selections, visualizations, and other report settings.
Bookmarks can be created manually or through Power BI's recording feature.
They can be accessed and managed through the Bookmarks pane in Power BI Desktop or the Bookmarks menu in Power BI ...read more
Q3. Tell about Tableau dash boards.
Tableau dashboards are interactive visualizations that help users analyze and understand data.
Dashboards are made up of multiple worksheets and can include filters, parameters, and actions.
They allow users to explore data and answer questions in real-time.
Dashboards can be shared with others and embedded in websites or other applications.
Examples of dashboards include sales performance dashboards, marketing campaign dashboards, and financial analysis dashboards.
Q4. How and where Gauge charts are used?
Gauge charts are used to visually represent a single value within a given range.
Gauge charts are commonly used in business dashboards to display key performance indicators (KPIs).
They provide a quick and intuitive way to assess the current status or progress towards a goal.
Gauge charts can be used to show metrics such as sales targets, customer satisfaction scores, or production efficiency.
They are effective in highlighting deviations from the desired value or target.
Gauge ch...read more
Q5. How to approach if you're stuck in a Tableau problem. How to optimize your dashboards
To approach a Tableau problem, identify the issue and use available resources. To optimize dashboards, simplify design and use efficient data sources.
Identify the issue and use available resources such as Tableau community forums or Tableau support
Simplify design by removing unnecessary elements and using consistent formatting
Use efficient data sources by minimizing the amount of data being loaded and using data extracts instead of live connections
Consider using Tableau's per...read more
Q6. what are the data visulaztion tools?
Data visualization tools are software that help in creating visual representations of data to aid in understanding and analysis.
Tableau
Power BI
QlikView
Google Data Studio
D3.js
Q7. Tell me about Architecture of Tableau?
Tableau follows a client-server architecture with a three-tier structure.
Tableau Desktop is the client application used for creating and publishing content.
Tableau Server is the central server that manages user authentication, data sources, and content distribution.
Tableau Online is a cloud-based version of Tableau Server.
Tableau's three-tier structure includes the data source, the VizQL server, and the application server.
Tableau's architecture allows for scalability and flex...read more
Q8. How Tableau get data from SAS environment?
Tableau can connect to SAS environment through ODBC or SAS/ACCESS Interface.
Tableau can use ODBC to connect to SAS environment and access data.
SAS/ACCESS Interface can also be used to connect Tableau to SAS environment.
Tableau can directly connect to SAS datasets and tables.
Tableau can also use SAS data connectors to access data from SAS environment.
Data Visualization Jobs
Q9. PowerBI - Create Bookmarks in Power BI
Bookmarks in Power BI allow users to save the current state of a report for easy navigation.
Bookmarks can be created by selecting 'View' and then 'Bookmarks' in the Power BI toolbar.
Users can add bookmarks for specific filters, slicers, and visuals to save the current view of the report.
Bookmarks can be renamed, rearranged, and deleted as needed.
Bookmarks can also be used to create interactive presentations or storytelling within a report.
Q10. Diff types of charts and graphs used by pm and leads
Various types of charts and graphs are used by project managers and team leads to visualize data.
Gantt charts for project timelines
Pie charts for showing percentages or proportions
Bar graphs for comparing data
Line graphs for showing trends over time
Scatter plots for showing correlations
Heat maps for visualizing data density
Flow charts for showing process flows
Tree maps for showing hierarchical data
Bubble charts for showing three dimensions of data
Waterfall charts for showing ...read more
Q11. How to apply row level security in spotfire?
Row level security can be applied in Spotfire using data limiting expressions.
Create a data limiting expression that defines the criteria for the rows that should be visible to a specific user or group.
Assign the data limiting expression to the data table or view.
Create a user or group filter that references the data limiting expression.
Assign the user or group filter to the visualization.
Test the row level security by logging in as the user or group and verifying that only t...read more
Q12. What is blending in Tableau ?
Blending in Tableau is combining data from multiple sources to create a single view.
Blending allows for analysis of data from different sources without the need for merging.
Data sources can be blended based on common fields or dimensions.
Blending can be used to create a single view with data from multiple sources.
Example: Blending sales data from Excel with customer data from a database to analyze customer behavior.
Example: Blending survey data from SurveyMonkey with sales da...read more
Q13. How do you create a dashboard
A dashboard can be created using data visualization tools like Tableau or Power BI.
Choose a data visualization tool like Tableau or Power BI
Connect the tool to your data source
Select the type of visualization you want to use (e.g. bar chart, pie chart, line graph)
Drag and drop the data fields onto the dashboard canvas
Customize the dashboard layout and design to make it visually appealing
Add filters and interactivity for user engagement
Q14. Have you worked on Tableau Server?
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.
Q15. 2.How to schedule auto refresh of dashboard
Auto refresh can be scheduled using Tableau Server or Tableau Online
In Tableau Server, go to the dashboard and click on 'Schedule Refresh'
Set the frequency and time for the refresh
In Tableau Online, go to the dashboard and click on 'Schedule Refresh'
Set the frequency and time for the refresh
Make sure the data source is set to refresh before the dashboard refreshes
Q16. How to make live Dashboards with Power BI
Live dashboards can be created in Power BI by connecting to real-time data sources and using features like streaming datasets and push datasets.
Connect to real-time data sources such as Azure Stream Analytics, Azure Event Hubs, or Power Automate
Create streaming datasets to continuously update data in real-time
Use push datasets to push data from external sources to Power BI
Design visualizations and add them to a dashboard
Set up automatic data refresh intervals for real-time up...read more
Q17. What is box plot? Why is it used? How do we assess the skewness of distribution from the box plot?
Box plot is a visual representation of the distribution of a dataset, used to identify outliers and assess skewness.
Box plot displays the median, quartiles, and potential outliers of a dataset.
It is used to visually assess the spread, skewness, and presence of outliers in the data.
Skewness can be assessed from the box plot by observing the relative lengths of the whiskers and the position of the median.
Q18. Pull dataset from SQL to Power BI and perform the visualization
Use Power BI to connect to SQL database, import dataset, and create visualizations
Connect Power BI to SQL database
Import dataset from SQL into Power BI
Create visualizations using the imported data
Q19. How you look into data ?
I analyze data by identifying patterns, trends, and outliers to derive insights and make informed decisions.
I start by understanding the context and purpose of the data analysis.
I clean and preprocess the data to ensure accuracy and consistency.
I use statistical methods and data visualization techniques to explore and interpret the data.
I apply machine learning algorithms for predictive modeling and pattern recognition.
I communicate findings and recommendations based on the d...read more
Q20. What was visualization
Visualization is the representation of data in a visual format, such as charts, graphs, and maps.
Visualization helps in understanding complex data by presenting it in a more digestible format
It can reveal patterns, trends, and outliers that may not be apparent in raw data
Examples include bar charts, pie charts, scatter plots, and heat maps
Q21. How to draw pivot? With short cut key.
To draw a pivot in Excel, use the shortcut key Alt + D + P.
Press Alt + D to open the Data tab in Excel.
Then press P to open the PivotTable dialog box.
Select the range of data you want to use for the pivot table and choose where you want the pivot table to be placed.
Click OK to create the pivot table.
Q22. What is different between report and dashboard??
Reports are detailed and provide specific information, while dashboards are high-level and provide an overview.
Reports are typically longer and more detailed than dashboards
Reports are often used to provide specific information to a targeted audience
Dashboards are high-level and provide an overview of key metrics
Dashboards are often used to monitor performance and identify trends
Reports are usually static, while dashboards are interactive and allow for real-time data explorat...read more
Q23. What is the use of parameters in Tableau?
Parameters in Tableau allow users to dynamically change the values of calculations, filters, and reference lines.
Parameters can be used to create dynamic filters that allow users to change the data displayed in a visualization.
Parameters can also be used in calculations to perform complex calculations based on user input.
Parameters can be used in reference lines to dynamically set thresholds or benchmarks for comparison.
Q24. Explain Pareto chart with diagram
Pareto chart is a bar graph that displays the frequency of defects or issues in descending order to prioritize improvement efforts.
Pareto chart helps in identifying the most significant factors contributing to a problem.
It follows the 80/20 rule, where 80% of the problems are often caused by 20% of the factors.
The bars are arranged in descending order of frequency, with a cumulative percentage line to show the total contribution.
It helps in focusing on the vital few issues th...read more
Q25. 2.what is histro diagram
A histogram is a graphical representation of data distribution.
It is a bar graph-like representation of data that groups a range of values into intervals.
It shows the frequency of occurrence of data in each interval.
It helps to identify the central tendency, spread, and shape of the data distribution.
It is commonly used in quality control to analyze process variations.
Example: A histogram of test scores in a class can show the number of students who scored within each grade r...read more
Q26. How do you create dashboard, actions,
To create dashboards and actions in Tableau, you can use the drag-and-drop interface to add visualizations and set up interactivity.
Use the drag-and-drop interface to add visualizations to the dashboard
Set up actions to create interactivity between different visualizations
Define filter actions to allow users to interact with the data dynamically
Q27. What is LOD in Tableau?
LOD stands for Level of Detail. It is a technique used in Tableau to perform complex calculations on aggregated data.
LOD expressions allow users to compute values at different levels of detail in a visualization
They can be used to create custom aggregations, filters, and calculations
There are three types of LOD expressions: FIXED, INCLUDE, and EXCLUDE
FIXED LOD expressions define a level of detail that is independent of the visualization
INCLUDE LOD expressions add a specified ...read more
Q28. What are various data visualisation platforms
Various data visualisation platforms include Tableau, Power BI, Google Data Studio, and D3.js.
Tableau
Power BI
Google Data Studio
D3.js
Q29. What is extensions in tableau?
Extensions in Tableau are custom add-ons that enhance the functionality of Tableau by allowing users to integrate external services and applications.
Extensions can be used to connect Tableau with third-party applications, services, and data sources.
They can be developed using HTML, CSS, and JavaScript to create custom visualizations, write-back capabilities, and more.
Examples of extensions include integrating Tableau with Google Maps for geospatial analysis, embedding Tableau...read more
Q30. what is scatter plot
A scatter plot is a type of data visualization that displays the relationship between two numerical variables through dots on a graph.
Scatter plots are used to identify patterns and relationships between variables.
Each dot on the plot represents a single data point with the x-axis representing one variable and the y-axis representing the other variable.
The pattern of the dots can indicate the strength and direction of the relationship between the variables.
Scatter plots are c...read more
Q31. How to add date table in power bi
To add a date table in Power BI, you can create a new table with a list of dates and relationships with other tables.
Create a new table in Power BI with a list of dates
Add columns for day, month, year, etc. for additional analysis
Establish relationships between the date table and other tables in the data model
Q32. What do you shown on any dashboard or reporting tool
I show key performance indicators, trends, and metrics on the dashboard or reporting tool.
Key performance indicators (KPIs) such as sales revenue, customer acquisition cost, and customer retention rate
Trends in sales, marketing, and operational data over time
Metrics related to productivity, efficiency, and profitability
Visual representations like charts, graphs, and tables for easy interpretation
Q33. What all types can you create in Nprinting ?
Nprinting allows creation of various types of reports such as pixel perfect, Excel, PowerPoint, Word, and HTML.
Pixel perfect reports for precise formatting
Excel reports for data analysis
PowerPoint reports for presentations
Word reports for document creation
HTML reports for web publishing
Q34. Difference between real time graphs and historical graph
Real time graphs show current data while historical graphs show past data.
Real time graphs display data as it is happening, while historical graphs show data from a specific time period.
Real time graphs are useful for monitoring current trends and making immediate decisions, while historical graphs are useful for analyzing past trends and making long-term decisions.
Examples of real time graphs include stock market tickers and weather radars, while examples of historical graph...read more
Q35. How to handle large amount of data on tableau.
Utilize Tableau's features like data extracts, data blending, and performance optimization techniques.
Use data extracts to improve performance by reducing the amount of data being processed.
Utilize data blending to combine data from multiple sources without the need for complex ETL processes.
Optimize performance by using filters, aggregations, and calculations efficiently.
Consider using Tableau's in-memory data engine for faster processing of large datasets.
Q36. how fast can you prepare a bar chart with product operations data
I can prepare a bar chart with product operations data within a few minutes.
I have experience using data visualization tools like Tableau, Power BI, or Excel to quickly create bar charts.
I am proficient in organizing and cleaning data to ensure accurate representation in the chart.
I can customize the chart with relevant labels, colors, and titles to make it visually appealing and easy to understand.
Q37. Tell me about tableau architecture
Tableau architecture is a visual analytics platform that helps users to understand data through interactive visualizations.
Tableau consists of three main components: Data Connection, Data Engine, and VizQL Server.
Data Connection allows users to connect to various data sources such as databases, spreadsheets, and cloud services.
Data Engine processes and optimizes data queries for faster performance.
VizQL Server translates data queries into visualizations that can be displayed ...read more
Q38. Difference between heat map an tree map
Heat map displays data using color intensity while tree map displays data using nested rectangles.
Heat map is used to show the distribution of data across a two-dimensional space.
Tree map is used to display hierarchical data using nested rectangles.
Heat map uses color intensity to represent the data values while tree map uses the size of the rectangles.
Heat map is useful for identifying patterns and trends in large datasets while tree map is useful for visualizing hierarchica...read more
Q39. What is the use of histogram chart
Histogram chart is used to visually represent the distribution of data in a dataset.
Histograms show the frequency of data values within specified intervals or bins
They are useful for identifying patterns, trends, and outliers in data
Histograms are commonly used in quality control to monitor process variations
Q40. Which Visulization tool you used.
I have experience using Tableau and Power BI for data visualization.
Tableau is a powerful data visualization tool that allows for interactive dashboards and storytelling.
Power BI is another popular tool for creating interactive reports and visualizations.
I have used both tools to create visually appealing and informative charts, graphs, and dashboards.
Q41. Explain Tableau Dashboard actions
Tableau Dashboard actions allow users to interact with the data and visualizations by clicking on specific elements.
Dashboard actions can be used to filter data, highlight specific data points, or navigate to other dashboards.
There are four types of actions in Tableau: filter, highlight, URL, and parameter.
For example, a user can click on a bar chart to filter the data in a related table or click on a map to highlight the corresponding data points.
Dashboard actions can be cus...read more
Q42. Can you merge multiple dashboards into one
Yes, multiple dashboards can be merged into one by using dashboarding tools like Tableau or Power BI.
Use dashboarding tools like Tableau or Power BI to merge multiple dashboards into one
Identify common data sources and fields across the dashboards
Create a new dashboard and bring in the necessary visualizations and data from the existing dashboards
Arrange the visualizations and data in a cohesive and meaningful way to create a unified view
Q43. Can you explain basemap
A basemap is a foundational map used as a background for displaying additional layers of geographic information.
Basemaps provide context and reference for other data layers
They typically include features like roads, boundaries, water bodies, and terrain
Examples of basemaps include Google Maps, OpenStreetMap, and Esri World Imagery
Q44. Explain about dual axis in tableau
Dual axis in Tableau allows for combining two different measures on the same axis for better comparison.
Dual axis allows for comparing two measures on the same chart
Each measure can have its own scale, allowing for better visualization
Different chart types can be used for each measure, such as bars and lines
Q45. Have you created Geo Spatial charts in Tableau?
Yes, I have created Geo Spatial charts in Tableau.
I have used Tableau's built-in mapping functionality to create Geo Spatial charts.
I have also used custom shapefiles to create more detailed maps.
I have experience with creating heat maps, point maps, and choropleth maps.
I have used Geo coding to plot latitude and longitude coordinates on maps.
I have also used Tableau's integration with Mapbox to create custom maps.
I have created Geo Spatial charts for various projects, includ...read more
Q46. What visualizations you use for different forms of data and contexts?
I use a variety of visualizations such as bar charts, line graphs, scatter plots, and heat maps depending on the type of data and context.
Bar charts are useful for comparing categories of data
Line graphs are great for showing trends over time
Scatter plots help in identifying relationships between variables
Heat maps are effective for visualizing large datasets and identifying patterns
Q47. 1. What is box plots and why are they used
Box plots are a graphical representation of data distribution using quartiles and outliers.
Box plots show the median, quartiles, and outliers of a dataset.
They are used to identify skewness, outliers, and the spread of data.
They are also useful for comparing multiple datasets.
Box plots can be created using software like Excel or R.
Q48. Which visualisation tools you have worked on?
I have worked on Tableau, Power BI, and Excel for data visualization.
Tableau for creating interactive dashboards and visualizations
Power BI for creating reports and visualizations with real-time data
Excel for creating basic charts and graphs
Q49. Explain the dashboard navigation in looker
Looker dashboard navigation allows users to easily access and analyze data visualizations.
Users can navigate through different dashboards by clicking on tabs or links.
Filters can be applied to customize the data being displayed.
Drill-down functionality allows users to explore data in more detail.
Users can create bookmarks to save specific views for easy access.
Looker also provides search functionality to quickly find specific data or visualizations.
Q50. what is the custom chart you have worked on
I have worked on creating a custom sales performance chart for tracking monthly revenue
Utilized Excel to create a custom chart with data from multiple sources
Implemented color coding to highlight trends and outliers
Added interactive features for easy data analysis
Presented the chart to senior management for decision-making purposes
Q51. What is pivot chart?
A pivot chart is a graphical representation of data from a pivot table in Excel, allowing for easy visualization and analysis.
Pivot charts are linked to pivot tables, updating automatically when the table data changes
They can display data in various chart types like bar, line, pie, etc.
Users can easily filter and manipulate data in pivot charts for better insights
Pivot charts are commonly used in Excel for data analysis and reporting
Q52. What can we say by seeing this graph
The graph shows a steady increase in sales over the past year.
The graph indicates a positive trend in sales performance.
There is a clear upward trajectory in the sales data.
The sales figures have been consistently improving over time.
The company's revenue appears to be growing steadily.
There may have been successful marketing campaigns or product launches contributing to the sales growth.
Q53. How you make understand your dashboard to non technical person
I use simple language, visuals, and real-life examples to explain the dashboard to non-technical individuals.
Use simple language and avoid technical jargon
Include visuals like charts and graphs to make data easier to understand
Provide real-life examples to illustrate the data and its implications
Q54. Fetching data from an api and showing the result
To fetch data from an API and show the result, use HTTP requests and parse the response data.
Identify the API endpoint and required parameters
Make an HTTP request using a library like Axios or Fetch
Parse the response data using JSON.parse()
Display the data in the desired format, such as a table or list
Q55. Python code for data visualization.
Python's popular libraries for data visualization are Matplotlib, Seaborn, and Plotly.
Matplotlib is a basic library for creating static, interactive, and animated visualizations.
Seaborn is a high-level interface for creating informative and attractive statistical graphics.
Plotly is a web-based library for creating interactive visualizations and dashboards.
Use Pandas for data manipulation and NumPy for numerical computing.
Use Jupyter Notebook for creating and sharing data visu...read more
Q56. Data visualisation using Excel
Excel is a powerful tool for data visualization. It offers various chart types and customization options.
Select the data range and choose the chart type from the Insert tab
Customize the chart by adding titles, labels, and formatting options
Use conditional formatting to highlight specific data points
Create pivot tables to summarize and analyze large datasets
Utilize Excel's built-in functions for calculations and data manipulation
Q57. connections in tableau
Connections in Tableau refer to the relationships between data sources and how they are linked together in a visualization.
Connections in Tableau are established by creating joins between tables or blending data from different sources.
Primary keys and foreign keys are commonly used to establish connections between tables.
Tableau allows for both inner and outer joins to combine data from multiple sources.
Data blending is used when the data sources have no common fields to join...read more
Q58. data visualization techniques you have studied and used
I have studied and used various data visualization techniques including bar charts, line graphs, scatter plots, and heat maps.
I have experience creating bar charts to compare data across categories
I have used line graphs to show trends over time
I have created scatter plots to identify correlations between variables
I have used heat maps to visualize data density and identify patterns
Q59. Issue faced while visualization on tablau
Issues faced while visualizing on Tableau
Data not properly formatted
Incorrect use of chart types
Inadequate labeling and formatting
Poor data quality
Lack of understanding of Tableau features
Slow performance with large datasets
Q60. Visualization use cases
Visualization is used to represent data in a graphical format for better understanding.
Identifying trends and patterns in data
Comparing data sets
Showing relationships between variables
Presenting data to stakeholders
Exploring data for insights
Creating dashboards for monitoring
Visualizing geographic data
Displaying complex data in a simple way
Q61. Charts and their required data types to plot them
Different types of charts require different data types to plot them.
Line charts require numerical data
Bar charts require categorical data
Pie charts require numerical data that adds up to 100%
Scatter plots require numerical data for both x and y axes
Heat maps require numerical data for both x and y axes, and a third numerical value for the color intensity
Bubble charts require numerical data for both x and y axes, and a third numerical value for the size of the bubbles
Q62. Type of Filters in Tableau.
Tableau offers various types of filters including quick filters, context filters, and data source filters.
Quick filters allow users to easily filter data by selecting values from a list.
Context filters are applied before other filters, affecting the data visible to subsequent filters.
Data source filters limit the data available to Tableau by filtering data at the data source level.
Other types of filters include extract filters, top N filters, and relative date filters.
Q63. Data visualization rationale
Data visualization helps to communicate complex information in a clear and concise manner.
Data visualization allows for easier interpretation and analysis of data
It can highlight patterns and trends that may not be immediately apparent in raw data
Visualizations can be tailored to specific audiences and purposes
Examples include charts, graphs, maps, and infographics
Q64. Design and Develop Data Visualization Project
Develop a data visualization project
Identify the data to be visualized
Choose appropriate visualization tools
Design the user interface
Implement the project using programming languages such as Python, R, or JavaScript
Test and refine the project based on user feedback
Q65. Context filters in tableau ?
Context filters in Tableau allow users to control the scope of the data being analyzed by defining specific filters for certain worksheets or dashboards.
Context filters are used to limit the data being analyzed in Tableau to a specific subset.
They can be applied to individual worksheets or entire dashboards.
Context filters are useful for focusing on specific segments of data without affecting the overall analysis.
They can be created by right-clicking on a filter and selecting...read more
Q66. Types of LODs in Tableau
Types of LODs in Tableau include Fixed, Include, and Exclude.
Fixed LOD: Computes a value using specified dimensions, regardless of the visualization level.
Include LOD: Computes a value at a specified level of detail, including dimensions not in the visualization.
Exclude LOD: Computes a value at a specified level of detail, excluding dimensions not in the visualization.
Q67. Componets of Tableau ? What are the different connection is there in Tableau ?
Tableau components include Desktop, Server, Prep, Online, Public. Different connections include live, extract, ODBC, cloud, etc.
Tableau components: Desktop, Server, Prep, Online, Public
Different connections: Live, Extract, ODBC, Cloud, etc.
Live connection: Directly connects to the data source and updates in real-time
Extract connection: Data is extracted and stored in Tableau's proprietary format for faster performance
ODBC connection: Connects to databases using ODBC drivers
Cl...read more
Q68. What tool tableau use for optimization of deployments?
Tableau uses Tableau Server for optimization of deployments.
Tableau Server provides centralized management and scalability for Tableau deployments.
It allows for easy sharing and collaboration of dashboards and data sources.
Tableau Server also offers features such as load balancing, failover, and backup and recovery.
It can be deployed on-premises or in the cloud, depending on the organization's needs.
Tableau also offers a tool called Tableau Prep Conductor for managing data pr...read more
Q69. How can we share a power bi report with an external user?
To share a Power BI report with an external user, we can use the Publish to Web feature or share it via email.
Use the Publish to Web feature to generate an embed code that can be shared with external users
Ensure that the report contains only non-sensitive data before using the Publish to Web feature
Alternatively, share the report via email by granting access to the external user's email address
The external user must have a Power BI account to view the report
Q70. Describe your tableau dashboards and thought process behind building them.
I have built interactive Tableau dashboards that provide actionable insights for business decision-making.
I start by understanding the business objectives and key metrics to be tracked.
I gather and clean the relevant data to ensure accuracy and completeness.
I design the dashboard layout to present the data in a visually appealing and intuitive manner.
I use Tableau's features like filters, parameters, and calculated fields to enable interactivity.
I incorporate various visualiz...read more
Q71. how to optimize tableau dashboard
Optimizing Tableau dashboard involves simplifying visuals, reducing clutter, optimizing data sources, and utilizing performance tuning techniques.
Simplify visuals by removing unnecessary elements and focusing on key metrics
Reduce clutter by organizing data in a logical manner and using filters effectively
Optimize data sources by cleaning and aggregating data before connecting to Tableau
Utilize performance tuning techniques such as extracting data, using data blending instead ...read more
Q72. Give me details about the data visualisation tools you have worked on
I have experience working with Tableau, Power BI, and Google Data Studio for data visualization.
Proficient in creating interactive dashboards and reports using Tableau
Utilized Power BI for data analysis and visualization to track key performance indicators
Experience in designing visually appealing charts and graphs in Google Data Studio
Q73. whats bookmark in powerBI
A bookmark in Power BI is a feature that allows users to save the current state of a report, including filters, slicers, and visuals.
Bookmarks can be used to save different views of a report for easy navigation.
Users can create bookmarks to save specific filter selections or highlight certain data points.
Bookmarks can also be used to create interactive presentations by linking different bookmarks together.
Q74. what are the different types of charts in tableau
Tableau offers a variety of chart types to visualize data effectively.
Bar chart - used to compare different categories
Line chart - shows trends over time
Pie chart - displays parts of a whole
Scatter plot - shows relationships between two variables
Heat map - visualizes data using color intensity
Tree map - displays hierarchical data using nested rectangles
Q75. On tableau - what is row level security ?
Row level security in Tableau allows users to restrict access to specific rows of data based on their role or permissions.
Row level security is used to control which rows of data a user can access in Tableau.
It is typically implemented by creating a security table that defines the relationship between users and the data they can access.
Users can be granted access to specific rows based on their role or permissions.
Row level security helps ensure that users only see the data t...read more
Q76. How to create dashboard in Power BI for larger data?
To create a dashboard in Power BI for larger data, use data modeling, optimize data loading, utilize DAX calculations, and design visually appealing visuals.
Utilize data modeling to structure and organize large datasets efficiently
Optimize data loading by using query folding and reducing unnecessary data
Leverage DAX calculations for complex calculations and measures
Design visually appealing visuals using various chart types and interactive elements
Q77. How to publish on to tableau server
To publish on Tableau Server, use Tableau Desktop to create a workbook, then save it to Tableau Server.
Create a workbook in Tableau Desktop with the desired visualizations and data connections
Save the workbook to Tableau Server by selecting 'Server' > 'Publish Workbook'
Choose the project and permissions for the workbook on Tableau Server
Access the published workbook on Tableau Server through a web browser or Tableau Desktop
Q78. Draw Box-plot and explain its characteristics
Box-plot is a visual representation of the distribution of a dataset, showing the median, quartiles, and outliers.
Box-plot displays the median (middle line), quartiles (box), and outliers (dots or lines).
The length of the box represents the interquartile range (IQR).
Whiskers extend to the smallest and largest non-outlier data points within 1.5 times the IQR from the quartiles.
Outliers are plotted individually as dots or lines beyond the whiskers.
Box-plots are useful for compa...read more
Q79. LOD in tableau and itโs types
LOD in Tableau stands for Level of Detail and refers to the ability to control the level of aggregation in visualizations.
LOD expressions allow you to compute values at different levels of detail in Tableau.
There are three types of LOD expressions: INCLUDE, EXCLUDE, and FIXED.
INCLUDE LOD expressions compute values at the specified level of detail and then aggregate them up to the view level.
EXCLUDE LOD expressions exclude the specified dimension from the view level of detail....read more
Q80. Types of visualizations
Visualizations can be categorized into various types such as charts, graphs, maps, infographics, and dashboards.
Charts - bar charts, line charts, pie charts
Graphs - network graphs, scatter plots
Maps - choropleth maps, point maps
Infographics - data visualizations combined with text and images
Dashboards - interactive visual displays of data
Q81. What are parameters in Tableau
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.
Examples of parameters include date ranges, thresholds, and tar...read more
Q82. What is drill down and drill through in Power bi
Drill down and drill through are interactive features in Power BI that allow users to explore data in more detail.
Drill down allows users to navigate from a higher level of data to a more detailed level by clicking on a visual element, such as a bar chart or table.
Drill through allows users to access a more detailed report or page by clicking on a specific data point within a visual element.
Both features provide users with the ability to analyze data in a more granular way an...read more
Q83. How to make dashboards?
Dashboards can be made using various tools like Tableau, Power BI, Excel, etc.
Identify the purpose of the dashboard
Choose the appropriate tool for creating the dashboard
Select the relevant data sources
Design the layout and visualizations
Add filters and interactivity
Test and refine the dashboard
Q84. What are the ways to optimize Tableau dashboard?
Optimizing Tableau dashboard involves improving performance, usability, and visual appeal.
Limit the number of worksheets on a dashboard to improve performance
Use filters and parameters effectively to allow for interactivity
Optimize data source connections for faster loading times
Utilize dashboard actions to create dynamic interactions
Design with user experience in mind to ensure clarity and ease of use
Q85. Some Common Data Visualization Tools That Have Used?
Some common data visualization tools include Tableau, Power BI, and Google Data Studio.
Tableau
Power BI
Google Data Studio
Q86. Build charts in tableau
Tableau is a data visualization tool used to build interactive charts and dashboards.
Connect to data source
Drag and drop dimensions and measures
Choose chart type
Customize colors, labels, and formatting
Add filters and parameters
Create calculated fields
Build interactive dashboards
Q87. Lod in tableau , Row level security
Row level security in Tableau allows users to restrict access to specific rows of data based on user roles or permissions.
Row level security in Tableau is implemented by creating user filters based on user roles or permissions.
Users can only see data that they have been granted access to, based on the row level security settings.
Row level security can be set up using Tableau Server or Tableau Online.
Example: A sales manager can only see sales data for their region, while a ma...read more
Q88. Is it possible to update data in Tableau Extract?
Yes, it is possible to update data in Tableau Extract.
Tableau Extracts can be refreshed to update data
Data can be added, removed or modified in the data source and then refreshed in Tableau
Extracts can be set to refresh automatically or manually
Q89. Difference between tableau and power bi
Tableau is more user-friendly and better for data visualization, while Power BI is more powerful for data manipulation and integration.
Tableau is known for its ease of use and intuitive drag-and-drop interface.
Power BI has more advanced data manipulation capabilities and better integration with Microsoft products.
Tableau is better for creating visually appealing dashboards and reports, while Power BI is better for complex data analysis and modeling.
Power BI offers more advanc...read more
Q90. Make a dashboard using company data
I will create a dashboard using company data to visualize key metrics and trends.
Gather relevant company data such as sales, expenses, customer feedback, etc.
Choose appropriate visualization tools like charts, graphs, and tables.
Include key performance indicators (KPIs) to track progress and goals.
Ensure the dashboard is user-friendly and interactive for easy analysis.
Regularly update the dashboard to reflect real-time data changes.
Q91. Types of charts and uses
Different types of charts serve different purposes in data analysis and visualization.
Bar chart - compares categories of data
Line chart - shows trends over time
Pie chart - displays parts of a whole
Scatter plot - shows relationship between two variables
Histogram - displays distribution of data
Q92. How do you visualize the things In tableau
Visualize data in Tableau using various charts and graphs.
Select appropriate chart type based on data and analysis goal
Use color, size, and shape to encode additional information
Create interactive dashboards for exploration and analysis
Utilize Tableau's built-in features such as filters and parameters
Consider audience and design for effective communication
Q93. What are bookmarks in Power BI and how to restrict the filters from affecting the visual data while using bookmarks?
Bookmarks in Power BI are used to save the current state of a report page, including filters, slicers, and visuals.
Bookmarks allow users to save specific views of a report page for easy navigation.
To restrict filters from affecting visual data when using bookmarks, you can use the 'Edit interactions' feature to control how visuals interact with each other.
By setting the interactions between visuals to 'None' for certain bookmarks, you can ensure that filters do not affect the...read more
Q94. What are the types of the dashboards you have worked in Tableau?
I have worked on various types of dashboards in Tableau including interactive dashboards, performance dashboards, and executive dashboards.
Interactive dashboards
Performance dashboards
Executive dashboards
Q95. Difference on multiple tableau files (.twb,. Twice)
TWB files are Tableau workbook files that contain data and visualizations, while TWBX files are Tableau packaged workbook files that contain data and visualizations along with any external files.
TWB files are used to create and save Tableau workbooks
TWBX files are used to package Tableau workbooks along with any external files
TWBX files can be easily shared and opened on other computers
TWB files require the data source to be available on the computer where it is opened
TWBX fi...read more
Q96. explain the power bi visuals
Power BI visuals are interactive graphical representations of data that help users analyze and understand information.
Power BI visuals include charts, graphs, maps, tables, and custom visuals.
Users can customize visuals by changing colors, fonts, and other properties.
Visuals can be interactive, allowing users to drill down into data for more detailed analysis.
Examples of Power BI visuals include bar charts, pie charts, line graphs, and scatter plots.
Q97. How does Power BI help in visualisation? Give me difference between basic and advance dashboards
Power BI helps in visualizing data through interactive and customizable dashboards.
Power BI allows users to create visually appealing charts, graphs, and maps to represent data in a meaningful way.
Basic dashboards in Power BI typically include simple visuals like bar charts, line graphs, and pie charts to display key metrics.
Advanced dashboards in Power BI involve more complex visuals like heat maps, scatter plots, and custom visuals created using Power BI's developer tools.
A...read more
Q98. calculate the percentage of sales of states of the whole region in tableau
To calculate the percentage of sales of states of the whole region in Tableau.
Create a bar chart with states on the x-axis and sales on the y-axis
Add a table calculation to compute the percentage of total sales for each state
Format the chart to display the percentage values
Use the 'Region' field to filter the data to the desired region
Q99. Create a dashboard using Power Bi or Tableau.
Create a dashboard using Power Bi or Tableau
Gather relevant data sources for analysis
Identify key performance indicators (KPIs) to track
Design visually appealing and user-friendly dashboard
Utilize interactive features for data exploration
Include filters and slicers for customization
Consider audience needs and tailor dashboard accordingly
Q100. how to create dashboards
Creating dashboards involves selecting relevant data, designing visualizations, and arranging them in a user-friendly layout.
Identify key metrics and data sources to include in the dashboard
Design appropriate visualizations such as bar charts, line graphs, and maps
Arrange visualizations in a logical and intuitive layout
Use filters and parameters to allow users to interact with the data
Add annotations and titles to provide context and insights
Top Interview Questions for Related Skills
Interview Questions of Data Visualization Related Designations
Interview experiences of popular companies
Reviews
Interviews
Salaries
Users/Month