What users are saying about

SAS Business Intelligence

45 Ratings
Score 8.4 out of 101

Microsoft BI

594 Ratings
Score 7.8 out of 101

Add comparison

Likelihood to Recommend

SAS Business Intelligence

It is best suited to when you have different data sources that need to be combined. It does not require a sourcing team (such as MicroStrategy) which needs to combine the data into one schema before you can start joining data.The question to ask is "Are you going to have a dedicated administrator?" This is a full time job and this person (persons) need to focus on that and not be expected to also analyze the data.
Erik Larsen profile photo

Microsoft BI

Flexibility, engagement, training resources, updates, cost, implementation, ease of use, support; these are the reasons why I would recommend Power BI. Power BI is best suited for situations where collaboration is needed among several different groups who are working concurrently on different activities. Where there are multiple levels of data that need to be parsed through. It's difficult to think of a scenario where it wouldn't be beneficial other than the obvious.
Jason Leidig profile photo

Feature Rating Comparison

BI Standard Reporting

SAS Business Intelligence
7.5
Microsoft BI
8.2
Pixel Perfect reports
SAS Business Intelligence
8.0
Microsoft BI
8.1
Customizable dashboards
SAS Business Intelligence
7.8
Microsoft BI
8.1
Report Formatting Templates
SAS Business Intelligence
6.8
Microsoft BI
8.4

Ad-hoc Reporting

SAS Business Intelligence
7.4
Microsoft BI
8.5
Drill-down analysis
SAS Business Intelligence
8.5
Microsoft BI
8.6
Formatting capabilities
SAS Business Intelligence
7.6
Microsoft BI
8.3
Integration with R or other statistical packages
SAS Business Intelligence
5.9
Microsoft BI
8.3
Report sharing and collaboration
SAS Business Intelligence
7.7
Microsoft BI
8.8

Report Output and Scheduling

SAS Business Intelligence
8.2
Microsoft BI
8.7
Publish to Web
SAS Business Intelligence
8.0
Microsoft BI
8.7
Publish to PDF
SAS Business Intelligence
8.6
Microsoft BI
8.5
Report Versioning
SAS Business Intelligence
8.1
Microsoft BI
8.8
Report Delivery Scheduling
SAS Business Intelligence
8.2
Microsoft BI
8.8
Delivery to Remote Servers
SAS Business Intelligence
7.9
Microsoft BI
8.5

Data Discovery and Visualization

SAS Business Intelligence
7.8
Microsoft BI
8.8
Pre-built visualization formats (heatmaps, scatter plots etc.)
SAS Business Intelligence
8.0
Microsoft BI
9.0
Location Analytics / Geographic Visualization
SAS Business Intelligence
6.9
Microsoft BI
8.8
Predictive Analytics
SAS Business Intelligence
8.4
Microsoft BI
8.5

Access Control and Security

SAS Business Intelligence
8.3
Microsoft BI
8.7
Multi-User Support (named login)
SAS Business Intelligence
7.9
Microsoft BI
8.8
Role-Based Security Model
SAS Business Intelligence
8.0
Microsoft BI
8.6
Multiple Access Permission Levels (Create, Read, Delete)
SAS Business Intelligence
8.5
Microsoft BI
9.0
Single Sign-On (SSO)
SAS Business Intelligence
8.8
Microsoft BI
8.5

Mobile Capabilities

SAS Business Intelligence
7.5
Microsoft BI
8.5
Responsive Design for Web Access
SAS Business Intelligence
8.5
Microsoft BI
8.4
Dedicated iOS Application
SAS Business Intelligence
7.0
Microsoft BI
8.7
Dedicated Android Application
SAS Business Intelligence
7.0
Microsoft BI
8.5
Dashboard / Report / Visualization Interactivity on Mobile
SAS Business Intelligence
7.5
Microsoft BI
8.5

Application Program Interfaces (APIs) / Embedding

SAS Business Intelligence
7.5
Microsoft BI
8.4
REST API
SAS Business Intelligence
8.0
Microsoft BI
8.6
Javascript API
SAS Business Intelligence
8.0
Microsoft BI
8.4
iFrames
SAS Business Intelligence
6.5
Microsoft BI
8.4
Java API
SAS Business Intelligence
6.5
Microsoft BI
8.3
Themeable User Interface (UI)
SAS Business Intelligence
10.0
Microsoft BI
8.7
Customizable Platform (Open Source)
SAS Business Intelligence
6.0
Microsoft BI
8.0

Pros

  • Providing a seamless data access engine to monitor utilization of credit lines across several lines of business. Pulling data from Teradata, Oracle, DB2, Netezza and others to be combined into a single data source for reporting
  • Ability to analyze data through thin client which is able to access the data on the network
  • Reporting software which is also thin client and can be productionalized to refresh at any time.
