- 1. www.sryitsolutions.com USA: +1-319-804-4998 India:+91-9948030675 Email id: [email protected]
2. SAS BI Overview: Business Intelligence overviewBusiness Intelligence Information ConsumersNavigating in SAS Data Integration StudioWhat is change management?Repository typesUsing change management 3. Designing The Course Data Mart Planning a data warehouseBuilding a Data MartDefining the source dataDefining the target tablesLoading the target tables 4. Creating Reports Report TransformationsUsing the Transformation Generator WizardSAS Data Integration Studio and stored -processes Transformations for Slowly Changing DimensionsDefining slowly changing dimensionsUsing the SCD Type 2 Loader transformationUsing the Fact Table Lookup transformation 5. Debugging & Interpreting Error Messages Scheduling SAS Data Integration Studio jobsSAS Data Integration Studio and Data Quality SAS and Data QualityUsing the Data Validation transformationUsing the Apply Lookup Standardization transformationUsing the Create Match Code transformation 6. SAS/Enterprise Guide Starting SAS Enterprise GuideSAS Enterprise Guide windowsBasic elements of SAS Enterprise GuideEntering dataCreating a list reportProducing a frequency report 7. Reading Data From Files Opening a SAS data set from your local computerOpening a SAS data set stored in a SASlibrary Opening a Microsoft Excel file 8. Creating Reports Creating a simple reportChanging titles and footnotesChanging column labels and formatting valuesDefining your own formatsCreating a grouped reportSelecting a style for the report 9. Working With Data In The Query Builder Opening the Query BuilderSelecting columnsCreating a new columnOrdering and removing columnsFiltering dataSorting the data rows 10. Joining Two Data Files Together Opening the two data files to be joinedJoining tablesFiltering the dataModifying the type of join 11. Offered Other Modules: SAP: SAP BPC, BASIS,ABAP,BO,ADMIN,FICO,MDM,CRM TRAINING,HANA TRAININGFSCM,IS UTILITIESBO DATA SERVICES, APO. DWH: AB INITIO TRAINING,AJAX TRAINING,INFORMATICA TRAINING,DATA STAGE TRAINING, HANDOOP TRAINING, WEBSPHERE TRAINING. 12. Contact us for more details and Session Schedules atUSA: +1-319-804-4998 India:+91-9948030675 Email : [email protected] Web : www.sryitsolutions.com
