Google's BigQuery is part of the Google Cloud Platform, a database-as-a-service (DBaaS) supporting the querying and rapid analysis of enterprise data.
$6.25
per TiB (after the 1st 1 TiB per month, which is free)
Google Sheets
Score 8.9 out of 10
N/A
Google Sheets is the spreadsheet app available on Google Workspace, or standalone, with a free plan for personal use and accessible via mobile apps for iOS and Android.
N/A
LibreOffice
Score 8.8 out of 10
N/A
LibreOffice is a free and open-source Office Suite from The Document Foundation, presented as the successor to OpenOffice.org. The suite includes Writer (word processing), Calc (spreadsheets), Impress (presentations), Draw (vector graphics and flowcharts), Base (databases), and Math (formula editing).
$0
free and open source under the Mozilla Public License v2.0
Pricing
Google BigQuery
Google Sheets
LibreOffice
Editions & Modules
Standard edition
$0.04 / slot hour
Enterprise edition
$0.06 / slot hour
Enterprise Plus edition
$0.10 / slot hour
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
Google BigQuery
Google Sheets
LibreOffice
Free Trial
Yes
No
No
Free/Freemium Version
Yes
No
Yes
Premium Consulting/Integration Services
No
No
No
Entry-level Setup Fee
No setup fee
No setup fee
No setup fee
Additional Details
—
—
—
More Pricing Information
Community Pulse
Google BigQuery
Google Sheets
LibreOffice
Considered Multiple Products
Google BigQuery
Verified User
Analyst
Chose Google BigQuery
Main reason is how it integrates directly with the google ecosystem which really facilitates the automatization proceses for the whole company. This ensures that sales and all the other departments have the correct information on a daily bases with a ease of use with day to day …
Compared to PostgreSQL and MySQL, Google BigQuery is faster and more scalable for large datasets. It’s serverless, so there’s no need to manage infrastructure. We chose Google BigQuery for its ease of use built-in analytics features
I have used other data manipulation tools like SQL Server and Google BigQuery feels more intuitive, Google provides so much documentation and tutorials that getting to know the software is not only easy but even satisfactory, so I'd say Google BigQuery is very superior to that …
Google Sheets is newest of all and is easy to understand. It has better UI or display then rest all. Minimal design helps to focus more on work. In built chat features is one that makes it stand out of league then rest of all. Unlike MS Excel and LibreOffice it is available …
Google Sheets collaborative mode and integration with google drive makes it much easier to share data across teams or organizations, while also allowing for multiple users on the product. The functionality of equations, appscripts, and AI integrations make it invaluable …
Google Sheets is the best online application for spreadsheets. I think it's far above the rest in terms of features and sharing capabilities. The other programs all have standalone applications that can take advantage of an individual user's computer to process large swaths of …
Microsoft Office 2016 is the premium option for word processing, but in my line of work the content is more important than the presentation. I am mostly content to work in Google Docs unless working with documents of a sensitive nature. Then I use LibreOffice.
Event-based data can be captured seamlessly from our data layers (and exported to Google BigQuery). When events like page-views, clicks, add-to-cart are tracked, Google BigQuery can help efficiently with running queries to observe patterns in user behaviour. That intermediate step of trying to "untangle" event data is resolved by Google BigQuery. A scenario where it could possibly be less appropriate is when analysing "granular" details (like small changes to a database happening very frequently).
Google Sheets is well suited in two main areas: is free to use and you don't need to buy a license to use it, comparing to the most direct competitors ; collaboration is in my opinion the best advantage, with multiple people working together and seeing others working in real time. It's less appropriate in low connectivity environments (offline capabilities)
If you're working with numbers, LibreOffice doesn't get in your way and try to make changes as it sees fit, forcing you to repeatedly go back and undo processes you didn't want, didn't ask for, and that have no place in the document you are trying to produce. All I want to do is assemble the data, process it for the task at hand, and then print it for distribution. LibreOffice allows me to do that.
GSheet data can be linked to a BigQuery table and the data in that sheet is ingested in realtime into BigQuery. It's a live 'sync' which means it supports insertions, deletions, and alterations. The only limitation here is the schema'; this remains static once the table is created.
Seamless integration with other GCP products.
A simple pipeline might look like this:-
GForms -> GSheets -> BigQuery -> Looker
It all links up really well and with ease.
One instance holds many projects.
Separating data into datamarts or datameshes is really easy in BigQuery, since one BigQuery instance can hold multiple projects; which are isolated collections of datasets.
Collaborative planning : In the initial phase of project, Team leads and architects create a permission matrix along with the naming convention simultaneously, seeing who is editing / adding the details in real-time.
Cost tracking : We use this tool to track cloud resource usage monthly costs, so that we can analyse it and send out comms for high cost based resources. By storing cost data here, it's easy for use to store data of last couple of years.
Flexible documentation : For change logging of different scenarios we would need different / ad-hoc columns to be added on the fly, which makes using this tool much simpler then reputed third party tools.
Please expand the availability of documentation, tutorials, and community forums to provide developers with comprehensive support and guidance on using Google BigQuery effectively for their projects.
If possible, simplify the pricing model and provide clearer cost breakdowns to help users understand and plan for expenses when using Google BigQuery. Also, some cost reduction is welcome.
It still misses the process of importing data into Google BigQuery. Probably, by improving compatibility with different data formats and sources and reducing the complexity of data ingestion workflows, it can be made to work.
We have to use this product as its a 3rd party supplier choice to utilise this product for their data side backend so will not be likely we will move away from this product in the future unless the 3rd party supplier decides to change data vendors.
I am not involved in the purchase/selection process, but my organization is a Google shop, and Sheets meets most of our spreadsheet needs and works seamlessly with our other tools. I don't anticipate our switching anytime soon.
We use it consistently and have a lot of documents in the OpenDocument format so it will be necessary to use LibreOffice or a compatible product such as Openoffice in the future to be able to open these files. Because the license fee for Libreoffice is zero it is not very costly to keep using it - the costs are mostly for keeping it installed on the office PCs and regularly updated, and solving employee issues with the user support.
I think overall it is easy to use. I haven't done anything from the development side but an more of an end user of reporting tables built in Google BigQuery. I connect data visualization tools like Tableau or Power BI to the BigQuery reporting tables to analyze trends and create complex dashboards.
It can easily handle most uses and functions. It is only for very large datasets or advanced analysis that it either lacks the proper functions or performance begins to slow. Most employees who continue to use competitors' products do so out of preference, familiarity with the user interface, or other surface-level reasons.
For all of the reasons in the foregoing evaluation. Its menus are clean, intuitive and straightforward. Any function I need to use can be accessed via keystrokes, without having to stop, move my hand to the mouse, deal with it, and then get back to the keyboard to proceed. It helps me keep my mind on my work and not worry about dealing with the mouse all the time.
I have never had any significant issues with Google Big Query. It always seems to be up and running properly when I need it. I cannot recall any times where I received any kind of application errors or unplanned outages. If there were any they were resolved quickly by my IT team so I didn't notice them.
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.
Libreoffice is a desktop app not requiring any server part so it is always available when the PC is working normally. Installing it on another machine if one PC fails is very quick and easy. This is a non-issue.
I think Google Big Query's performance is in the acceptable range. Sometimes larger datasets are somewhat sluggish to load but for most of our applications it performs at a reasonable speed. We do have some reports that include a lot of complex calculations and others that run on granular store level data that so sometimes take a bit longer to load which can be frustrating.
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.
For big/imported tables or text documents with images loaded from the internet it is sometimes getting very slow, RAM and CPU intensive, and sometimes even hangs due to some memory leaks or other bugs. This is a long-term problem and is still not resolved perfectly.
BigQuery can be difficult to support because it is so solid as a product. Many of the issues you will see are related to your own data sets, however you may see issues importing data and managing jobs. If this occurs, it can be a challenge to get to speak to the correct person who can help you.
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.
Support is not officially offered. However, you can find answers to any usage questions or trouble-shooting online easily, typically starting with a Google search. (I believe that all forums / tips for OpenOffice apply equally to LibreOffice, and vice versa.) While Microsoft Office, for example, officially includes support, I find that typically you end up going to a Google search in any case. So, this is not really a downside. However, in all these cases, you end up doing a lot of figuring things out for yourself.
Generally easy to perform, issues are how to ensure regular automatic updates on Mac OS X. Fortunatly we have only a few machines with OS X run by management and we can do these updates manually occasionally. Windows updates are quite easy with the support of third party software such as Ninite or Chocolatey, and Linux updates are super-easy thanks to the package manager (apt-get).
PowerBI can connect to GA4 for example but the data processing is more complicated and it takes longer to create dashboards. Azure is great once the data import has been configured but it's not an easy task for small businesses as it is with BigQuery.
I have found that I can do almost everything I could have done in Microsoft Excel faster and easier in Google Sheets. We recommend Google Sheets in 99.9% of our use cases and feel it meets the needs of our workers very well. I am sure there are other spreadsheet creation programs out there, but because we are already in the Google environment, adopting Google Sheets in very easy.
If you are looking for a well-rounded, GNU-licensed product that will encompass word processing, spreadsheets, presentations, and database then LibreOffice is probably all you need.
For online collaboration, links with cloud storage, and more robust support, Microsoft Office 365 and Google Docs are probably what you or your organization needs.
LibreOffice is at its best for regular document creation and spreadsheet management. It is more cumbersome when it comes to fonts but also when it comes to linkages with cloud-based services. It is there, but you need some more computer knowledge to make it work.
There are other free alternatives, most notably Apache Open Office, which is also a very good alternative if you do not like LibreOffice.
Having said that, I honestly think off-line computers or laptops used off-site can certainly benefit from having LibreOffice installed.
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.
We have continued to expand out use of Google Big Query over the years. I'd say its flexibility and scalability is actually quite good. It also integrates well with other tools like Tableau and Power BI. It has served the needs of multiple data sources across multiple departments within my company.
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.
With more users using it in the company there are more cases when a simultaneous editing of the same document is needed and this feature is lacking in Libreoffice even though the files concerned are shared and synced by some solution (we use ownCloud). Google Docs or MS Office365 via Sharepoint/Onedrive offer a better function for this.
Google Support has kindly provide individual support and consultants to assist with the integration work. In the circumstance where the consultants are not present to support with the work, Google Support Helpline will always be available to answer to the queries without having to wait for more than 3 days.
Previously, running complex queries on our on-premise data warehouse could take hours. Google BigQuery processes the same queries in minutes. We estimate it saves our team at least 25% of their time.
We can target our marketing campaigns very easily and understand our customer behaviour. It lets us personalize marketing campaigns and product recommendations and experience at least a 20% improvement in overall campaign performance.
Now, we only pay for the resources we use. Saved $1 million annually on data infrastructure and data storage costs compared to our previous solution.
Don't need to pay for windows 365 license as it is free
Has a positive impact since I am not cursing excel for annoying problems(I don't want the new Pivot table format, I want to use Classic and I don't want to expand/collapse arrows. "x$#%")
[Haven't] looked at return on investment on work, but has "simplified" for basic and medium spreadsheets.
I am able to quickly create and edit word processing documents and spreadsheets which are for all intents and purposes equivalent to documents I could create and edit in other tools such as Microsoft Office and Google Docs/Sheets.
Lack of an online portal for sharing documents necessitates the use of Google Sheets for automation/integration. Ideal would be an all-in-one solution.
Having open-source software that provides common functionality eliminates the need for expensive licenses.
Lack of dedicated support is negligible. Most issues can be resolved using online search.
