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

Product Suite Language Region Location Event status Seats available Sign-up period Session times Rooms Session status Actions
Monarch English Europe/Africa, Asia Pacific Online
  • Upcoming
  • Booking open
 60 Before , Timezone: America/Detroit , - , Timezone: America/Detroit
  • Upcoming
Go to event
Monarch English Americas Online
  • Upcoming
  • Booking open
 60 Before , Timezone: America/Detroit , - , Timezone: America/Detroit
  • Upcoming
Go to event

Past events

Showing all previous events – show less

Product Suite Language Region Location Event status Seats available Session times Rooms Altair Instructor Session status
Monarch English Americas Online
  • Over
  • Booking closed
 54 , - , Timezone: America/Detroit
  • Session over
Monarch English Americas Online
  • Over
  • Booking closed
 56 , - , Timezone: America/Detroit
  • Session over
Monarch English Americas Online
  • Over
  • Booking closed
 23 , - , Timezone: America/Detroit
  • Session over
Monarch English Europe/Africa, Asia Pacific Online
  • Over
  • Booking closed
 52 , - , Timezone: America/Detroit
  • Session over
Monarch English Europe/Africa, Asia Pacific Online
  • Cancelled
 58 , - , Timezone: America/Detroit
  • Cancelled
Monarch English Europe/Africa, Asia Pacific Online
  • Cancelled
 59 , - , Timezone: America/Detroit
  • Cancelled
Monarch English Americas Online
  • Cancelled
 57 , - , Timezone: America/Detroit
  • Cancelled