An analyst for a small business with multiple locations is using each location's quarterly sales reports from last year to create a single revenue report for the year. Which of the following data…

The correct answer is B. Data append. Data Append means stacking datasets that have the same structure (same columns) on top of each other, simply adding new rows from each dataset into one combined dataset. Since each location's quarterly sales report likely has the same columns (e.g., Date, Sales), appending the…

Data Mining

Question

An analyst for a small business with multiple locations is using each location's quarterly sales reports from last year to create a single revenue report for the year. Which of the following data mining techniques should the analyst use to complete this task?

Options

AData merge
BData append
CData blending
DData imputation

How the community answered

(39 responses)

B
92% (36)
C
5% (2)
D
3% (1)

Explanation

Data Append means stacking datasets that have the same structure (same columns) on top of each other, simply adding new rows from each dataset into one combined dataset. Since each location's quarterly sales report likely has the same columns (e.g., Date, Sales), appending the four quarterly reports for each location into a single table that includes all rows is the straightforward way to consolidate the data for the whole year.

Topics

#Data manipulation#Data integration#Data append#Data preparation

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice