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)
SAP Business One
Score8.5 out of 10
N/A
SAP Business One is an integrated enterprise resource planning (ERP) solution for small and medium-sized businesses, The product encompasses functionality around sales, customer relationships, inventory, operations, financials and human resources.
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
SAP Business One would be more useful if it contained tools to acommodate the growing need of online sales. A more complete shipping module which handles tracking numbers with the common couriers would be great. A built in warehouse management system would be great designed to be used with barcode scanners
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
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
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
Following a bench mark process - this seems contradicting to flexibility however we have wished we could follow more of an industry benchmark. Our challenge as a small company has been knowing how to properly use the system. We have discovered that we have set up the system wrong based and are using it improperly which has cause a lot work to correct.
Better live reporting options - current we are on prem SQL. Yes SAP is moving to HANA however smaller companies like ourselves are not ready for that. We need to be able to maintain our existing SQL DB. We also have a demand for live BI Reporting. It has been difficult to do this with our current set up.
Error handling - have found it very difficult to troubleshoot. Errors are not always clear and answers are hard to find.
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
As I said before, it is a first level tool, well developed, and with very strong development support, although the learning curve, its implementation, the cost-benefit ratio, the price and the user experience is not the most suitable for small and medium-sized companies. It is a company with extensive experience, market positioning, technical support and expanded use
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
I would like to give 8 out of 10 rating for SAP Business One because SAP Business One is a good choice for the mostly used business management solutions for the small and medium-sized companies. SAP Business One can help in optimizing the existing business process and enables streamline business processes for the daily activities for all users across the entire organization. The importance realization of SAP Business One implementation is based on the selection of the good reputation partner and its approach for the entire implementation. SAP Business One is a user-friendly and easy to use Enterprise system that the organization can benefit its features and functionalities by utilizing it.
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
The SAP Business One software is up and running every time you need it as it was planned. In more than 6 years that we have been using the product, it has never been unavailable and if it ever was, it was because of a planned maintenance window scheduled in the 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
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
SAP Business One performance depends mostly on the speed of your internal servers, should you have the solution on premise as we do. Sometimes the system tends to be a little slower for some users when others are executing really big reports of performing some batch loads, but generally, the performance is acceptable to all the users.
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
I rate my experience with SAP Business One's support team as excellent (10). They are easy to contact and effortless to work with on any issue or concern. I like the support SAP provides for any of their products. SAP has a great backing and I would recommend them to any of my colleagues.
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 I get was a consultant level training, so it's basically a 6 weeks training covering every aspect and every module of the system. It covered most common use cases and exercise training so you can get along with the software, as well as examples so there culd be a better understanding.
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
Over the past two years SAP has added a great deal of new SAP Business One on-line training for version 9.0 and 9.1. Most of the training is very strong, but some is difficult to understand and follow. Additionally, SAP still has a few holes in their on-line training around Production, Bill-of-Materials, MRP and Service.
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
These implementations are not easy. Even a standard implementation can be difficult. With a never-been-done-before implementation, the implementation team and the user team need to be thorough with planning, make a decision on key points, and stick to them before any design happens. Our biggest challenge was not from StellarOne, rather it was from the mid-implementation decisions from our internal team. StellarOne did a great job warning us, implementing our decision, and then helping us adjust our SAP to handle the new direction we took.
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
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
SAP provides the most robust solution, with modules available for all department managers and even options for customization according to the company's special needs. We especially used the Crystal reports options to provide reports for each module. Overall, even if it's not the least expensive option, it has the best value for money.
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
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
For most small businesses, the only way you outgrow SAP Business One is if the nature of your business changes radically. Going from 1 to 50 users is quite easy with SAP B1. Going beyond 50 may require moving to the Hana SAP B1 platform to maintain or improve performance, but the path is there. Add-ons to SAP B1 can also be added as specific needs are encountered that are not closely met by the standard product. These may be required early in the product life because of the nature of your business, or as you expand the use of SAP B1.
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
Employee efficiency has definitely increased with SAP Business One. This is attributed in a lot of ways to information visibility. Our employees are able to gather the data they need, quickly, and effectively.
Identifying inconsistencies in pricing has also been accomplished through use of reporting off individual tables. Previously, we weren't able to access our data in such a way as to enable us to write custom reports in-house.
We have also benefited greatly from having a single source of all business information. We utilize SAP Business One exclusively in-house. All documentation is attached to specific orders and Business Partners, as well as serialized equipment that has been sold.
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
