2016
Euro 2016 analytics: Who's playing the toughest game?
2016/06/21
I am really enjoying Uefa Euro 2016 Footbal Competition, even because our national team has done pretty well so far. That’s why after browsing for a while statistics section of official EURO 2016 website I decided to do some analysis on the data they share ( as at the 21th of June).
Just to be clear from the beginning: we are not talking of anything too rigourus, but just about some interesting questions with related answers gathered mainly through data visualisation.
tags:
analytics /data /data analysis /data analytics /Github /R /Rstudio /soccer /
2015
Introducing Afraus: an Unsupervised Fraud Detection Algorithm
2015/07/02
The last Report to the Nation published by ACFE, stated that on average, fraud accounts for nearly the 5% of companies revenues.
on average, fraud accounts for nearly the 5% of companies revenues


Projecting this number for the whole world GDP, it results that the “fraud-country” produces something like a GDP 3 times greater than the Canadian GDP.
tags:
algorithm /analytics /apps /computer science /data /data analysis /data analytics /fraud /fraud analytics /internal audit /R /shiny /shiny apps /
Catching Fraud with Benford's law (and another Shiny App)
2015/02/06
In the early ‘900 Frank Benford observed that ’1’ was more frequent as first digit in his own logarithms manual.
More than one hundred years later, we can use this curious finding to look for fraud on populations of data.
2014
download data to excel from web
2014/10/28
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”



**select **data you want to download


Refresh downloaded data
select “data” tab
![Image [9]](https://andreacirilloblog.files.wordpress.com/2014/10/image-9.png?w=300)
tags:
data /excel /excel spreadsheet /tutorials /web query /
excel right() function in R
2014/10/27
as part of the** excel functions in R,** I have developed this custom function, reproducing the excel right() function in th R language. Feel free to copy and use it.
[code language=“r”]
right = function (string, char){
substr(string,nchar(string)-(char-1),nchar(string))}
[/code]
you can find other function in the Excel functions in R post.
tags:
analytics /data /data analysis /data analytics /excel /excel spreadsheet /functions /R /
excel left() function in R
2014/10/27
as part of the excel functions in R, I have developed this custom function, emulating the excel left() function in th R language. Feel free to copy and use it.
left = function (string,char){
substr(string,1,char)}
you can find other function in the** Excel functions in R post**.
tags:
analytics /data /data analysis /data analytics /excel /functions /R /