Docstoc

SAS BI Online Training and Placement @ Crescent IT Solutions

Document Sample
SAS BI Online Training and Placement @ Crescent IT Solutions Powered By Docstoc
					     Crescent IT Solutions
    Visit : http://www.crescentits.com

Call Us: (01) 713-589-5479/2879, 704-248-2649
SAS BI Online Training and Placement Support @
             Crescent IT Solutions
                    SAS BI Course Content


Overview of SAS 9 Enterprise Intelligence Platform and SAS Data
  Integration Studio
• Business Intelligence overview
• Business Intelligence Information Consumers
• Navigating in SAS Data Integration Studio
Change Management
• What is change management?
• Repository types
• Using change management
           Visit: http://www.crescentits.com
    SAS BI Online Training and Placement Support @
                 Crescent IT Solutions
                        SAS BI Course Content

Designing the Course Data Mart

•    Planning a data warehouse
•    Building a Data Mart
•    Defining the source data
•    Defining the target tables
•    Loading the target tables



              Visit: http://www.crescentits.com
 SAS BI Online Training and Placement Support @
              Crescent IT Solutions
                          SAS BI Course Content

Creating Reports
• Report Transformations
• Using the Transformation Generator Wizard
• SAS Data Integration Studio and stored -processes Transformations for Slowly
   Changing Dimensions
• Defining slowly changing dimensions
• Using the SCD Type 2 Loader transformation
• Using the Fact Table Lookup transformation




              Visit: http://www.crescentits.com
    SAS BI Online Training and Placement Support @
                 Crescent IT Solutions
                        SAS BI Course Content

Job Scheduling

•    Scheduling SAS Data Integration Studio jobs SAS Data Integration
     Studio and Data Quality
•    SAS and Data Quality
•    Using the Data Validation transformation
•    Using the Apply Lookup Standardization transformation
•    Using the Create Match Code transformation




              Visit: http://www.crescentits.com
SAS BI Online Training and Placement Support @
             Crescent IT Solutions
                      SAS BI Course Content

SAS/Enterprise Guide
Introduction
• Starting SAS Enterprise Guide
• SAS Enterprise Guide windows
• Basic elements of SAS Enterprise Guide
• Entering data
• Creating a list report
• Producing a frequency report
• Creating a scatter plot
• Adding a note to the project
• Saving the project



           Visit: http://www.crescentits.com
    SAS BI Online Training and Placement Support @
                 Crescent IT Solutions
                            SAS BI Course Content

SAS/Enterprise Guide

•    Reading Data from Files
•    Opening a SAS data set from your local computer
•    Opening a SAS data set stored in a SAS library
•    Opening a Microsoft Excel file




               Visit: http://www.crescentits.com
    SAS BI Online Training and Placement Support @
                 Crescent IT Solutions
                        SAS BI Course Content

SAS/Enterprise Guide

•    Creating Reports
•    Creating a simple report
•    Changing titles and footnotes
•    Changing column labels and formatting values
•    Defining your own formats
•    Creating a grouped report
•    Selecting a style for the report



              Visit: http://www.crescentits.com
    SAS BI Online Training and Placement Support @
                 Crescent IT Solutions
                         SAS BI Course Content

SAS/Enterprise Guide

•    Working with Data in the Query Builder
•    Opening the Query Builder
•    Selecting columns
•    Creating a new column
•    Ordering and removing columns
•    Filtering data
•    Sorting the data rows




              Visit: http://www.crescentits.com
    SAS BI Online Training and Placement Support @
                 Crescent IT Solutions
                         SAS BI Course Content

SAS/Enterprise Guide

•    Joining Two Data Files Together
•    Opening the two data files to be joined
•    Joining tables
•    Filtering the data
•    Modifying the type of join




              Visit: http://www.crescentits.com
                Contact Us
               Crescent IT Solutions

Address: 10919 west road, apt 518 Houston, Tx, USA,77064

E-mail: training@crescentits.com

Visit : http://www.crescentits.com

Toll Free No: 1-800-929-0849

Skype Id: crescent_demo1

Call US @ (01) 704-248-2649, 713-589-5479/2879

				
DOCUMENT INFO
Categories:
Stats:
views:14
posted:2/7/2013
language:Unknown
pages:11
Description: Crescent IT Solutions is established with the motto of providing interactive learning of essential IT related business courses viz., SAP,SAS, Data warehousing, QA, .Net, Java etc to anyone, at any time and at any place and provides an easy, convenient and effective solution.