Google Sheets vs. Tableau Public

Google Sheets is great for just recording tabular information that needs to be shared with and/or edited by multiple people. Sharing and collaborating is especially convenient because Sheets is designed to be browser-based; while Excel has a browser version, it's limited compared to the desktop app. Google Sheets's editing, suggesting, commenting, and viewing permissions settings are absolutely perfect for my department. Google Sheets does not handle large datasets well. It does not load in a timely manner and often freezes. Apps Scripts fail to process large amounts of data.

Incentivized

Tableau public is the best platform to build dashboards for your personal profile and share with recruiters. It's always good to keep ourselves updated on the latest features, create sample dashboards and save them to a personal profile. Tableau public is free and doesn't need any subscription. anyone can create an account and start building reports.

• It is a cloud-based platform.
• You can work in the same file simultaneously with your colleagues.
• It allows you to share files much faster.
• It allows you to access your Google Sheet files whenever you like and wherever you like if you have stable internet connection.
• It has great integration with other Google software.
• Google Sheets is very user-friendly and very intuitive to use.

Incentivized

• Data visualization: lots of different options, including bar, scatter, pie, waterfall charts to explore relationships between variables, and to present findings/trends to different teams
• Integrates readily with limited, though different data sources: TXT, CSV, TDE, Access
• Exports reports for review of different dashboards: client-ready/team-ready, with a clean and tidy presentation in PDF format (or hardcopy)

Incentivized

• Pivot tables are different but could be improved upon; sort, totals, filters
• When entering negative numbers as the first in a formula you need to remember to "+-100+25" instead of "-100+25"
• The power of the internet of course makes it easy to find solution, but the help function is not easily available
• Color coding changes on the cell, but there is not an easy way to click on a cell and use the selected color; like excel

Incentivized

• Tableau Public (both Desktop and Server) like their "for a fee" counterparts offer very easy to learn and use tools to transform data into pictures and gain insights into your data. Most organizations report a reduction in development time of 10x vs. other similar tools, due to the intuitive user interface. That said, with Tableau Public, published workbooks are "disconnected" from the underlying data sources and require periodic updates when the data changes. Users are limited to 1 Gb of storage space per user ID and password as well.
• I would like to see better options for public sharing of visualizations and data from within the "for a fee" products as more and more organizations are moving in the direction of data sharing with partners and their communities.

Incentivized

It is easy to use, free of charge for basic functionality, and easy to share with people within or outside your team or company

Incentivized

It's free, right? I'll keep using the free version. So the real question to ask is this? Will I pay $999 for the Personal version or $1,999 for the Professional? Yikes! That is a big stretch. I'm not sure about that. The product comparison chart is at: http://www.tableausoftware.com/public/comparison

Overall the formula functions could improve but there's workarounds for them. Utilzing different formulas or approaches for building out accounting schedules. While collebrating with multiple team members and different departments being able to go in and see where others are on the sheets is helpful. Google Sheets overall is a great product

Incentivized

Tableau public is a great training tool to understand the basics of Tableau before buying it. A great tool to extend Excel's visualization and to publish data for others. Not useful for anything you need secure. No ability to access databases. Static information only.

Like most Google products, Google Sheets rarely has outages or slowness, and when it does, connection is always momentarily restored. I can't recall a time when I've been unable to access Google Sheets but able to access other sites just fine. That said, errors aren't uncommon when handling large data volume. You know what they say about using spreadsheets as databases, but sometimes it's just the most convenient option, especially for smaller or one-off projects, and not being able to store large amounts of data hampers our ability to move quickly with scrappy prototypes or full solutions. It would be great if we could better integrate our data manipulation (Apps Script) with big data in the sheet.

Incentivized

Again, Google Sheets is no exception to Google's general high speed and reliability, but load times can be slow for larger amounts of data. I've used Sheets with Zapier and have used the Python API, and speed has never been an issue.

Incentivized

I have never contacted Google Sheets support, but Google Sheets makes it very easy to report an issue or suggest a feature from Sheets itself (Help > Help Sheets improve), and I've had mostly good experiences with support for other Google products.

Incentivized

I have not yet required to contact support as the documentation and help i found online has always worked so far

Incentivized

I found it sufficient, and fast. I could easily "kick the tires" with Tableau on my data so I got up and running fast.

Start at the end and work backward. Identify the business case / issue and questions the end users have, then identify the data needed, and where to get it.

Incentivized

The major reason I use Google Sheets over Microsoft Excel and Apple Numbers is for its ability to allow multiple users to access and work on the same spreadsheet at once. This is incredibly more efficient and effective than updating and sending copies upon copies of the same Excel or Numbers spreadsheet back and forth as email attachments.

Incentivized

Google Charts/Drive is sufficient for simpler data sets, but it does not integrate with other web platforms and the visualization does not look as professional. I'm not aware of any other competitors that offer the same package as Microsoft.

Incentivized

I'm not involved with the purchase, but I assume everything goes smoothly and that the pricing structure is predictable and reasonable. We do not get surprise fees.

Incentivized

Google Sheets works very well with multiple users. It's convenient to see in real-time who is collaborating in a sheet, down to the specific cell that they're viewing/editing. Linking Sheets across departments is convenient with the IMPORTRANGE function.

Incentivized

• We've used it to prepare quick budgets, presentations for funds that have helped raise money
• It has helped us quickly analyze raw data, collaboratively.
• it has helped us work more efficiently by making it easier to work from one sheet and not lose track of versions by passing around attached documents

Incentivized

• Tableau Public visualizations have helped drive traffic to our content and sites
• The lack of cost means it's easy to demonstrate our experience to attract paying clients

Incentivized