bi skills review

Data & Text Mining 1

BI Skills Review

Zhangxi Lin

ISQS 3358

Texas Tech University

Data & Text Mining 2

Outline

SAS Enterprise Guide Data import Reporting Query Specific topics: parameterized variables, parameterized query,

variable expression, joining tables SAS Enterprise Miner

Classification Clustering Association analysis

SAS EG/Excel analytics tasks Regression, t-test, etc.

About the final

Data & Text Mining 3

Data import

Excel file Text file

Dataset: Order.txt Column Formatting Column defining Data formatting

Data & Text Mining 4

Reporting

Listing (SupplyInfo.xls) One-way frequency (Product) Two-way frequency (Product) Variable parameter (Product)

Data & Text Mining 5

Query

Simply query (SupplyInfo.xls) Joining tables (Commrex_data0)

Data & Text Mining 6

Data Mining

Decision tree Clustering Association analysis

Data & Text Mining 7

About the final exam

You know how to use the above tools – so what? You need to Be able to what out the task according to different

requirements Be able to explain the outcomes