BI Skills Review

1
BI Skills Review

• Zhangxi Lin
• ISQS 3358
• Texas Tech University

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

3
Data import

• Excel file
• Text file
• Dataset Order.txt
• Column Formatting
• Column defining
• Data formatting

4
Reporting

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

5
Query

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

6
Data Mining

• Decision tree
• Clustering
• Association analysis

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