SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag R Language Rss

   Items 1 to 20 of 73    Older >>
 

Creating Functions

By Steve Jones 2017/12/13 | Category: r language
Rating: (not yet rated) |  Discuss |   Briefcase | 573 reads

Naming the Columns

By Steve Jones 2017/12/06 | Category: r language
Rating: (not yet rated) |  Discuss |   Briefcase | 603 reads

Merging Frames

By Steve Jones 2017/11/29 | Category: r language
Rating: (not yet rated) |  Discuss |   Briefcase | 640 reads

SQL Server R Services: Generating Sparklines and Other Types of Spark Graphs

By being able to run R from SQL Server, you have available to you not just a convenient way of performing analysis on data but also a wide range of more specialized graphical facilities. Rob Sheldon illustrates the point by demonstrating how you can create sparklines that can then be embedded in reports.  Read more...
By 2017/11/23 | Source: SimpleTalk | Category: sql server r services
Rating: (not yet rated)  Rate this |   Briefcase | 2,675 reads

Are these equal?

By Steve Jones 2017/11/22 | Category: r language
Rating: (not yet rated) |  Discuss |   Briefcase | 647 reads

Adding New Libraries

By Steve Jones 2017/11/08 | Category: r language
Rating: (not yet rated) |  Discuss |   Briefcase | 655 reads

SQL Server R Services: Working with Data Frames

Although you can get started with R in SQL Server without understanding data frames, they are a key structure of the R language that are the equivalent of SQL Server table variables. They give you many ways of manipulating and analyzing data and passing it between R and SQL Server. For a database professional, they provide a clear and familiar concept when getting to grips with integrating R into the database.  Read more...
By Additional Articles 2017/11/08 | Source: SimpleTalk | Category: r services
Rating: (not yet rated)  Rate this |   Briefcase | 3,081 reads

The Working Folder

By Steve Jones 2017/11/01 | Category: r language
Rating: (not yet rated) |  Discuss |   Briefcase | 641 reads

Loading Tab Values

By Steve Jones 2017/10/25 | Category: r language
Rating: (not yet rated) |  Discuss |   Briefcase | 777 reads

SQL Server R Services: Working with ggplot2 Statistical Graphics

It is when you use R in SQL Server with one of the huge range of packages that comes with it that you can begin to appreciate the power of the system. With a package such as ggplot there are many 'knobs one can twiddle' in order to get spectacular and informative visualisations. Rob Sheldon continues his beginners series for R in SQL Server by showing how to refine the output to get it as you need it.  Read more...
By Additional Articles 2017/10/25 | Source: SimpleTalk | Category: sql server r services
Rating: (not yet rated)  Rate this |   Briefcase | 2,826 reads

Loading CSVs

By Steve Jones 2017/10/18 | Category: r language
Rating: (not yet rated) |  Discuss |   Briefcase | 710 reads

Loading Data using R and PowerBI

I'm not a fan of R visuals in PowerBI. I recently learned I can use R to load data and native PowerBI visuals to display the data. Here's how.  Read more...
By Nick Burns 2017/10/16 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 796 reads

Get the data row

By Steve Jones 2017/10/11 | Category: r language
Rating: (not yet rated) |  Discuss |   Briefcase | 812 reads

R Data frames

By Steve Jones 2017/10/04 | Category: r language
Rating: (not yet rated) |  Discuss |   Briefcase | 704 reads

Real-time moving averages for IoT with R

Computing an average over all your data is easy, but what if your data arrives incrementally and you need to be able to compute real-time averages on the fly? That's what we are going to look at.  Read more...
By Nick Burns 2017/10/02 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 464 reads

Reading a CSV

By Steve Jones 2017/09/27 | Category: r language
Rating: (not yet rated) |  Discuss |   Briefcase | 773 reads

Adding the average

By Steve Jones 2017/09/20 | Category: r language
Rating: (not yet rated) |  Discuss |   Briefcase | 752 reads

Moving beyond principal components analysis

Principal components analysis is a standard, but usually terrible, technique for visualising complex data. We're using network diagrams to solve this problem.  Read more...
By Nick Burns 2017/09/19 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 469 reads

SQL Server R Services: Digging into the R Language

It is not just the analytic power of R that you get from using SQL Server R Services, but also the great range of packages that can be run in R that provide a daunting range of graphing and plotting facilities. Robert Sheldon shows how you can take data held in SQL Server and, via SQL Server R Services, use an R package called ggPlot that offers a powerful graphics language for creating elegant and complex plots.  Read more...
By Additional Articles 2017/09/15 | Source: SimpleTalk | Category: sql server r services
Rating:  Rate this |   Briefcase | 5,439 reads

Heat Maps

By Steve Jones 2017/09/13 | Category: r language
Rating: (not yet rated) |  Discuss |   Briefcase | 790 reads
   Items 1 to 20 of 73    Older >>
 
Tags
data analysis (9)    
sql server r services (6)    
statistics (6)    
microsoft r server (4)    
outlier detection (4)    
r services (4)    
editorial (3)    
machine learning (3)    
machine learning (ml) (3)    
data mining (2)    
data science (2)    
microsoft r services (2)    
prediction (2)    
sql server (2)    
sql server 2016 (2)    
sql server 2017 (2)    
statistical analysis (mathematics) (2)    
t-sql (2)    
visualisation (2)    
administration (1)    
advanced analytics (1)    
analytics (1)    
association (1)    
association rules (1)    
baseline (1)    
bi (1)    
big data (1)    
cluster analysis (1)    
clustering (1)    
crm analysis (1)    
csv (1)    
data analtyics (1)    
data insight (1)    
database administration (1)    
database growth (1)    
dba (1)    
disk space usage (1)    
dmvs (1)    
enterprise (1)    
enterprise environment (1)    
glm (1)    
introduction (1)    
library (1)    
microsoft (1)    
pattern recognition (1)    
performance (1)    
power bi (1)    
power bi desktop (1)    
powerbi (1)    
powershell (1)    
principal components analysis (1)    
python (1)    
query store (1)    
r package (1)    
r script (1)    
r studio (1)    
r tools for visual studio (1)    
real-time monitoring (1)    
regression (1)    
reporting services (ssrs) (1)    
sales data (1)    
sql server on linux (1)    
ssms (1)    
statistical modeling (1)    
statistics (data) (1)    
time series (1)    
visual analytics (1)    
visualization (1)