К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Automate Auditable SAS EG Analytics · LearnSpace
Назад в каталог
courseraАнализ данных

Automate Auditable SAS EG Analytics

Курс от Coursera
Средний≈ 4.1 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

Research shows 80% of analytical projects is dedicated to data preparation, making efficient data structuring workflows critical for productivity. This Short Course was created to help Data Analysis professionals accomplish rapid development of reproducible SAS Enterprise Guide pipelines using visual tools and automation features. By completing this course, you'll be able to build Query Builder flows for filtering, joining, and aggregating data, implement parameterized prompts for standardized reruns, validate generated SAS code for accuracy, and structure projects with clear traceability—capabilities you can deploy to production tomorrow. By the end of this course, you will be able to: ● Use the Query Builder for filtering, sorting, and creating calculated columns ● Perform table joins, aggregations, and transpose operations for data reshaping ● Create prompts for user input and implement conditional execution logic to support standardized workflows ● Understand and validate generated SAS code, debug using the SAS log, and create repeatable analytical processes with governance controls This course is unique because it emphasizes the full analytical lifecycle from data manipulation through workflow automation to code validation, bridging point-and-click Query Builder operations with reproducible research principles and auditability requirements for regulated environments. To be successful in this project, you should have a background in data analysis fundamentals, basic SQL concepts, and analytical workflow design at CB2 intermediate-level expertise.

Навыки, которые вы освоите

DebuggingData ValidationData AnalysisCode ReusabilityVerification And ValidationQuery LanguagesBusiness LogicData PipelinesData GovernanceData PreprocessingData ManipulationData TransformationAnalyticsSQL Server Reporting ServicesSAS (Software)

Программа курса

4 модулей · 27 учебных материалов

01Using Query Builder for Data Operations7 материалов
Welcome to Build Reproducible SAS EG FlowsDIALOGUEWhen Manual Data Prep Costs You HoursВидеоQuery Builder Fundamentals: Filtering, Sorting, and Calculated ColumnsЧтениеBuilding a Query Builder Flow: Filtering, Sorting, and Computed Columns Step by StepЧтение

Учитесь у экспертов

Professionals in the Industry

Преподаватель курса

Automate Auditable SAS EG Analytics
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 4.1 ч

4 модулей

Язык: Английский

Часть программы вашего университета
Navigating Filter Logic and Column Expressions: A Decision WalkthroughDIALOGUE
Build a Query Builder Flow: Filter, Sort, and ComputeЗадание
Knowledge Check: Using Query Builder for Data OperationsЗадание
02Performing Advanced Data Transformations6 материалов
Why Combining Data Tables Reflection: Your Experience Combining Data TablesDIALOGUEJoins, Aggregations, and Transpose: Concepts and Options in Query BuilderЧтениеJoining Three Tables and Aggregating Results in SAS EGВидеоChoosing Join Types and Handling Aggregation Edge CasesDIALOGUEReshape a Dataset: Join, Aggregate, and TransposeЗаданиеKnowledge Check: Performing Advanced Data TransformationsЗадание
03Creating Parameterized Workflows7 материалов
The Monthly Report That Ran ItselfВидеоPrompts, Macro Variables, and Conditional Execution in SAS Enterprise GuideЧтениеUnderstanding When and Why to Use ParameterizationDIALOGUEConfiguring Prompts and Conditional Nodes in SAS Enterprise GuideВидеоDesigning Reliable Parameterized SAS Enterprise Guide Workflows: Trade-offs and Best PracticesDIALOGUEParameterize a Workflow: Add Prompts and Conditional ExecutionЗаданиеKnowledge Check: Creating Parameterized WorkflowsЗадание
04Validating Code and Ensuring Reproducibility7 материалов
What the Log Reveals That the Output HidesDIALOGUEThe Three Lives of SAS Code: Understanding What Enterprise Guide GeneratesВидеоReading the SAS Log and Applying Governance Controls: A Step-by-Step WalkthroughЧтениеEvaluating Code Quality and Deciding What Passes Governance ReviewDIALOGUEDocument Your Pipeline: Annotate Code, Trace Data Lineage, and Validate ReproducibilityЧтениеKnowledge Check: Validating Code and Ensuring ReproducibilityЗаданиеCourse Assessment: Build Reproducible SAS EG FlowsЗадание