Microsoft BI is a business intelligence product used for data analysis and generating reports on server-based data. It features unlimited data analysis capacity with its reporting engine, SQL Server Reporting Services alongside ETL, master data management, and data cleansing.
$9.99
per user/per month
SAS Viya
Score 6.9 out of 10
N/A
An end-to-end platform for AI, data science, and analytics, used for modeling, as well as management and deployment of AI models.
Microsoft BI has an advantage over other BI platforms because it integrates nicely with the Microsoft products, such as Excel, Microsoft SQL, Access, and all the other parts of the Microsoft business. A user that has spent time with Microsoft products will find Microsoft BI to …
Microsoft BI is well suited for Stream analytics, easy data integration, report creation and UI/UX designs (limited but what all available are great ones) Microsoft BI may be less appropriate for handling huge number of datasets and difficult queries. It may also be difficult for a company with heavy data.
SAS Advanced Analytics excels with projects that have at least 3 parts. The first part is the ability to address and compare different modeling types. Suppose you are an analyst interested in predicting home prices or whether an individual will reapply for unemployment insurance. There are lots of model types that could work for these two situations. SAS Advanced Analytics makes it easy (although not as easy as SAS Enterprise Miner) to compare the performance of different modeling types, such as comparing support vector machines with random forest models. A second scenario that SAS Advanced Analytics does a good job at is making the analysis reproducible. By showing the lineage of analyses, another analyst is able to follow the work of the previous analyst. This is a huge advantage for individuals working in corporations or governments. The third area SAS Advanced Analytics is useful is in text analytics. The field is huge now, and I haven't come across a software that makes text analytics as easy as SAS Advanced Analytics.
Complex Survey Analysis- SAS is a great resource if you need to analyze complex survey data. One can easily write code for this by inserting (survey) in front of the procedure with the weight, cluster, and strata variables. (ex: surveyfreq)
Modeling/ Graphing- SAS creates clean and easy to understand graphs and models which take visual data to the next level.
Support- There is a large SAS Advanced analytics online support in place. It is easy to find help on many procedures that you will use in this software.
The race to perfect gathering of Non-Traditional datasets is on-going; with Microsoft arguably not the leader of the pack in this category.
Licensing options for PowerBI visualizations may be a factor. I.e. if you need to implement B2C PowerBI visualizations, the cost is considerably high especially for startups.
Some clients are still resistant putting their data on the cloud, which restricts lots of functionality to Power BI.
SAS Analytics does not have very good graphic capabilities. Their advanced graphics packages are expensive, and still not very appealing or intuitive to customize.
SAS Analytics is not as up-to-date when it comes to advanced analytical techniques as R or other open-source analytics packages.
Microsoft BI is fundamental to our suite of BI applications. That being said, Northcraft Analytics is focused on delighting our customers, so if the underlying factors of our decision change, we would choose to re-write our BI applications on a different stack. Luckily, mathematics are the fundamental IP of our technology... and is portable across all BI platforms for the foreseeable future.
Not only does SAS become easier to use as the user gets more familiar with its capabilities, but the customer service is excellent. Any issues with SAS and their technical team is either contacting the user via email, chat, text, WebEx, or phone. They have power users that have years of experience with SAS there to help with any issue.
The Microsoft BI tools have great usability for both developers and end users alike. For developers familiar with Visual Studio, there is little learning curve. For those not, the single Visual Studio IDE means not having to learn separate tools for each component. For end-users, the web interface for SSRS is simple to navigate with intuitive controls. For ad-hoc analysis, Excel can connect directly to SSAS and provide a pivot table like experience which is familiar to many users. For database development, there is beginning to be some confusion, as there are now three tool choices (VS, SSMS, Azure Data Studio) for developers. I would like to see Azure Data Studio become the superset of SSMS and eventually supplant it.
If SAS Enterprise Guide is utilized any beginning user will be able to shorten the learning curve. This is allow the user a plethora of basic capabilities until they can utilize coding to expand their needs in manipulating and presenting data. SAS is also dedicated to expanding this environment so it is ever growing.
SAS probably has the most market saturation out of all of the analytics software worldwide. They are in every industry and they are knowledgable about every industry. They are always available to take questions, solve issues, and discuss a company's needs. A company that buys SAS software has a dedicated representative that is there for all of their needs.
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.
Although nothing is perfect, SAS is almost there. The software can handle billions of rows of data without a glitch and runs at a quick pace regardless of what the user wants to perform. SAS products are made to handle data so performance is of their utmost important. The software is created to run things as efficiently as SAS software can to maximize performance.
While support from Microsoft isn't necessarily always best of breed, you're also not paying the price for premium support that you would on other platforms. The strength of the stack is in the ecosystem that surrounds it. In contrast to other products, there are hundreds, even thousands of bloggers that post daily as well as vibrant user communities that surround the tool. I've had much better luck finding help with SQL Server related issues than I have with any other product, but that help doesn't always come directly from Microsoft.
SAS is generally known for good support that's one of the main reasons to justify the cost of having SAS licenses within our organization is knowing that customer support is just a quick phone call away. I've usually had good experiences with the SAS customer support team it's one of the ways in which the company stands out in my view.
SAS has regional and national conferences that are dedicated to expanding users' knowledge of the software and showing them what changes and additions they are making to the software. There are user groups in most of the major cities that also provide multi-day seminars that focus on specific topics for education. If online training isn't the best way for the user, there is ample in-person training available.
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.
There are online videos, live classes, and resource material which makes training very easy to access. However, nothing is circumstantial so applying your training can get tricky if the user is performing complex tasks. When purchasing software, SAS will also allocate education credits so the user(s) can access classes and material online to help expand their knowledge.
We are a consulting firm and as such our best resources are always billing on client projects. Our internal implementation has weaknesses, but that's true for any company like ours. My rating is based on the product's ease of implementation.
Ask as many questions you can before the install to understand the process. Since a third party does the installation your company is sort of a passanger and it is easy to get lost in the process. It also helps to have all users and IT support involved in the install to help increase the knowledge as to how SAS runs and what it needs to perform correctly.
We have used the built in ConnectWise Manager reports and custom reports. The reports provide static data. PowerBI shows us live data we can drill down into and easily adjust parameters. It's much more useful than a static PDF report.
We had major use of SAS in forecasting where it doesn't require high level of coding knowledge and which has highly efficient models built in which can give good results on forecasts without lot of manual intervention. This tool was designed specifically for forecasting and hence was always a better choice compared to other tools.
It all depends on the type of SAS product the user has. Scaleability differs from product to product, and if the user has SAS Office Analytics the scaleability is quite robust. This software will satisfy the majority of the company's analytic needs for years to come. In addition, if SAS is not meeting the users needs the company can easily find SAS solutions that will.
As a SaaS provider we see being able to provide self-service BI to our client users as a competitive advantage. In fact the MSSQL enabled BI is a contributing factor to many winning RFPs we have done for prospective client organisations.
However MSSQL BI requires extensive knowledge and skills to design and develop data warehouses & data models as a foundation to support business analysts and users to interrogate data effectively and efficiently. Often times we find having strong in-house MSSQL expertise is a bless.
SAS Advanced Analytics is not the cheapest software on the market. The overall cost was weighed against free, open-source software tools. The overall return, I think, was quite positive because SAS Advanced Analytics saves enormous amounts of time compared to the open-source software tools.
At first, adopting SAS Advanced Analytics was a negative return because it took time for individuals to change their analytics habits and adjust to superior tools available at their discretion.
SAS Advanced Analytics has replaced the need to hire less expensive R or Python programmers. So, although the software requires an initial expensive upfront investment, the ease of use makes it so that other areas of expenditure save money.
