Skip to Content
Author's profile photo Former Member

Data Geek Challenge – Analyzing Italian Lottery numbers from the Italian Lottery GoLive

Hi guys,

I want to use SAP Lumira to analyze italian lottery numbers, from GoLive of italian lottery to now.

To do this I have used a txt file with all extractions.

/wp-content/uploads/2013/08/1_267404.png

In Italy we organize lottery by cities. For each city, in a lottery extraction 5 numbers ( ranage [1,90]) are extracted.

In uploaded file there are:

– the extraction date

– the city code ( eg. MI for Milan, Na for Naples, TO for Turin and so on…)

– the 5 number extracted.

After this I have created a new document, using this datasource.

For each wheel I choose AVG as aggregation operator.

/wp-content/uploads/2013/08/2_267405.png

After this, let’s have fun with Lumira 🙂

I choose to diplay AVG number for each wheel, and to visualize in big the city wheel with biggest number extracted.

/wp-content/uploads/2013/08/3_267406.png

I discover that the first extraction average is high on Cagliari wheel.

/wp-content/uploads/2013/08/4_267407.png

Then I discovered that Cagliari got hottest(highest) numbers on quite all extractions from lottery GoLive:

/wp-content/uploads/2013/08/5_267409.png

Conclusion: when you will be in Italia enjoying a pasta alla matriciana near the Colosseo, and you see a Tabaccheria where you can play italian lottery, bet an high number on Cagliari wheel. You will be back home as a billionaire ! 🙂

Last but not least, all this is true if you are “truly” convinced that past drive the future in lottery. If not, spend your 2€ in more enjoyable italian activities, like having a gelato (Ice Cream) after your matriciana.

Filippo

Assigned tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Jitendra Kansal
      Jitendra Kansal

      Filippo Naggi

      i never knew this lottery system.

      great effort by you to analyze it. its really nice. 🙂

      Regards,

      Jitendra

      Author's profile photo Former Member
      Former Member

      Nice use of SAP Lumira, Filippo.

      Bye,

      Andrea

      Author's profile photo Ivan Femia
      Ivan Femia

      HI Filippo,

      keep going and post more examples 😛

      Ivan