About huy.vu

This author has not yet filled in any details.
So far huy.vu has created 6 blog entries.

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 [...]

December 5th, 2016|Engineering|

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 [...]

December 5th, 2016|SQL|

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 [...]

December 5th, 2016|SQL|

Tableau vs Holistics

Holistics gives you more flexibility and control over Tableau for data extraction and preparation. 1. Ask Better Questions Tableau is good for reporting organized data (where you already have the data in your columns), but it falls short for business and operational reporting where you need more specific reports across different tables. While not impossible, [...]

December 5th, 2016|Compare|

How ShopBack Deliver Faster Better Data Reports with Holistics

ShopBack is a well-known online consumer cashbacks store in Singapore. In this case study, we explain what were the manual data extraction challenges they had, and how Holistics has helped them solved this problem and built a better data-informed culture ShopBack, the online Cashback shopping website, is a treat for all shoppers in Southeast Asia. [...]

December 5th, 2016|Success Stories|

Why You Should Use Postgres Over MySQL For Analytics Purpose

Being an analytics/reporting product company, we’ve worked with a fair amount of customers who run Postgres/Redshift for their analytics, and the same fair amount who uses MySQL. And from our experience with both, I’d prefer our new customers to use Postgres all the time. For reporting/analytics/data-warehouse purpose, Postgres wins over MySQL hands-down. In this post [...]

December 5th, 2016|Engineering|