Erik Larsen profile photo
  • The layout of Power BI is very intuitive. Someone that is familiar with Excel and working with Charts and Graphs in that environment will find the learning curve a rather short one to start using Power BI.
  • I like the way Power BI fits an assortment of users and how the functionality that you engage is replicated in Excel, that being Power Query and Power Pivot. So what you learn in one tool can be readily applied towards the other which allows you to more effectively apply your training.
  • I appreciate how Microsoft is working to develop tools that go a long ways to empowering the end user. Prior to Power BI I would have had to consult with a "BI" professional to develop a dashboard. With Power BI I don't have to consult with anyone, I can work to put together the dash board I want and using a tool set that is really robust and allows me to engage an enormous amount of data. It's provides a great deal of flexibility and the types of data I can connect to.
  • Updates...Microsoft is working diligently to keep Power BI current with monthly updates. They do a really good job of listening to the end user, if there is functionality not currently present just give them a month or so.
  • Just to be clear, even though it's easy to get going right out of the gate with Power BI it provides plenty of opportunities to create some really sophisticated reporting solutions. With DAX in Power Pivot and M language in Power Query, you are provided with plenty of head room to do some really amazing things in Power BI.
  • Training...there are resources across the web for learning and growing your skills and Power BI. And what's even better is the majority of those resources are free.
  • Data engagement, when presenting the data to the end user Power BI goes a long way to allowing that end user to engage the data and begin to identify root cause by simply interacting with the graph/chart/data set. It allows for really fluid engagement. Prior to Power BI so many times during the presentation of data we often times ended the engagement with that data with more questions than what were answered. With Power BI, more often than not, the end user is able to get answers to the questions by simply clicking on the data in the graph/chart/dataset to see the details. This tool really does have the capacity to make you look like a rock star.
Jason Leidig profile photo

Cons

  • 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.
Nicole Jagusztyn profile photo
  • Its not a web based application yet. So you have to install the client application on your local machine. In addition, you pretty much have to install a the full SSMS package. Its a heavy weighted suite of products
  • Compared to Tableau you are limited in your dashboard building ability. In SSRS you have to build a master report along with a subreport where these two items have to have a key that links them together. From there you can break up the screen into multiple quadratics with your visualization.
  • If someone wants to view the report on their iPad, you have to make sure that the subscription for their report is in PDF or CSV format. If its in Excel and they dont have Excel on their iPad, they cant view it. If its in CSV, I believe the report will open up in the iPads native spreadsheet app.
  • When you are stuck while building a report, the forums for Microsoft pretty much suck. Their technical articles suck also. Microsoft support is pretty much non-existent.
Mashhood Syed profile photo

Likelihood to Renew

SAS Business Intelligence9.3
Based on 3 answers
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.
Erik Larsen profile photo
Microsoft BI8.0
Based on 25 answers
Flexibility and ease of use! I have not found something that I can't do with the Microsoft BI tools. Some things may be a struggle, but that comes with any tool. The online community support for developers and users of Microsoft is tops as well. If you have a problem you can post in the forums provided by Microsoft or just post on Twitter and you will get an answer from the experts in the field in no time. There is no better community out there for technology that is very supportive and will not bash you even for asking the most basic question. There are plenty of options for support that don't require you to contact Microsoft and that helps save a lot of dollars and time. The tools are keep up-to-date and are constantly evolving.
Steve Wake profile photo

Usability

No score
No answers yet
No answers on this topic
Microsoft BI7.0
Based on 5 answers
It's a good rating for people willing to learn and get used to it, but it's not inherently user friendly, especially to people who are not Excel power users.
Alexander Lubyansky profile photo

Reliability and Availability

No score
No answers yet
No answers on this topic
Microsoft BI9.5
Based on 2 answers
The product has been reliable.
Robert Goodman profile photo

Performance

No score
No answers yet
No answers on this topic
Microsoft BI7.0
Based on 2 answers
SQL Server Reporting Services (SSRS) can drag at times. We created two report servers and placed them under an F5 load balancer. This configuration has worked well. We have seen sluggish performance at times due to the Windows Firewall.
Robert Goodman profile photo

Support

SAS Business Intelligence10.0
Based on 1 answer
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.
Nicole Jagusztyn profile photo
Microsoft BI7.1
Based on 6 answers
We are not currently utilizing Microsoft's technical support.
Robert Goodman profile photo

In-Person Training

No score
No answers yet
No answers on this topic
Microsoft BI6.9
Based on 3 answers
This training was more directed toward what the product was capable of rather than actual programming.
Stephanie Grice profile photo

