We are using an on-premise version of SAS Visual Analytics and we soon are moving to the cloud.
I'm in the insurance sector, and there are lots of use cases for SAS Visual Analytics. The reporting tool can be used for multiple use cases. We are using it extensively.
If you are monitoring the sales in a daily manner, by using SAS Visual Analytics it would have improved. It's a reporting tool, and the tool will give you insights into where you are going wrong and where you are right. It gives you the information to where you can improve. It is very good for the reporting process.
Data handling is one of the best features of SAS Visual Analytics.
You have the flexibility to design your data models and overall it is a good tool.
The visualization should be better in SAS Visual Analytics. It is easy to use but when compared to other solutions it is lacking and the support is not very good.
The updates of the system take too much time and they charge a fee to upgrade.
In terms of visualization, SAS Visual Analytics it's stronger than Tableau and Microsoft BI, but they should improve their objects, the custom graphs, and the support. They don't have any object create case support from the SAS Visual Analytics. If you work with Microsoft BI, they have different solutions, they have different teams for support on the object. If you want to see different objects, you can request them, they can create and they can send them to the library. It's a very good thing for the Microsoft BI, but not for the SAS Visual Analytics.
I have used SAS Visual Analytics for approximately six years.
I have found the solution stable.
SAS Visual Analytics is scalable for users. However, the cost is a little high to justify it.
We have approximately 300 users using the solution. We have internal team members, sales members, and management using it.
I have used Microsoft BI and Tableau.
The implementation has many sections. The administrator section is very complex. The data management, it's very good, but the visualization is not good. The only complexity is the management.
The full process took approximately five days.
We used a consultant that does the implementation of the solution. They were very good and had five years of experience.
We have an internal team that manages this solution. I have a large team to design the reports. There are four to five people who are developing, two people for the requirement gathering, and two people for the deployment.
The cost of the solution can be expensive. There is an additional cost for users.
You will mainly focus on the data transformation layer in SAS Visual Analytics. You have to work a lot on the data transformation, during this activity you will learn a lot about the data itself. This was a very good thing for me that I learned with SAS Visual Analytics.
I rate SAS Visual Analytics an eight out of ten.
Originally posted in Spanish at https://blog.mbitschool.com/2015/05/data-science-tools-sas-vs-r.html and https://sasybi.blogspot.com.es/2015/05/data-science-tools-sas-vs-r.html
Some of the disciplines that have experienced the most development in recent years have all related to data science. The techniques and tools used in this discipline are gaining more weight in the business environment. If we take a look at the tools most commonly used, we see that there have been changes in recent years. The next (www.datasciencecentral.com) chart shows the major tools currently used by data scientists.
They are the most sought after today and represent the long trend led by R, and if we focus on existing posts, the leader has been SAS. We could add to those listed in the chart Phython, which although is a general-purpose language, its use in data analysis is increasingly widespread. We can also add to previous tools such as SCALA, RapidMiner, Weka or KNIME.
In this post, we will try to compare two of the most-used tools: SAS and R. Besides being the most-used tools, they also represent different architectures, different orientations and from the point of view of costs: paid vs free. Probably much more interesting to compare a Ferrari with a Lamborghini, to compare R with SAS, but although we also purchased speed, and cost usability, in the business-analytics context we focus on SAS and R.
Do not lose sight that considering the hectic pace leading the IT industry, if we make the same comparison within two years, tools will have evolved and certainly the criteria to assess them, there will be the need to integrate new data types into the analysis.
We begin with a brief introduction of both tools:
SAS: data analysis tool with tradition. It takes many years to lead the market and present in large accounts. It has several tools for data analysis: SAS / BASE, SAS / Enterprise Guide and SAS / Enterprise Miner. Annual term licenses at a cost affordable by only large accounts.
R: data analysis tool, unless you're a SAS veteran, but with a remarkable presence in the market. Widespread in universities and research centers, it is entering with force in the business landscape. Open source license. Extensive community and active users, the amount of available libraries is growing by the day.
The comparison criteria to consider are:
Ease of use / learning curve:
In this aspect SAS may be a simpler language for non-programmers, and there are many business analysts who must use such tools without prior technical background programming. SAS data steps are easy to learn for anyone even slightly acquainted with table structures, as it has a design type DML (Data Manipulation Language). Moreover SAS proc SQL allows the option to write SQL code directly in R may demand a more solid base of knowledge in programming and data structures. If SAS is similar to SQL, R would have its equivalent in C++. In structuring, R is an object-oriented language, while SAS responds to a type of structured, sequential language. R can do the same thing in many different ways, for example, if SAS aggregations, we'll go to a proc SQL aggregation or a PROC MEANS. But in R, there are multiple ways to do this (aggregate, summarize, apply Functions, Doby, etc.). This can be confusing to the novice who is learning R. As for training resources, it's easy to find useful resources on the web. SAS has certifications, but this formal training is also expensive.
Management and Data Management:
The key difference in data management is that R works in memory and SAS disk. Working mostly in RAM has its advantages and disadvantages, facing processes with high-volume datasets R records should be taken into account. There are libraries that allow R disc also work. SAS processes has traditionally been a problem footprint and libraries as the work must be well managed. Both work well paralleling processes.
Graphical and visualization capabilities:
The graphics capabilities of SAS focus on SAS / BASE and SAS / Enterprise Guide and, without considering SAS / Visual Analytics is licensed part, they are pretty fair. SAS in this area covers the essentials, at least in their own modules of data mining. Besides it is not limited in its use intricate. R, however, has very potent display capabilities and numerous packages with advanced functionality.
Software updates:
Due to the nature of open source, R has new algorithms and techniques readily available as individual packages are updated. To date R has about 15000 packets in CRAN (Comprehensive R Archive Network). SAS's policy of regular releases of commercial software, so that R can have more flexibility to incorporate new functionalities, although it may do SAS tested in a controlled environment.
Support services and communities:
R has a widespread and community but has no support, even if you have SAS support. In everyday practice, the broad user community for R (forums, questions, resources), supplies more than the lack of support. That said, some people are more relaxed having support on the other side of the line or you resolve the problem or you can "push" to an alternative solution.
Workflow capabilities:
SAS module features the Enterprise Guide an intuitive interface for developing process flows analytic. There are different tools based on R which also allow the development of workflows (an example is Rattle), but the have not been finally imposed, nor are they optimized. Experience shows that many analytic processes are not supported by the components of these tools and, for example, in the case of SAS, most code is purely SAS / BASE and of little use to the predefined components of which Enterprise Guide is made.
Ecosystems:
SAS provides a range of tools in fields near the Science Data as Business Intelligence, Dashboarding, Data Visualization, Data Warehouse, ETL and Data Quality, which can be integrated with data science processes (end-to-end), while R is a language focused exclusively on data science.
Integration with other languages and tools:
With regard to integration with other tools and languages, it is possible that R will take the lead from SAS. There are many open-source community tools that are integrated with R and rarely does commercial software not offer integration with R. Logically, SAS also has integrations and partnerships, analytical environments, but perhaps stay one step behind.
Licensing and costs:
There is little to say on this: as we know R is open source and SAS is commercial software with high cost. It would be interesting to see what happens in terms of trends of use if SAS lowered prices. So far it has already released one version for free training (SAS OnDemand for Academics). There are approaches in line to use both, something perfectly acceptable since R is free. There are facilities that use SAS for all data management (extraction of sources, merging, cleaning, application of business rules, consolidation, etc.) and allows the final dataset R prepared to apply the statistical model and perform the final presentation. Not a bad approach, especially considering that we can save the license SAS / Enterprise Miner (models) which is the most expensive .Equally useful is to know some equivalences between code level tools: SAS and R Equivalents
Finally an interesting study in which SAS or R preference based on years of experience is analyzed.
In this brief summary we have tried the aspects we consider most critical, this post serves as a home to possible ways to provide comments or considerations not listed in this compendium and that may also have relevance in the selection of the data analysis tool. We Also welcome contributions about other tools (Python, Matlab, SPSS, SCALA, etc.).
Interesting training services about SAS and R, ask at: cursos_a_medida_r@yahoo.es
Originally posted in Spanish at https://sasybi.blogspot.com.es/2015/07/sas-visual-a...
SAS Visual Analytics is a business analytics solution that allows you to visually explore all data in an easy-to-use platform that's accessible to users of all levels without statistical, technical, or design skills.
Visual Analytics within BI solutions that are available on the market are positioned within the analytical displays solutions group. In this group, we have solutions such as QlikView, Tableau, and TIBCO Spotfire, amongst others. In summary the proposed solutions have:
SAS Visual Analytics offers a complete analytical platform for displaying information, allowing you to identify patterns and relationships in data that were not previously apparent. The interactive capabilities of self-service BI and reporting combine with advanced analytics for all to help discover knowledge of data of any size and type.
Let us now look at the features of the tool, analyzing each of the main modules, and its technical architecture:
Data Preparation
SAS Visual Analytics has a module for importing data and other data preparation based on SQL which allows adapting imported data to the optimal structure for its exploitation. For most potential analyses, the recommended tool works on a table that consolidates aggregate information from multiple tables and starting file. This is the classic board obtained as N junction fact tables and dimensions. The tool also enables the option of working with a model in which star felling facts and dimensions would be separate tables.
The tool has a module for data preparation that allows data transformation on imported data for performance analysis based on a SQL query builder. This module may, thus, stop a little when transformations to be performed are fairly complex. In this case, I propose using SAS Enterprise Guide, offering the choice of Visual Analytic Pro (Visual Analytics + Enterprise Guide).
With the fields of the imported tables, it is relatively easy to derive the calculated fields using elements in a simple way, giving access to a powerful expression editor.
Exploratory analysis
One of the main differences of SAS over other analytical tools are its display analytic capabilities (predictive techniques, time series, associations, etc.) based on the long experience of SAS tools such as SAS Enterprise Miner. The algorithms apply predictive analytics for automatic detection, and you can get detailed info on the selected algorithm. You can easily create decision trees for groups or classifications in the data, as well as box-plot diagrams to learn more about the distribution of data.
The ability to easily obtain time series for process Forecasts. These processes are very simple to implement, but would fall short if we think of a more industrialized forecast that would make a massive entry which would result forecast for other systems (e.g. forecast need for stocks), in these cases it is advisable to go solutions SAS Forecast Server type.
In predictive processes, we can use the functionality " underlying factors "that allows us to evaluate how other variables affect our prediction can perform scenario analysis and simulations, "what-if".
It has the ability to connect through add-in to Visual Statistics for processes that need more advanced statistical analysis.
Utilities to learn about the relationships between variables, such as correlation matrices. Descriptive statistics that provide insight into the distribution of values in the variables (minimum, maximum, average, zero, etc.)
Report Designer:
Report Designer very intuitive use (drag and drop). We can easily create reports or dashboard using the graphics and visualization objects as include indicators or classifiers select.
Ability to incorporate dashboards analysis documents obtained in the process of exploratory analysis.
Once you designed a serial graphic objects on a document we can define interactions between them, to relate the selections made some of them to other objects or to define navigation between them.
SAS Visual Analytics incorporates multiple possible visualization box plots, heat maps, animated bubble charts, network diagrams, decision trees, geolocation. Likewise, auto charting capabilities help determine the most appropriate graph to display the data according to the elements selected for analysis. A bar overview allows you to zoom on the range of data that you want, without losing the whole picture.
Dimensions and hierarchies Organization for OLAP analysis multidimensional.
Creation, display, publication and distribution of multi-device analysis and reporting. Integration with Office Outlook, SharePoint, Excel and Power Point
Technical architecture:
Response times are nimble because the data is loaded into memory based on SAS LASR (server analytical high performance memory). It also has solution oriented Cloud with an on-premise option.
In short it is a powerful analytical tool display, which is an interesting option for companies without having to make a large initial investment, want to start making analytical, with the ability to scale and grow into other tools.
