**Data analytics** is the process of analyzing data sets to make decisions based on the information available, which is increasingly being done with the help of specialized applications and systems. **Data visualization** is a graphical representation of data.

**Data Analytics and Visualization MCQs**: This section contains ** multiple-choice questions and answers on data analytics and visualization**. It will help the students to test their skills and prepare well for their exams.

List of Data Analytics and Visualization MCQs

**1. A probability distribution is a ___.**

- Library function
- Statistical function
- Physical property
- None of the mentioned above

**Answer:** B) Statistical function

**Explanation:**

Uncertainty distributions are statistical functions that describe all of the different possible values and likelihoods that a random variable can take within a given range of values. This range will be restricted to the range between the minimum and maximum possible values, but the precise location of the possible value on the probability distribution will depend on a variety of factors, including the probability distribution itself. The mean (average), standard deviation, skewness, and kurtosis of a distribution are among the variables to consider.

**2. Following chart is an example of,**

- Probability Distribution Chart
- Line chart
- Pie chart
- All of the mentioned above

**Answer:** A) Probability Distribution Chart

**Explanation:**

A probability distribution is, in essence, a bar chart that depicts the likelihood of an event occurring in the future. It’s a quick way to see what’s going on and how likely it is that something will happen. In the field of statistics, probability distribution charts can become quite complicated. The normal distribution, also known as the “bell curve,” is perhaps the most widely used probability distribution, although there are several other distributions that are also widely used.

**3. Amongst which of the following is / are the types of Probability Distribution?**

- Normal distribution, Binomial distribution
- Bernoulli distribution
- Uniform distribution, Poisson distribution
- All of the mentioned above

**Answer:** D) All of the mentioned above

**Explanation:**

The Normal distribution, the Binomial distribution, the Bernoulli distribution, the Uniform distribution, and the Poisson distribution are the most commonly encountered Probability Distribution functions in statistics.

**4. Binomial distribution is a discrete distribution?**

- True
- False

**Answer:** A) True

**Explanation:**

It is a discrete distribution when it is a binomial distribution. A discrete distribution is a type of probability distribution that describes the probability of occurrence of each value of a discrete random variable occurring. If you have 6 apples in your refrigerator, and only 1 of them has spoiled, you have an example of a discrete probability distribution. In a discrete probability distribution, each possible value of a discrete random variable can be associated with a non-zero probability of occurring in the future. In the case of a given success probability p in each trial, a binomial distribution is used to represent the probability of x success in each trial.

**5. Continuous Probability Distribution includes ___.**

- Normal distribution
- Uniform distribution
- Both A and B
- None of the mentioned above

**Answer:** C) Both A and B

**Explanation:**

The Normal distribution and the Uniform distribution are both examples of Continuous Probability Distribution. When it comes to probability distributions, a continuous probability distribution is one in which the random variable X can have any value (is continuous). Because there are an infinite number of possible values for X to take on, the probability of X taking on any specific value is equal to zero.

**Normal distribution**– A normal distribution is defined as one in which the parameters (also known as the mean) and s2 (also known as the variance) have a range of -8 to +8. The following are the characteristics of its continuous probability distribution:

f(x;µ, s)= (1/ s p) exp(-0.5 (x-µ)2/ s2).**Uniform distribution**– When it comes to distribution functions, uniform distribution is one in which every possible result is equally likely to occur; that is, the probability of each occurrence is the same.

**6. The Bernoulli random variable’s expected value is p, it is also known as the ___.**

- Bernoulli distribution’s path
- Bernoulli distribution’s function
- Bernoulli distribution’s parameter
- None of the mentioned above

**Answer:** C) Bernoulli distribution’s parameter

**Explanation:**

The expected value of a Bernoulli random variable is p, which is also referred to as the Bernoulli distribution’s parameter in some circles. In this experiment, the outcome can be either a value of zero or one. Bernoulli random variables can have values of 0 or 1, depending on the situation.