Online Training

No score
No answers yet
No answers on this topic
Microsoft BI8.5
Based on 2 answers
I have used on-line training from Microsoft and from Pragmatic Works. I would recommend Pragmatic Works as the best way to get up to speed quickly, and then use the Microsoft on-line training to deep dive into specific features that you need to get depth with.
Sean Brady profile photo

Implementation

No score
No answers yet
No answers on this topic
Microsoft BI9.6
Based on 7 answers
Be prepared to help business users define their data. We found that different campuses had different definitions for the same thing. This took some change management and negotiating to get each team to come to a common understanding.
Robert Goodman profile photo

Breadth of Deployment

about 100 users, about 10 departments
Alex Rubin profile photo
Everyone uses it around my company. Mostly as BI professionals that use it to create BI solutions.
Michał Becker profile photo

Alternatives Considered

Tapan Jain profile photo
Microsoft BI provides the most flexibility and best integration across of the products in the SQL Server Microsoft BI Suite (and with other Microsoft tools). The tools are flexible enough to work just as well in a small group as they are in a large enterprise and without having to re-learn the products to fit those different scenarios. All of the tools in the SQL Server Microsoft BI stack are provided with one licenses (assuming you install everything on one server) and all of the development tools required are available for free if they they aren't included with the main installer. The Microsoft BI tools will work with most of the major database systems out of the box and if it doesn't, there is a very active 3rd party software environment that develops free or paid add-ons that will cover the options that Microsoft doesn't out of the box. The tools are easy to learn and use and updated on a very regular basis. There is always the flexibility to add or take away from the products installed as part of a Microsoft BI solution, so you never have to be locked into using only the tools provided by Microsoft.
Steve Wake profile photo

Collaboration and Sharing

SAS Business Intelligence9.0
Based on 5 answers
Our Business Intelligence implementation is seamlessly integrated with our active directory structure and single sign-on. This allows simplified control for reporting and access across the entire world-wide organization.
Ken Sparks profile photo
Microsoft BI8.2
Based on 27 answers
It is easy to export anything you build in Microsoft BI to Excel or other tools and then share it from there. With SSRS being a web based reporting tool, that makes it very easy to share reports with anyone that has access to the internet or the network. At this point the weak point in report accessibility is on tablets and smartphones, Microsoft is working to make all of their tools HTML5 compliant, but it is not there yet. Security for all of the tools is baked in and is easy to setup if you already have a Microsoft Active Directory infrastructure. If you are not using Microsoft Active Directory you can still enhance the tools to use your own security tools without a lot effort. I believe that in the very near future this rating will be a 10 as well, once all of the tools are supported on all platforms using established standards.
Steve Wake profile photo

Data Integration

SAS Business Intelligence9.0
Based on 5 answers
We easily present data from various data sources via a consistent user interface. Our numerous data models can now be presented to our users using a consistent reporting interface. This has allowed our technical team to provide a much improved level of service to our end-users for the purpose of reporting.
Ken Sparks profile photo
Microsoft BI8.7
Based on 26 answers
I really like how Microsoft brings data from multiple sources together. I think this is one of the strengths of the software allowing for a more complex accumulation of data and information. This results on more complex analysis but again Microsoft BI does a superb job at making this complex data easy to interpret and take action on.
Brian Caulfield profile photo

Return on Investment

  • Positive Impact: better customer service. We have been able to deliver reports that will help multiple employees and implement any feedback they have on those reports quickly.
  • Positive Impact: increased inter-departmental discussions. We have long had a problem working in silos. Now we are pulling data from multiple departments into one report, and it becomes easy to see how what one department is doing in affecting another. We had a meeting to discuss a preliminary report on course scheduling efficiency. It included data from our Facilities folks and our academic Deans. Once we put the numbers up on the screen, there spawned a helpful discussion about how what one department can do to help another.
  • Positive Impact: organizational transparency. For the first time, our users are exposed to a wealth of data about themselves and other areas of the college. It is starting to make some question the way we do business, and if there is a better way.
Nicole Jagusztyn profile photo
  • Cleaner, more accurate data returned to end users.
  • Better decision making.
  • Increased control over data.
Nathan Patrick Taylor profile photo

Pricing Details

SAS Business Intelligence

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
SAS Business Intelligence Editions & Modules
SAS Business Intelligence
Additional Pricing Details

Microsoft BI

General
Free Trial
Free/Freemium Version
Yes
Premium Consulting/Integration Services
Entry-level set up fee?
No
Microsoft BI Editions & Modules
Microsoft BI
Edition
Power BI
$0
Power BI Pro
$102
2. per user per month
Additional Pricing Details