Business Intelligence

Suppose your task as a software engineer at Company X is to design a data mining system to examine their internal data, which contains the following information such as: product name, location address, and order status, etc.

Describe the architecture/Block diagram you would choose. What is the purpose of each component of this architecture?

Q2: Characterize the data provided in the attached Excel sheet (usa_colleges_data.xls) using following target classes:

Private universities in California

• Public universities in California

The characterization should be based on following attributes:

• Number of universities/colleges
• Average of Math SAT
• Average of Verbal SAT
• Average of stud./fac. Ratio
• Average of outof-state tuition
• Average of % fac. w/PHD

1. You can use Excel Pivot Table and Pivot Chart to characterize the results
2. What knowledge can you deduce from this characterization?