**7. A Poisson distribution is a probability distribution used in statistics to show how many times an event is likely to happen over a given period of time?**

- True
- False

**Answer:** A) True

**Explanation:**

When it comes to statistics, a probability distribution known as a Poisson distribution is used to show how many times an event is likely to occur over a given period of time. When a constant rate of independent events occurs at a constant rate over a given time interval, the Poisson distribution is frequently used to comprehend the events.

**8. The ___ function applies one or more conditions in the specified range of data and returns only those which fulfill all of the conditions.**

- COUNTIFS
- COUNT
- IF
- None of the mentioned above

**Answer:** A) COUNTIFS

**Explanation:**

The COUNTIFS function applies one or more conditions in the specified range of data and returns only those which fulfill all of the conditions.

**9. Amongst which of the following is / are related to Standard Deviation Function?**

- Standard Deviation is one of the ways to quantify dispersion
- It is a measure of how widely values are dispersed from the average value
- STDEV.P function which is used to calculate standard deviation based on the entire population given as arguments
- All of the mentioned above

**Answer:** D) All of the mentioned above

**Explanation:**

If you use a sample of the population (STDEV) or a biassed sample of the population (STDEV), then the statistical standard deviation of all values in the set will be returned by the standard deviation function (STDEVP). The standard deviation is useful for measuring variance within a data set and, in the context of statistical results, for assessing confidence in those results. To quantify dispersion, one of the methods used is to calculate the standard deviation. In other words, it is a measure of how widely values are dispersed from the mean value.

**10. STDEV.P function which is used to calculate standard deviation based on the entire population?**

- True
- False

**Answer:** A) True

**Explanation:**

When the entire population is given as arguments, the STDEV.P function is used to calculate the standard deviation. The STDEV.P function makes the assumption that the arguments it receives represent the entire population. In a sample set of data, the standard deviation is calculated using the STDEV.S() function. When a large sample size is used, the standard deviations of the population and the samples will have values that are very close to one another.

**11. Amongst which of the following is best fitted to Tableau?**

- Tableau is a powerful and fastest growing data visualization tool used in the Business Intelligence Industry
- Tableau is a people in Business Intelligence Industry
- Tableau is suitable for factory industry only
- Tableau is a new alternative for data programming

**Answer:** A) Tableau is a powerful and fastest growing data visualization tool used in the Business Intelligence Industry

**Explanation:**

Tableau is a powerful and fastest growing data visualization tool used in the Business Intelligence Industry. Tableau is a visual analytics platform that is revolutionizing the way we use data to solve problems. It is enabling individuals and organizations to make the most of their information.

**12. Tableau displays measures over time as a ___.**

- Bar
- Line
- Histogram
- Scatter Plots

**Answer:** B) Line

**Explanation:**

As a series of Lines, the tableau displays the progression of measurements over time. Tableau categorizes data into two types: dimensions and measures. Dimensions are the dimensions of the data, while measures are the measures of the data. In most cases, dimensions are fields that cannot be aggregated; measures, on the other hand, are those fields that can be measured, aggregated, or used in mathematical operations, as the name suggests.

**13. Amongst which of the following is / are the file extensions in Tableau?**

- .twb
- .twbx
- .tds
- All of the mentioned above

**Answer:** D) All of the mentioned above

**Explanation:**

TWB (Tableau Workbook), TDS(Tableau Data Source), TDE(Tableau Data Extract), TWBX(Tableau Packaged Workbook), TDSX(Tableau Packaged Data Source), TBM(Tableau Bookmark), TDC(Tableau Data source Connection) , TMS(Tableau Map Source), and TPS(Tableau Preferences) are some of the file extensions in Tableau.

**14. Amongst which of the following is / are the components of an interactive Dashboard in Tableau?**

- Vertical
- Horizontal
- Image Extract
- All of the mentioned above

**Answer:** D) All of the mentioned above

**Explanation:**

Vertical, Horizontal and Image Extract are the common components of an interactive Dashboard in Tableau?

