Business Analytics Exam 1

Select the value "NA" from the "age_group" column.

Row > Row Selection

Aggregate the total number of COVID deaths, Male, and 70+ by Month

Table > Summary

Which data transformation process does this statement relate to? Who is our employee-of-the-month?

data query

Data visualization is the process of _____ data and _____ information in a visually appealing manner using tables, charts, maps, and dashboards.

presenting and conveying

What role does each of the following key features play in preliminary analysis? 1. A primary key 2. SQL 3. Summary 4. Highlights

1. Combines data from multiple tables in data query 2. Retrieves and combine data in a data query 3. Facilitates sense making in data reporting 4. Draws attention to issues in data reporting

What is the order of Data Hierarchy?

1. Date field 2. Date record 3. File 4. Database 5. Database management systems

What is the sequence of the decision making process?

1. Define a decision making situation 2. Determine the criteria used to evaluate alternative solutions 3. Identify alternative solutions 4. Evaluate each alternative using the chosen criteria 5. Choose one alternative

What are 4 characteristics of a business analytics approach to decision making?

1. fact-based 2. data-driven 3. scientific 4. computer-assisted

Which of the following is used to visualize COVID deaths by gender graphically in this application? Check all that apply.

A bar chart A pie chart A column chart

Compare two or more categorical variables simultaneously in a pair-wise fashion.

A contigency table

Make precise numerical comparisons.

A table

Compare multiple categorical variables where some variables have a large number of categories.

A treemap

Which of the following statements about data visualization is TRUE? A) "Never use a 3D chart if a 2D chart is sufficient" is an example of the "Keep it Simple" design principle. B) Data visualization can be used to identify data errors and outliers. C) General design principles are about knowing when to use tables instead of charts. D) A low data-ink ratio is indicative of a good design. E) Use tables instead of charts when making relative and approximate comparisons on performance of sales representatives. F) Data visualization can be used to display data relationships and patterns.

A) "Never use a 3D chart if a 2D chart is sufficient" is an example of the "Keep it Simple" design principle. B) Data visualization can be used to identify data errors and outliers. F) Data visualization can be used to display data relationships and patterns.

The Tableau workspace includes _____. A) Analytics pane B) Sheet tabs C) Menus D) Toolbar E) Files pane F) Side bar

A) Analytics pane B) Sheet tabs C) Menus D) Toolbar

What are the basic data visualization methods that you learned in this class? A) Bubble chart B) Biplot C) Table D) Dashboard E) Constellation plot F) Dendrogram G) Scatter plot matrix H) Heat map

A) Bubble chart C) Table G) Scatter plot matrix H) Heat map

The purpose of data cleansing is to ensure data in the data set is _____. A) Complete B) Biased C) Available D) Valid E) Accurate F) Legitimate

A) Complete E) Accurate F) Legitimate

A cross tab is also known as a _____. A) Contingency table B) Cross-over table C) Pivot table D) Two-way table E) 3D table

A) Contingency table C) Pivot table D) Two-Way table

Which 3 of the following Business Analytics functionalities will be covered in this class? A) Data analysis B) Data warehousing C) Data reporting D) Data pre-processing E) Data management F) Data outsourcing

A) Data analysis C) Data reporting D) Data pre-processing

Which 2 of the following tasks is included in preliminary analysis? A) Data reporting B) Data pre-processing C) Data query D) Data analysis E) Data acquisition

A) Data reporting C) Data query

Which of the following is a means to evaluate the effectiveness of a visual design? A) Data-ink ratio B) Suitability C) Accessibility D) General design principles E) Usability

A) Data-ink ratio D) General design principles

Which of the following is TRUE about primary data? A) First-hand data B) Open-source data C) Properitary data D) Collected indirectly by someone else E) Collected directly from the data's source F) Managed by a database management systems G) Second-hand data

A) First-hand data C) Properitary data E) Collected directly from the data's source F) Managed by a database management systems

Which of the following file types is compatible with JMP? A) HTML B) R code C) SPSS D) wp4 E) Excel F) Tableau G) Zip

A) HTML B) R code C) SPSS E) Excel

Which 1 of the following is a predictive analytics software tool? A) IBM SPSS Modeler B) Oracle C) Regression tree D) Simulation E) Time-Series forecasting

A) IBM SPSS Modeler

Which of the following is FALSE about JMP? A) It is a Business Analytics technique. B) You need to install Citrix Receiver in order to use it offline. C) It is a Business Analytics tool. D) You need to install the Pro version on your own device so you can use it offline. E) It cannot be accessed remotely. F) It was developed at SAS. G) You must have Internet access to use it. H) Its strength is in data visualization.

