Chrysalis Consulting Group/Monarch Data Prep Studio Essentials - Delimited

  • Free

Monarch Data Prep Studio Essentials - Delimited

  • Course
  • 19 Lessons

This course teaches how to import delimited files into Monarch. Designed for professionals who perform core data preparation; cleaning, combining, and transforming data—examples include accountants, analysts, auditors, and operations teams across industries; Banking, Healthcare Finance, and General Accounting Operations.

Contents

Introduction

Introduction
Monarch Overview
Monarch for Delimited Files
Use Cases

Data Prep Studio Overview

Data Prep Studio Windows
File Types

Importing Delimited Files

1. Comma
2. Pipe
3. Semicolon
4. Space
5. Tab
6. Appending Multiple CSV Files
7. Importing TSV Files

Non-Traditional CSV Files

Text Files Saved as CSV
Excel files Saved as CSV

Exercises

Exercise 14
Exercise 16
Exercise 23

Quiz

Monarch DPS Essentials - Delimited