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. […]
Data manipulation is a big part of a data mining process. Some authors claims it could take 80% of a data mining project. I could […]
data warehouse, mysql, olap
PS : This post is quite old now and isn’t relevant anymore. MySQL 5.6 introduced hash join which basically makes it more suitable to a data […]