Questions from Analytics

Q: 1. Which items would be currently out of scope for Data

1. Which items would be currently out of scope for Data Analytics? a. Direct observation of processes b. Evaluation of time stamps to evaluate workflow c. Evaluation of phantom vendors d. Duplicate pa...

Q: In the ETL process, the first step is extracting the data

In the ETL process, the first step is extracting the data. When you are obtaining the data yourself, what are the steps to identifying the data that you need to extract?

Q: 1. What would you consider to be Financial Performance KPIs?

1. What would you consider to be Financial Performance KPIs? a. Total Shareholder Return b. Customer Profitability Score c. Market Growth Rate d. Klout Score 2. What would you consider to be an Operat...

Q: 1. The DuPont analysis of return on equity (ROE)

1. The DuPont analysis of return on equity (ROE) includes all of the following component ratios except: a. Asset turnover. b. Inventory turnover. c. Financial leverage. d. Profit margin. 2. XBRL stand...

Q: 1. Big Data is often described by the three Vs,

1. Big Data is often described by the three Vs, or a. Volume, velocity, and variability. b. Volume, velocity, and variety. c. Volume, volatility, and variability. d. Variability, velocity, and variety...

Q: 1. Mastering the data can also be described via the ETL

1. Mastering the data can also be described via the ETL process. The ETL process stands for: a. Extract, total, and load data. b. Enter, transform, and load data. c. Extract, transform, and load data....

Q: Download the rejected loans dataset of LendingClub data titled “Reject Stats

Download the rejected loans dataset of LendingClub data titled “Reject Stats A Ready” from the Connect website and do an Excel PivotTable by state; then figure out the number of rejected applications...

Q: Consider the 2013 declined loan data from LendingClub titled “RejectStatsB2013”

Consider the 2013 declined loan data from LendingClub titled “RejectStatsB2013” from the Connect website. Similar to the analysis done in the chapter, let’s scrub the risk score data. First, because o...

Q: Consider the 2013 declined loan data from LendingClub titled “RejectStatsB2013.”

Consider the 2013 declined loan data from LendingClub titled “RejectStatsB2013.” Similar to the analysis done in the chapter, let’s scrub the debt-to-income data. Because our analysis requires risk sc...

Q: Consider the 2013 declined loan data from Lending Club titled “RejectStatsB2013

Consider the 2013 declined loan data from Lending Club titled “RejectStatsB2013.” Similar to the analysis done in the chapter, let’s scrub the employment length. Because our analysis requires risk sco...