Monarch Data Prep Studio Introduction

Course Outline:


Prerequisites:

There are no pre-requisite courses required; however, basic computer knowledge and Microsoft Office would be useful.  

Day 1/(Session 1):
    • Monarch Data Prep Studio user interface.
    • How to save the workspace.
    • Extract data from multiple files with different formats.
    • Extract data from CSV files.
    • How to load data from a web page and capture data.
    • How to do prep data using calculated fields, split data, and other functions.
    • What is pin workspace.
    • How to export tables to different format.
Day 2/(Session 2):
    • How to combine tables using join and append.
    • How to transform tables using Group, Pivot, Unpivot, Transpose, and Show/Remove duplicates.
    • How to create defined filters and sorts.
    • How to create Summaries.
    • How to export tables and summaries using defined filters and sorts to different formats.
    • How to load and prep database tables using ODBC.



Loading
Reset

Upcoming events

No results

Past events

Language Location Event status Seats available Session times Rooms Altair Instructor Session status
English Online
  • Over
  • Booking closed
51 , - , Timezone: America/Detroit
  • Session over