E022 – Tech Spec – Tableau Project Maestro Data Prep

Zip file of all the sample data, Maestro flows, and Tableau workbook I used to get a first impression: E022_maestro_demo_files.

Sample Flow from Tableau

Field Selection

Data Profiling

Filters

Join Clause

Refresh / Run Flow

File Output Options

Has the clean, intuitive feel of Tableau. I did my hands-on test with no training or previous exposure
Lots of features for a first release – joins, unions, type conversion, calculated fields, data connectors, etc.
Easy to click into any part of your flow and see data
Ability to edit inline – much like tweaking an Excel pivot table
Data profiling is a nice visual cue to begin working with data
Ability to sort, filter, rename, add calculated fields anywhere along the way
Great for quick and dirty data prep that you know is heading into Tableau for ad-hoc analysis

Ability to sort, filter, rename, add calculated fields anywhere along the way – this can get messy for others to come behind you to maintain or see what is happening
Reconciliation issues between reports will now be complicated by similar flows doing slightly different things
You have to remove header fields from Excel if you want Maestro to latch onto and display field names from table. By default, it looks at first row and gives generic names if column headings aren’t there (i.e., F1, F2, …)
Can only have one flow open at any time
Performance seems a tiny bit slow on my example with ~13,000 rows. Curious to see how it will perform against larger data sets, RDBMS, and big data connectors
Only outputs to TDE or Hyper formats currently. No ability to save as CSV, XLSX, PDF, or write back to a data store
Unable to source data from a TDE or Tableau Workbook
No reuse of common transformations or logic across different flows
NO community generated content yet – since it is very new, you can’t Google for answers or YouTube videos. Established, mature ETL and data prep tools will continue to have a leg up on this front for a while.

Deep Sky Blue by Graphiqs Groove