Dataform vs Tableau

Overview

Tableau

Stacks1.3K

Followers1.4K

Votes8

Dataform

Stacks818

Followers53

Votes0

GitHub Stars934

Forks188

Dataform vs Tableau: What are the differences?

What is Dataform? *A framework for managing SQL based data operations *. It helps you manage all data processes in your cloud data warehouse. Publish tables, write data tests and automate complex SQL workflows in a few minutes, so you can spend more time on analytics and less time managing infrastructure.

What is Tableau? Tableau helps people see and understand data. Tableau can help anyone see and understand their data. Connect to almost any database, drag and drop to create visualizations, and share with a click.

Dataform can be classified as a tool in the "Database Tools" category, while Tableau is grouped under "Business Intelligence".

Some of the features offered by Dataform are:

Version ontrol
Scheduling
Notifications and logging

On the other hand, Tableau provides the following key features:

Connect to data on prem or in the cloud—whether it’s big data, a SQL database, a spreadsheet, or cloud apps like Google Analytics and Salesforce. Access and combine disparate data without writing code. Power users can pivot, split, and manage metadata to optimize data sources. Analysis begins with data. Get more from yours with Tableau.
Exceptional analytics demand more than a pretty dashboard. Quickly build powerful calculations from existing data, drag and drop reference lines and forecasts, and review statistical summaries. Make your point with trend analyses, regressions, and correlations for tried and true statistical understanding. Ask new questions, spot trends, identify opportunities, and make data-driven decisions with confidence.
Answer the “where” as well as the “why.” Create interactive maps automatically. Built-in postal codes mean lightning-fast mapping for more than 50 countries worldwide. Use custom geocodes and territories for personalized regions, like sales areas. We designed Tableau maps specifically to help your data stand out.

Dataform is an open source tool with 77 GitHub stars and 7 GitHub forks. Here's a link to Dataform's open source repository on GitHub.

Share your Stack

Help developers discover the tools you use. Get visibility for your team's tech choices and contribute to the community's knowledge.

View Docs

CLI (Node.js)

Manual

Advice on Tableau, Dataform

Vojtech

Head of Data at Mews

Nov 24, 2019

Decided

Power BI is really easy to start with. If you have just several Excel sheets or CSV files, or you build your first automated pipeline, it is actually quite intuitive to build your first reports.

And as we have kept growing, all the additional features and tools were just there within the Azure platform and/or Office 365.

Since we started building Mews, we have already passed several milestones in becoming start up, later also a scale up company and now getting ready to grow even further, and during all these phases Power BI was just the right tool for us.

353k views353k

Comments

Wei

CTO at Flux Work

Jan 8, 2020

Decided

Very easy-to-use UI. Good way to make data available inside the company for analysis.

Has some built-in visualizations and can be easily integrated with other JS visualization libraries such as D3.

Can be embedded into product to provide reporting functions.

Support team are helpful.

The only complain I have is lack of API support. Hard to track changes as codes and automate report deployment.

230k views230k

Comments

Detailed Comparison

Tableau	Dataform
Tableau can help anyone see and understand their data. Connect to almost any database, drag and drop to create visualizations, and share with a click.	Dataform helps you manage all data processes in your cloud data warehouse. Publish tables, write data tests and automate complex SQL workflows in a few minutes, so you can spend more time on analytics and less time managing infrastructure.
Connect to data on prem or in the cloud—whether it’s big data, a SQL database, a spreadsheet, or cloud apps like Google Analytics and Salesforce. Access and combine disparate data without writing code. Power users can pivot, split, and manage metadata to optimize data sources. Analysis begins with data. Get more from yours with Tableau.; Exceptional analytics demand more than a pretty dashboard. Quickly build powerful calculations from existing data, drag and drop reference lines and forecasts, and review statistical summaries. Make your point with trend analyses, regressions, and correlations for tried and true statistical understanding. Ask new questions, spot trends, identify opportunities, and make data-driven decisions with confidence.; Answer the “where” as well as the “why.” Create interactive maps automatically. Built-in postal codes mean lightning-fast mapping for more than 50 countries worldwide. Use custom geocodes and territories for personalized regions, like sales areas. We designed Tableau maps specifically to help your data stand out.; Ditch the static slides for live stories that others can explore. Create a compelling narrative that empowers everyone you work with to ask their own questions, analyzing interactive visualizations with fresh data. Be part of a culture of data collaboration, extending the impact of your insights.	Version ontrol; Scheduling; Notifications and logging; Assertions; Web based development environment; Alerting; Incremental tables; Packages; Reusable code snippets; Unit tests; Data tests
Statistics
GitHub Stars -	GitHub Stars 934
GitHub Forks -	GitHub Forks 188
Stacks 1.3K	Stacks 818
Followers 1.4K	Followers 53
Votes 8	Votes 0
Pros & Cons
Pros 6 Capable of visualising billions of rows 1 Responsive 1 Intuitive and easy to learn Cons 3 Very expensive for small companies	No community feedback yet
Integrations
No integrations available	Amazon Redshift Google BigQuery GitHub JavaScript PostgreSQL Snowflake Git

