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

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

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

Master SQL query for SaaS startups analytics

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

Read more...

The master analytics table for SaaS startups

At the foundation of deep analytics there is a nicely structured master table. Let’s see where a startup need to start.

Read more...

Startup reporting template for investors and insights

A good dashboard is a tool to reflect on the business, find new questions and insights to achieve growth. Get some tips.

Read more...

How to : What to do when your model fails?

Sometimes (well most of the time) using your favorite data mining methods and the more obvious attributes are not good enough. What to do then? […]

Read more...