An HTML report without a BI tool

With the synthetic data at hand as described here the next step is the reporting part”. As said before, having an interactive report, i.e., one that enables to sort, filter, and even cross-filter visuals and tables, does not require an overkill tool such as Tableau or PowerBI. Instead it can... [Read More]
Tags: Data and Business, business, data analytics, reporting, R, HTML, synthetic data

Building synthetic data you can trust

When applying for a position with SERV, Switzerland’s export risk insurance, I thought I might showcase a couple of reporting solutions that avoid the typical BI tools. The reporting should work in a transitional phase, where one cannot rely on a top-notch analytics environment (I’m mainly speaking about data availability... [Read More]
Tags: Data and Business, business, data analytics, AI, synthetic data

The two-way bargain between business and data

“Can you pull the new FTS numbers?” The message looks like a thirty-second favour. The first part of this pair followed it downstream, into a wrong number baked into an expensive decision, and landed on a single observation: the recurring failure is a question that was never framed properly before... [Read More]
Tags: Data and Business, business, data analytics, data literacy, AI, governance

Why 'becoming data-driven' keeps falling short

A message lands in the analyst’s chat: “Can you pull the new FTS numbers?” It feels like a thirty-second favour. It isn’t. Hidden inside that one sentence are half a dozen unasked questions: which metric, which season, which period, compared to what, and, least asked of all, for what decision.... [Read More]
Tags: Data and Business, business, data analytics, data literacy, AI

dbt on DuckDB — from raw tables to mart models

In the previous post I described how to load Parquet exports into a local DuckDB database — a fast, free, file-based data warehouse you can have running in an afternoon. The raw tables are queryable straight away. But to turn them into something reliable, documented, and ready for an analytics... [Read More]
Tags: DuckDB, dbt, SQL, data modeling, data engineering, staging, marts