Data Analytics Exam 2 Questions and
All Correct Answers.
Dimensions - Answer contain qualitative values (such as names, dates, or geographical data).
You can use dimensions to categorize, segment, and reveal the details in your data. Dimensions
affect the level of detail in the view
Measures - Answer contain numeric, quantitative values that you can measure. Measures
can be aggregated. When you drag a measure into the view, Tableau applies an aggregation to
that measure (by default)
Parameter - Answer a numerical measurement describing data from a population
Dashboard - Answer an information management tool that visually tracks, analyzes and
displays key performance indicators (KPI), metrics and key data points to monitor the health of a
business, department or specific process
Metadata - Answer ensures that we will be able find data, use data, and preserve and re-use
data in the future. Metadata summarizes basic information about data, making finding &
working with particular instances of data easier. Metadata can be created manually to be more
accurate, or automatically and contain more basic information
Jittering - Answer a technique for separating overlapping marks on a view. By giving marks
some extra room by separating them into different columns, hidden data is often revealed and it
is easier to visualize how the data points are distributed
Histogram - Answer represents the frequency distribution of continuous variables.
Conversely, a bar graph is a diagrammatic comparison of discrete variables. Histogram presents
numerical data whereas bar graph shows categorical data. The histogram is drawn in such a way
that there is no gap between the bars
Live Connection - Answer allows you real-time data. Any changes will be done at the Data
source end that will be directly available to the tableau desktop.
Live Connection: Pros - Answer Real-time updates, When you need up-to-the-minute data
Live Connection: Cons - Answer Databases are not always optimized for fast performance
(unlike extracts), other factors can affect speed, stress
, Extract File - Answer are kind of batch which needs to be refreshed from time to time to get
the updated data
Extract File: Pros - Answer Speeds up the workbook through optimization, Offline, Privacy,
Portability, Reduce, Load Filters
Extract File: Cons - Answer Snapshot, Size/Structure
Joint - Answer is used to combine columns from different tables
Union - Answer is used to combine row from different tables
Is Tableau Prep an ETL - Answer Tableau ETL is a very visual tool, allowing users involved in
data preparation to create effective data pipelines, whilst producing understandable analysis
and reports for executives. The reason ETL is such a critical part of modern data management is
that it allows all your data to be analyzed in one destination source.
Drill Down - Answer capability that takes the user from a more general view of the data to a
more specific one at the click of a mouse (Click on a state)
Star schema - Answer multidimensional model which is used for data warehouse. the fact
tables and the dimension tables are contained. Star schema is diagrammed by surrounding each
fact with its associated dimensions.
Preattentive attributes - Answer visual properties that we notice without using conscious
effort to do so. They are a very powerful tool in your data visualization toolbox - they determine
what your audience notices first when they look at your Power BI report. I.E. Length, width, size,
position, color hue, color intensity, etc.
Integrated Development Environment (IDE) - Answer is software for building applications
that combines common developer tools into a single graphical user interface (GUI).
Why are variables often described as "a chunk of computer memory"? - Answer it holds a
value. For example, int total holds a chunk of memory named total.
Open Source R - Answer the statistical programming language that data experts use for
everything from mapping broad social and marketing trends online to developing financial and
climate models that help drive our economies and communities.
Advantages of R - Answer Lower software cost
All Correct Answers.
Dimensions - Answer contain qualitative values (such as names, dates, or geographical data).
You can use dimensions to categorize, segment, and reveal the details in your data. Dimensions
affect the level of detail in the view
Measures - Answer contain numeric, quantitative values that you can measure. Measures
can be aggregated. When you drag a measure into the view, Tableau applies an aggregation to
that measure (by default)
Parameter - Answer a numerical measurement describing data from a population
Dashboard - Answer an information management tool that visually tracks, analyzes and
displays key performance indicators (KPI), metrics and key data points to monitor the health of a
business, department or specific process
Metadata - Answer ensures that we will be able find data, use data, and preserve and re-use
data in the future. Metadata summarizes basic information about data, making finding &
working with particular instances of data easier. Metadata can be created manually to be more
accurate, or automatically and contain more basic information
Jittering - Answer a technique for separating overlapping marks on a view. By giving marks
some extra room by separating them into different columns, hidden data is often revealed and it
is easier to visualize how the data points are distributed
Histogram - Answer represents the frequency distribution of continuous variables.
Conversely, a bar graph is a diagrammatic comparison of discrete variables. Histogram presents
numerical data whereas bar graph shows categorical data. The histogram is drawn in such a way
that there is no gap between the bars
Live Connection - Answer allows you real-time data. Any changes will be done at the Data
source end that will be directly available to the tableau desktop.
Live Connection: Pros - Answer Real-time updates, When you need up-to-the-minute data
Live Connection: Cons - Answer Databases are not always optimized for fast performance
(unlike extracts), other factors can affect speed, stress
, Extract File - Answer are kind of batch which needs to be refreshed from time to time to get
the updated data
Extract File: Pros - Answer Speeds up the workbook through optimization, Offline, Privacy,
Portability, Reduce, Load Filters
Extract File: Cons - Answer Snapshot, Size/Structure
Joint - Answer is used to combine columns from different tables
Union - Answer is used to combine row from different tables
Is Tableau Prep an ETL - Answer Tableau ETL is a very visual tool, allowing users involved in
data preparation to create effective data pipelines, whilst producing understandable analysis
and reports for executives. The reason ETL is such a critical part of modern data management is
that it allows all your data to be analyzed in one destination source.
Drill Down - Answer capability that takes the user from a more general view of the data to a
more specific one at the click of a mouse (Click on a state)
Star schema - Answer multidimensional model which is used for data warehouse. the fact
tables and the dimension tables are contained. Star schema is diagrammed by surrounding each
fact with its associated dimensions.
Preattentive attributes - Answer visual properties that we notice without using conscious
effort to do so. They are a very powerful tool in your data visualization toolbox - they determine
what your audience notices first when they look at your Power BI report. I.E. Length, width, size,
position, color hue, color intensity, etc.
Integrated Development Environment (IDE) - Answer is software for building applications
that combines common developer tools into a single graphical user interface (GUI).
Why are variables often described as "a chunk of computer memory"? - Answer it holds a
value. For example, int total holds a chunk of memory named total.
Open Source R - Answer the statistical programming language that data experts use for
everything from mapping broad social and marketing trends online to developing financial and
climate models that help drive our economies and communities.
Advantages of R - Answer Lower software cost