A) It is a Business Analytics technique. B) You need to install Citrix Receiver in order to use it offline. E) It cannot be accessed remotely. G) You must have Internet access to use it. H) Its strength is in data visualization.

Which 3 of the following is TRUE about JMP? A) It is developed at SAS. B) Its goal is to transform a world of data into intelligence. C) It is developed in 2003. D) Its goal is to make data understandable to ordinary people. E) It is developed in Stanford University. F) It is developed in 1989.

A) It is developed at SAS. B) Its goal is to transform a world of data into intelligence. C) It is developed in 1989.

Which of the following is FALSE about a dashboard? A) Only one key performance indicator is shown. B) It is interactive. C) All visuals should be viewed without scrolling. D) It is dynamic. E) It involves multiple screens.

A) Only one key performance indicator is shown E) It involves multiple screens

Which of the following statements about data visualization method is FALSE? A) Parallel coordinate plots work with numerical variables only. B) A tree map uses nested rectangles of varying sizes and/or color to visualize data along mulitiple dimensions. C) A scatter plot matrix works with numerical variables only. D) A dashboard uses colors, symbols, and bubbles to draw attention to KPIs in a static view. E) A geographical map cannot show categorical data. F) A heat map uses different shades of color to represent magnitude of data values.

A) Parallel coordinate plots work with numerical variables only. D) A dashboard uses colors, symbols, and bubbles to draw attention to KPIs in a static view. E) A geographical map cannot show categorical data.

Which of the following about the JMP Home Window is TRUE? A) The Help menu is where you will go to access sample data files. B) It has two panels: Recent Files and Window List. C) There is no way to stop the Tip of the Day window from popping up when JMP is launched. D) It has a menus of items such as File, Tables, Analyze, and Help across the top. E) To see an explanation of a specific part of the JMP Home window, you can point your cursor at that part of the window after you select Tools > Help.

A) The Help menu is where you will go to access sample data files. B) It has two panels: Recent Files and Window List. D) It has a menus of items such as File, Tables, Analyze, and Help across the top.

Which of the following is a distractor that should be avoided in visual design? A) Unnecessary use of colors B) Pictures C) Grammatical mistakes D) Large font size E) Misspellings

A) Unnecessary use of colors

The principles of good table design include _____. A) Use light shading to distinguish columns B) Align text values on the right C) Align numeric values on the left D) Avoid horizontal lines E) Use just enough precision

A) Use light shading to distinguish columns E) Use just enough precision

You should use a table when _____ . A) Values have very different magnitudes. B) Values are measured using different units. C) Focus is on specific categorical values. D) Focus is on specific numeric values. E) Focus is on relative numeric values.

A) Values have very different magnitudes B) Values are measured using different units D) Focus is on specific numeric values

Which 3 of the following is TRUE if you install a personal copy of JMP Pro on your own laptop? A) You will save your work locally. B) You will need to renew your license after this course. C) You will access JMP Pro locally. D) You will need to install Citrix Receiver. E) You will access JM Pro remotely. F) You will need to renew your license annually.

A) You will save your work locally. C) You will access JMP Pro locally. F) You will need to renew your license annually.

Which of the following is TRUE about Business Analytics techniques?

An answer to "what could happen" type of questions can be found by using forecasting techniques such as time-series analysis.

The Tableau workspace includes _____. Check all that apply.

Analytics pane Sheet tabs Menus Toolbar

Use a table to show the frequency distribution of "Female" and "Male" COVID deaths.

Analyze > Tabulate

Which of the following statements about data visualization method is FALSE? A) A Tree Map uses nested rectangles of varying sizes and color to visualize data along multiple dimensions. B) A Parallel Coordinate Plot displays values of multiple Categorical Variables using the lengths/heights of each bar relative to the others. C) A Geographical Map cannot show Categorical data. D) A Heat Map uses different shades of color to represent magnitudes of data values. E) A Dashboard uses colors, symbols, and bubbles to draw attention to KPIs in a static view. F) A Scatter Plot Matrix works with numerical variables only.

B) A Parallel Coordinate Plot displays values of multiple Categorical Variables using the lengths/heights of each bar relative to the others. C) A Geographical Map cannot show Categorical data. E) A Dashboard uses colors, symbols, and bubbles to draw attention to KPIs in a static view.

Which 2 of the following tasks is included in data preparation? A) Data analysis B) Data pre-processing C) Data acquistion D) Data reporting E) Data query

B) Data pre-processing C) Data acquistion

