SAS-DI Data Integration Studio

Teacher
maziworld
Category:
SAS-BI
4 out of 5
4
6 reviews

SAS Data Integration Studio ?

SAS Di is basically SAS Data Integration studio , a tool like base sas editor for coding and reporting purpose. You can call it a drag and drop tool which is equipped with many inbuilt functions, macros , transformation, loaders etc.

Hightlits  :

Creating a new job

Debugging

Check points

Control flow

Populating jobs

Review job statistics

Setting properties for transformation jobs

Scheduling jobs

Submitting the job.

Target Audience :

Base SAS

Advanced SAS

 Basics of Datawarehouse

Software Installation : Currently software installation is a paid one. You need to do it from system administrator.  

System requirements :

Processor : i5 and above

RAM : 8GB and above [preferable 16 GB Best ]

Harddisk : SSD Harddisk with 500 GB OR Above  / other harddisk also its ok

Target Audience :

Any person who completed the graducation is perfect. This Base SAS Is a foundation tool  and its very easy to learn very basic coding language will be there.the most important thing is that when ever you start the class from the day you need to have the SAS Software Installation.

Materials :

Books and Daily notes will be provided by us along with that recording also will be provided for reference . Step by step notes will be provided and excersises also.

Sample Videos : We request you that first don’t join the course directly as we provide the sample videos in the cirriculam first watch that try to understand. If you understand and feel comfortable with trainer explanation then gohead for classes. Join the course.

Working hours  : 9:00 am ist  to 8 pm ist .

Overview of SAS Data Integration Studio

1
exploring the platform for SAS Business Analytics
2
reviewing the course data and course tasks

Working with Change Management

1
introduction to change management
2
establishing a change management environment (self-study)

Creating Metadata for Source Data

1
setting up the environment
2
registering source data metadata

Creating Metadata for Target Data

1
registering target data metadata
2
importing metadata for target data

Creating Metadata for Jobs

1
introduction to jobs and the job editor
2
using the SQL join transformation

Additional Features for Jobs

1
importing SAS code
2
working with propagation and mappings
3
chaining jobs
4
investigating performance statistics

Working with Transformations

1
working with the extract transformation
2
working with summary statistics transformation
3
exploring status handling for transformations and jobs
4
working with the data validation transformation
5
working with the sort transformation
6
working with the append transformation
7
working with the transpose transformation
8
working with the apply lookup standardization transformation

Working with Slowly Changing Dimensions

1
defining slowly changing dimensions
2
using the SCD Type 2 Loader and Lookup transformations
3
introducing the Change Data Capture transformations (self-study)

Working with Loop Transformations

1
introduction to Loop transformations
2
iterating a job with Loop transformations
3
iterating a single transformation with Loop transformations

Defining New Transformations

1
SAS code transformations
2
using the new transformation wizard

Working with Tables and the Table Loader Transformation

1
basics of the Table Loader transformation
2
load styles of the Table Loader transformation
3
table properties and load techniques of the Table Loader transformation

Additional Topics for SAS Data Integration Studio Users

1
overview
2
analyzing metadata using impact analysis
3
metadata promotion
4
metadata reports
5
checkpoint/restart
6
deploying jobs for scheduling
7
deploying jobs as SAS Stored Processes

Implementing Data Quality Techniques

1
SAS and data quality
2
working with the DataFlux IS transformations
Faq Content 1
Faq Content 2

Productivity Hacks to Get More Done in 2018

— 28 February 2017

  1. Facebook News Feed Eradicator (free chrome extension) Stay focused by removing your Facebook newsfeed and replacing it with an inspirational quote. Disable the tool anytime you want to see what friends are up to!
  2. Hide My Inbox (free chrome extension for Gmail) Stay focused by hiding your inbox. Click "show your inbox" at a scheduled time and batch processs everything one go.
  3. Habitica (free mobile + web app) Gamify your to do list. Treat your life like a game and earn gold goins for getting stuff done!


4
4 out of 5
6 Ratings

Detailed Rating

Stars 5
3
Stars 4
0
Stars 3
3
Stars 2
0
Stars 1
0

{{ review.user }}

{{ review.time }}
 

Show more
Please, login to leave a review
Add to Wishlist
Get course
Enrolled: 67 students
Duration: 45 Days
Lectures: 42
Video: Available
Level: Advanced

Archive

Working hours

Monday 9:00 am to 8 pm ist
Tuesday 9:00 am to 8 pm ist
Wednesday 9:00 am to 8 pm ist
Thursday 9:00 am to 8 pm ist
Friday 9:00 am to 8 pm ist
Saturday 9:00 am to 8 pm ist
Sunday Closed