data brewery, data warehouse, etl
Launching my first product, an open-source ETL for data warehouse with an emphasis on agility and productivity.
Read more...
postgresql, powerbi
A step by step adventure on how to connect PowerBI Service to a Postgresql data warehouse. Happy to save you some hours.
Open Source ETL tool for data warehouse : Agile and SQL-based
Find more...
python, scala, spark
JupyterLab is an awesome piece of technology for prototyping, self documenting research. But can you use it for projects that have a big codebase ?
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.
analytics, excel, powerbi
You think Excel is not suitable for analytics? Let me convince you that Excel can be your best tool with PowerBI.
analytics, saas, sql
A query to dissect the MMR evolution between new, lost, winback, expansion and reduction MRR.
hadoop, spark
In order to use Spark on windows you need to install winutils.exe and change some environment variables. Here is a nice fix.
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.
