BigQuery vs SAS Viya

Last Updated:

Our analysts compared BigQuery vs SAS Viya based on data from our 400+ point analysis of Big Data Analytics Tools, user reviews and our own crowdsourced data from our free software selection platform.

Product Basics

BigQuery, a cloud-based data warehouse offered by Google, provides businesses with a scalable and cost-effective solution for analyzing massive datasets. It eliminates the need for infrastructure management, allowing users to focus on extracting valuable insights from their data using familiar SQL and built-in machine learning capabilities. BigQuery's serverless architecture enables efficient scaling, allowing you to query terabytes of data in seconds and petabytes in minutes.

BigQuery is particularly well-suited for organizations dealing with large and complex datasets that require rapid analysis. Its ability to integrate data from various sources, including Google Cloud Platform and other cloud providers, makes it a versatile tool for businesses with diverse data landscapes. Key benefits include scalability, ease of use, and cost-effectiveness. BigQuery offers a pay-as-you-go pricing model, allowing you to only pay for the resources you consume. You are billed based on the amount of data processed by your queries and the amount of data stored.

While BigQuery offers numerous advantages, it's important to consider factors such as your specific data analytics needs and budget when comparing it to similar products. User experiences with BigQuery have generally been positive, highlighting its speed, scalability, and ease of use. However, some users have noted that the pricing structure can become complex for highly demanding workloads.

read more...
SAS Viya is a cloud-based in-memory analytics engine that provides data visualization, reporting and analytics to businesses for actionable data insights. Powered by AI, it brings together visual analytics, visual statistics and data science for enterprises to achieve end-to-end self-service analytics. It uses a standardized code base with support for programming in R, Python, SAS, Java and Lua.

Deployable in the cloud, on-premises and hybrid environments, it integrates with a wide range of business applications through an agile, scalable architecture. The vendor offers an introductory 30-day free trial.

Pros
  • Comprehensive features
  • Powerful analytics capabilities
  • User-friendly interface
  • Scalable architecture
  • Strong support from SAS
Cons
  • Steep learning curve
  • Limited customization options
  • High cost of ownership
  • Potential vendor lock-in
  • Resource-intensive
read more...
$6.25/TiB, Usage-Based
Get a free price quote
Tailored to your specific needs
$10,000 Annual
Get a free price quote
Tailored to your specific needs
Small 
i
Medium 
i
Large 
i
Small 
i
Medium 
i
Large 
i
Windows
Mac
Linux
Android
Chromebook
Windows
Mac
Linux
Android
Chromebook
Cloud
On-Premise
Mobile
Cloud
On-Premise
Mobile

Product Assistance

Documentation
In Person
Live Online
Videos
Webinars
Documentation
In Person
Live Online
Videos
Webinars
Email
Phone
Chat
FAQ
Forum
Knowledge Base
24/7 Live Support
Email
Phone
Chat
FAQ
Forum
Knowledge Base
24/7 Live Support

Product Insights

  • Forecast and Plan Ahead: Ingest large amounts of data quickly to strengthen forecasting and boost decision-making processes. 
  • Deliver Insights: Find discrepancies in data and act on them accordingly. 
  • Focus on Analytics and Not Infrastructure: Handles large volumes of data without putting strain on an organization’s IT resources. 
  • Provide a User-Friendly Environment: It’s user-friendly for both technical and non-technical users. High-level knowledge is not necessary to operate the software effectively. 
  • Speed Up Processes: Utilizes fast SQL databases to quickly and efficiently analyze terabytes worth of data. 
