Business Intelligence

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.

The existence of every company depends on the revenues it generates from the products and services it offers to its customers – whatever the company may be. Among all teams, the one that [...]

Whoever who has ever written code in any language would agree that date and time data types are the most frustrating of all. Of course SQL is not an exception. Each SQL dialect has its own [...]

The majority of the SQL-dialects admittedly offer to the users a rich set of data types. The most commonly used among them are probably the Integer and Float of different precision, the Boolean, [...]

How can I effectively organize my SQL query code to further reuse? In their everyday life, many people use SQL to construct queries that they are going to reuse at some point. But how do these [...]

Pattern matching over strings in SQL is a frequent need, much more frequent that some may think. Queries aren’t just for compiling demanding aggregate calculations, advanced joins and table [...]