**15. Amongst which of the following is not a Pattern Line display?**

- Binomial Pattern Line
- Multiple Pattern Line
- Straight directed Pattern Line
- None of the mentioned above

**Answer:** A) Binomial Pattern Line

**Explanation:**

Binomial Pattern Line is not a Pattern Line display. Generally, trend lines can be displayed in a visualization to draw attention to patterns in our data. In order to edit a view that contains trend lines on the web, we can publish the view with trend lines and then add trend lines to the view as we wish. When we add trend lines to a view, we have the ability to specify how they should appear and behave.

**16. Sets can be made on Measures?**

- Yes
- No

**Answer:** B) No

**Explanation:**

No, sets can be made on measures. It is possible to compare and ask questions about a subset of data when using sets. The term “set” refers to a custom field that defines a subset of data based on a set of conditions. Set Actions allow us to make sets more dynamic and interactive by incorporating them into our program. When our audience interacts directly with a visualization or dashboard, they can control various aspects of their investigation. When a user selects marks in the view, set actions can be executed, which can change the values in the set.

**17. A bullet graph is a variation of a bar graph developed to replace dashboard gauges and meters?**

- True
- False

**Answer:** A) True

**Explanation:**

Bullet graphs are a type of bar graph that was created to replace dashboard gauges and meters. When comparing the performance of a major metric to one or more additional measures, a bullet graph is beneficial.

**18. Tableau displays data source connections and data fields for the workbook in the ___ on the left side of the workspace.**

- Data pane
- Basic Expression
- LoD Expression
- None of the above

**Answer:** A) Data pane

**Explanation:**

In the Data pane on the left side of the workspace, Tableau displays data source connections and data fields for the worksheet. The data source connections and fields display on the left side of the worksheet in the Data pane once we connect to our data and set up the data source using Tableau. The top of the Data pane displays the current data source connections. If there are many connections available, choose one to pick it and begin working with the data.

**19. Dimensions can be aggregated?**

- True
- False

**Answer:** B) False

**Explanation:**

We may aggregate measurements or dimensions in Tableau; however aggregate measures are more popular. By default, when we add a measure to our view, we apply an aggregation to that measure. Depending on the context of the view, the type of aggregate used differs.

**20. Which of the following is NOT a Tableau field data type?**

- String
- Number
- Float
- Boolean

**Answer:** C) Float

**Explanation:**

Float is not a Tableau field data type. The common data types are:

- String values
- Number/Integer values
- Date values
- Date & Time values
- Boolean values
- Geographic values
- Cluster or mixed values

**21. This data type consists of both integer type and floating type.**

- Numeric Data type
- Date and Time Data type
- Boolean Data type
- None of the mentioned above

**Answer:** D) None of the mentioned above

**Explanation:**

Numeric Data type consists of both integer type and floating type. Integer types are preferred over floating types by users because it is difficult to accumulate the decimal point over a certain limit. It also has a method called Round() that may be used to round up float numbers.

**22. Can Tableau be installed on MacOS?**

- Yes
- No

**Answer:** A) Yes

**Explanation:**

Tableau can be installed on MacOS. Tableau Desktop licences may be installed on up to two PCs, so we could use one for Windows at work and another for our Mac at home. Tableau Desktop for Windows files will work on Tableau Desktop for Mac, and vice versa.

**23. Default aggregation used for tree map.**

- Avg
- Sum
- Count
- Countd

**Answer:** B) Sum

**Explanation:**

Sum is a default aggregation used for tree map. We may aggregate measurements or dimensions in Tableau, however aggregate measures are more popular. By default, when we add a measure to our view, we apply an aggregation to that measure. Depending on the context of the view, the type of aggregate used differs.

**24. Which of the following allows tableau publicly accessible?**

- Tableau Reader
- Tableau Desktop
- Tableau Public
- None of Above

**Answer:** C) Tableau Public

**Explanation:**