read more...
  • Improve Decision-Making: Make informed business decisions by using historical and current proprietary information to derive analytical insights. Compute vast amounts of data faster and resolve complexities through parallel processing. Boost workflow efficiencies by deploying operational decisions that define real-time best actions at scale. 
  • Self-Service Analytics: Easily perform automated forecasting, goal-seeking and scenario analysis — no technical skills needed. Identify user sentiment through text analytics and incorporate geographical data for a complete picture of business metrics. 
  • Maximize ROI: Save time through built-in automation for data prep, feature engineering, algorithm selection and AI-powered data discovery. Innovate, rather than spending time on tedious data management and analytics tasks. 
  • Data Security: Ensure data encryption at rest and while moving across systems, in addition to auditing protocols. Connect to external data management systems like Oracle, Teradata, Facebook, Amazon and Esri seamlessly through Kerberos, SAML, OAuth and OpenID. 
  • Data Management: Import data by using an IDE or through REST APIs, and visualize and analyze it through self-service data prep. Join tables, apply functions and perform calculations, or drag-and-drop, pivot, and slice and dice to view desired metrics. 
  • Augmented Analytics: Identify relationships in data through automatically generated suggestions and guided analysis, and track anomalies and outliers. Tell data stories by generating easy-to-understand visuals and dashboard summaries in natural language. Derive meaningful insights for the future by creating what-if scenarios for forecasting and predictive analytics. 
  • Mobility: Access business reports on the go through a native mobile app that supports a variety of charts, graphs and tables. Configure app functionality per device for specific users to add and view reports, share links, add and view comments and view alerts. 
  • Scalable Architecture: Leverage its modular microservices architecture to scale as per business needs. Monitor and manage the health and configuration of individual microservices instances through the SAS Environment Manager. Deploys seamlessly to any type of environment, including the cloud, and runs on Cloud Foundry as a platform-as-a-service (PaaS). 
read more...
  • Machine Learning: Comes with machine learning modules that can perform mass-segmentation and recommendations in seconds. These modules can be built and trained within minutes without ingesting data for training. 
  • Cloud Hosted: Handles all the hardware provisioning, warehousing and hardware management from the cloud. 
  • Real-Time Analytics: Large volumes of business data are quickly analyzed and presented to the user to ensure that insights and data discrepancies can be immediately uncovered. 
  • Automated Backups: Data is automatically stored and backed up multiple times a day. Data histories can be easily restored to prevent loss and major changes. 
  • Big Data Ecosystem Integrations: Integrate with other big data products such as Hadoop, Spark and Beam. Data can be directly written from the system into these products. 
  • Data Governance: Features such as access management, filter views, encryption and more are included in the software. The product is compliant with data regulations such as the GDPR. 
read more...
  • Visualization and Reporting: Dig into data for in-depth analysis and view key business metrics through autonomous data exploration and manipulation. Create and customize interactive reports and charts to share with others across the organization for collaborative insight. Get suggestions on graphics best suited to display pertinent data through auto charting. 
  • Data Modeling: Analyze data with predictive models through regression, clustering and neural networks. Ensure version control by tracking data models from creation through usage by registering, validating and monitoring each version. Creates snapshots of model properties and files and retains them for the future. 
  • Visual Statistics: Build diverse scenarios simultaneously and refine them with what-if analyses to uncover insights through experimentation. Unifies all business tools, irrespective of the language they support, into a common visual analytics solution. 
  • Cloud Integrations: Develop low-code technologies by porting SAS open-source models into mobile and business applications through its cloud-native capability. Optimize analytics workloads on clouds like Microsoft Azure and ensure cost-efficient migration of analytics to the cloud through a workload management tool. 
  • ML-Based Insights: Get valuable insights from new data types by combining structured and unstructured data in integrated machine learning programs. Choose the desired ML algorithm from a range of options and easily find the optimal parameter settings. Use Python within Jupyter notebooks for deep learning functions like computer vision, natural language processing, forecasting and speech processing. 
read more...

Product Ranking

#10

among all
Big Data Analytics Tools

#41

among all
Big Data Analytics Tools

Find out who the leaders are

Analyst Rating Summary

we're gathering data
94
we're gathering data
96
we're gathering data
100
we're gathering data
98
Show More Show More

Analyst Ratings for Functional Requirements Customize This Data Customize This Data

BigQuery
SAS Viya
+ Add Product + Add Product
Augmented Analytics Computer Vision And Internet Of Things (IoT) Dashboarding And Data Visualization Data Management Data Preparation Geospatial Visualizations And Analysis Machine Learning Mobile Capabilities Platform Capabilities Reporting 96 100 98 96 86 93 70 96 0 25 50 75 100
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
96%
0%
4%
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
100%
0%
0%
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
100%
0%
0%
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
86%
14%
0%
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
100%
0%
0%
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
86%
0%
14%
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
93%
0%
7%
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
63%
0%
37%
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
100%
0%
0%
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
86%
14%
0%

Analyst Ratings for Technical Requirements Customize This Data Customize This Data

we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
100%
0%
0%
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
82%
0%
18%
we're gathering data
N/A
we're gathering data
N/A
we're gathering data
N/A
100%
0%
0%

User Sentiment Summary

Excellent User Sentiment 724 reviews
Great User Sentiment 203 reviews
90%
of users recommend this product

