SQL Is The New Excel

There was a time when being a power Excel user gave you an edge in your resume – it implied that you can perform your tasks more efficiently than your peers. Excel remains one of the most commonly used tool for analyzing data today and can be applied in various scenarios such as financial modeling, data analytics, or even invoicing. However, it is running into a… Read More

How 99.co Gains Better Customer Insights With Holistics

Moving away from an in-house dashboard helps the data team at 99.co focus their time on analysis and insights, while freeing up engineering resources to deliver on their product roadmap. Business teams can now get immediate answers to questions from their data, which help them make business decisions. About 99.co, a property portal 99.co is the first property search portal in Singapore… Read More

Setting Up Your Own MySQL Instance Using Google CloudSQL

Holistics helps you present any queries from your database as online reports and dashboards. As Holistics does not store your data, you will need to BYOD (bring your own database). However, you may not know how to get started with setting your database as a non-technical user. In this guide, we will show you how to set up your very own basic mySQL instance database… Read More

Splitting array/string into rows in Amazon Redshift or MySQL

We've worked with a lot of customers who writes SQL on a regular basis. And from time to time they come to us with SQL question - that we thought would be interesting to share with others! Today, one of our customers came to us with a question - They were having problems unnesting a string/array into rows in Amazon Redshift. Question - Splitting… Read More