What users are saying about
Top Rated
1538 Ratings
52 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.9 out of 100
Top Rated
1538 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.8 out of 100

Feature Set Ratings

    BI Standard Reporting

    6.7

    SAS Business Intelligence

    67%

    Microsoft SQL Server

    Feature Set Not Supported
    N/A
    SAS Business Intelligence ranks higher in 3/3 features

    Pixel Perfect reports

    7.1
    71%
    5 Ratings
    N/A
    0 Ratings

    Customizable dashboards

    7.1
    71%
    5 Ratings
    N/A
    0 Ratings

    Report Formatting Templates

    6.1
    61%
    5 Ratings
    N/A
    0 Ratings

    Ad-hoc Reporting

    7.0

    SAS Business Intelligence

    70%

    Microsoft SQL Server

    Feature Set Not Supported
    N/A
    SAS Business Intelligence ranks higher in 4/4 features

    Drill-down analysis

    5.2
    52%
    5 Ratings
    N/A
    0 Ratings

    Formatting capabilities

    7.1
    71%
    5 Ratings
    N/A
    0 Ratings

    Integration with R or other statistical packages

    6.0
    60%
    5 Ratings
    N/A
    0 Ratings

    Report sharing and collaboration

    9.8
    98%
    5 Ratings
    N/A
    0 Ratings

    Report Output and Scheduling

    9.5

    SAS Business Intelligence

    95%

    Microsoft SQL Server

    Feature Set Not Supported
    N/A
    SAS Business Intelligence ranks higher in 5/5 features

    Publish to Web

    8.0
    80%
    5 Ratings
    N/A
    0 Ratings

    Publish to PDF

    9.9
    99%
    5 Ratings
    N/A
    0 Ratings

    Report Versioning

    9.9
    99%
    5 Ratings
    N/A
    0 Ratings

    Report Delivery Scheduling

    9.9
    99%
    5 Ratings
    N/A
    0 Ratings

    Delivery to Remote Servers

    9.9
    99%
    4 Ratings
    N/A
    0 Ratings

    Data Discovery and Visualization

    8.6

    SAS Business Intelligence

    86%

    Microsoft SQL Server

    Feature Set Not Supported
    N/A
    SAS Business Intelligence ranks higher in 3/3 features

    Pre-built visualization formats (heatmaps, scatter plots etc.)

    7.0
    70%
    3 Ratings
    N/A
    0 Ratings

    Location Analytics / Geographic Visualization

    8.9
    89%
    4 Ratings
    N/A
    0 Ratings

    Predictive Analytics

    9.9
    99%
    4 Ratings
    N/A
    0 Ratings

    Access Control and Security

    9.9

    SAS Business Intelligence

    99%

    Microsoft SQL Server

    Feature Set Not Supported
    N/A
    SAS Business Intelligence ranks higher in 4/4 features

    Multi-User Support (named login)

    9.9
    99%
    5 Ratings
    N/A
    0 Ratings

    Role-Based Security Model

    9.9
    99%
    5 Ratings
    N/A
    0 Ratings

    Multiple Access Permission Levels (Create, Read, Delete)

    9.9
    99%
    5 Ratings
    N/A
    0 Ratings

    Single Sign-On (SSO)

    9.9
    99%
    4 Ratings
    N/A
    0 Ratings

    Mobile Capabilities

    5.8

    SAS Business Intelligence

    58%

    Microsoft SQL Server

    Feature Set Not Supported
    N/A
    SAS Business Intelligence ranks higher in 3/3 features

    Responsive Design for Web Access

    7.1
    71%
    4 Ratings
    N/A
    0 Ratings

    Mobile Application

    5.1
    51%
    4 Ratings
    N/A
    0 Ratings

    Dashboard / Report / Visualization Interactivity on Mobile

    6.1
    61%
    4 Ratings
    N/A
    0 Ratings

    Application Program Interfaces (APIs) / Embedding

    7.3

    SAS Business Intelligence

    73%

    Microsoft SQL Server

    Feature Set Not Supported
    N/A
    SAS Business Intelligence ranks higher in 6/6 features

    REST API

    8.0
    80%
    3 Ratings
    N/A
    0 Ratings

    Javascript API

    6.1
    61%
    3 Ratings
    N/A
    0 Ratings

    iFrames

    6.0
    60%
    3 Ratings
    N/A
    0 Ratings

    Java API

    7.9
    79%
    3 Ratings
    N/A
    0 Ratings

    Themeable User Interface (UI)

    10.0
    100%
    2 Ratings
    N/A
    0 Ratings

    Customizable Platform (Open Source)

    6.0
    60%
    1 Rating
    N/A
    0 Ratings

    Attribute Ratings

    • SAS Business Intelligence is rated higher in 2 areas: Likelihood to Renew, Support Rating
    • Microsoft SQL Server is rated higher in 2 areas: Likelihood to Recommend, Usability

    Likelihood to Recommend

    7.7

    SAS Business Intelligence

    77%
    9 Ratings
    9.1

    Microsoft SQL Server

    91%
    95 Ratings

    Likelihood to Renew

    9.3

    SAS Business Intelligence

    93%
    3 Ratings
    9.0

    Microsoft SQL Server

    90%
    6 Ratings

    Usability

    6.0

    SAS Business Intelligence

    60%
    1 Rating
    9.9

    Microsoft SQL Server

    99%
    10 Ratings

    Availability

    SAS Business Intelligence

    N/A
    0 Ratings
    10.0

    Microsoft SQL Server

    100%
    2 Ratings

    Performance

    SAS Business Intelligence

    N/A
    0 Ratings
    9.0

    Microsoft SQL Server

    90%
    2 Ratings

    Support Rating

    8.0

    SAS Business Intelligence

    80%
    3 Ratings
    7.9

    Microsoft SQL Server

    79%
    49 Ratings

    In-Person Training

    SAS Business Intelligence

    N/A
    0 Ratings
    9.0

    Microsoft SQL Server

    90%
    1 Rating

    Online Training

    SAS Business Intelligence

    N/A
    0 Ratings
    9.0

    Microsoft SQL Server

    90%
    1 Rating

    Implementation Rating

    SAS Business Intelligence

    N/A
    0 Ratings
    9.0

    Microsoft SQL Server

    90%
    10 Ratings

    Configurability

    SAS Business Intelligence

    N/A
    0 Ratings
    10.0

    Microsoft SQL Server

    100%
    1 Rating

    Ease of integration

    SAS Business Intelligence

    N/A
    0 Ratings
    9.0

    Microsoft SQL Server

    90%
    1 Rating

    Product Scalability

    SAS Business Intelligence

    N/A
    0 Ratings
    9.0

    Microsoft SQL Server

    90%
    1 Rating

    Vendor post-sale

    SAS Business Intelligence

    N/A
    0 Ratings
    9.0

    Microsoft SQL Server

    90%
    1 Rating

    Vendor pre-sale

    SAS Business Intelligence

    N/A
    0 Ratings
    9.0

    Microsoft SQL Server

    90%
    1 Rating

    Likelihood to Recommend

    SAS

    SAS Business Intelligence is more suited to organizations which are already using SAS as the primary software for their analytics needs. Learning curve is relatively shorter for teams already skilled in BASE SAS. For organizations already working with open source software like Julia and Python, it doesn't make much sense to use SAS BI.
    Read full review

    Microsoft

    Microsoft SQL Server is a great RDBMS and meets all of our requirements. If you need a stable DB platform to support your line of a business application you'll be well served. Licensing costs are far cheaper, more portable and a lot more user friendly than Oracle. Product support and security patches from Microsoft are strong.
    Read full review

    Pros

    SAS

    • SAS BI makes it very easy to create interactive dashboards even for someone who is not from an IT background. For some specific requirements, basic knowledge of SQL is good enough.
    • A lot of functions have been predefined which makes it very convenient to create dashboards and reports. One doesn't need to be from an IT or a programming background to understand and create dashboards.
    • It supports other programming languages like R and also has a seamless API integration with various data management platforms.
    Read full review

    Microsoft

    • Easy to configure and use with Visual Studio and Dot Net
    • Easy integration with MSBI to perform data analysis
    • Data Security
    • Easy to understand and use
    • Very easy to export database and tables in the form of SQL query or a script
    Read full review

    Cons

    SAS

    • There will be a steep learning curve for individuals transitioning from BASE SAS to SAS BI. Our department was filled with experienced SAS programmers, but that did little to prepare us for the challenges of SAS BI. Training will be a must.
    • It is possible, but extremely difficult to customize the web-based portions of SAS BI, like the Information Delivery Portal or Web Report Studio. Having an out-of-the box solution is great to get up and coming quickly, but customizing the look and feel for the web-based users will require some previous web design skills.
    • In order to fully appreciate the features of SAS BI, you absolutely need someone on your team with a background in platform administration, security, web design or some other basic IT skills. Alternatively, you may just need strong support from your IT department. Simply having a group of individuals experienced in BASE SAS will not cut it.
    Read full review

    Microsoft

    • The import/export process can be tricky to follow with lots of steps and could be better for importing flat files
    • Obtaining help from Microsoft is cumbersome and often other internet sources are better and quicker
    • The documentation is not great and again it's generally better to obtain help elsewhere if needed
    Read full review

    Pricing Details

    SAS Business Intelligence

    Starting Price

    Editions & Modules

    SAS Business Intelligence editions and modules pricing
    EditionModules

    Footnotes

      Offerings

      Free Trial
      Free/Freemium Version
      Premium Consulting/Integration Services

      Entry-level set up fee?

      No setup fee

      Additional Details

      Microsoft SQL Server

      Starting Price

      $0 Per License

      Editions & Modules

      Microsoft SQL Server editions and modules pricing
      EditionModules
      Enterprise$13,748.001
      Subscription$1,418.002

      Footnotes

      1. Per License
      2. Per License

      Offerings

      Free Trial
      Free/Freemium Version
      Premium Consulting/Integration Services

      Entry-level set up fee?

      No setup fee

      Additional Details

      Likelihood to Renew

      SAS

      There is no other product that can match SAS. There are some products that can compare to ETL but lack the analytics that SAS has. Others can perform a limited set of analytical procedures but lack the data processing that comes with SAS. Using thin client allows users to access data whenever they have an internet connection.
      Read full review

      Microsoft

      We understand that the Microsoft SQL Server will continue to advance, offering the same robust and reliable platform while adding new features that enable us, as a software center, to create a superior product. That provides excellent performance while reducing the hardware requirements and the total cost of ownership of our solution.
      Read full review

      Usability

      SAS

      SAS BI is good for creating reports and dashboards and then sharing it with the users. It also has ability to manage access to the reports and dashboards but somehow with most of the world moving to open source languages R, Python and Julia, SAS BI feels to be archaic in terms of feature set and integrations it allow[s]. Also, comparing it with other Business Intelligence tools like Tableau and Microsoft BI, the functionality of SAS BI is very limited and doesn't justify the pricing.
      Read full review

      Microsoft

      SQL Server mostly 'just works' or generates error messages to help you sort out the trouble. You can usually count on the product to get the job done and keep an eye on your potential mistakes. Interaction with other Microsoft products makes operating as a Windows user pretty straight forward. Digging through the multitude of dialogs and wizards can be a pain, but the answer is usually there somewhere.
      Read full review

      Reliability and Availability

      SAS

      No answers on this topic

      Microsoft

      Its does not have outages.
      Read full review

      Performance

      SAS

      No answers on this topic

      Microsoft

      SSAS data cubes may some time slow down your Excel reports.
      Read full review

      Support Rating

      SAS

      When you call tech support, you are immediately routed to a person who can answer your question. Often they can answer on the spot. However, if they cannot, you are given a track number and then followed up with. There have been times when I have had multiple track numbers open and they will actually TRACK YOU DOWN to ensure that your problem has been resolved. Issues do not fall into black holes with SAS. They are also willing to do a WebEx with you to diagnose the problem by seeing your environment, which is always helpful.
      Read full review

      Microsoft

      We managed to handle most of our problems by looking into Microsoft's official documentation that has everything explained and almost every function has an example that illustrates in detail how a particular functionality works. Just like PowerShell has the ability to show you an example of how some cmdlet works, that is the case also here, and in my opinion, it is a very good practice and I like it.
      Read full review

      In-Person Training

      SAS

      No answers on this topic

      Microsoft

      It was good
      Read full review

      Online Training

      SAS

      No answers on this topic

      Microsoft

      very hands on and detailed training
      Read full review

      Implementation Rating

      SAS

      No answers on this topic

      Microsoft

      Other than SQL taking quite a bit of time to actually install there are no problems with installation. Even on hardware that has good performance SQL can still take close to an hour to install a typical server with management and reporting services.
      Read full review

      Alternatives Considered

      SAS

      SAS Business Intelligence is not the cream of the crop for business intelligence applications, but it is not far behind. The software is generally easier to apply than most other business intelligence software. Additionally, SAS Business Intelligence runs smoothly in the background when making real-time updates. With that said, the software is not as efficient of many of the other business intelligence software applications that have been on the market for longer than this one.
      Read full review

      Microsoft

      [Microsoft] SQL Server has a much better community and professional support and is overall just a more reliable system with Microsoft behind it. I've used MySQL in the past and SQL Server has just become more comfortable for me and is my go to RDBMS.
      Read full review

      Scalability

      SAS

      No answers on this topic

      Microsoft

      SQL server does handle growing demands of a mid sized company.
      Read full review

      Return on Investment

      SAS

      • Having a stable reporting environment. That is, everyone is using the same starting data, thus alleviating differences for timing, etc.
      • Allows for a simple reporting environment for executives which do not have the technical knowledge to gather the data
      Read full review

      Microsoft

      • Increased accuracy - We went from multiple users having different versions of an Excel spreadsheet to a single source of truth for our reporting.
      • Increased Efficiency - We can now generate reports at any time from a single source rather than multiple users spending their time collating data and generating reports.
      • Improved Security - Enterprise level security on a dedicated server rather than financial files on multiple laptop hard drives.
      Read full review

      Add comparison