TrustRadius: an HG Insights company

CaseWare IDEA vs. Microsoft R Open / Revolution R Enterprise

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    CaseWare IDEA

    Score4.8 out of 10
    N/ACaseWare IDEA is a data analysis and data extraction tool supporting audit processes. IDEA integrates with various solutions to make obtaining and exporting data easy, such as SAP solutions, accounting packages, CRM systems and other enterprise solutions for a single version of the truth.N/A

    Microsoft R Open / Revolution R Enterprise

    Score8.9 out of 10
    N/AMicrosoft R Open and Revolution R Enterprise are big data R distribution for servers, Hadoop clusters, and data warehouses. Microsoft acquired original developer Revolution Analytics in 2016. Microsoft R is available in two editions: Microsoft R Open (formerly Revolution R Open) and Revolution R Enterprise.N/A
    Pricing
    CaseWare IDEAMicrosoft R Open / Revolution R Enterprise
    Editions & Modules
    No answers on this topic
    No answers on this topic
    Offerings
    Pricing Offerings
    CaseWare IDEAMicrosoft R Open / Revolution R Enterprise
    Free Trial
    NoNo
    Free/Freemium Version
    NoNo
    Premium Consulting/Integration Services
    NoNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional Details——
    More Pricing Information
    Features
    CaseWare IDEAMicrosoft R Open / Revolution R Enterprise
    Platform Connectivity
    Comparison of Platform Connectivity features of CaseWare IDEA and Microsoft R Open / Revolution R Enterprise
    Feature
    CaseWare IDEA
    -
    Ratings
    Microsoft R Open / Revolution R Enterprise
    5.3
    3 Ratings
    45% below category average
    Connect to Multiple Data Sources00 Ratings6.13 Ratings
    Extend Existing Data Sources00 Ratings6.03 Ratings
    Automatic Data Format Detection00 Ratings6.03 Ratings
    MDM Integration00 Ratings3.01 Ratings
    Data Exploration
    Comparison of Data Exploration features of CaseWare IDEA and Microsoft R Open / Revolution R Enterprise
    Feature
    CaseWare IDEA
    -
    Ratings
    Microsoft R Open / Revolution R Enterprise
    7.0
    3 Ratings
    19% below category average
    Visualization00 Ratings7.03 Ratings
    Interactive Data Analysis00 Ratings7.03 Ratings
    Data Preparation
    Comparison of Data Preparation features of CaseWare IDEA and Microsoft R Open / Revolution R Enterprise
    Feature
    CaseWare IDEA
    -
    Ratings
    Microsoft R Open / Revolution R Enterprise
    4.8
    3 Ratings
    52% below category average
    Interactive Data Cleaning and Enrichment00 Ratings5.13 Ratings
    Data Transformations00 Ratings5.03 Ratings
    Data Encryption00 Ratings3.01 Ratings
    Built-in Processors00 Ratings6.03 Ratings
    Platform Data Modeling
    Comparison of Platform Data Modeling features of CaseWare IDEA and Microsoft R Open / Revolution R Enterprise
    Feature
    CaseWare IDEA
    -
    Ratings
    Microsoft R Open / Revolution R Enterprise
    6.0
    3 Ratings
    34% below category average
    Multiple Model Development Languages and Tools00 Ratings5.03 Ratings
    Automated Machine Learning00 Ratings5.02 Ratings
    Single platform for multiple model development00 Ratings8.03 Ratings
    Self-Service Model Delivery00 Ratings6.03 Ratings
    Model Deployment
    Comparison of Model Deployment features of CaseWare IDEA and Microsoft R Open / Revolution R Enterprise
    Feature
    CaseWare IDEA
    -
    Ratings
    Microsoft R Open / Revolution R Enterprise
    6.5
    2 Ratings
    27% below category average
    Flexible Model Publishing Options00 Ratings6.02 Ratings
    Security, Governance, and Cost Controls00 Ratings6.92 Ratings
    Best Alternatives
    CaseWare IDEAMicrosoft R Open / Revolution R Enterprise
    Small Businesses
    No answers on this topic
    RapidMiner
    Score8.9 out of 10
    Medium-sized Companies
    No answers on this topic
    Anaconda
    Score8.8 out of 10
    Enterprises
    No answers on this topic
    IBM Watson Studio
    Score10 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    CaseWare IDEAMicrosoft R Open / Revolution R Enterprise
    Likelihood to Recommend
    8.3
    (2 ratings)
    6.0
    (5 ratings)
    Likelihood to Renew
    -
    (0 ratings)
    7.0
    (1 ratings)
    Usability
    -
    (0 ratings)
    7.0
    (1 ratings)
    Support Rating
    9.0
    (1 ratings)
    8.0
    (2 ratings)
    User Testimonials
    CaseWare IDEAMicrosoft R Open / Revolution R Enterprise
    Likelihood to Recommend
    Caseware International Inc.
    One example of specific scenario in [CaseWare] IDEA is the ability to run samples separately and then based off of the results, compare and contrast the values recorded and easily discern if there are any variables or discrepancies within the data itself. Also, we can test journal entries with certain parameters to check the audit for any issues that may arise pertaining to the criteria. By testing, we are able to make sure the data is accurate and sufficient.
    Incentivized
    Read full review
    Microsoft
    If you are a MS shop specifically, or have more generic data requirement needs from Microsoft sourced data this will work well. If you have a lot of disparate data across a number of unique platforms/cloud systems/3rd party hosted data warehouses then this product will have issues or a lack of documentation on the net. Performance-wise this product is equal to other R platforms out there.
    Incentivized
    Read full review
    Pros
    Caseware International Inc.
    • Easy to understand and easy to use.
    • Can use on large quantities of data and quickly analyze them.
    • Uses logic that can be followed if one is an auditor. I, for example, could understand the logic in a number of samples, i.e how the number of samples thrown changes when risk changes from low to moderate in proportion taking in consideration the materiality.
    • Other audit firms are using 2 software for the process that IDEA alone can do. So IDEA has a definite advantage here.
    • Customizable by the company.
    Read full review
    Microsoft
    • It allows distributed algorithm runs on Hadoop HDFS cluster
    • It allows using different file formats such as SAS7BAT files or complex files in tab or comma delimited making data munging easier
    • It provides scalable solutions by allowing users to re-use R scripts and distributing the computing over nodes through RHadoop
    Read full review
    Cons
    Caseware International Inc.
    • Bit of a learning curve for the advanced features as a beginner.
    Incentivized
    Read full review
    Microsoft
    • Very steep learning curve... for such a quick and useful tool the learning curve is unacceptable.
    • Very dangerous in the wrong hands. Because most add-ons are pre-written, you have to trust the community that malicious script is not used.
    Incentivized
    Read full review
    Likelihood to Renew
    Caseware International Inc.
    No answers on this topic
    Microsoft
    In general, Revolution Analytics brings a lot of value to the organization. The renewal decision would be based on return on investment in terms of quantified actionable insights that are getting generated against the cost of the product. Additionally, market brand of the tool and reputation risk in terms of possible acquisition and its impact to overall organizational analytic strategy would be considered as well.
    Read full review
    Usability
    Caseware International Inc.
    No answers on this topic
    Microsoft
    It is good, easy to use, improvements are being made to the product and more info being shared in the community. It just needs some more time to become more integrated to other platforms and tools/data out there.
    Incentivized
    Read full review
    Support Rating
    Caseware International Inc.
    I would rate it a 9 because I never really needed support on this but if I did, there was the necessary support given promptly.
    Read full review
    Microsoft
    Generally support comes through the forums and user generated channels which are helpful, easy to access, quickly turned around and provided by knowledgeable users. However the support channels are not employees and the channels are often used as a way to learn quick difficult elements of R. Better design, users interface and tutorial options would alleviate the need for this sort of interaction.
    Incentivized
    Read full review
    Alternatives Considered
    Caseware International Inc.
    I have used Microstart and would definitely vote for IDEA because IDEA combines what Microstart does with the help of one/more softwares. Where Microstart just gives a number of samples, IDEA selects the number of samples based on materiality, risk, and other factors. It selects those samples from the population leaving out line items that are invalid/ zero. I would prefer using IDEA any day.
    Read full review
    Microsoft
    The two are different products for different purposes. But for someone who has little or no experience in R programming, Power BI would be better for starting with. Having said that, Microsoft R is built on R, thus allowing for customization of complex calculations not typically available otherwise.
    Incentivized
    Read full review
    Return on Investment
    Caseware International Inc.
    • We were able to save time by over 200 billable hours over our last busy season cycle
    • We saved roughly 12% on costs compared to the last program we used.
    Incentivized
    Read full review
    Microsoft
    • Helped save company money versus buying other stat software
    Incentivized
    Read full review
    ScreenShots