Welcome to

alt text

About Bryan Cafferky...

alt text

email: bryan256.@msn.com

blog: sql-fy.com

Twitter: @BryanCafferky

LinkedIn: linkedin.com/in/bryancafferky

Experience

  • Author: Pro PowerShell for Database Developers by Apress.
  • Microsoft 2016 MVP
  • Found and Lead The RI MS BI User Group.
  • Health Care, Banking, Insurance, ecommerce, utilities.
  • Frequent technical speaker at technical events.
  • Decades of IT experience.

Group Goals

  • Share experiences and knowledge.

  • Network: Get to know and help each other.

  • Have presentations on current relevant topics.

  • Create an open environment people are comfortable to share in.

  • Gain a better sense of what is going on out there.

  • Have fun and share in the excitement of new developments.

It is proven that the celebration of birthdays is healthy. Statistics show that those people who celebrate the most birthdays become the oldest.

Implementation Details

  • Monthly meetings.
  • Presentations.
  • 1 to 1 ½ Hour Meetings.
  • Open discussion.
  • Respectful of each other and always professional.
  • RSVP for meetings.
  • Use features of Meetup like messaging and posting files.

R Humor

alt text

Your Ideas

  • Introduction.
  • Experience with other groups.
  • Topics you would like to see covered.
  • Venue.
  • Speakers?
  • Other?

Getting R...

R Language and Command Line interface (CLI).
https://cran.r-project.org/bin/windows/base/

Designed for interactive single command at a time.

R Studio: An Integrated Development Environment. https://www.rstudio.com/products/rstudio/download/

A complete script development environment.

R Highlights

  • R Studio features. (script_1)
  • Amazing Charts and Graphs. (script_2)
  • Community support and packages.
  • Loading and manipulating data.
  • Addressing Scalablity.
  • SQL Server Integration.
  • Publishing in R Studio. (R_Highlights.Rpres)
  • Interfacing with other languages like Python, STAN, etc.
  • Other R Integrated Development Environments (IDE). (Visual Studio)

R Studio

alt text

Publishing Dynamic Documents in R

Problem:

With technical presentations, you need to cut and paste code samples into slides and switch between the slides and the IDE.

The goal of dynamic documents is to maintain the code with the presentation.

Saves time and effort!

Publishing Dynamic Documents in R

  • Markdown (books, slides)
  • Beamer (slides)
  • LaTeX
  • R HTML
  • Shiny (interactive web apps, think RSP) demo_shiny
  • FlexDashboard (interactive web apps)
  • knitr integrates some of the above technologies.

R and the Smart Kid

alt text

Machine Learning - Iris Data Set

alt text

R - Profiling Data - str

str will return the structure of the data.

str(iris, vec.len=1)

'data.frame':   150 obs. of  5 variables:
 $ Sepal.Length: num  5.1 4.9 ...
 $ Sepal.Width : num  3.5 3 ...
 $ Petal.Length: num  1.4 1.4 ...
 $ Petal.Width : num  0.2 0.2 ...
 $ Species     : Factor w/ 3 levels "setosa","versicolor",..: 1 1 ...

R - Profiling the Data - Summary

See the basic statistics…

summary(iris)
Sepal.Length Sepal.Width Petal.Length Petal.Width Species
Min. :4.300 Min. :2.000 Min. :1.000 Min. :0.100 setosa :50
1st Qu.:5.100 1st Qu.:2.800 1st Qu.:1.600 1st Qu.:0.300 versicolor:50
Median :5.800 Median :3.000 Median :4.350 Median :1.300 virginica :50
Mean :5.843 Mean :3.057 Mean :3.758 Mean :1.199 NA
3rd Qu.:6.400 3rd Qu.:3.300 3rd Qu.:5.100 3rd Qu.:1.800 NA
Max. :7.900 Max. :4.400 Max. :6.900 Max. :2.500 NA

Machine Learning - Histogram

Does the data fit a normal curve?

hist(iris$Petal.Width,x.lab="petal width", col="lightblue")

plot of chunk unnamed-chunk-5

R Humor

alt text

R Highlights Review

  • R Studio features.
  • Amazing Charts and Graphs.
  • Community support and packages.
  • Loading and manipulating data.
  • Addressing Scalablity.
  • SQL Server Integration.
  • Publishing in R Studio.
  • Interfacing with other languages like Python, STAN, etc.
  • Other R Integrated Development Environments (IDE). (Visual Studio)

Q & A