Our Experience Going Through YC Startup School

Y-Combinator (YC) has always been recognized as one of the top accelerators/incubator for promising startups to apply for. They recently launched the first session of Startup School, which provides thousands of startup founders to learn from the experience of the YC alumni without the paperwork overheads of equity and incorporating a foreign entity. In this post, I'll highlight some of our experiences going through… Read More

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

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

Reusing Your SQLs with Query Templates

As engineers we refactor and abstract our code regularly, this is part of process to improve our code quality and scale up our codebase. In my previous job, we refactor our code religiously - "Leave the codebase a better place than you found it" so we said, that was the main reason to help us build big, complex system with just a handful of engineers!… Read More