Qlikview
tool icon

QlikView vs SAS Viya: A Comparative Analysis

Jump to

    Introduction

    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

    What is QlikView?

    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.

    tool icon

    What is SAS Viya?

    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.

    • Core Features

    • Provides access to data of any size or complexity.
    • Enables data cleansing and transformation through intuitive interfaces.
    • Supports the creation of robust data pipelines.
    • Builds trust in data with lineage and transparency features.
    • Facilitates the construction of highly performant models quickly.
    • Supports deployment of decision flows.

    • Automation and Performance

    • Automates performance monitoring and model tuning.
    • Automatically retrains models to ensure accuracy and relevance.
    • Delivers verifiable and trustworthy results.
    • Operates 30x faster than alternative open source and commercial offerings.
    • Automates machine learning processes, uniquely positioning it as the only tool with this capability.

    • Business Value

      SAS Viya maximizes the value derived from data and AI investments, making it a pivotal tool in modern data-driven environments.

    Qlikview

    Key Features of QlikView

    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
  • Qlik Cloud Analytics offers a cloud-based SaaS deployment, enriching analytics with AI-powered insights.
  • Qlik Sense, an on-premises solution, empowers users to shift from passive to active analytics.
    • tool icon

    Key Features of SAS Visual Analytics (SAS Viya)

    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
  • Includes a variety of chart types such as Bar, Pie, Donut, Line, Scatter, and Heat map.
  • Autocharting selects the optimal graph for the given data.
    		•

    Enhanced Reporting Features
  • Enables the addition of web content and images to reports.
  • Supports the reuse and sharing of report elements like filters and formatting.
  • Allows saving of report pages as templates.
    		•

    Collaboration Tools

    Facilitates teamwork through features that allow users to comment on reports and create alerts for report objects.

    Report Distribution
  • Secure distribution of reports via PDF or email.
  • Capability to schedule recurring report distribution.
  • Exporting of reports to Excel for further analysis.
    		•

    Advanced Analytics and Geospatial Support
  • Includes analytical visualizations like box plots, heat maps, and correlation matrices.
  • Offers decision tree and forecasting tools with confidence intervals.
  • Integrates with Esri for geospatial data analysis.
    		•

    Custom Visualizations

    Allows integration of custom visualizations, including D3.js graphs and Google charts, enhancing analytical capabilities.

    Qlikview

    Advantages of Using Qlikview for Business Intelligence

    Self-Service BI Tool

    Qlikview empowers users with self-service business intelligence capabilities, facilitating autonomous report generation and data analysis.

    Dynamic Data Interpretation

    Its dynamic dashboards provide efficient data interpretation and analysis, enhancing quick decision-making processes.

    Collaboration

    The platform fosters collaboration among teams, enabling collective, data-driven decision-making.

    Implementation and Usability

    Qlikview's simplicity allows for easy and swift implementation, offering an intuitive user experience.

    Data Security

    With robust data security measures, Qlikview ensures the protection of sensitive business information.

    Performance

  • Qlikview's in-memory technology delivers fast data processing speeds.

    • Qlikview's in-memory technology delivers fast data processing speeds.

  • Good data compression techniques contribute to its efficiency.

    • Good data compression techniques contribute to its efficiency.

    Data Visualization

    Effective data visualization tools within Qlikview turn complex data sets into understandable charts and graphs.

    QIX Engine

    The powerful QIX Engine is the backbone of Qlikview, driving its fast and responsive data analysis capabilities.

    Cost-Effectiveness

    As a cost-effective solution, Qlikview provides a high return on investment for business intelligence tasks.

    Qlikview

    Disadvantages of Qlikview for Business Intelligence

    Inefficiency in Real-Time Data Analysis

    Qlikview may not be the most efficient tool for real-time data analysis, potentially hindering timely decision-making.

    Technical Expertise Requirement

    Developing applications in Qlikview requires a high level of technical expertise, which can be a barrier for users without IT backgrounds.

    Integration Challenges

    Embedding Qlikview with other software systems may present difficulties, leading to suboptimal utilization within the business tech stack.

    Customer Support Issues

    Reports of poor customer support can affect user satisfaction and delay issue resolution, impacting productivity.

    Outdated Tools and Interfaces

    Older tools and interfaces may result in a less intuitive user experience, impeding user adoption and efficiency.

    Cost Implications for SMEs

    The expense of Qlikview might be prohibitive for small to medium-sized enterprises, making it a less viable option for these businesses.

    Consumer Perception

    Poor ratings in surveys could reflect user dissatisfaction and influence prospective buyers' perceptions of Qlikview's value.

    Qlikview

    Frequently Asked Questions About Qlikview

    How much memory does QlikView use when running a script compared to when working in the layout?

    QlikView uses 3-4 times as much memory when running a script as when working in the layout.

    Can QlikView handle large data sets and how much?

    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.

    Can QlikView join fields with the same name or with different names?

    Yes, QlikView can automatically join fields with the same name, and it can join fields with different names using an alias or AS statement.

    How can QlikView be shared with others?

    QlikView can be shared with others using QlikView Server or QlikView Publisher.

    Is it possible to control access to a QlikView document?

    Yes, QlikView can limit who can use a document using section access.

    Use Cases for Qlikview

    • Qlikview

      Improving efficiency, customer service, and sales as demonstrated by Dominos Pizza

    • Qlikview

      Simplifying analytics with a company-wide portal as utilized by Intuit

    • Qlikview

      Boosting operational success as seen with Urban Outfitters

    • Qlikview

      Lowering costs and reducing effort to convert loan prospects as achieved by Integra Financial

    tool icon

    Advantages of SAS Viya for Business Intelligence and Data Analytics

    Cloud-Based Analytics Platform

    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.

    Advanced Analytics and Reporting

    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.

    Collaboration and Productivity

    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.

    Flexibility and Extensibility

    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.

    Integration and Scalability

    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.

    Data Science and Machine Learning

    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.

    tool icon

    Disadvantages of SAS Viya for Business Intelligence

    Accessibility and Usability

    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.

    Integration and Compatibility

    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.

    Performance and Scalability

    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.

    Cost and Support

    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.

    tool icon

    Frequently Asked Questions About SAS Viya

    How is SAS Viya priced?

    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.

    What is the starting price for SAS Viya?

    SAS Viya pricing starts at $1500 per user and $10,000 for core capacity for select offerings.

    Can the cost of SAS Viya go up to millions?

    Yes, SAS Viya pricing can go up to multiple millions for a full implementation.

    Who can help determine the best SAS licensing option?

    A SAS account representative can help determine the best SAS licensing option for your needs.

    Are there any discounts available for SAS Viya?

    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.

    Use Cases for SAS Viya

    • tool icon

      SAS Viya providing services complementary to SAS Grid Manager in different project steps

    • tool icon

      SAS Viya feeding data into SAS Grid Manager for further processing

    • tool icon

      SAS Visual Analytics customers leveraging SAS Grid Manager to enhance their business intelligence capabilities

    sourcetable

    Why Sourcetable is a Superior Alternative for Business Intelligence

    • Simplified Data Integration

      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.

    • User-Friendly Interface

      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.

    • Real-Time Collaboration

      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.

    • AI-Powered Insights

      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.

    • Cloud-Based Flexibility

      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
    vs
    tool icon

    Comparison Between QlikView and SAS Viya

    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.

    Analytics Capabilities

    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.

    Deployment Flexibility

    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.

    Collaboration and Action

    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.

    Integration of AI

    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
    vs
    tool icon

    QlikView vs. SAS Viya

    Deployment Options

    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.

    Data Processing

    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.

    Intuitive Analysis

    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.

    AI Integration

    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.

    Real-time Collaboration

    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.

    sourcetable

    Comparison of Qlikview, SAS Viya, and Sourcetable

    Qlikview vs. SAS Viya

    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.

    Qlikview vs. Sourcetable

    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 vs. Sourcetable

    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

    Frequently Asked Questions About Sourcetable

    What is Sourcetable and who typically uses it?

    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.

    Do I need to know how to code to use Sourcetable?

    No, Sourcetable does not require any coding to use. Users can query data, build live models, and create reports without coding knowledge.

    How does Sourcetable handle data integration and how often does it update?

    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.

    How much does Sourcetable cost and is there a free trial available?

    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.

    How quickly can I start creating reports with Sourcetable?

    Users can start creating reports with Sourcetable within minutes after accessing it.

    Qlikview

    Qlikview Pricing Overview

    • Standard Plan

      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.

    • Premium Plan

      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.

    • Enterprise Plan

      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.

    • Additional Information

    • Both premium and enterprise plans build upon the standard plan's features.
    • All plans alert users as they approach their capacity limit.
    tool icon

    Cost of SAS Viya

    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.

    Qlikview

    User Reviews and Ratings of QlikView

    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.

    • Functionality and Usability

      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.

    • Performance and Integration

    • QlikView's in-memory processing contributes to its fast data processing capability.
    • Scheduled batch jobs for Extract, Transform, Load (ETL) are highlighted as a feature.
    • The software allows customization through VBA or other programming languages.
    • Despite its advantages, users point out QlikView's less competitive edge in visualization compared to Qlik Sense, Tableau, and PowerBI.

    • Cost and Value Proposition

      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.

    Conclusion

    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.

    Recommended Reading



    Simplify Your BI Tooling

    Sourcetable is the AI spreadsheet that lets you analyze your data in one place. Get unlimited access free for 14 days.


    Try out Sourcetable
    Drop CSV