What is DisplayR?

DisplayR  provides two functionalities in a single app.
* Complete Data Science Platform
* Comprehensive Reporting Platform

You create online dashboards and export to PowerPoint & Excel. Since it is cloud based, you have access from anywhere in any browser.

The workflow in DisplayR is similar to other software of this genre.

• Get data by import

    ** SPSS Data Files

    ** SQL Tables

    ** Excel

    ** CSV

    ** Any format that R can handle

Explore Data

Analyze with data science

   Point& Click

    

• ANOVA
• CARTCluster analysis
• Correlation
• Correspondence Analysis
• Linear Discriminant Analysis
• MANOVA
• Max-Diff experimental design
• Multidimensional Scaling
• Multinomial logit
• NBD Regression
• Ordered Logit
• Poisson Regression
• Principal Components Analysis
• Quasi-Poisson Regression
• Random Forest

CODE

• Huge range of statistical techniques using R

Report (Data Visualization)

• Standard chart types
• Area Chart
• Word Clouds
• Donut Chart
• Labeled Bubbleplot
• Labeled Scatterplot
• Palm Trees
• Pictograph
• Pictograph Bar Chart
• Pie Chart

• CODE
• Huge range of graphical techniques using R

It does all of the above in one step. Well, Power BI can also do this as R is integrated with it and Power BI is also integrated with reporting services. Report update is a nice feature as you can start with a partial set and finish off after importing the whole set. Future updating can be automatic. More importantly, DisplayR has the  'no need for code' slogan.

Here are some main features:

• Quality Control and Reproducibility
• Easy updating and automation
• Simple to create and manipulate variables
• Statistical testing based on data type

You can have an app for free (DisplayR Public) that does a few things, but if you need more advanced features you need to buy DisplayR Professional ($2399/Yr) or DisplayR Enterprise(available on request)

Get the free version and more information from here:
https://www.displayr.com

Watch this blog for some easy tutorials, comparisons etc.

How do you enable Machine Learning in SQL Server 2017?

The important question is whether Machine Learning (ML) is enabled or not.

You can find if ML is enabled or not by the following:


Launch SQL Server, the version for which you want to use and start a New Query. Run the following in the context of the server:

sp_configure 'external scripts enabled'

Depending on the response to this query, you can find whether Machine Learning is installed or not. If the run_value=0, ML is not enabled.

MachineLearning_0
However the following query gives more information.

MachineLearning_1
You need to install 'Advanced Analytics Extensions' to enable Machine Learning (Using R or Python)

What are rbind and cbind for matrices in R?

rbind is short for row bind. rbind binds concatenated datapoints into matrix of compatible dimensions. cbind does the same taking column data.

Let us take the matrix defined in an earlier post:

MTX_0

In the above the matrix is:

     [,1] [,2] [,3]
[1,]    1    2    3
[2,]    4    5    6
[3,]    7    8    9

This has three rows. Let us define the following:

row1=c(1,2,3)
row2=c(4,5,6)
row3=c(7,8,9)

We can define the same matrix using rbind as shown below.

mtx2=rbind(row1,row2,row3)
Then we can form the matrix using the rbind as shown here:

MTX_1
 
There is a slight difference in the displayed results. However, you can perform this to get the matrix displayed in the original format as shown here:

MTX_2

The cbind works the same way as rbind. Instead of binding row-wise you bind column-wise. Of course you need to use the columns correctly.

MTX_3

What R language items are installed when you install SQL Server 2016?

R langugage support featured in SQL Server the  first time in SQL Server 2016. There were items  at isntallation time that explicitly shows the items.

Ritems_00 in help

The following items (RServer and R Services) were installed according to the above choice.

When you install SQL Server 2016 Developer you will be able to use the following:



SQL@2K16_defaultInstall

Also in the SQL Server Installation Center you can install a stand-alone Microsoft R Server by clicking the link in the installation center, if for some reason you do not find the Microsoft R Server in your search.

RServer_00

After installing SQL Server 2016 Developer edition you should be able to find the R Server related folders/files here:

 

R_Folder

R is Power full.
 
