Tagredshift

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 (2016): 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

© 2017 Koen Kamphuis

Theme by Anders NorénUp ↑