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)
Vena
Score8.1 out of 10
Mid-Size Companies (51-1,000 employees)
Vena Solutions provides a financial process automation solution to automate Corporate Performance Management, accounting and budgeting, Regulatory & Compliance, and other finance-related processes. It is scaled for medium to large-sized organizations.
N/A
Pricing
Google BigQuery
Vena
Editions & Modules
Standard edition
$0.04 / slot hour
Enterprise edition
$0.06 / slot hour
Enterprise Plus edition
$0.10 / slot hour
Professional
N/A
Complete
N/A
Offerings
Pricing Offerings
Google BigQuery
Vena
Free Trial
Yes
No
Free/Freemium Version
Yes
No
Premium Consulting/Integration Services
No
Yes
Entry-level Setup Fee
No setup fee
Optional
Additional Details
—
The Professional Plan is the most flexible way to get started quickly and can be added onto as a company grows. The plan includes: Vena Platform, Customer Success Manager, Standard Support and Customer Portal.
Complete Plan includes everything in Professional, plus: Vena Insights, Premium Support, Sandbox Environment, and Expert Managed Services.
For a limited time, new customers who use Microsoft Dynamics 365 Business Central (Online) as their primary ERP can get a free year of Vena and 40% off implementation costs.
Vena also offers special pricing for not for profit organizations. To learn more, speak to an expert.
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).
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. TR verified that a representative sample of customers was invited. More Info
It is well suited for planning, budgeting, and forecasting. Using its capabilities also allows you to use it for reporting, whether it's month-end reporting or other reporting where you want to rely on data from a source that can be nicely presented and adjusted in Excel.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
The Admin function of Vena, being able to set up the users in the user categories and the different groups and assigning the groups and the task bindings, is particularly easy and very helpful because as we have so many different departments and disciplines in our organization, we do need to establish pretty specific user access so this process works really well for us.
Running reports in Vena is fairly easy, and we do enjoy being able to just push a button and get some budget versus actuals.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Have another license between power user and contributor that allows building reports that aren't ad hoc, but don't have all the admin rights of a power user.
Have a session on best in class Workforce Planning prior to implementation.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. TR verified that a representative sample of customers was invited. More Info
Vena has become an integral part of finance and our daily process. Without it we would take longer to prepare results and decisions will be delayed. Vena has given the whole organization more visibility of results and budgets so that all departments participate more actively in managing their budgets rather than it being the sole responsibility of finance.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Vena is somehow easy to manipulate. If you want to map accounts, or change mapping. there are clear instructions and guidance. and also Vena AI is on the way, so i think we can leverage it more and let AI help us mapping and check errors. overall a very good product and easy to learn and set up.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Vena is seemingly always available. They plan maintenance windows well in advance and always off hours (typically over a weekend) and communicate clearly throughout maintenance about what will be affected. Over 5 years of using the product, I can only remember one time when the platform was unavailable (I believe due to an underlying server hosting issue from their provider), and they resolved the issue and had everything up and running again within 8 hours.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
The performance is dependent on how much data and calculations are involved and how complex the security settings are. A simple template or report loads in seconds. A complex template or report can take a while. If there are many users with complex security settings, that will be a factor in the load time.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
When I reach out to our support team, they are always able to fix any issues we are having in a timely manner. It is always resolved quickly which proves that customer support always helps out our support team with any issues so they can in turn help us quickly
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
This is the best way to learn and buy-in. The in person effect gives students both a hands on approach but an instruction to be there to customize assistance and understanding. In person also builds greater buy in with your future team on creators. However if your audience is better at on line learning this is another good option.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
The training was structured as a group training to learn the basics of creating a data model and mapping a template. While we had nearly 10 participants, I was the only actual implementer so we probably didn't actually need the training and could have just learned the initial skills from the implementation consultant. Two years later, when we hired a new team member, they completed several modules in Vena Academy (a self paced learning course) which allowed them to get up to speed on the basics with just a bit of supplemental guidance from me as our existing admin.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
The Vena consultant had great knowledge of both the Vena solution and Excel and Excel functions. He was able to help suggest ways to build our templates that met our requirements using Excel functions we had not previously considered using. And we have been able to use the Excel information he provided in other ways outside of Vena. He was very patient and flexible as we learned the Vena tool and created templates
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. TR verified that a representative sample of customers was invited. More Info
Previously used Synario for long-term forecasting. Ultimately moved to Vena for this to keep budgeting and forecasting together in a single solution. Vena's system is much easier to learn on the admin side since it is Excel-based so the transition was pretty simple. Previously used Jenzabar with JICS for budgeting. Vena's budget system is more user-friendly for end users and more flexible so it works better for our specific needs. Vena's reporting system is easier to use and customize.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Vena solutios is a software that provides robust tools that help different departments in their statistics and we can visualize a lot of promising and visually attractive data. Vena Solutions' level of scalability is high and sustainable over time thanks to the fabulous technical support that is ready to help us at all times
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. TR verified that a representative sample of customers was invited. More Info
Vena has helped save time by reducing the manual work involved with budgeting, reporting, and variance analysis. Instead of spending as much time organizing data and reconciling spreadsheets, I can focus more on reviewing results and making informed decisions. It has improved collaboration between teams and provided better visibility into financial performance, creating more efficient processes overall.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
