• How to receive data from Google Analytics using R in Microsoft SQL Server

    • Tutorial

    In this article I want to show in detail how you can use R in Microsoft SQL Server to get data from Google Analytics (and generally from any API).


    The task — we have MS SQL server and we want to receive data in DWH by API


    We will use googleAnalyticsR package to connect to Google Analytics (GA).


    This package is chosen as an example due to its popularity. You can use another package, for example: RGoogleAnalytic.
    Approaches to problem solving will be the same.

    Read more →
  • Python Vs R — Data Science

    • Tutorial
    When mulling over the best programming language to use for data science, Python and R ring a bell (very quickly). While there are a lot of languages like C, C++, Java, Julia, Perl, and Scala, it's protected to state that Python and R are the harbingers in data science.

    While a great deal of data researchers will discuss the customary shortcomings like data wrangling in R or data representation in Python, ongoing improvements like Altair for Python or R have adequately reacted to these shortcomings.

    So which one would it be a good idea for you to decide for your next data investigation venture?

    R has been ruling this space for a long time now. This bodes well as this programming language was explicitly intended for analysts.
    Read more →
  • Zotero hacks: unlimited synced storage and its smooth use with rmarkdown

    • Tutorial
    Here is a bit refreshed translation of my 2015 blog post. The post shows how to organize a personal academic library of unlimited size for free. This is a funny case of a self written manual which I came back to multiple times myself and many many more times referred my friends to it, even non-Russian speakers who had to use Google Translator and infer the rest from screenshots. Finally, I decided to translate it adding some basic information on how to use Zotero with rmarkdown.


    A brief (and hopefully unnecessary for you) intro of bibliographic managers


    Bibliographic manager is a life saver in everyday academic life. I suffer almost physical pain just thinking about colleagues who for some reason never started using one — all those excel spreadsheets with favorite citations, messy folders with PDFs, constant hours lost for the joy-killing task of manual reference list formatting. Once you start using a reference manager this all becomes a happily forgotten nightmare.

    Read more →