Tableau Public allows it publicly accessible. Tableau Public is a free online platform for exploring, creating, and sharing data visualizations. Tableau Public makes learning data skills simple by providing access to the world’s biggest archive of data representations.

**25. A sheet cannot be used within a story directly. Either sheets should be used within a dashboard, or a dashboard should be used within a story.**

- True
- False

**Answer:** B) False

**Explanation:**

Tableau uses a workbook and sheet file structure, much like Microsoft Excel. Tableau follows Microsoft Excel’s workbook and sheet file structure. Sheets are included in a workbook. A story is made up of a series of worksheets or dashboards that provide information. In the sidebar, you’ll find the story and Layout windows.

**26. Which one is not the best fitted for Tableau?**

- Self Service BI
- Mobile enablement
- Big Data connectivity
- Enterprise Deployment

**Answer:** D) Enterprise Deployment

**Explanation:**

Tableau is a Business Intelligence solution that allows users to visualize data. Users can construct and share an interactive and shareable dashboard that displays the data’s trends, variances, and density in graphs and charts. To acquire and process data, Tableau may connect to files, relational databases, and Big Data sources.

**27. Which type of chart is not available in Tableau V8?**

- Pie Chart
- Speed Dial
- Bullet Chart
- Bubble Chart

**Answer:** B) Speed Dial

**Explanation:**

Speed Dial chart is not available in Tableau V8.

**28. Tableau Desktop is a ___ application and anyone can use it.**

- Spark based
- Business analytics
- Traditional based
- None of the mentioned above

**Answer:** B) Business analytics

**Explanation:**

Anyone may use Tableau Desktop, which is a business analytics solution. Tableau Desktop is a data visualization tool that allows us to quickly explore almost any type of structured data and create highly interactive, stunning graphs, dashboards, and reports.

**29. Tableau Server is a ___ that offers ___ anyone can utilize.**

- Business intelligence application, browser-based analytics
- Application development, customer oriented
- Runs on browser, server development and control system devices
- All of the mentioned above

**Answer:** A) Business intelligence application, browser-based analytics

**Explanation:**

Tableau Server is a business intelligence program that provides anyone with browser-based analytics. It’s a lightning-fast alternative to typical business intelligence tools. It is a web-based tool for sharing, distributing, and collaborating on Tableau material.

**30. What makes Tableau different?**

- There is no scripting required
- Everyone can use it and grow to be an analytics expert
- Get quick insights from data with interactive visualization
- All of the mentioned above

**Answer:** D) All of the mentioned above

**Explanation:**

Tableau is different from other applications because in this; there is no scripting required. Everyone can use it and grow to be an analytics expert; we can get quick insights from data with interactive visualization.

**31. Amongst which of the following is / are true about Tableau Online?**

- Tableau Online is a secure, cloud-based solution
- It can be used for sharing, distributing, and collaborating on Tableau views
- We can create interactive Tableau dashboards.
- All of the mentioned above

**Answer:** D) All of the mentioned above

**Explanation:**

Tableau Online is a cloud-based, secure solution. Tableau views can be shared, distributed, and collaborated on using this tool. Tableau dashboards may be made interactive. Tableau Online is a powerful cloud-based data visualization tool that allows us to operate without the need for servers, server software, or IT help. It makes rapid-fire business analytics more accessible than ever before. In minutes, share dashboards with team members, customers, and partners.

**32. Tableau Public is a ___ to facilitate users to create interactive data visualizations.**

- Freeware application
- Paid application
- Not Secure application
- None of the mentioned above

**Answer:** A) Freeware application

**Explanation:**

Tableau Public is a free software program that allows users to create interactive data representations. It is provided as a service, allowing the user to be up and running the next day. Users can create great interactive graphics and publish them rapidly using Tableau Public, without the need for programmers or IT. It’s made for businesses who want to add interactive data visualizations to their websites.

**33. A worksheet contains a single view along with shelves, cards, legends, and the Data?**

