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 — Converters

CSV → JSON

Csv To Json — Converters

JSON → XML

Json To Xml — Converters

XML → JSON

Xml To Json — Converters

Data cleaning

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

Chart picker

data type → recommended visualization

Dataset statistics

numbers → mean, median, percentiles, standard deviation

Sample size

confidence × margin of error × population → minimum n

A/B test

variant conversions → z-test, p-value, significance verdict

A/B significance

two-proportion z-test, p<0.05

Excel cheatsheet

formulas by task — lookup, aggregation, text, dates

Normalization

number set → min-max [0–1] or z-score

Moving average

time series → SMA, trend direction, forecast

Open data

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

Data quality

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

Small-biz databases

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

Data report

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

Anonymization

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

3-2-1 backups

data volume → copy capacity by the 3-2-1 rule

ETL pipeline

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

Analyst's glossary

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

Guides

Role-based dashboard

Metrics for owner, marketing, sales, finance — what each role should see

Scraping rules

Legal framework, robots.txt, personal data, technical etiquette, scraping tools

API integration

10 steps: keys, timeouts, retries, webhooks, limits, monitoring, fallback