Tag Archives: Project Maestro

• 

  How to handle new input files in Tableau Prep

  Posted on June 7, 2018 by Joshua Milligan in All, Data Shape & Structure, Tableau Prep (Maestro), Tips and Tricks.

  How to handle new input files in Tableau Prep Let’s say you’ve got a situation where you get new input files for Tableau Prep every month (or, maybe in your case it’s every week or every day or every so often). These aren’t files to be added to your data source in addition to existing […]

  Post Tagged with Data Flows, File Management, Input Files, Input Node, maestro, Project Maestro, Replace Step, Tableau Prep
  Continue Reading...
  2 Comments.
• 

  How to remove duplicate records in Tableau Prep

  Posted on May 23, 2018 by Joshua Milligan in All, Calculations, Data Shape & Structure, Level of Detail Calcs, Tableau Prep (Maestro), Tips and Tricks, Uncategorized.

  One of the questions that comes up quite often is “How do I remove duplicate records in Tableau Prep?” or “How do I dedup data in Tableau Prep?” Some data preparation tools have a specific feature to do this. At first glance, the first version of Tableau Prep doesn’t seem to have this feature. BUT […]

  Post Tagged with dedup, duplicate data, FIXED, lod calc, maestro, Project Maestro, Tableau Prep
  Continue Reading...
  No Comments.
• 

  Unpivot in Tableau Prep (Rows to Columns)

  Posted on April 23, 2018 by Joshua Milligan in All, Calculations, Data Blending & Joining, Data Shape & Structure, Tableau Prep (Maestro).

  You know you have a great piece of software when you can use its paradigm to come up with workarounds to features that don’t yet exist.  Such is the case with Tableau Prep (formerly Project Maestro).  I recently needed to unpivot some data and realized, the Tableau devs are truly miracle workers! Unpivot Data – […]

  Post Tagged with data shaping, Pivot, Project Maestro, Tableau Prep, unpivot, unpivot data
  Continue Reading...
  6 Comments.
• 

  A Sample Flow in Tableau Prep (Project Maestro)

  Posted on February 13, 2018 by Joshua Milligan in All, Data Blending & Joining, Data Shape & Structure, Level of Detail Calcs, Tableau Prep (Maestro).

  I recently had the privilege of presenting a preview of Tableau’s Project Maestro (now known as Tableau Prep) to the Amazon Tableau User Group.  This is not the exact presentation, but is a very similar data flow to the one I demonstrated there.  The flow also shows how to replicate a Level of Detail calculation […]

  Post Tagged with Data Flow, ETL, maestro, Project Maestro, Tableau Prep, Video
  Continue Reading...
  No Comments.
• 

  Latest Snapshot in Tableau and Maestro

  Posted on February 1, 2018 by Joshua Milligan in All, Calculations, Data Blending & Joining, Data Shape & Structure, Level of Detail Calcs, Tableau Prep (Maestro).

  Often, you’ll have data that looks something like this:   Every day, there are new records for projects that give the latest status and count of hours used.  Often a project spans multiple days and the status can change and count of hours might go up.  But if I want to get the most recent […]

  Post Tagged with Data Flow, dedup, duplicate data, Latest Record, Latest Snapshot, level of detail, LOD, Most Recent Record, Project Maestro, Table Calc, Tableau Prep
  Continue Reading...
  3 Comments.
• 

  Have a Maestro Christmas and Tableau New Year!

  Posted on December 13, 2017 by Joshua Milligan in All, Dashboards, Data Shape & Structure, Fun, Tableau Prep (Maestro).

  Tableau’s new data prep tool, Maestro, is now in public beta, and I’m loving it!  While the first beta doesn’t necessarily include all the features that might soon make it to a production release, what blows me away is the overall paradigm.  It brings the intuitiveness and transparency that Tableau brought to visual analytics and […]

  Post Tagged with Fractal, fun, Joins, maestro, Project Maestro, Tableau Prep
  Continue Reading...
  3 Comments.