Ah, writing a blog post! This is a pleasure I was forgetting, and you can guess it looking at last post date of publication: it was around january... you may be wondering: what have you done along this long time? Well, quite a lot indeed:

• changed my job ( I am now working @ Intesa Sanpaolo Banking Group on Basel III statistical models)

• became dad for the third time (and if you are guessing, it’s a boy!)

  tags: algorithm /analytics /apps /computer science /data analysis /data analytics /Github /R /Rstudio /shiny /shiny apps /social media /social media analytics /tutorials /web query /

If you have a blog you may want to discover how your website is performing for given keywords on Google Search Engine. As we all know, this topic is not a trivial one.

Problem is that the analogycal solution would be quite time-consuming, requiring you to search your website for every single keyword, on many many pages.

Feeling this way?

[caption id=“attachment_273” align=“aligncenter” width=“300”] “Pain and fear, pain and fear for me” - Oliver Twist[/caption]

tags: algorithm /analytics /apps /google /R /Rstudio /SEO /shiny /shiny apps /social media /social media analytics /web query /

This simple tutorial will show you how to download data into an excel spreadsheet, creating a web query.

Download data into excel

select “data” tab

select “from web”

input the desidered web URL

click “go” button

**select **data you want to download

click “import” button

Refresh downloaded data

select “data” tab

tags: data /excel /excel spreadsheet /tutorials /web query /