- True
- False

**Answer:** A) True

**Explanation:**

A worksheet’s side bar comprises a single view, as well as shelves, cards, legends, and the Data and Analytics panes. In the Tableau screen, the worksheet is where we develop the data analysis views. When we make a connection to a data source, Tableau creates three blank worksheets by default. We can continue to add worksheets to examine different data views in the same screen, one after the other.

**34. Data extraction in Tableau creates a subset of data from the ___.**

- Data view
- Data source
- Data pane
- None of the mentioned above

**Answer:** B) Data source

**Explanation:**

Tableau creates a subset of data from the data source by extracting it. This is useful for enhancing performance through the usage of filters. It also aids in the application of Tableau capabilities to data that may not be present in the data source, such as discovering distinct values in the data. The data extract function, on the other hand, is most commonly used to create an extract that can be saved to the local drive and accessed by Tableau offline.

**35. A dashboard is a collection of ___.**

- Views
- Hash function
- Both A and B
- None of the mentioned above

**Answer:** A) Views

**Explanation:**

A dashboard is a visual representation of numerous worksheet views. In the sidebar, we can find the Dashboard and Layout panes.

**36. We can aggregate a dimension in the view as Minimum, Maximum, Count, or Count?**

- True
- False

**Answer:** A) True

**Explanation:**

In the view, we can aggregate a dimension as Minimum, Maximum, Count, or Count. When we aggregate a dimension, we establish a new temporary measure column, which gives the dimension measure-like features.

**37. Dimensions are displayed above the gray line and measures below the gray line?**

- True
- False

**Answer:** A) True

**Explanation:**

For each table or folder, the dimensions are presented above the grey line, and the measurements are displayed below the grey line. A table or folder may have only dimensions or measures to begin with in some situations. If all of the input fields for calculated fields come from the same table, they are listed with their originating field.

The table with the originating field is used to list the sets. Parameters are displayed in the Parameters box and are global to the workbook. Fields that do not belong to a certain table are displayed below the tables in the general section. Calculations that use fields from various tables, Measure Names, and Measure Values are examples of these.

**38. A bullet chart is a variation of?**

- Bar chart
- Pie Chart
- Gantt Chart
- None of the mentioned above

**Answer:** A) Bar chart

**Explanation:**

A bullet chart is a variation of Bar chart. A bar chart shows data as rectangular bars, with the length of each bar proportional to the variable’s value. When you drag a dimension to the Row shelf and a measure to the Column shelf, Tableau automatically creates a bar chart. The bar chart option in the Show Me button can also be used. This option will be automatically greyed out if the data is not suitable for a bar chart.

**39. In Tableau, a crosstab chart is also known as ___.**

- Text table
- Field table
- Both A and B
- None of the mentioned above

**Answer:** A) Text table

**Explanation:**

In Tableau, a crosstab chart is also known as a Text table because it displays data in textual format. One or more dimensions and one or more metrics make up the chart. This chart can also display other calculations on the measure field’s data, such as a running total, % total, and so on.

**40. A ___ represents the frequencies of values of a variable bucketed into ranges.**

- Histogram
- Gantt Chart
- Box Plot
- None of the mentioned above

**Answer:** A) Histogram

**Explanation:**

The frequency of values of a variable bucketed into ranges is represented by a histogram. Similar to a bar chart, a histogram arranges values into continuous ranges. The height of each bar in a histogram represents the number of items present in that range. Tableau generates a histogram from a single metric. It adds a bin field for the measure that was used to make the histogram.

**41. Amongst which of the following is / are true about Tableau story?**

- To tell a data narrative
- Demonstrate how decisions relate to outcomes
- To make a compelling case
- All of the mentioned above

**Answer:** D) All of the mentioned above

**Explanation:**

A story in Tableau is a collection of graphics that work together to convey data. We can use stories to communicate a data storey, provide context, show how decisions affect results, or simply make a strong argument. A storey is a sheet, the same techniques that we use to create, identify, and manage worksheets and dashboards apply to tales as well. A story is also a collection of sheets that are placed in a specific order. A storey point is the name given to each individual sheet in a storey.