Which 1 of the following is a prescriptive analytics technique? A) Cluster analysis B) Decison rules C) Linear regression D) What-If analysis E) Simulation

B) Decison rules

Which of the following is an advanced data visualization method that you learned in this class? A) Box plot B) Geographical map C) Biplot D) Tree map E) Parallel coordinate plot F) Heat map

B) Geographical map D) Tree map E) Parallel coordinate plot

Which of the following is the definition of decision making you learned from this class? A) It is to maximize profit. B) It is to choose among alternative courses of action to improve organization performance. C) It is to provide leadership for an organization. D) It is to minimize costs. E) It is to make successful business plans.

B) It is to choose among alternative courses of action to improve organization performance.

Which of the following is TRUE about a tree map? A) It is useful for displaying trends and correlations. B) It is useful for visualzing hierarchical data along multiple dimensions. C) It conveys values of multiple numerical variables associated with each value of a categorical variable. D) It uses lines and color to convey information. E) It uses varying sizes and/or color of a rectangular area to convey information

B) It is useful for visualzing hierarchical data along multiple dimensions. E) It uses varying sizes and/or color of a rectangular area to convey information

Which of the following is FALSE about a geographical map? A) It requires mapping data. B) It shows locations in the U.S. only. C) It captures spatial information. D) It does not support color. E) It cannot represent categorical data

B) It shows locations in the U.S. only D) It does not support color E) It cannot represent categorical data

What anomalies are needed to be detected in cleansing data acquired in this case? A) Duplication B) Outliers C) Primary source D) Missing values E) Dimension reduction

B) Outliers D) Missing Values

Method used to count the number of observations in each category?

Bar Chart

Method used to show the relationship among three variables in a two-dimensional space?

Bubble Chart

Data visualization is useful for _____. A) Detecting duplicates B) Detecting falsified data C) Detecting data errors D) Detecting missing values E) Detecting outliers

C) Detecting data errors E) Detecting outliers

We discussed many business analytics applications in various business domain in this class. Which 2 of the following is explicitly cited as an illustrative example? A) Artificial intelligence B) Accounting C) Health care D) Statistics E) Sports

C) Health care E) Sports

Which of the following is TRUE about data preparation? A) It consists of Data Query and Data Reporting. B) Secondary data is the sole source of data acquisition. C) It is to ensure the right data is collected to meet quality and suitability requirements. D) It consists of Data Acquisition and Data Pre-Processing.

C) It is to ensure the right data is collected to meet quality and suitability requirements. D) It consists of Data Acquisition and Data Pre-Processing.

An example of a database management systems is: A) SPSS B) Rapidminer C) Oracle D) Tableau E) JMP

C) Oracle

Descriptive analytics techniques include the following EXCEPT: A) What-If analysis B) Data-mining C) Simulations D) Data queries E) Reports

C) Simulations

When identifying the source of your data, the 3 factors to be considered include? A) Variety B) Volume C) Time D) Cost E) Veracity F) Availabilty

C) Time D) Cost F) Availabilty

Which 3 of the following are characteristics of big data? A) Validity B) Valence C) Volume D) Variety E) Vitality F) Veracity

C) Volume D) Variety F) Veracity

What other methods can you use to visualize the data in the cross tab table? Check all that apply.

Clustered column charts. Stacked column charts.

Which of the following is used to perform dimension reduction in JMP?

Cols > Delete Columns

Method used to summarize two or more categorical variables in a pairwise fashion?

Cross-Tab

Which of the following is used to perform dimension reduction in JMP? A) Analysis > Distribution B) Cols > New Columns C) Rows > Row Selection D) Cols > Delete Columns E) Cols > Distribution

D) Cols > Delete Columns

Which of the following is TRUE about Tableau? A) It is developed at SAS. B) It is developed in 1989. C) Its goal is to transform a world of data into intelligence. D) It is developed at Stanford University. E) It is developed in 2003. F) Its goal is to make data understandable to ordinary people.

D) It is developed at Stanford University. E) It is developed in 2003. F) Its goal is to make data understandable to ordinary people.

What is the Business Analytics approach for managerial decision making? A) It is to make experience-based decisions. B) It is to follow traditions in making decisions. C) It is to fully automate decision making. D) It is to improve business performance by transforming data into actionable insights. E) It is to completely do away with a subjective approach to decision making. F) It is to make evidence-based decisions.

D) It is to improve business performance by transforming data into actionable insights. F) It is to make evidence-based decisions.

