Page 2 of 3

Finding the perfect Data (SQL) Analyses tool

This is probably the most generic title I can come up with but at my current company  we are looking into new ways of visualising and sharing our data within the company.

This sounds like it should be very easy to find but after the guys from WagonHQ got bought by Box there seems to be quite a gap in the SQL dashboarding landscape.

We used Wagon for quickly pumping out some shared chart we can embed into a page, which we can then send across the office. Nothing complicated. We use Redshift as a data warehouse.

Keep in mind that when I’m saying the tools below are “bad” or “not working” it’s because they aren’t doing the thing I want them to do. Doesn’t mean its a crap platform or wouldn’t work for you.

Continue reading

Mode Analytics: finding the perfect Analysis tools

EDIT 2017-10-22: The team at Mode has been updating the tool almost every single month, the below is based on what our team needed in 2016 and what Mode Analytics could provide at the time of writing.

Lots of the work we do, and one of the many things we use our SQL tool for,  is for small little investigations (wouldn’t want to call it growth hacking but something similar).

This means writing quick, single queries with an output that only needs to be looked and stared at for 5 minutes and then never again. Mode Analytics in this instance doesn’t feel like the right tool for the job but we go it to work for part of the business. Especially A/B Experiments in combination with the Python environment.

Continue reading

Where to buy a PS Vita in 2017?

The PSP is one of my most beloved consoles I ever owned. When it came out in 2004, my friends and I imported the handheld from Japanese retailer Lik-Sang together with Lumines.

It’s been almost 5 years since the PS Vita got released and with some amazing games on the platform, the support for the console seems to be completely gone in the west with only indie games being released. This makes it very hard to find a good retailer to buy the PS Vita console in 2016 or 2017.

Continue reading

Pro Evolution Soccer 2017 on PS4

I’ve got no idea how Pro Evolution Soccer 2017 is getting such high reviews. The current score on Metacritic is around the 90% and I can’t find any reason what so ever why that is the case.

The last time I’ve played a Pro Evolution Soccer game has to be in 2014 when I bought the game on the PC. It was decent, not the best football game ever but with the Master League and the Be A Legend mode it kept me busy for half a year. I did try FIFA but wasn’t the biggest fan.

In 2015 I made the switch, found Pro Evolution Soccer quite lacking and FIFA 15 and 16 are both great football games. Very frustrating but also very good. This years Pro Evolution Soccer is only frustrating and not that good at all.

Continue reading

Howto Bulk Unfollow Playlists on Spotify

I’ve been trying to use Spotify the last couple of weeks as a substitute for Google Music. And at the moment I’m quite loving it. The account I’ve created about 3 years ago was still active but had all my old playlists on it. The problem was that this was a import from iTunes and it imported all my 283(!) playlists and unfortunately there is no easy way of deleting playlists inside Spotify.

Continue reading

© 2021 Koen Kamphuis

Theme by Anders NorénUp ↑