Courses
SAP
- SAP ABAP
- SAP BASIS
- SAP SECURITY
- SAP NETWEAVER
- SAP XI
- SAP FICO
- SAP FSCM
- SAP MM
- SAP WM
- SAP PP
- SAP SRM
- SAP BW
- SAP BI
- SAP BPC
- SAP MDM
- SAP SD
- SAP CRM
- SAP BO
- SAP HR
- SAP HR-ABAP
- SAP GRC
- SAP HCM
- SAP APO
- SAP EP ADMIN
- SAP IS UTILITIES
- SAP PLM
- SAP SCM
- SAP PC
- SAP QM
- SAP IS RETAIL
- SAP EP JAVA WEBDYNPRO
- SAP HANA
- SAP PS
- SAP PI
- SAP IS OIL & GAS
- SAP CS
Oracle
- ORACLE 10 g
- ORACLE APPS DBA
- ORACLE APPS FINANCIALS
- ORACLE APPS TECHNICAL
- ORACLE BPEL
- ORACLE OAF
- ORACLE APPS FINANCE FUNCTIONAL R12
- OBIEE
- ORACLE 11G
- ORACLE DBA
- PL-SQL
- ORACLE HRMS
- ORACLE ADF
Other Technologies
- MS.NET
- SHARE POINT
- JAVA
- SAS
- SAS BI
- SAS OC
- QA TESTING
- SQL SERVER
- TIBCO
- SIEBEL CRM
- SIEBEL ANALYTICS
- UNIX SHELL
- BIZTALK SERVER
- CCNA
- SAS FINANCIAL MANAGEMENT
- AJAX
- LINUX
- SALES FORCE
- CCNP
- MCSE
- VMWARE
- PEOPLESOFT HRMS TECHNICAL
- CRYSTAL-REPORTS
- PMP
- TERA DATA
- WEBSPHERE
- ANDROID
- HADOOP
Data Warehousing
- INFORMATICA
- COGNOS
- DATA STAGE
- BUSINESS OBJECTS
- BUSINESS ANALYST
- COGNOS TM1
- AB INITIO
- MICROSTRATEGY
- COGNOS PLANNING AND BUDGETING
- HYPERION ESSBASE
- HYPERION DATA RELATIONSHIP MANAGEMENT
- HYPERION FINANCIAL MANAGEMENT
- HYPERION INTERACTIVE REPORT
- HYPERION FINANCIAL DATA QUALITY MANAGEMENT
- HYPERION PLANNING
- HYPERION FINANCIAL REPORT
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
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
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
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
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
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
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
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
Joining Two Data Files Together
- Opening the two data files to be joined
- Joining tables
- Filtering the data
- Modifying the type of join