Data & analytics

Data converters, statistics, sampling, A/B tests, dashboards

Subtopics

Calculators

JSON → CSV

Json To Csv — Converters

CSV → JSON

Csv To Json — Converters

JSON → XML

Json To Xml — Converters

XML → JSON

Xml To Json — Converters

Data opschonen

checklist of typical dataset problems: duplicates, missing values, formats, outliers — and fixes

Grafiek kiezen

datatype → aanbevolen visualisatie

Dataset-statistiek

getallen → gemiddelde, mediaan, percentielen, standaardafwijking

Steekproefgrootte

betrouwbaarheid × fout × populatie → minimum n

A/B-test

variantconversies → z-test, p-waarde, significantie

A/B-significantie

z-test twee proporties

Excel-spiekbrief

formules per taak — zoeken, aggregatie, tekst, datums

Normalisatie

reeks → min-max [0–1] of z-score

Voortschrijdend gem.

tijdreeks → SMA, trendrichting, voorspelling

Open data

catalog of Ukrainian state registries: data.gov.ua, EDR, Prozorro, courts — where to find machine-readable data

Datakwaliteit

data quality audit across 6 dimensions: accuracy, completeness, consistency, timeliness

DB voor mkb

choosing data storage for small business: Sheets, Airtable, Notion, CRM — scenario comparison

Datarapport

analytics report skeleton generator: goal, metrics, findings, recommendations — BLUF structure

Anonimisering

personal data masking techniques: masking, pseudonymization, k-anonymity

3-2-1-backups

datavolume → kopiecapaciteit volgens 3-2-1

ETL-pipeline

ETL pipeline planning: extract, transform, load — 6 stages, tools, mistakes

Analistenwoordenlijst

statistics and analytics terms: median, percentile, correlation, p-value, cohort

Guides