Articles on Data Analytics.

ETL pipelines, data warehouses, BI dashboards — turning raw data into actionable insight within weeks.

Data AnalyticsBenchmarkMeasurementStatisticsAI

Benchmark scores are not your scores: build your own evaluation set to choose an AI model — and how many questions it needs

Every week a new AI model claims the top of some leaderboard. But leaderboards measure other people's work, and the two biggest ones right now do not even agree with each other. The only way to know which model is good for your work is to measure it yourself. This article shows how to build an evaluation set from real data, and uses simulation to answer a question few people calculate: with two models 6 percentage points apart, 30 questions pick the better model only about 72% of the time — you need around 200 to be nearly certain.

16/10/202611 min read

Data AnalyticsData analyticsExcelRetail

Reorder on average sales and you run out every other cycle — working out safety stock in Excel

The most common way small shops and distributors reorder is average daily sales times the days the delivery takes. We simulated 200,000 replenishment cycles: that rule runs out of stock 50% of the time. This piece gives a safety-stock formula that fits in six Excel cells, shows why a supplier who delivers two days either side can double the buffer you need, and sets out when the formula does not apply.

04/10/202612 min read

Data AnalyticsDashboardsData AnalyticsDigital transformation

The dashboard was delivered and nobody opens it: the tool is not the problem

A company pays for a reporting screen, the handover goes well, and three months later nobody opens it. The first instinct is to blame the software, or to blame staff for not being comfortable with numbers. One figure shows both explanations miss: inside the same company, executives use it around 80% while employees use it around 26% — same software, same data, same screen.

14/08/202611 min read

Data AnalyticsPersonal Data ProtectionComplianceData Architecture

Vietnam's Personal Data Protection Law: the legal text takes an afternoon, the engineering takes months

Law 91/2025/QH15 took effect on 1 January 2026 alongside Decree 356/2025/NĐ-CP. Reading both takes an afternoon, but the real obligations reduce to three architectural questions — and most operating businesses cannot answer the first one: what personal data are you holding, and where?

01/08/202612 min read

Data AnalyticsGISSatelliteChina Tech

China's GIS technology leads Asia: the concrete evidence, and why 'surpassing Japan' needs a closer look

China now holds 34.2% of the Asia-Pacific GIS market — the largest share in the region, ahead of Japan — with SuperMap leading software and Jilin-1/Gaofen leading commercial remote-sensing satellites. But "surpassing Japan" needs qualification: Japan still leads in micro-SAR satellites and HD autonomous-driving maps, and some direct comparisons simply don't exist in real sources.

20/07/20268 min read

Data AnalyticsData QualitydbtObservability

Monitoring data quality: from dbt tests to anomaly detection for analytics pipelines

An ELT pipeline running green every day doesn't mean the data is correct — structural tests only catch part of the problem. How to add freshness, volume, and anomaly-detection layers that catch data errors before someone notices a wrong number on a dashboard.

30/06/20267 min read

Data AnalyticsdbtAirflowELT

Building an ELT pipeline with dbt and Airflow: from zero to a production dashboard

A concrete roadmap from scattered data across multiple systems to a data warehouse you can trust — with dbt for transforms, Airflow for orchestration, and data contracts so teams don't break each other's dashboards.

12/06/20268 min read

Data AnalyticsOCRData QualityMaster Data Management

Data digitization: from paper, Excel, and legacy systems to a single source of truth

Most data digitization projects fail not because OCR misreads characters, but because no one reconciles, normalizes, and merges the data afterward. A digitization pipeline architecture: OCR/ICR, validation, entity resolution/MDM, and an incremental migration strategy — why "one source of truth" matters more than "99% character accuracy".

11/06/20268 min read

← See all articles