Data science for data-driven startups

Covid-19 dashboard with Power Query / Power Pivot / Excel

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...

Data science: software engineering or business intelligence?

Kind of a rant discussing the shift of Data Science towards technology and losing sight of the business value.

Read more...

Data Brewery - Manage your data warehouse

Open Source ETL tool for data warehouse : Agile and SQL-based

Find more...

Web Analytics Data Warehouse : Google Analytics and Search

In this tutorial, we will create a web analytics data warehouse and a dashboard for content marketing strategies.

Read more...

Data Brewery – A modern ETL for agile data warehouse

Launching my first product, an open-source ETL for data warehouse with an emphasis on agility and productivity.

Read more...

PowerBI and PostgreSQL : SSL, Let’s encrypt and Gateway

A step by step adventure on how to connect PowerBI Service to a Postgresql data warehouse. Happy to save you some hours.

Read more...

JupyterLab for complex Python and Scala Spark projects

JupyterLab is an awesome piece of technology for prototyping, self documenting research. But can you use it for projects that have a big codebase ?

Read more...

MySQL/MariaDB for Data Science : Pro and cons

Is MySQL or MariaDB suited for the analytics workload of data science? Can it be used as a data warehouse? Let’s find out.

Read more...

How to escape the data monkey trap to leverage analytics

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.

Read more...

Supercharged Excel for startup analytics with PowerBI

You think Excel is not suitable for analytics? Let me convince you that Excel can be your best tool with PowerBI.

Read more...

Master SQL query for SaaS startups analytics

A query to dissect the MMR evolution between new, lost, winback, expansion and reduction MRR.

Read more...

« Older posts