- Home
- SAS Data Integration Studio: Fast Track
SAS Data Integration Studio: Fast Track
This course is a boot camp that covers the content of both SAS Data Integration Studio: Essentials and SAS Data Integration Studio: Additional Topics.
Power up your staff’s skills and boost your business
About Program
Format of Training
Training Features
Course Curriculum
Course Fees
Watch
ContactAbout Program
This course is a boot camp that covers the content of both SAS Data Integration Studio: Essentials and SAS Data Integration Studio: Additional Topics. It introduces and expands the knowledge of SAS Data Integration Studio and includes topics for registering sources and targets; creating and working with jobs; and working with transformations. This course also covers information about working with slowly changing dimensions, working with the Loop transformations, and defining new transformations.
The self-study version of this course includes structured course notes that provide a detailed overview, essential skills, and exercises, along with a software Virtual Lab to practice.
The e-learning includes:
- digital course notes for self-study
- Virtual Lab: 50 hours of hands-on software practice.
This course can help prepare you for the following certification exam(s): SAS Data Integration Development for SAS 9.
Format of Training
Taught by certified instructors at high-tech facilities across the country
- A SAS expert at your side.
- Focused learning away from the office
- Networking opportunities
- State-of-the-art facilities
- Electronic course notes downloadable to your device and permission to print
- Business Knowledge Series: in-depth courses on the latest business topics
- We offer Connected Classes! Watch for courses in Cary, New York, Arlington, Dallas and San Francisco that connect remote students via our Live Web classroom.
Training Features
- register source data and target tables
- create jobs and explore the functionality of the job editor
- work with many of the various transformations
- work with slowly changing dimensions
- work with Loop transformations
- create new transformations
- examine impact analysis
- examine exporting and importing of metadata
- establish checkpoints in job flow
- deploy jobs for scheduling
- deploy jobs as SAS Stored Processes.
Course Curriculum
Introduction
- exploring the platform for SAS Business Analytics
- introduction to the Data Management applications
- introduction to the classroom environment and the course tasks
Working with Change Management
- introduction to change management
- establishing a change management environment (Self-Study)
Creating Metadata for Source Data
- setting up the environment
- registering source data metadata
Creating Metadata for Target Data
- registering target data metadata
- importing metadata
Creating Metadata for Jobs
- introduction to jobs and the job editor
- using the Join transformation
Orion Star Case Study
- defining and loading the customer dimension table
- defining and loading the organization dimension table
- defining and loading the time dimension table
Additional Features for Jobs
- importing SAS code
- propagation and mapping
- chaining jobs
- performance statistics
- metadata reports
Working with Transformations
- using the extract and summary statistics transformations
- exploring SQL transformations
- establishing status handling
- using the Data Validation transformation
- using the Transpose, Sort, Append, Rank, and List Data transformations
- using the Apply Lookup Standardization, Standardize with Definition and One-Way Frequency transformations(self-study)
Working with the Loop Transformations
- introduction to the loop transformations
- iterating a job
- iterating a transformation
Working with Slowly Changing Dimensions
- defining slowly changing dimensions
- using the SCD Type 2 Loader and Lookup transformations
- using the SCD Type 1 Loader transformations
- introducing the Change Data Capture transformations (self-study)
Creating Custom Transformations
- using the new transformation Wizard
- using the new transformation wizard
Working with the Table Loader Transformations
- exploring the basics of the Table Loader transformations
- exploring the load styles of the Table Loader transformation
- managing indexes and constraints during loading
- exploring bulk loading for DBMS tables
Working with Databases
- introduction to In-Database processing
- using In-Database processing
- exploring ELT processing
- using DBMS functions
Additional Topics for SAS Data Integration Studio Users
- overview
- analyzing metadata using impact analysis
- comparing tables
- conditional execution
- metadata promotion
- version control
- establishing checkpoints
Deploying Jobs
- introduction
- deploying jobs for scheduling
- deploying jobs in batch
- deploying jobs as stored processes
Implementing Data Quality Techniques (self-study)
- verifying data quality settings
- using the DataFlux transformation
Course Fees
Are you ready to take on SAS Data Integration Studio: Fast Track?
Let’s get you started with one of the learning paths.
Find My Path Popular Courses
SAS® Academy for Clinical Programming SAS® Academy for Data Science Introduction to CDISC Domains & Standards Data Visualization Machine Learning & AI Data Management Data Analytics Predictive Business AnalystCertification
SAS Certified Base Programmer for SAS 9 SAS® Certified Big Data Professional Using SAS®9 Predictive Modeling certification exam SAS® Certified Clinical Trials Programmer Using SAS®9 SAS® Certified Data Scientist SAS® Certified Platform Administrator for SAS®9
© 2024 Epoch Research Institute India Pvt. Ltd. All Rights Reserved. All Contents Shown from SAS are sole propriety of © SAS Institute Inc. All Rights Reserved. SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Adobe and the Acrobat logo are trademarks of Adobe Systems Incorporated.