BI Skills Review - PowerPoint PPT Presentation

1 / 7
About This Presentation
Title:

BI Skills Review

Description:

Title: Steven F. Ashby Center for Applied Scientific Computing Month DD, 1997 Author: Computations Last modified by: zlin Created Date: 3/18/1998 1:44:31 PM – PowerPoint PPT presentation

Number of Views:76
Avg rating:3.0/5.0
Slides: 8
Provided by: Comput529
Category:

less

Transcript and Presenter's Notes

Title: 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
Write a Comment
User Comments (0)
About PowerShow.com