Articles by Jonathan

Data Warehousing and Data Mining

August 7, 2019 | Jonathan

The relationship between data mining tools and data warehousing systems can be most easily seen in the connector options of popular analytics software packages. For example, the image below right shows the many source options from which to pull data in from warehouse backends in Tableau Desktop. Microsoft Power BI ...
[Read more...]

R and SurveyGizmo API update

May 8, 2018 | Jonathan

I made a public fork of the original RSurveyGizmo package to accommodate the API Secret, as the original package sometimes errored out with authentication issues. The post R and SurveyGizmo API update appeared first on Jonathan Fowler. [Read more...]

Wagging the Dog: BI Tools, Not Solutions

March 15, 2018 | Jonathan

If you’re familiar with the expression, or perhaps have seen the eponymous film, you understand the idea of something with far less importance or weight driving a much bigger process. In the film’s case, the expression was used to characterize a completely fabricated war shifting attention away from ... [Read more...]

Doppelgänger search with R and MatchIt

March 6, 2018 | Jonathan

In his book Everybody Lies, Seth Stephens-Davidowitz discusses the Doppelgänger Discovery method used most notably in baseball, in the case of slugger David Ortiz. Doppelgänger Discovery is a way to load up a model with as many data points about a person as possible and find their statistical ... [Read more...]

SurveyGizmo, R, and MySQL on Amazon AWS

February 27, 2018 | Jonathan

Those who have been in any sort of sociological research field should very familiar with the available survey platforms out on the web now (e.g., SurveyMonkey, SurveyGizmo, or LimeSurvey). Getting your results usually involves a multi-step generate/export/import cycle. Is there a better way? I asked the question ... [Read more...]

R, Azure SQL Server, and Mac OS X

February 23, 2018 | Jonathan

There are a few options out there for those of us who work (mostly or solely) on a Mac and need to access MSSQL databases through R.   RODBC and RSqlServer are the two I’ve worked with. RODBC requires some additional workarounds with a Unix ODBC driver; RSqlServer has issues ... [Read more...]

Never miss an update!
Subscribe to R-bloggers to receive
e-mails with the latest R posts.
(You will not see this message again.)

Click here to close (This popup will not appear again)