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.
analytics, dashboard, marketing, sql
In this tutorial, we will create a web analytics data warehouse and a dashboard for content marketing strategies.
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 ?
analytics, saas, sql
A query to dissect the MMR evolution between new, lost, winback, expansion and reduction MRR.
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.
analytics, business, dashboard, startup
A good dashboard is a tool to reflect on the business, find new questions and insights to achieve growth. Get some tips.
data mining, statistics
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? […]