Data & analytics

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

Subtopics

Data converters

4 tools

Data cleaning

1 tools

Visualization

1 tools

Statistics

1 tools

Sampling

1 tools

A/B tests

2 tools

Dashboard

1 tools

Excel cheatsheets

1 tools

Normalization

1 tools

Forecasting

1 tools

Government open data

1 tools

Scraping

1 tools

Data quality

1 tools

Databases for small business

1 tools

Data report

1 tools

Anonymization

1 tools

API integrations

1 tools

Data backups

1 tools

ETL pipeline

1 tools

Analyst's glossary

1 tools

Calculators

JSON → CSV

Json To Csv — Konverter

CSV → JSON

Csv To Json — Konverter

JSON → XML

Json To Xml — Konverter

XML → JSON

Xml To Json — Konverter

Datenbereinigung

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

Diagramm-Wahl

Datentyp → empfohlene Visualisierung

Datensatz-Statistik

Zahlen → Mittelwert, Median, Perzentile, Standardabweichung

Stichprobengröße

Konfidenz × Fehler × Population → Mindest-n

A/B-Test

Varianten-Konversionen → z-Test, p-Wert, Signifikanz

A/B-Signifikanz

Zwei-Proportionen-z-Test

Excel-Spickzettel

Formeln nach Aufgabe — Suche, Aggregation, Text, Datum

Normalisierung

Zahlenreihe → Min-Max [0–1] oder z-Score

Gleitender Durchschnitt

Zeitreihe → SMA, Trendrichtung, Prognose

Open Data

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

Datenqualität

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

Datenbanken für KMU

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

Datenbericht

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

Anonymisierung

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

3-2-1-Backups

Datenvolumen → Kopiekapazität nach 3-2-1

ETL-Pipeline

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

Analysten-Glossar

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

Guides

Rollen-Dashboard

Metriken für Inhaber, Marketing, Vertrieb, Finanzen — was jede Rolle sehen sollte

Scraping-Regeln

Rechtsrahmen, robots.txt, personenbezogene Daten, Scraping-Tools

API-Integration

10 Schritte: Keys, Timeouts, Retries, Webhooks, Limits, Monitoring, Fallback