ITM 209 Quiz Terms
What type of analytics are used when creating a bar chart showing the top se3lling real estate agents in the state and the amount of sales they had in the past month? Descriptive Analytics Predictive Analytics Diagnostic Analytics Prescriptive Analytics
Descriptive analytics
Jackson has a set of data that lists profits for a particular product line based upon each of the states in which the products are sold. The range of values (by state) vary from $-128,319.34 to $267,987 for the month of April. Which of the following color schemes would be the best option for him to use the profits for each state? Categorical Sequential Highlight Diverging
Diverging
if the following join statement is used to join two tables in a query, which of the following tables would all the tuples in the relation appear in results? left outer join schema.customers on invoice.customerID = customer.customerID
Invoices
continuous data
Numerical data values that can be MEASURED
How would you sort MySQL query results by a field called "lastName" from a table called "cashiers" from named "store"?
ORDER BY cashiers.lastName
1:1
One to one Example People ----> physical attributes (Height, weight, eye color)
inner join
The INNER JOIN keyword selects records that have matching values in both tables.
You are creating a line graph showing the number of students that have graduated from MSU over time. You want the line to show a running today of number of students. Which Tableau feature would make this task easy?
Quick table Calculation
DATEDIFF
Returns the number of days between two dates
GROUP BY
The level of aggregation at which calculations or aggregated functions are applied. This must have at least one field and can specify additional fields. Data will be grouped by based upon the order of the fields listed. The GROUP BY statement is often used with aggregate functions (COUNT(), MAX(), MIN(), SUM(), AVG()) to group the result-set by one or more columns.
What chart type would be the best to show the hierarchical nature of data
Tree map
Count
aggregation function shows the number of records that meet a set of criteria
What SQL command allows you to rename your column heading?
as
Symmetric Key Encryption
involves one key for both encryption and decryption.
TPS
transaction processing system
Data Aggregation
Collecting information from many sources and storing them together into a single location is referred to as
HAVING
Criteria for filtering on aggregated or calculated fields. Can list as many fields and operators as needed. Order of logical operators (i.e. and / or) can be specified by using parenthesis to group together.
Describe what trendlines are
A feature that shows a line that represents the relationships between a set of data points that have been plotted
Primary key (SQL)
A field (or group of fields) that uniquely identifies a given entity in a table
Hermann Effect
A grid illusion is any kind of grid that deceives a person's vision
How many rows will you return in the following statement of code: select count(consulatants.ID) from teleworks.consultatns;
1
What is the order of commands in a SQL query? table.column condition(x>10) schema.table Select from where
1. Select 2. table.column 3. from 4. scheme.table 5. where 6. condition(x>10)
Flat database
A simple database file that is not related or linked to any other collection of data.
data element
The smallest or basic unit of information
Diagnostic Analytics
Why did it happen?
In what relationship does the primary key in one table become a foreign key in a existing table
1:n
data lake (enterprise data hub)
A "store everything" approach to big data that saves all the data in its raw and unaltered form.
Foreign Key SQL
A primary key of one table that appears an attribute in another table and acts to provide a logical relationship among the two tables
Which of the following uses of color in visualization has contrasting colors for individual comparison? Highlight Diverging Sequential Categorical
Categorical
A diverging color scheme would be one the shades of a single color diverge T/F
False
In a SQL query if you were averaging grade points from a table of students grades for each of the classes they took (field studentClass.grade) and want to tlist those equal to or above a 3.0 you would utilizee the follwoing line in your query: where avg(studentClass.grade) >= 3.0 T/F?
False
You should never share a public key with anyone T/F
False
A colon punctuation mark (:) used to signify the end of query? T/F
False it's a semicolon(;)
Which of the following is decreased when using a relational database? Informational Redundancy Flexibility Scalability Security
Information Redundancy
Which of the following charts are good for showing data changes over time?
Line chart
Tree maps and heat maps use which of the following to show proportional size of values Size and color size and font orientation and size color and orientation
Size and color
Velocity of data
Speed of data analysis
Three primary transactional processing enterprise systems
Supply chain management Customer Relationship management Enterprise resource planning
The select clause of the statement is used to list the attributes desired in the result of a query T/F
T
When your write a string in a piece of SQL code to label your column heading you will always need to use apostrophe(``) or quotation ("") around it t/f
TRUE
Which of the following describes a scenario in which a concatenated key would be utilized? one to one relationship one to many relationship Tables where there are no foreign keys to identify unique records Tables where only a combination of two attributes combined can make a unique identifier for rows (tuples) in a table
Tables where only a combination of two attributes combined can make a unique identifier for rows (tuples) in a table
avg
The AVG() function returns the average value of a numeric column.
countof
The COUNT() function returns the number of rows that matches a specified criterion.
outer join
The FULL OUTER JOIN keyword returns all records when there is a match in left (table1) or right (table2) table records. Tip: FULL OUTER JOIN and FULL JOIN are the same.
WHERE
The WHERE clause is used to filter records. It is used to extract only those records that fulfill a specified condition. Where customer.customersName is null
In determining the average sales per unit sold, why is the aggregate function sum(sales)/sum(quantity) instead of sales/quantity
The correct version: takes the total sales and total quantity and determines the average across all unit sold, The wrong version: considers each line item of equal weight regardless of whether or not it has more or less quantity than other line items
Which of the following would you use to show information when you hover your mouse over a data point in a Tableau visualization? Size Color Label Tooltip
Tooltip
For the following piece of code we would use the having function: count(payment.payments) > 10 T/F
True
One example of discrete data is the number of computer in a computer lab T/F
True
one example of continuous data is height T/F
True
In a dashboard you would usually place the visualization that requires the most emphasis in which quadrant
Upper Right
If an individual would like to place a non-aggregate condition (such as country = 'US') in code that only results rows that fit certain criteria which of the following area would this code be place?
WHERE
relational database
a collection of data items with pre-defined relationships between them. These items are organized as a set of tables with columns and rows. ... Each row in a table could be marked with a unique identifier called a primary key, and rows among multiple tables can be made related using foreign keys.
You created a scatterplot in Tableau that contains plotted data points showing the number of class periods attended for a course vs. the grade assigned for students. You are trying to see if there is a positive relationship between the two. Which feature / function will best aid you in this?
adding trendlines to the scatter plot
Which fo the following features in Tableau is NOT found in the mark shelf? color label columns detail tooltip
columns
Gestalt Principles
consist of several principles that describe how the human brain sees visual information, namely - proximity, similarity, continuity, closure, connection, and enclosure
Metadata
data that describes other data
data dictionary
document that contains all of the metadata about the data elements in a database
Predictive Analytics
extracts information from data and uses it to predict future trends and identify behavioral patterns
predicitive analytics
extracts information from data and uses it to predict future trends and identify behavioral patterns
discrete data can take on any value within a range t/f
false
The three factors of the variety of data are:
form, function, source
Anscombe's Quartet
four datasets that have the same simple descriptive statistics (mean, median, ... ), yet appear very different when graphed.
Jacyln is writing a query that sums the profit by business line for her organization. For the sum to performed against each business line, she would use which of the following to specify the level of aggregation that sum should be executed against?
group by table.businessLine
discrete data
is information that can only take certain values. ... This type of data is often represented using tally charts, bar charts or pie charts. Continuous data is data that can take any value. Height, weight, temperature and length are all examples of continuous data.
Data Model
logical data structures that detail the relationships among data elements using graphics or pictures
Database
maintains information about various types of objects (inventory), events (transactions), people (employee) and places (warehouses)
Variety of data
numerical, text, audio, video
data redundancy
occurs when unnecessary duplicate information exists in a database
1:n
one to many The primary key of the "one" table is posted as the foreign key in the "Many" table customers ------> addresses
The operator LIKE in a SQL statement is used for:
pattern matching in a where clause
The three basic clauses of a SQL statement to select data are
select, from, where
Tree maps and heat maps use which of the following to show proportional size of values? size and color size and font orientation and size color and orientation
size and color
Veracity of data
the degree to which data is accurate, precise and trusted
Descriptive Analytics
the use of data to understand past and current business performance and make informed decisions
Hashing
transforming plaintext of any length into a short code called a hash
Moire effect
visual perception that occurs when viewing a set of lines or dots that is superimposed on another set of lines or dots, where the sets differ in relative size, angle, or spacing.
Out of the situations below which would be best performed using bar chart in tableau When showing proportions when investigating the relationship between different variables when viewing trends in data over time when comparing data across categories
when comparing data across categories
When is having used instead of where?
when groups are present through the use of an aggregate function (such as avg, count, etc.) and conditions need to be applied to the groups
F pattern
Users' eyes start scanning the page on the left-hand edge of design for a keyword or point of interest. - when something interesting is found, they read the line horizontally - loses effectiveness after first few rows
The columns in a table represent which of the following about an entity described in the table?
attributes
Which of the following is a challenge with symmetric encryption Management and distribution of keys creation of keys keeping your private key protected limits on data sizes that can be encrypted
management distribution of keys
SQL wildcards % [] _ ^
% represents zero or more characters bl% finds bl, black, blue, and blob [] allows you to look for a single character _ represents a single character h_t hit, hat, hot - range of characters (c[a-b]t finds cat and not cbt)
Zara is ready to by a house, so she decides to hire a real estate agent from East Lansing Realty. Each real estate agent works with several customers and the agent receives a commission on the sale of each house. However, East Lansing Realty has a policy that each customer can be assigned to no more than one real estate agent. This is an example of what type of relationship between customer and agent?
1:n
dual-axis chart
A chart that uses the left side (or top) of the chart as one value axis (y-axis) and the right side (or bottom) of the chart as a second value axis (y-axis)
bubble chart
A type of scatter plot with circular symbols used to compare three variables; the area of the circle indicates the value of a third variable
When loading data in Tableau which of the following types of data usually appears under measures?
Continuous
What is the where clause in a SQL statement used for
Criteria for filtering on fields (non-aggregated / non-calculated). Can list as many fields and operators as needed. Order of logical operators (i.e. and / or) can be specified by using parenthesis to group together.
Which of the following keywords when used in a SQL select statement will remove duplicate records from the results?
Distinct
asymmetric key encryption
Encryption system in which two keys are used: a public key used only to encrypt data, and a private key used only to decrypt it.
When building a dashboard which of the following would you consider when laying out your visualizations
F Pattern
If you are sending a message to a friend and you want to ensure confidentiality you would encrypt with your public key and they would use your private key to decrypt the message T/F
False
distinct
Inside a table, a column often contains many duplicate values; and sometimes you only want to list the different (distinct) values.
n:m
Many to many requires a third table which has two foreign keys that combined are a unique combination Students ---> class
left join
The LEFT JOIN keyword returns all records from the left table (table1), and the matching records from the right table (table2). The result is 0 records from the right side, if there is no match.
ORDER BY
The ORDER BY keyword is used to sort the result-set in ascending or descending order. The ORDER BY keyword sorts the records in ascending order by default. To sort the records in descending order, use the DESC keyword.
right join
The RIGHT JOIN keyword returns all records from the right table (table2), and the matching records from the left table (table1). The result is 0 records from the left side, if there is no match.
Penelope works for a prominent biomedical facility. Her boss, candy has asked her to create a dashboard showing the following 1. Total sales by product category for the products they produce 2. The total quantity of each product sold 3. Number of recalls due to quality issues by product 4. A map showing the countries and states/provinces in the world using color to highlight the area with the least and most sales 5. Top 12 customers of the company If applying the F pattern for design, which of the followoing would Penelope put in the lower right hand corner of the dashboard?
Top 12 customers of the company
bar chart
a chart with bars whose lengths are proportional to quantities
concatenated key (SQL)
a combination of two or more column values used to define a key in a table. two identifiers?
Tree Map
a diagram representing hierarchical data in the form of nested rectangles, the area of each corresponding to its numerical value. think of the sp 500 tree map
Scatterplot
a graphed cluster of dots, each of which represents the values of two variables
data warehouse
a place where databases are stored so that they are available when needed
Ceaser Cipher
a technique for encryption that shifts the alphabet by some number of characters
You created a scatterplot in Tableau that contains plotted data points showing the number of class periods attended for a course vs the grade assigned for students. you are trying to see if there is a positives relationship between the two which feature/function will best aid you in this?
adding trend lines to the scatterplot
In a family, there are 4 individuals and each individual is able to drive any of the famaily's three cars. what type of relationship is present between people and cars?
n:m
Prescriptive Analytics
techniques that create models indicating the best decision to make or course of action to take