Page 377 -

Chapter 9 Business Intelligence Systems
376

Figure 9-4a
Sample Extracted Data: Order
Extract Table
Source: © Access 2013, Microsoft
Corporation

Acquire Data

As shown in Figure 9-3, acquiring data is the first step in the BI process. In response to the team’s
request for data, the IS department extracted operational data to produce the following two tables:
Sales (CustomerName, Contact, Title, Bill Year, Number Orders, Units, Revenue, Source,
PartNumber)
Part (PartNumber, Shipping Weight, Vendor)

Sample data for these two tables is shown in Figure 9-4. As team members examined this
data, they concluded they had what they needed and actually wouldn’t need all of the data
columns in the Sales table. They were surprised that the data was divided into different billing
years, but because they planned to sum item sales over those years, that division wouldn’t affect
their analysis.

Figure 9-4b
Sample Extracted Data:
Part Data Table
Source: © Access 2013, Microsoft
Corporation