excel, powerbi
Can Excel (using Power Query and Power Pivot) be used to monitor the Covid-19 pandemic? Sure, and we will learn a lot in the process.
Read more...
analytics, data science
Kind of a rant discussing the shift of Data Science towards technology and losing sight of the business value.
Open Source ETL tool for data warehouse : Agile and SQL-based
Find more...
analytics, dashboard, marketing, sql
In this tutorial, we will create a web analytics data warehouse and a dashboard for content marketing strategies.
data brewery, data warehouse, etl
Launching my first product, an open-source ETL for data warehouse with an emphasis on agility and productivity.
postgresql, powerbi
A step by step adventure on how to connect PowerBI Service to a Postgresql data warehouse. Happy to save you some hours.
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.
