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 BusinessObjects Business Intelligence
Score 8.1 out of 10
N/A
The SAP® BusinessObjects™ Business Intelligence Platform provides users with ad hoc queries, reporting, data visualizations, and analysis tools. Its integrated, unified infrastructure aims to offer scalability from one-to-many tools and interfaces on-premise, in the cloud, or as a hybrid approach.
Google BigQuery really shines in scenarios requiring real-time analytics on large data streams and predictive analytics with its machine learning integration. Teams have been using it extensively all over. However, it may not be the best fit for organizations dealing with small datasets because of the higher costs. And also, it might not be the best fit for highly complex data transformations, where simpler or more specialized solutions could be more appropriate.
The proper management of SAP BusinessObjects Dashboards requires an expert on the team to manage and build reports. If an organization does not have the proper expertise on board to build and deploy reports it will fail. Data analytics, dropping into excel, and broadcasting of information are major bonuses for the use of SAP BusinessObjects Dashboards.
Its serverless architecture and underlying Dremel technology are incredibly fast even on complex datasets. I can get answers to my questions almost instantly, without waiting hours for traditional data warehouses to churn through the data.
Previously, our data was scattered across various databases and spreadsheets and getting a holistic view was pretty difficult. Google BigQuery acts as a central repository and consolidates everything in one place to join data sets and find hidden patterns.
Running reports on our old systems used to take forever. Google BigQuery's crazy fast query speed lets us get insights from massive datasets in seconds.
This software is easy to initially learn, and very powerful in producing reusable reports.
It is much faster than my company's internal manual queries. The ability to build off of a saved query and share queries to other users is a great positive.
My favorite part is that you can run queries in the background and it does not interfere with your current work or slow your computer down.
It is challenging to predict costs due to BigQuery's pay-per-query pricing model. User-friendly cost estimation tools, along with improved budget alerting features, could help users better manage and predict expenses.
The BigQuery interface is less intuitive. A more user-friendly interface, enhanced documentation, and built-in tutorial systems could make BigQuery more accessible to a broader audience.
The installation can be very complex and time-consuming, it requires a lot of planning and foresight as to what role the software will play in the organization.
The software has a relatively large learning curve that takes dedicated users months to get comfortable with, the UI is a bit intimidating for new users.
SAP could organize their help better, it can be difficult to find dependable solutions to issues via their website and support channels.
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.
The institution has decided to move in a different direction, and will be using MSBI for reporting. I have been very happy with the Business Objects suite of tools, and will continue to use them heavily until we make the transition.
web UI is easy and convenient. Many RDBMS clients such as aqua data studio, Dbeaver data grid, and others connect. Range of well-documented APIs available. The range of features keeps expanding, increasing similar features to traditional RDBMS such as Oracle and DB2
From a server and client side perspective. the Business Intelligence Platform provides a foundation for all aspects of content development, distribution, analysis, collaboration and self service. Ease of use from targeted content delivery through controlled accessibility. Content exporting in the format of the users choice. Scheduling for internal or external delivery. Public and private folders for secure content access when requied. Web based for viewing on the users device of choice without the need to download additional applications.
Overall, the tool (Web Intelligence 4.2) is fast and solid. One issue is a dependability on JAVA for a full feature report creation/edit capabilities (as opposed to limited HTML option). Second, planned end of JAVA support by major browsers (Chrome is already not supporting JAVA applet).
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.
SAP has released various versions of SAP BO BI. starting from 3.1 and going to 4.0,4.1,4.2 and latest being 4.3. SAP provides support to these new versions. As new versions keep on coming, support for the very old software goes out of scope from SAP. it is when the different organization plans to get their BO content migrated from a lower version to a newer version. The newer version had definitely added functionality and features which ease the work of users.
Hire specialists and experienced staff. Mix some beginners so that everyone is not a leader but a learner too. Plan well; architect well; break down implementation in small steps and move towards larger steps. Create a centralized and authorized SAP Business Objects implementation team.
I have used Snowflake and DataGrip for data retrieval as well as Google BigQuery and can say that all these tools compete for head to head. It is very difficult to say which is better than the other but some features provided by Google BigQuery give it an edge over the others. For example, the reliability of Google is unmatchable by others. One thing that I really like is the ability to integrate Data Studio so easily with Google BigQuery.
We selected SAP BusinessObjects Business Intelligence (BI) based on price. It can stack up against others in terms of price and honestly, that's about it. Salesforce Commerce does a hell of a better job at handling it. However, in the space of Business Intelligence, SAP can do more, and that's why at the end we went with it
SAP BusinessObjects Business Intelligence (BI) Platform supports SOA Service Oriented Architecture. You can start/restart/enable/disable all the servers. You can seamless do load balancing and clustering. It supports all leading application and web server. Supports LDAP SSO integration. People who can work on excel with training they can work on SAP Business Objects Web Intelligence, dashboard, Lumira, Information design tool product suite. Tool is very user friendly and easy to learn and implement
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.
Pricing has been very reasonable for us. The first 10 GB of storage is free each month and costs start at 2 cents per GB per month after that. For example, if you store 1 terabyte (TB) for a month, then the cost would be $20. Streaming data inserts start at 1 cent per 200 megabytes (MBs). The first 1 TB of queries is free, with additional analysis at $5 per TB thereafter. Meta data operations are free.
Big Query helps reduce the bar for data analytics, ML and AI. BQ takes care of mundane tasks and streamlines for easy data processing, consumption. The most impressive thing is the ML and AI integration as SQL functions, so the need for moving data around is minimized.
The visuals of ML models is very helpful to fine tune training, model building and prediction, etc.
By generating and distributing reports in a timely manner, we were able to save millions of dollars for the company which otherwise would not have been visible.
Almost realtime dashboard, saved the company a huge amount by showing the outages and kept the company from buying a tool to do just that.
It showed the customers who were not paying the bills and were missing in the system due to some loophole. This was visible by doing reporting on the theft usage of electricity.