Which of the following is TRUE about a parallel coordinate plot? A) It is useful for displaying values of multiple numerical variables associated with each value of a numerical varaiable.. B) It is useful for displaying summary statistics. C) It uses bubbles to capture the magnitude of the variables. D) It is useful for displaying values of three or more numerical variables associated with each value of a categorical varaiable. E) It uses lines to convey information. F) It captures spatial information

D) It is useful for displaying values of three or more numerical variables associated with each value of a categorical varaiable. E) It uses lines to convey information.

The following techniques go with which data pre-processing function? 1. Imputation 2. Recoding 3. Omission

Data Cleansing

The age field of the customer table is removed because we can always compute a custmer's age from his/her data of birth.

Data dimension reduction

The following techniques go with which data pre-processing function? 1. Binning 2. Dimension reduction 3. Mathematical manipulation

Data modification

It involves two steps: data cleansing and data modification.

Data pre-processing

The misspelling of a customer's name is corrected.

Data recoding

Which concept does this following statement illustrate? We rely solely on our CEO's feeling to promote the next year's assortment of products.

Decision making based on intuition.

What type of analytics asks "What has happened?"

Descriptive Analytics

Build a bar chart to show the frequency distribution of COVID deaths by gender.

Graph > Graph Builder

Method used to discover the relationship between two numeric variables?

Line Chart

Which concept does this statement define? It is a software called database management systems.

Oracle

Which concept does this following statement illustrate? We use SQL to find our most profitable customers.

Perform data query to answer what has happened questions

What type of analytics asks "What could happen?"

Predictive Analytics

Which concept does this following statement illustrate? We use a sophisticated software tool to predict employee turnover and retention.

Predictive analytics application in human resource.

What type of analytics asks "What should happen?"

Prescriptive Analytics

Which concept does this statement define? It is data collected directly from business transactions.

Primary Data

Which concept does this statement define? It combines relevant data from multiple tables into a single one for data analysis.

Query

Which concept does this statement define? It replaces data values with legitimate and correct ones.

Recording

Method used to show how multiple numerical variables are related to each other in one comprehensive visual?

Scatter plot matrix

SAS stands for _____.

Statistical Analysis Systems

What does SQL stand for?

Structured Query Language

Create a table that contains only the selected categories of sex, gender, and ethnicity.

Tables > Subset

Build a dashboard using the geographical map, heat map, and tree map you created in the previous questions. Which of the following statements is TRUE?

The dashboard shows all three visuals simultaneously in a dynamic fashion.

True or False? The source of data acquired in this application is secondary.

True

Which concept does this statement define? It is at the lowest level of the data hierarchy.

Variable

Which concept does this following statement illustrate? We have millions rows of customer data in numbers, text, audio, video, pictures. and other multi-media format.

Volume and variety of big data.

What is the most appropriate data visualization method can be used to convey the following information? Display the relationship among sleep time, screen time, and academic performance on a two-dimensional space.

a bubble chart

What is the most appropriate data visualization method can be used to convey the following information? Distinguish high performers from laggards using color gradations in presenting weekly performance data.

a heat map

What is the most appropriate data visualization method can be used to convey the following information? Compare demand for cupcakes over time.

a line chart

What is the most appropriate data visualization method can be used to convey the following information? Displays lines connecting the values of Sales, Profit, Number-of-Employees, and Years-in-Business associated with each value of Company-Size.

a parallel coordinate

What is the most appropriate data visualization method can be used to convey the following information? Compare the number of students in each Major as a percentage of a whole.

a pie chart

What is the most appropriate data visualization method can be used to convey the following information? Compare the number of employees by job title for the last five years

a stacked or clustered column chart

What is the most appropriate data visualization method can be used to convey the following information? Display height, weight, body temperature, and blood pressure of all patients.

a table

A data table organizes data into _____ and _____ .

columns and rows

Which data transformation process does this statement relate to? A customer is 1,000 years old.

data cleansing

Which data transformation process does this statement relate to? The age field of the customer table is removed because we can always compute a customer's age from his/her data of birth.

data dimension reduction

Which data transformation process does this statement relate to? The missing income of a customer is replaced with the average income of all customers.

data imputation

We can use treemap to answer

geo map question

A _____ uses_____ colors to depict magnitude of data values.

heat map and color shades

To visualize the relationship between COVID deaths and the three demographic risk factors.

scatter plot matrix

Business Analytics tools are essentially _____.

software

We can use pie chart

to answer line chart question

We can use bar chart

to answer pie chart question

Which of the following is used to compare COVID deaths by gender, age, and ethnicity on one chart in this application?

treemap

Track changes of a numeric variable over time.

A line chart

A data column is also known as a _____.

data variable