什么是R (What is R)
R is a very popular data programing language. R is especially used in data analysis, statistics calculations, predictions, data mining and machine learning. R is used by data scientist, economist, genetic scientists, and statisticians. R has very wide usage in real life. Healthcare, finance, marketing, and manufacturing are some of them.
R是一种非常流行的数据编程语言。 R特别用于数据分析,统计计算,预测,数据挖掘和机器学习。 R由数据科学家,经济学家,遗传科学家和统计学家使用。 R在现实生活中用途非常广泛。 医疗保健,金融,市场营销和制造业就是其中一些。
In short, R is/has:
简而言之,R是/具有:
- open source 开源的
- flexible for statistics calculation 灵活的统计计算
- huge chart ability 巨大的图表能力
- suitable for big data analyses 适用于大数据分析
- a large community 大型社区
- the ability to integrate with many programs (Microsoft SQL Server , SAP HANA Oracle vs.) 与许多程序集成的能力(Microsoft SQL Server,SAP HANA Oracle与)
The capabilities of the R program improve with additional packages. You can easily find or develop additional libraries for R.
R程序的功能通过附加软件包来改进。 您可以轻松找到或开发R的其他库。
什么是“词云” (What is a “Word cloud”)
A “Word cloud” is a technique that allows us to focus on the most repetitive words in a text, article or any word sequence. Using this technique, we can analyze keywords in a word sequence.
“词云”是一种技术,使我们可以专注于文本,文章或任何词序中最重复的词。 使用这种技术,我们可以分析单词序列中的关键字。
To give a simple example, if we analyze product comments of an online shopping website, we can find most common words. These words can tell us what our customers think about this product. Now we will make our article word cloud. As shown in below, our article keywords are “SQL” and “server” if we combine the two words, our article is about probably about “SQL Server”.
举一个简单的例子,如果我们分析一个在线购物网站的产品评论,我们可以找到最常用的词。 这些话可以告诉我们客户对这款产品的看法。 现在,我们将使文章词云化。 如下所示,如果我们将这两个词结合使用,则我们的文章关键字为“ SQL”和“ server”,我们的文章可能涉及“ SQL Server”。
![](https://www.sqlshack.com/wp-content/uploads/2017/11/c-users-esat-erkec-merkezcelik-desktop-ekran-alin1.png)
Microsoft BI和SQL Server R服务 (Microsoft BI and SQL Server R Services)
Microsoft is one of the key players in Business Intelligence market. Gartner positions Microsoft as a leader in Business Intelligence and analytics platforms. Microsoft Business Intelligence platform includes a lot of capable tools (Power BI, Power View, Reporting Service, Microsoft SQL Server Mobile Report, Analysis Services and Integration Services).
微软是商业智能市场的主要参与者之一。 Gartner将Microsoft定位为商业智能和分析平台的领导者。 Microsoft商业智能平台包括许多功能强大的工具(Power BI,Power View,Reporting Service,Microsoft SQL Server移动报表,Analysis Services和Integration Services)。
Specifically, Microsoft has developed some very strong features for SQL Server. The first come to mind include columnstore index, R script integration, Python integration and graph database. Azure Machine Learning is an impressive tool for predictive analytics. PolyBase allows us to process data outside of the database via T-SQL. With PolyBase we can access Hadoop data. When we look at all these features, the Microsoft BI stack without a doubt, very impressive.
具体地说,