Good basic ETL option
October 07, 2020

Good basic ETL option

Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Tableau Prep

We use it to prepare data from multiple sources for report generation.
  • Clean data
  • Join data files
  • Create calculated values
  • Output to CSV
  • More output options
  • Allow SQL code to input data files for prep
  • Allow row level edits/deletes
  • Quicker data sets for online reports
  • More efficient data cleaning Ad Hoc reports
  • Costly if using data management to schedule data pull and cleaning (priced per viewer accounts not creator accounts)
Selected Tableau Prep because it came with out Tableau license.
Do not talk to actual person. Just received email support only.
It works well and is user friendly for the basics but needs more options for bring in data (using SQL queries for example) and export format options.

Do you think Tableau Prep delivers good value for the price?

No

Are you happy with Tableau Prep's feature set?

Yes

Did Tableau Prep live up to sales and marketing promises?

Yes

Did implementation of Tableau Prep go as expected?

Yes

Would you buy Tableau Prep again?

Yes

Great for pulling in multiple files to combine and clean for an output file for further analysis. Not good if you need to query your database for a data set to review and prep for analysis.

Using Tableau Prep

1 - Publishing key analytics/KPI for decision makers. Generating data files for various reports and fulfilling data requests by internal and external stakeholders.
1 - Data analysis and statistics knowledge would be highly desirable. Understanding of database connections, storage and retrieval, as well as basic SQL.
  • Preparing data files for further analysis/reporting
  • Fulfilling data requests by internal and external stakeholders
  • Visually troubleshooting data file issues
  • As our go to ETL for multiple projects
  • Generating OneRoster aligned files for export to vendor systems
  • Generating CSV files for external stakeholders to match required layouts and field names
It is a valuable tool for generating and cleaning files for multiple purposes.

Evaluating Tableau Prep and Competitors

  • Product Features
  • Product Reputation
Recommended by another local school district.
Broader search to included more vendors. Was up against a tight timeline for purchase decision.

Tableau Prep Implementation

Live connections to cloud services (Google Sheets for example) and cloud hosted databases (cloud hosted SIS for example) for scheduled flows are not supported
Change management was minimal - Change management was not a part of implementation
  • Setting up connections for scheduling data flows and outputs

Tableau Prep Support

No - Not sure it's available
Not really. Support is via email and their website. I prefer immediate phone support. I typically do not have time to wait for a response.

Using Tableau Prep

  • Calculating new fields
  • Changing data layout and field names
  • Joins
  • Remove duplicate records
  • Query database tables
  • Edit single records