What are some alternatives to Tableau, Dataform?

dbForge Studio for MySQL

It is the universal MySQL and MariaDB client for database management, administration and development. With the help of this intelligent MySQL client the work with data and code has become easier and more convenient. This tool provides utilities to compare, synchronize, and backup MySQL databases with scheduling, and gives possibility to analyze and report MySQL tables data.

dbForge Studio for Oracle

It is a powerful integrated development environment (IDE) which helps Oracle SQL developers to increase PL/SQL coding speed, provides versatile data editing tools for managing in-database and external data.

dbForge Studio for PostgreSQL

It is a GUI tool for database development and management. The IDE for PostgreSQL allows users to create, develop, and execute queries, edit and adjust the code to their requirements in a convenient and user-friendly interface.

Metabase

It is an easy way to generate charts and dashboards, ask simple ad hoc queries without using SQL, and see detailed information about rows in your Database. You can set it up in under 5 minutes, and then give yourself and others a place to ask simple questions and understand the data your application is generating.

dbForge Studio for SQL Server

It is a powerful IDE for SQL Server management, administration, development, data reporting and analysis. The tool will help SQL developers to manage databases, version-control database changes in popular source control systems, speed up routine tasks, as well, as to make complex database changes.

Liquibase

Liquibase is th leading open-source tool for database schema change management. Liquibase helps teams track, version, and deploy database schema and logic changes so they can automate their database code process with their app code process.

Sequel Pro

Sequel Pro is a fast, easy-to-use Mac database management application for working with MySQL databases.

DBeaver

It is a free multi-platform database tool for developers, SQL programmers, database administrators and analysts. Supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, Teradata, MongoDB, Cassandra, Redis, etc.

dbForge SQL Complete

It is an IntelliSense add-in for SQL Server Management Studio, designed to provide the fastest T-SQL query typing ever possible.

Knex.js

Knex.js is a "batteries included" SQL query builder for Postgres, MySQL, MariaDB, SQLite3, and Oracle designed to be flexible, portable, and fun to use. It features both traditional node style callbacks as well as a promise interface for cleaner async flow control, a stream interface, full featured query and schema builders, transaction support (with savepoints), connection pooling and standardized responses between different query clients and dialects.

Related Comparisons

Some of the features offered by Dataform are:

Version ontrol
Scheduling
Notifications and logging

On the other hand, Tableau provides the following key features:

Connect to data on prem or in the cloud—whether it’s big data, a SQL database, a spreadsheet, or cloud apps like Google Analytics and Salesforce. Access and combine disparate data without writing code. Power users can pivot, split, and manage metadata to optimize data sources. Analysis begins with data. Get more from yours with Tableau.
Exceptional analytics demand more than a pretty dashboard. Quickly build powerful calculations from existing data, drag and drop reference lines and forecasts, and review statistical summaries. Make your point with trend analyses, regressions, and correlations for tried and true statistical understanding. Ask new questions, spot trends, identify opportunities, and make data-driven decisions with confidence.
Answer the “where” as well as the “why.” Create interactive maps automatically. Built-in postal codes mean lightning-fast mapping for more than 50 countries worldwide. Use custom geocodes and territories for personalized regions, like sales areas. We designed Tableau maps specifically to help your data stand out.

Dataform is an open source tool with 77 GitHub stars and 7 GitHub forks. Here's a link to Dataform's open source repository on GitHub.

Dataform vs Tableau