Rainer Mesi

Portfolio

Data & Analytics

rainer.data.blog
03/21/2020
(re)Learning SQL - Window functions

Some time last year I felt that I needed to brush up on SQL. I took a few evenings to skim some courses and online resources. (Stackoverflow, Vertabello Academy, db-fiddle.com) Below are some of my thoughts and notes from going over the material. * Window functions* Rows and range* Partition by Window Functions I have...

rainer.data.blog
03/29/2020
Water quality in Estonian swimming pools?

Last year I decided to start swimming regularly. At the time I thought it would be a good time to look at what public data is available about public pool water quality in Estonia. I found that, with some exceptions, the vast majority of swimming pools in Estonia had passed the health board inspection.

rainer.data.blog
06/30/2020
Booknotes: Avoiding data pitfalls by Ben Jones

I noticed Jones' book (Avoiding Data Pitfalls) from the reviews on Amazon and Goodreads. Few weeks ago I had a chance to read it. Below are my reading notes and main takeaways. Overall impression: a valuable book for new analysts / data professionals. Approachable and lays out the main points of efficent data work.

Press Releases and Fact Sheets

Tiatechnology
05/19/2016
TIA Technology wins Celent award for EMEA Policy Administration Systems

TIA Technology is honored with 3rd consecutive XCelent Award for serving the largest customer base in EMEA. Virum, Denmark - - TIA Technology, a leading provider of core insurance software, today announced that it has been awarded the 2015 XCelent Customer Base Award for EMEA Property & Casualty Policy Administration Systems. This is the third time TIA Solution has been honored with this hallmark distinction by Celent, an international research and consultancy firm.

Tiatechnology
05/19/2016
Zurich Colombia deploys TIA core insurance solution

Virum, Denmark 2015 - Zurich Insurance Group, (Zurich) one of the world's global insurance providers, has chosen the TIA core solution to help them start up their business in the fast-moving Colombian market. The TIA core solution was implemented by Accenture for policy administration, claims management and reinsurance, supporting the latest addition to their Latin American business - Zurich Colombia Seguros.

Travel Writing

Theculturetrip
Life of a Design Anti-Hero

Ettore Sottsass was proficient in many different fields of artistry, from sculpture, architecture, ceramics and glass works to painting and drawing. Born in Austria in 1917 to an Austrian mother and Italian father, Sottsass spent his youth in fashionable Milan.

Theculturetrip
10 Must-See Films from the World's Strictest Regimes

In countries laden with censorship laws and strict regimen, many artists, performers and filmmakers still choose to defy the status quo and create something that changes minds both within and without their nation's borders.

Theculturetrip
10 Films to Make you Fall in Love With Tokyo

The oldest film on this list, Kon Ichikawa's documentary explores the Summer Olympics held in Tokyo in 1964. The Games were highly symbolic and important for Japan as they marked the country's recovery and return to the world stage after the defeat and desolation of the Second World War.

Theculturetrip
Copenhagen's Top 7 Street Markets: From Gourmet to Vintage

Head across the harbor channel to Amager and enjoy some of the world's finest street food on Copenhagen's Paper Island. The name of the island refers to the old cellulose processing plant where the food market is situated. This indoor area of the plant is huge and houses a multitude of different food trucks and food stalls.

Theculturetrip
Helsinki's Top 10 Cocktail Bars & Old-School Pubs

If you are looking for the real hard rock vibe then the Bäkkari is the place for you. The venue has their own nightclub upstairs with live gigs every weekend but the bar downstairs is free and full of character.

Theculturetrip
The 5 Best Melbourne Street Artists and Where to Find Them

Originally from Tasmania, Ghostpatrol now works in Melbourne, where he has gained international recognition for his works both on the street and with other more traditional media. Describing himself as an experimenter and not an artist, Ghostpatrol's style is a mix of fantasy and science.

Theculturetrip
Tallinn's 10 Hip Bars & Cocktail Spots

Tallinn is the capital of Estonia. The city boasts a very charming, huge and well preserved Old Town dating back to the High Middle Ages. Most of the bars and drinking establishments are located in the historical center, but in recent years, the district of Kalamaja has also begun to grow in popularity, especially for hip and alternative establishments.

Theculturetrip
Kallio's Top 10 Local Restaurants | Hip Dining in Helsinki

Kallio has historically been known as Helsinki's workers' district. Over time, however, it transformed into a hip neighborhood boasting unique and innovative restaurants, eateries and bars thanks to an influx of students and artists fleeing high rents in the city center. If you are looking for a cool place to dine while in Helsinki, don't miss out on Kallio.

Theculturetrip
5 Estonian Books You Should Read Now

Written as a confession of an immigrant in Paris, Õnnepalu's acclaimed novel delves deep into the confrontation between East and West, in what is often a dark and bleak tale of Eastern Europe's reorientation towards western culture. Often psychotic and incoherent, reading Border State is like following the confessions of a madman.