R is supposed to be the most powerful language when it comes to statistical processing of a large amount of data; machine learning and graphics. It is open, that means world is the player. Microsoft got into R for these strengths but still there were challenges when it comes to volume of data and deployment scenarios. The open software was further tuned for SQL Server to include in Microsoft R Server.

The Microsoft R product consists of the following:

• Microsoft R Server
• Microsoft R Client
• Microsoft R Open
• SQL Server R Services

You should jump into R if you are going to work with databases and specially analytics. Analytics is the future! believe me.

How do you find what packages are installed when you install R?

It is very easy to find.

1. Launch R

2. Click Packages as shown. Click Load Packages and this code is run.

> local({pkg <- all.available="TRUE)),graphics=TRUE)<br" packages="" select.list="" sort="">+ if(nchar(pkg)) library(pkg, character.only=TRUE)})

After a while the list of available packages appear and you can choose the one you want.

 

4. If click, say Matrix and click OK, the matrix related package gets loaded, you get just the R prompt and nothing else.

Can you install R (version 3.2.2) programming executable on Windows 10 computer?

Yes you can.

You need to download the program from here. Double clicking will let you begin installing. The installation is quite fast on Windows 10. Accept all the defaults during installation unless you need to customize. You can see all the steps in my previous installation on a Windows 7 (x64) laptop here.
After installation you will find two shortcuts as shown:

RforWindows10.png

One of them is a shortcut for the x64bit program and the other shortcut R i386 3.2.2 is a x32bit program. Probably you only need one of them. The x64 version shortcut gets added to the Start.

What is a good way to learn R language?

There are many ways one can learn as Internet provides a whole lot of options from free sites to sites where you can
pay and register to learn.
R language has come to focus because it can be used to carry out Data Analysis as it has strong statistical basis.
Using R one can work with graphics as well. This means the analyzed data can be pictorially displayed in terms of
graphs and charts for data visualization.
Microsoft SQL Server 2016 will have built-in support for R language and it goes without saying that learning R
programming has great value.
One way, I can think of,  is to download the R programming interface on to your computer and start from there.

Downloading and Installing R language executable for Windows 7?

While it is available for Unix/Linux, it is also available for Windows (both x32bit and x64bit). You can download the latest version here (R-3.2.2-win.exe) . The version you will be downloading is R 3.2.2 for Windows (32/64) 62MB. A small file for the complicated things it does.

Here are some download/install screen shots for those who like:

If you are installing for the first time choose that option after you access the download link above.

Rforwindows01

 

The set up for R on Windows needs to be selected:

Rforwindows04

Complete the Installation wizard screens and you are done.

You can invoke it from the desktop shortcut as shown here and the R-GUI will be displayed as shown:

Rforwindows08

It can also be invoked from Command Line and it will be easier if add the directory of the R installation (C:\Program Files\R\R-3.2.2\bin;) to the Path in your environment variables set up.

After adding the above directory to the Path in environmental variables, you can launch R as shown here:

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.
C:\Users\mysorian>R
R version 3.2.2 (2015-08-14) -- "Fire Safety"
Copyright (C) 2015 The R Foundation for Statistical Computing
Platform: x86_64-w64-mingw32/x64 (64-bit)
R is free software and comes with ABSOLUTELY NO WARRANTY.
You are welcome to redistribute it under certain conditions.
Type 'license()' or 'licence()' for distribution details.
  Natural language support but running in an English locale
R is a collaborative project with many contributors.
Type 'contributors()' for more information and
'citation()' on how to cite R or R packages in publications.
Type 'demo()' for some demos, 'help()' for on-line help, or
'help.start()' for an HTML browser interface to help.
Type 'q()' to quit R.
> q()
Save workspace image? [y/n/c]: n

Now you are ready to rock and roll. You could also use the GUI shown previously (previous image).

If you enter help.start() either from GUI as shown here.

R_helpstart.png

You can also do this from command line. Note that as shown above help.Start() would produce an error as R language happens to be case sensitive, it has to be help.start().

In both cases help appears in a browser window hosted on your local IIS as shown.

This is all for today. Visit here again for more on R programming.