data brewery, data warehouse, etl
Launching my first product, an open-source ETL for data warehouse with an emphasis on agility and productivity.
data warehouse, mariadb, mysql
Is MySQL or MariaDB suited for the analytics workload of data science? Can it be used as a data warehouse? Let’s find out.
analytics, data warehouse, excel, sql
Do you feel spending more time getting the data instead of producing impactful insights? You are not alone. Let’s explore 4 ways to solve this.
data warehouse, postgresql
Is PostgreSQL a good companion for a data scientist at a startup? At which maturity stage should it be used? Let’s find out!
business, data warehouse, startup
At the foundation of deep analytics there is a nicely structured master table. Let’s see where a startup need to start.
After years of analytics pratice, we came to a set of opinions on how data warehouses should be built.
In those day of huge focus on the Big Data mouvement, it seems that nobody needs a data warehouse anymore but a huge cloud of […]
data warehouse, Greenplum, sql
Usually we use sequence to generate unique identifier for surrogate keys. A sequence is simply a database object that return a number every time you […]
analytics, business, data warehouse
For the end of 2011, many around the blogosphere are forecasting what will be on hype next year. I often read that big data and […]
data manipulation, data warehouse
My last post discuss about SQL queries. Nevertheless, sometimes data came from differents databases. In such cases, it is no longer possible to use SQL. […]