Data Analytics Exam 2 with Complete
Solutions
Dimensions - ANS-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 - ANS-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 - ANS-a numerical measurement describing data from a population
Dashboard - ANS-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 - ANS-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 - ANS-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 - ANS-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
Disadvantages of R - ANS-The difficulty of use
Compatibility issues
Liabilities and warranties
Hidden costs
"<-" - ANS-means left assignment, binary
"=" - ANS-means equal to, binary
List - ANS-An R list is an object consisting of an ordered collection of objects known as
its components.
, Vector - ANS-R operates on named data structures. The simplest such structure is the
numeric vector, which is a single entity consisting of an ordered collection of numbers.
Matrix - ANS-A matrix is just an array with two subscripts. However it is such an
important special case it needs a separate discussion. R contains many operators and
functions that are available only for matrices.
Array - ANS-An array can be considered as a multiply subscripted collection of data
entries, for example numeric. R allows simple facilities for creating and handling arrays,
and in particular the special case of matrices.
Data Frame - ANS-A data frame is a list with class "data.frame". A data frame may for
many purposes be regarded as a matrix with columns possibly of differing modes and
attributes. It may be displayed in matrix form, and its rows and columns extracted using
matrix indexing conventions.
Object in R Programming - ANS-a data structure having some attributes and methods
which act on its attributes. Object can hold pairs of variables and values, also that object
model can be used for another object just different values
Variable in R Programming - ANS-can only hold one value (string, number, boolean
etc).
Vector Mode - ANS-allows you to produce a vector of a given length or mode. The
argument mode returns a list, expression, symbol, or any aliases. The vector mode is a
character string that names an atomic mode
Data Transformation - ANS-is the process of changing the format, structure, or values of
data. If you visualize two or more variables that are not evenly distributed across the
parameters, you end up with data points close by. For a better visualization it might be a
good idea to transform the data so it is more evenly distributed across the graph.
Live Connection - ANS-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 - ANS-Real-time updates, When you need up-to-the-minute data
Live Connection: Cons - ANS-Databases are not always optimized for fast performance
(unlike extracts), other factors can affect speed, stress
Extract File - ANS-are kind of batch which needs to be refreshed from time to time to
get the updated data
Solutions
Dimensions - ANS-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 - ANS-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 - ANS-a numerical measurement describing data from a population
Dashboard - ANS-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 - ANS-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 - ANS-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 - ANS-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
Disadvantages of R - ANS-The difficulty of use
Compatibility issues
Liabilities and warranties
Hidden costs
"<-" - ANS-means left assignment, binary
"=" - ANS-means equal to, binary
List - ANS-An R list is an object consisting of an ordered collection of objects known as
its components.
, Vector - ANS-R operates on named data structures. The simplest such structure is the
numeric vector, which is a single entity consisting of an ordered collection of numbers.
Matrix - ANS-A matrix is just an array with two subscripts. However it is such an
important special case it needs a separate discussion. R contains many operators and
functions that are available only for matrices.
Array - ANS-An array can be considered as a multiply subscripted collection of data
entries, for example numeric. R allows simple facilities for creating and handling arrays,
and in particular the special case of matrices.
Data Frame - ANS-A data frame is a list with class "data.frame". A data frame may for
many purposes be regarded as a matrix with columns possibly of differing modes and
attributes. It may be displayed in matrix form, and its rows and columns extracted using
matrix indexing conventions.
Object in R Programming - ANS-a data structure having some attributes and methods
which act on its attributes. Object can hold pairs of variables and values, also that object
model can be used for another object just different values
Variable in R Programming - ANS-can only hold one value (string, number, boolean
etc).
Vector Mode - ANS-allows you to produce a vector of a given length or mode. The
argument mode returns a list, expression, symbol, or any aliases. The vector mode is a
character string that names an atomic mode
Data Transformation - ANS-is the process of changing the format, structure, or values of
data. If you visualize two or more variables that are not evenly distributed across the
parameters, you end up with data points close by. For a better visualization it might be a
good idea to transform the data so it is more evenly distributed across the graph.
Live Connection - ANS-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 - ANS-Real-time updates, When you need up-to-the-minute data
Live Connection: Cons - ANS-Databases are not always optimized for fast performance
(unlike extracts), other factors can affect speed, stress
Extract File - ANS-are kind of batch which needs to be refreshed from time to time to
get the updated data
