Available in:
Self-Service Data Preparation in SAS® Viya®
DIDP22 : DIDP1H
This course provides an overview of the data preparation capabilities of SAS Data Preparation in SAS Viya. These data preparation capabilities include bringing data in from a variety of sources, assessing the structure and quality of data, preparing and cleansing the data to be fit for purpose, exploring and monitoring the relationships between objects in your environment, and sharing the data with others to promote collaboration and operational use.
Learn How To
- Ingest and blend data from a variety of data sources.
- Visually assess and profile data with multiple tools for better understanding of quality issues.
- Restructure and cleanse data without using code.
- Write SAS code to perform custom processing on your data.
- Examine relationships between data to assess impact and aid in governance.
- Create and schedule repeatable workflows to automate time-consuming data preparation tasks.
Who Should Attend
Business and data analysts, data miners, data scientists, citizen data scientists, statisticians, and others who interact with data from a variety of sources to perform data discovery, wrangling, blending, and manipulation to ensure that the data is fit for purpose in analytical models, explorations, and reports
Prerequisites
No SAS experience or programming experience is required, although you should have some computer experience. Specifically, you should be able to:
- Log on and off a computer and use a keyboard or mouse.
- Use a web browser to access information.
SAS Products Covered
SAS Viya
Course Outline
Overview of Data Preparation in SAS Viya
- Overview of SAS Viya and its capabilities.
- Understand the analytics life cycle.
- Understand the data preparation tools in SAS Viya and how they fit into the analytics life cycle.
- Manage data using SAS Data Explorer.
- Create data source connections.
- Load and import data from caslibs and files local to the browser.
- Enrich tables with Esri geoenrichment and geocode data.
- Generate profiles in SAS Data Explorer.
- Assess data with SAS Information Catalog.
- Introduction to SAS Data Studio and plans.
- Use suggestions to prepare data.
- Prepare data using column transforms.
- Use custom code to transform and aggregate data.
- Cleanse data using data quality transforms.
- Blend data using multi-input transforms.
- Restructure and filter data using row transforms.
- Monitor object relationships using SAS Lineage Viewer.
- Schedule and monitor SAS Viya jobs and job flows in the SAS environment.
Live Class Schedule
Duration: 14 hours
Step into our live classes and experience a dynamic learning environment where you can ask questions, share ideas, and connect with your instructor and classmates. With on-demand lab hours, you can explore the material at your own pace. Our globally acclaimed instructors will motivate you to think bigger, so you can take what you've learned and achieve your biggest goals.
This course isn't publicly scheduled, but private training and mentoring may be available. Contact us to explore options.
Private Training
Get training tailored specifically for your team, led by expert SAS instructors. Choose from virtual sessions, or training at your location (or ours). Perfect for teams seeking a customized curriculum and plenty of interaction with a SAS specialist. We'll schedule it at a time that works for you.
Mentoring Services
Take your training to the next level with personalized mentoring. While private training offers structured coursework, mentoring provides hands-on, real-time support from a subject matter expert. As you work with your own data, you'll receive expert guidance to help you uncover insights, unlock the full potential of your data, and make faster progress. Perfect for those looking to apply what they’ve learned and see quicker results.