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.
- 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.
- 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.
Upcoming events
| Product Suite | Language | Region | new_Suite | Event status | Seats available | Sign-up period | Session times | Rooms | Session status | Actions |
|---|---|---|---|---|---|---|---|---|---|---|
| Monarch | English | Europe/Africa, Asia Pacific | Data Analyst |
|
60 | Before , Timezone: America/Detroit | , - , Timezone: America/Detroit |
|
||
| Monarch | English | Americas | Data Analyst |
|
60 | Before , Timezone: America/Detroit | , - , Timezone: America/Detroit |
|
||
| Monarch | English | Europe/Africa, Asia Pacific | Data Analyst |
|
59 | Before , Timezone: America/Detroit | , - , Timezone: America/Detroit |
|
||
| Monarch | English | Americas | Data Analyst |
|
60 | Before , Timezone: America/Detroit | , - , Timezone: America/Detroit |
|
||
| Monarch | English | Europe/Africa, Asia Pacific | Data Analyst |
|
60 | Before , Timezone: America/Detroit | , - , Timezone: America/Detroit |
|
||
| Monarch | English | Americas | Data Analyst |
|
60 | Before , Timezone: America/Detroit | , - , Timezone: America/Detroit |
|
Past events
Showing events form last 30 days – show all
| Product Suite | Language | Region | Event status | Seats available | Session times | Rooms | Session status |
|---|---|---|---|---|---|---|---|
| Monarch | English | Americas |
|
23 | , - , Timezone: America/Detroit |
|
|
| Monarch | English | Europe/Africa, Asia Pacific |
|
52 | , - , Timezone: America/Detroit |
|