BigQuery has a 'excellent' User Satisfaction Rating of 90% when considering 724 user reviews from 3 recognized software review sites.

85%
of users recommend this product

SAS Viya has a 'great' User Satisfaction Rating of 85% when considering 203 user reviews from 3 recognized software review sites.

4.4 (292)
4.2 (157)
n/a
4.3 (33)
4.6 (283)
4.7 (13)
4.4 (149)
n/a

Awards

BigQuery stands above the rest by achieving an ‘Excellent’ rating as a User Favorite.

User Favorite Award

SelectHub research analysts have evaluated SAS Viya and concluded it deserves the award for the Best Overall Big Data Analytics Tools available today and earns best-in-class honors for Augmented Analytics and Computer Vision and Internet of Things (IoT).

Analysts' Pick Award
Augmented Analytics Award
Computer Vision and Internet of Things (IoT) Award

Synopsis of User Ratings and Reviews

Performance: The system can execute queries on massive amounts of data with agility, as specified by about 89% of users who mentioned performance.
Functionality: About 68% of users who reviewed functionality talked about its robust inbuilt features.
Ease of Use: The UI is simple and easy to navigate, according to about 72% of users who talked about user-friendliness.
Integration: Approximately 75% of reviewers who talked about integration said that it connects to numerous other tools seamlessly.
Scalability: All users who reviewed scalability said that the platform scales to thousands of servers.
Show more
Ease of Use: All users who mention its interface say that it makes autonomous analysis and data modeling accessible to users of all skill levels.
Support: All users who review support say that representatives are responsive and helpful in resolving issues and queries.
Functionality: Around 71% of the users who comment on its feature set say that the software helps discover data insights through powerful visualizations and on-the-fly calculations.
Show more
Cost: Approximately 76% of users who mentioned cost complained that it’s expensive, and charges can rack up quickly if queries aren’t properly constructed.
Learning Curve: About 82% of users mentioned that the software has a steep learning curve.
Resources: About 89% of users who spoke about resources said that documentation and video tutorials are lacking and need improvement.
Visualization: Data visualization capabilities aren’t up to the mark, according to all users who talked about visualization.
Show more
Cost: All users who discuss its pricing say that the cost of acquisition is high.
Show more

Bigquery is a scalable big data warehouse solution. It enables users to pull correlated data streams using SQL like queries. Queries are executed fast regardless of the size of the datasets. It manages the dynamic distribution of workloads across computational clusters. The easy-to-navigate UI is robust and allows the user to create and execute machine learning models seamlessly. Users liked that it can connect to a variety of data analytics and visualization tools. However, users complained that query optimization is an additional hassle they have to deal with, as the solution is expensive and poorly constructed queries can quickly accumulate charges. It can be overwhelming for the non-technical user, and SQL coding knowledge is required to leverage its data analysis capabilities. Data visualization features are lacking and in need of improvement.

Show more

SAS Viya is an AI-powered data management and visual analytics platform with a robust, scalable architecture. All users who reviewed data source connectivity said that it connects to multiple sources and integrates easily with business applications, giving a seamless user experience. With fast in-memory processing of big data sets, it leverages the power of R to enable visual statistics. All users who mentioned predictive analysis said that it enables automated forecasting through what-if scenarios, goal-seeking, text mining and decision trees. Citing ease of use, all users say that the platform is intuitive and enables easy data modeling and self-service visual analytics. All users who mentioned support said that they are responsive and knowledgeable. Around 71% of the users who comment on its functionality say that it is a robust, scalable and flexible platform that enables visualization and analysis of business data, though some users say visual statistics need improvement. On the flip side, all users who review its cost say that the tool is expensive. In summary, SAS Viya is an analytics tool that provides data management, visualization and AI-powered analytics to enterprises for improved decision making, though small organizations and startups might find it cost-prohibitive.

Show more

Screenshots

Top Alternatives in Big Data Analytics Tools


Alteryx

Azure Synapse Analytics

Dataiku

H2O.ai

IBM Watson Studio

KNIME

Looker Studio

Oracle Analytics Cloud

Qlik Sense

RapidMiner

SageMaker

SAP Analytics Cloud

SAS Viya

Spotfire

Tableau

Related Categories

WE DISTILL IT INTO REAL REQUIREMENTS, COMPARISON REPORTS, PRICE GUIDES and more...

Compare products
Comparison Report
Just drag this link to the bookmark bar.
?
Table settings