**42. ___, connects several distinct data points, presenting them as one continuous evolution.**

- Scatter Plot
- Pie Chart
- The line chart or line graph
- All of the mentioned above

**Answer:** C) The line chart or line graph

**Explanation:**

The line chart, also known as a line graph, joins multiple data points to portray them as a single continuous progression. Line charts are used to visualise data trends, usually across time. As a result, there’s a simple, plain way to see how one value changes in relation to another.

**43. Bar charts are one of the most common data visualizations?**

- True
- False

**Answer:** A) True

**Explanation:**

One of the most used data visualizations is bar charts. We may use them to easily compare data across categories, highlight discrepancies, disclose historical highs and lows, and identify trends and outliers. When we have data that can be divided into several categories, bar charts are very useful.

**44. ___ are a powerful and compact way to visualize hierarchical and part-to-whole relationships.**

- Histogram
- Treemaps
- Bar charts
- None of the mentioned above

**Answer:** B) Treemaps

**Explanation:**

Treemaps are a great technique to represent hierarchical and part-to-whole relationships in a small space. Each tree branch is shown as a rectangle, with the size of each branch proportional to a defined data metric. Many people prefer treemaps because they’re visually appealing, so knowing how to use colour is advantageous. In a treemap, colour is frequently used to indicate dimensions; heat maps are useful for displaying a spectrum.

**45. ___ plot the number of occurrences of a given variable in a set of data.**

- Treemaps
- Histograms
- Pie charts
- None of the mentioned above

**Answer:** B) Histograms

**Explanation:**

The number of occurrences of a specific variable in a collection of data is plotted in a histogram. They’re a terrific way to get a quick overview of a variable’s complete distribution, and they look like a bar chart.

**46. Amongst which of the following shows in Box plot?**

- First quartile
- Median
- Outliers
- All of the mentioned above

**Answer:** D) All of the mentioned above

**Explanation:**

A box plot or box-and-whisker plot is a diagram of a distribution of data best known to highlight first quartile, median, third quartile, whiskers, and outlier’s values. Box plots are excellent for comparing sets of data, particularly data fluctuations. They’re a statistician’s favorite and are frequently utilized in statistical analytics. Tableau can display hundreds of thousands of rows per second, allowing it to convey far more data than a traditional box plot.

**47. ___ is a simple and compelling way to show how location correlates with trends in our data.**

- Map
- Treemaps
- Histograms
- None of the mentioned above

**Answer:** A) Map

**Explanation:**

Maps are a simple and engaging approach to display how location connects with patterns in our data if we have geographic information connected with our data. Whether it’s postal codes, state abbreviations, country names, or our own unique geocoding, maps are a no-brainer for showing any kind of location information.

**48. Gantt charts display a project schedule or show changes in activity over time?**

- True
- False

**Answer:** A) True

**Explanation:**

Gantt charts are used to indicate variations in activity over time or to display a project timeline. A Gantt chart depicts the actions that must be accomplished before others can begin, as well as the distribution of resources.

**49. Word clouds are like bubble charts in that words are sized according to some numerical measure?**

- True
- False

**Answer:** A) True

**Explanation:**

Word clouds are similar to bubble charts in that words are sized using a numerical scale and crammed into a certain area. They’re great for presenting information on, you guessed it, words. While word clouds aren’t ideal for correct interpretation, they can help a dashboard stand out and inspire more people to interact with the data.

**50. Density maps reveal ___.**

- Data storage
- Patterns
- Data demonstration
- None of the mentioned above

**Answer:** B) Patterns

**Explanation:**

Density maps let us discover locations with more or fewer data points by revealing patterns or relative concentrations that could otherwise be buried owing to an overlapping mark on a map. When working with a data set comprising many data points in a small geographic area, density maps are most useful.