Writing a good ETL flow with NodeJs

Last story was about if it’s better to write your own ETL flow instead of using any of the tools…

Are OLAP cubes dead?

Hi everyone,
it’s been a while since my last post, many things have changed since then see it as an another life.
Well today i was thinking: “Is there any chance that OLAP cubes are dead?”
You’re certainly are saying: “What’s wrong with you? I’m using them obviously are not!” and i’m not…

Generating report automatically with python and LateX

[Basics] How to create a good ETL flow for you data warehouse

As a BI analyst i need to ensure that everyone (also me) are writing a good ETL flow with standard name convention and SQL operations.
Let’s begin this tutorial with a brief explanation of what is an ETL flow.

Why you should write your own ETL

In this story i’m going to tell you why and when you need to write your own ETL flow to feed your…

Creating a Genomic Variants DB

Obviously during my studies the asked me to create a database (and even web interface) to store and query…

Developing and implementing a data warehouse to support genomic analyses

Tips and tricks for a good performance data pipeline

Analysing Twitter sentiment via Python

Hi all, as a data scientist or looking for to be one of us, this kind of analysis could have…

Don’t forget the WITH clause in PostgreSQL!

Working all day with PostgreSQL for BigData analysis i always encounter many problems.
Sometimes those problems are really annoying, just like query slow performance.

Performance is a key aspect in…