Business Intelligence

One of the most important SaaS metrics of your customer acquisition strategy is the Lifetime Value – or LTV– of a customer. Having a solid customer acquisition strategy is an essential component [...]

Although there are many NoSQL database systems that work directly with the JSON format, those who are used to work with RDBMS would love to be able to manipulate their JSON formatted data stored [...]

For quite some time, customer support has stopped being considered an optional service. Although in the past, businesses used to provide no real support to customers as they thought it was an [...]

One of the most basic clauses in any SQL dialect is the GROUP BY. Anyone who interacts frequently with relational databases has for sure used this clause thousands of times in order to compute [...]

At a time where more and more companies become data-driven, the process of decision making regarding key business activities like sales is changing once and for all. By leveraging data, a modern [...]

Some time ago we discussed how you can access data that are stored in Amazon Redshift and PostgreSQL with Python and R. Let’s say you did find an easy way to store a pile of data in your BigQuery [...]

For all companies, the generation of sufficient revenues is a process highly correlated with the company’s survival, no matter the product or the service it offers to its customers. Thus it [...]

I guess no one would argue with me if I say that satisfied customers are a key factor in sustainability and growth of a business. As Gregory Ciotti simply put it “a satisfied customer is one that [...]

As the saying goes “Theory is splendid but until put into practice, it is valueless”. In our previous post 20 Sales KPIs for awesome sales teams we discussed extensively how valuable can KPIs be [...]

What is an SQL Window Function? This is part #7 of our SQL blog post and it is an introduction with easy to use examples to get started with it.