Duration: 2 days – 14 hrs.
Overview.
This intensive 2-day training course provides a comprehensive understanding of data preparation for analytics and predictive modeling. Participants will explore the technical concepts and business considerations essential for preparing data to meet specific analytical and predictive modeling requirements. The course emphasizes the importance of viewing data preparation in the context of business objectives and delves into the intricacies of designing analytical variables using SAS programming. Moreover, participants will learn techniques to identify and circumvent common pitfalls that can compromise data quality and integrity during the preparation phase.
Objectives
- View data preparation through a business lens, aligning it with organizational goals.
- Identify the specific requirements for designing analytical variables.
- Master data preparation techniques using SAS programming.
- Recognize and mitigate common pitfalls that may impact data quality and integrity.
Audience
- Analysts
- Data Scientists
- IT Professionals
Pre- requisites
- Exposure to DATA step programming equivalent to SAS Programming 1: Essentials.
- Experience with programming in SQL or familiarity with the SQL procedure.
- Basic understanding of the analytical process involved in building predictive models.
Course Content
Module I: Data Preparation – A Business Point of View
- Understanding the strategic importance of data preparation.
- Aligning data preparation with business objectives.
- Exploring various data structures and data modeling techniques.
Module II: Designing Analytical Variables
- Principles of designing effective analytical variables.
- Best practices for variable creation and transformation.
- Avoiding common mistakes in analytical data preparation.
Use Cases:
Throughout the course, real-world use cases will be explored, including:
- Preparing data for Segmentation.
- Preparing data for Predictive Modeling.
- Building a Customer Data Mart.
