Choosing the right business intelligence tool is crucial for data-driven decision-making, and both Qlikview and SAS Viya offer robust capabilities. This comparison will highlight key differences and use cases for each platform.
Qlikview, known for its in-memory data processing and associative model, excels at interactive data visualization and discovery. SAS Viya, on the other hand, brings advanced analytics and AI capabilities to the table, making it a powerful option for complex data analysis.
We will also explore how Sourcetable provides a streamlined alternative for those seeking a modernized, spreadsheet-like interface that seamlessly syncs with your data, offering an intuitive solution for reporting and data analytics.
QlikView is a guided analytics solution designed to develop and deliver analytics applications and dashboards. It features an associative engine that allows for the dynamic generation of new data views, enabling an associative experience throughout the analysis.
QlikView is a guided analytics solution designed to develop and deliver analytics applications and dashboards. It features an associative engine that allows for the dynamic generation of new data views, enabling an associative experience throughout the analysis.
The platform optimizes data usage by compressing it and storing it in memory, which facilitates rapid data exploration by multiple users simultaneously. QlikView's in-memory feature allows for direct interaction with the data, removing the need for predefined drill paths or dashboards.
Its direct connection to data sources ensures that users have real-time access to data for analysis, making it a flexible tool for business intelligence and data visualization.
SAS Viya is an AI platform that delivers comprehensive and trustworthy capabilities for a range of users including data scientists and developers. It is designed as an end-to-end solution that scales with the evolving pace of AI technology.
SAS Viya is an AI platform that delivers comprehensive and trustworthy capabilities for a range of users including data scientists and developers. It is designed as an end-to-end solution that scales with the evolving pace of AI technology.
SAS Viya maximizes the value derived from data and AI investments, making it a pivotal tool in modern data-driven environments.
Associative Engine |
The associative engine is central to QlikView's uniqueness, enabling complex data analysis through intuitive exploration. |
Visual Discovery |
QlikView provides intuitive visual discovery that allows for immediate insight into data patterns and relationships. |
Complementary Solutions |
|
Data Integration |
SAS Viya supports a broad range of data sources, including databases, Hadoop, Excel, CSV, and social media for seamless data importation. |
Report and Dashboard Creation |
Intuitive report building is facilitated by drag-and-drop capabilities for Excel, CSV, and SAS data sets. |
Data Quality and Management |
Embedded data quality functions enable case changes, conversions, renaming, removal, and column splitting. |
Custom Calculations and Transformations |
Users can create custom calculated columns and perform data transformations using their own code. |
Visualization and Chart Types |
|
Enhanced Reporting Features |
|
Collaboration Tools |
Facilitates teamwork through features that allow users to comment on reports and create alerts for report objects. |
Report Distribution |
|
Advanced Analytics and Geospatial Support |
|
Custom Visualizations |
Allows integration of custom visualizations, including D3.js graphs and Google charts, enhancing analytical capabilities. |
Qlikview empowers users with self-service business intelligence capabilities, facilitating autonomous report generation and data analysis.
Its dynamic dashboards provide efficient data interpretation and analysis, enhancing quick decision-making processes.
The platform fosters collaboration among teams, enabling collective, data-driven decision-making.
Qlikview's simplicity allows for easy and swift implementation, offering an intuitive user experience.
With robust data security measures, Qlikview ensures the protection of sensitive business information.
Qlikview's in-memory technology delivers fast data processing speeds.
Good data compression techniques contribute to its efficiency.
Effective data visualization tools within Qlikview turn complex data sets into understandable charts and graphs.
The powerful QIX Engine is the backbone of Qlikview, driving its fast and responsive data analysis capabilities.
As a cost-effective solution, Qlikview provides a high return on investment for business intelligence tasks.
Qlikview may not be the most efficient tool for real-time data analysis, potentially hindering timely decision-making.
Developing applications in Qlikview requires a high level of technical expertise, which can be a barrier for users without IT backgrounds.
Embedding Qlikview with other software systems may present difficulties, leading to suboptimal utilization within the business tech stack.
Reports of poor customer support can affect user satisfaction and delay issue resolution, impacting productivity.
Older tools and interfaces may result in a less intuitive user experience, impeding user adoption and efficiency.
The expense of Qlikview might be prohibitive for small to medium-sized enterprises, making it a less viable option for these businesses.
Poor ratings in surveys could reflect user dissatisfaction and influence prospective buyers' perceptions of Qlikview's value.
QlikView uses 3-4 times as much memory when running a script as when working in the layout.
QlikView can handle a few million rows of typical transaction data on a PC with 512MB of RAM, and up to one billion rows of transaction data on large servers.
Yes, QlikView can automatically join fields with the same name, and it can join fields with different names using an alias or AS statement.
QlikView can be shared with others using QlikView Server or QlikView Publisher.
Yes, QlikView can limit who can use a document using section access.
Improving efficiency, customer service, and sales as demonstrated by Dominos Pizza
Simplifying analytics with a company-wide portal as utilized by Intuit
Boosting operational success as seen with Urban Outfitters
Lowering costs and reducing effort to convert loan prospects as achieved by Integra Financial
SAS Viya is a cloud-based analytics platform that offers businesses the flexibility to access and analyze data from anywhere. It helps organizations with analytics in the cloud, providing instant access to powerful statistical analysis and reporting applications.
The platform supports advanced statistical analysis tools, a wide range of statistical methods, and includes a prebuilt library of ready-to-use procedures. This enables businesses to use the latest statistical methodologies for tasks like geolocation analysis and data visualization, including 3-D relationship graphs.
SAS Viya's web-based environment fosters collaboration and enhances programmer productivity through web-based programming, analysis, and reporting. It integrates with tools like Microsoft Outlook and Excel, streamlining the workflow for business users.
As a highly flexible and extensible 4GL, SAS Viya offers hundreds of language elements and functions, suitable for a variety of business intelligence tasks. Its extensible nature allows for easy deployment in the cloud or on-site, accommodating different business requirements.
SAS Viya provides a scalable environment that integrates with AWS and is available on the AWS Marketplace. This scalability ensures that businesses can handle increasing data volumes and complexity without compromising performance.
The platform allows data scientists to create, test, and deploy analytics using various methods and languages within one cohesive environment. With machine learning and streaming analytics capabilities, SAS Viya aids in making real-time business decisions.
SAS Viya may present challenges for smaller organizations due to its complexity, potentially making it less suitable for small to medium-sized businesses. The steep learning curve and lack of tutorials for beginners can hinder effective use of the software for business intelligence purposes.
The lack of integration with popular open source tools such as Python, Julia, and R limits the flexibility for businesses to leverage existing codebases and community-driven resources.
The large installation file of SAS Viya could be a barrier for businesses with limited IT infrastructure, affecting deployment and scalability. Furthermore, the software's drill-down capability, important for detailed data analysis, could be improved.
The high cost of SAS Visual Analytics may not be justifiable for all business sizes, especially when considering the reported poor customer support which is critical for resolving issues and facilitating user adoption.
SAS Viya may be priced by users, core capacity, total revenue, transactions, and other factors. The pricing may vary by SaaS, on-premises, cloud, and other deployment options.
SAS Viya pricing starts at $1500 per user and $10,000 for core capacity for select offerings.
Yes, SAS Viya pricing can go up to multiple millions for a full implementation.
A SAS account representative can help determine the best SAS licensing option for your needs.
Students, educators, and researchers may get academic discounts for training and certification exams. SAS also offers a variety of discounts for training and certification exams.
SAS Viya providing services complementary to SAS Grid Manager in different project steps
SAS Viya feeding data into SAS Grid Manager for further processing
SAS Visual Analytics customers leveraging SAS Grid Manager to enhance their business intelligence capabilities
Sourcetable streamlines the process of data consolidation by automatically syncing data from various services into a user-friendly spreadsheet interface. This eliminates the need for complex data warehousing solutions.
Offering a spreadsheet-like experience, Sourcetable provides an intuitive environment for data analysis, making it accessible to users without specialized training in business intelligence tools.
With real-time collaboration features, Sourcetable enhances team productivity and decision-making, similar to the capabilities of Qlik Sense but with the added simplicity of a spreadsheet format.
Sourcetable integrates AI to deliver insights and analytics, offering a competitive edge to businesses in the same vein as Qlikview and Qlik Sense but through a more straightforward interface.
As a cloud-based platform, Sourcetable provides the flexibility and scalability needed for modern businesses, akin to Qlik Cloud Analytics, but with a focus on user accessibility and ease of use.
QlikView and SAS Viya are analytics solutions that enable organizations to make data-driven decisions. Both solutions offer advanced data processing capabilities and support various deployment options.
QlikView and SAS Viya are analytics solutions that enable organizations to make data-driven decisions. Both solutions offer advanced data processing capabilities and support various deployment options.
QlikView and SAS Viya provide robust analytics tools. QlikView with its associative engine and SAS Viya with its in-memory analytics both allow for intuitive visual discovery of data, facilitating a deeper understanding of complex datasets.
Both solutions offer flexibility in deployment. QlikView can be deployed on-premises with Qlik Sense or on the cloud with Qlik Cloud Analytics. Similarly, SAS Viya offers cloud-based solutions as well as on-premises deployment, catering to different organizational needs and preferences.
Real-time collaboration and the ability to take action based on insights are common features of both QlikView and SAS Viya. These capabilities ensure that teams can work together efficiently and respond to analytical findings promptly.
QlikView and SAS Viya integrate AI-powered insights into their platforms, enhancing human intuition and enabling more sophisticated analyses. This integration helps organizations leverage predictive and advanced analytics for strategic decision-making.
QlikView offers flexibility in deployment options, including cloud-based SaaS with Qlik Cloud Analytics and on-premises solutions with Qlik Sense. SAS Viya primarily emphasizes cloud-based analytics, potentially limiting organizations with strict on-premises data policies.
QlikView utilizes an associative engine for data processing, promoting intuitive visual discovery and real-time collaboration. SAS Viya processes data through a different architecture, which may not emphasize the associative data model that QlikView implements.
The associative engine of QlikView is designed to put business intelligence in the hands of more people, streamlining visual discovery without requiring advanced analytical skills. SAS Viya also provides advanced analytics but might have a steeper learning curve for non-analytical users.
Both QlikView, through Qlik Sense, and SAS Viya integrate AI to enhance insights. However, QlikView's AI is designed to augment human intuition alongside its associative engine, while SAS Viya focuses on advanced analytics and machine learning techniques.
QlikView facilitates real-time collaboration and action, enabling teams to make strategic decisions swiftly. SAS Viya also provides collaborative features but may approach real-time decision-making differently.
Qlikview is the first analytics solution from Qlik, leveraging an associative engine for data analysis, which is different from SAS Viya's approach that emphasizes advanced analytics, artificial intelligence, and machine learning capabilities. Qlikview focuses on intuitive visual discovery and encourages a shift from passive to active analytics, allowing users to interact with data actively. In contrast, SAS Viya is designed for complex analytical challenges and provides a cloud-ready, scalable platform. Qlikview supports real-time collaboration, enabling immediate action based on insights, a feature that is also available in SAS Viya, which offers collaborative features for sharing insights.
Sourcetable, a newer entrant compared to Qlikview, is a spreadsheet interface designed for data analysis and automation without requiring extensive technical expertise. Unlike Qlikview, which requires a structured approach to data modeling and exploration, Sourcetable provides a more familiar spreadsheet-like experience. Qlikview’s associative engine enables a more robust data discovery process compared to the simpler, formula-based operations in Sourcetable. While Qlikview is tailored for both passive and active analytics, Sourcetable is primarily focused on organizing and analyzing data within a user-friendly interface.
SAS Viya is an enterprise-grade analytics solution with a strong emphasis on advanced analytics, AI, and machine learning, which contrasts with Sourcetable's focus on spreadsheet simplicity and accessibility. SAS Viya offers a comprehensive suite of tools for data scientists and analysts, whereas Sourcetable caters to users who prefer a straightforward approach to data manipulation and reporting. While SAS Viya is designed for scalability and complex data environments, Sourcetable provides a more lightweight solution that can be quickly adopted by teams without specialized analytics training.
Sourcetable is a spreadsheet application that replaces workflows typically done in Excel, Google Sheets, and Business Intelligence tools. It is used by growth teams and business operations people who need to centralize, analyze, and model data that updates over time.
No, Sourcetable does not require any coding to use. Users can query data, build live models, and create reports without coding knowledge.
Sourcetable syncs data from over 100 applications and most databases. On the regular plan, data integrations update every 15 minutes, while on the pro plan they update every 5 minutes. Models update automatically as data updates.
Sourcetable costs $50 per month for the starter plan and $250 per month for the pro plan. All plans come with a 14-day free trial. Additional seats beyond the first 5 users cost $20 per month each.
Users can start creating reports with Sourcetable within minutes after accessing it.
The Qlikview standard plan is designed for a minimum of 20 full users. It provides 25 GB/year of data for analysis. This plan offers access to hundreds of data sources, interactive data visualizations, dashboards, augmented analytics with AI, collaboration features, and 24x7 customer support.
Qlikview's premium plan extends the standard offerings with 50 GB/year data capacity. It includes additional features such as automated report compilation, delivery, predictive analytics, no-code automation builder triggers, and enterprise-grade data governance.
The enterprise plan is the most extensive offering with 500 GB/year of data for analysis. It encompasses all premium features and facilitates connecting additional data sources and a personalized customer success plan.
SAS Viya is available for purchase via the Azure Marketplace. This allows for seamless integration with Azure services and simplified procurement for users with Azure accounts.
SAS Viya is available for purchase via the Azure Marketplace. This allows for seamless integration with Azure services and simplified procurement for users with Azure accounts.
The pricing structure of SAS Viya follows a pay-as-you-go model, providing flexibility to users by charging based on resource consumption and usage duration.
QlikView, as a business intelligence (BI) tool, has garnered an overall rating of 4.3. Its functionality is highly regarded with a 4.5 rating, while ease-of-use, customer support, and value for money each have a solid 4 rating. Users acknowledge QlikView's versatility in data visualization and its capability to combine data sources for complex reporting. However, users experience a slow response with heavy data volume and a slight delay in real-time data sync. Additionally, the inability to export a list of all currently licensed users has been noted.
QlikView, as a business intelligence (BI) tool, has garnered an overall rating of 4.3. Its functionality is highly regarded with a 4.5 rating, while ease-of-use, customer support, and value for money each have a solid 4 rating. Users acknowledge QlikView's versatility in data visualization and its capability to combine data sources for complex reporting. However, users experience a slow response with heavy data volume and a slight delay in real-time data sync. Additionally, the inability to export a list of all currently licensed users has been noted.
Users find QlikView's data visualization options satisfactory, though not the best in its class, and appreciate its use for creating sales and inventory dashboards. The tool's user interface (UI) is considered clunky and less user-friendly, particularly with certain data sources like BW and Big Data. There is also an absence of R integration and limitations noted for detailed reporting. Despite these drawbacks, the wide user group and support forum are considered valuable resources, especially for students and for automating report distribution and creation.
While users appreciate the free version and the fully-featured offerings of QlikView, the software is considered expensive. Nevertheless, it is deemed easy to implement, providing significant value and utility, particularly for fast and efficient data analysis in sales and marketing contexts. However, it does not support writing back to the database, which is a limitation for some users.
In summary, Qlikview and SAS Viya serve as robust business intelligence platforms, each with its unique strengths. Qlikview offers a speedy in-memory engine and intuitive data visualization tools, while SAS Viya provides advanced analytics with strong support for artificial intelligence and machine learning.
For those seeking a more streamlined solution, Sourcetable can be a valuable tool. It simplifies the business intelligence process by synchronizing data in real-time from various services into an easy-to-use spreadsheet interface.